Blockchain Data
Markets Data
Order Books Data
Exchange Data
Disclaimer & Privacy
Return on Investment Data
Return on Investment
ROI (Return on Investment) data are available via a simple syntax:
1
=CRYPTOFINANCE("BTC/USD", "roi")
Copied!
This will return the ROI for the
BTC/USD market as an exchange aggregated VWAP, from Jan 1st of the current year, until today.Note: Calls to ROI data fall into the Historical Data quota of 25 call per day per user.
Exchange Specific ROI
You can prefix an exchange name, to return ROI from a given exchange, and not the market average.
Example getting Kraken ROI since Jan 1st for its
BTC/EUR market:1
=CRYPTOFINANCE("KRAKEN:BTC/EUR", "roi")
Copied!
Specifying a Different Period
ROI can be returned per year, quarter and month. Here are a some examples.
Getting ROI for BTC against USD, as an exchange aggregated VWAP, for the year 2014:
1
=CRYPTOFINANCE("BTC/USD", "roi", "2014")
Copied!
Getting ROI for ETH against BTC, from Kraken, for the first quarter of 2018:
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "roi", "2018Q1")
Copied!
Getting ROI for Mutant Ape Yacht Club, from OpenSea, for the first quarter of 2022:
1
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "roi", "2022Q1")
Copied!
Getting ROI for BTC against EUR, as an exchange aggregated VWAP, for January 2015:
1
=CRYPTOFINANCE("BTC/EUR", "roi", "2015-01")
Copied!
Getting ROI for Mutant Ape Yacht Club for January 2022:
1
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "roi", "2022-01")
Copied!
Getting ROI for Mutant Ape Yacht Club for the past 1 month:
1
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "roi", "1m")
Copied!
Getting ROI for Mutant Ape Yacht Club for the past 1 year:
1
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "roi", "1y")
Copied!
Getting ROI for Mutant Ape Yacht Club for year to date:
1
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "roi", "ytd")
Copied!
Getting ROI for BTC against EUR, from Kraken, for the last quarter of 2015:
1
=CRYPTOFINANCE("KRAKEN:BTC/EUR", "roi", "2015Q4")
Copied!
Last modified 6d ago