Return on Investment
ROI (Return on Investment) data are available via a simple syntax:
=CRYPTOFINANCE("BTC/USD", "roi")
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. 196 exchanges are supported, you can find the list here.
Example getting Kraken ROI since Jan 1st for its BTC/EUR market:
=CRYPTOFINANCE("KRAKEN:BTC/EUR", "roi")
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:
=CRYPTOFINANCE("BTC/USD", "roi", "2014")
Getting ROI for ETH against BTC, from Binance, for the first quarter of 2018:
=CRYPTOFINANCE("BINANCE:ETH/BTC", "roi", "2018Q1")
Getting ROI for BTC against EUR, as an exchange aggregated VWAP, for January 2015:
=CRYPTOFINANCE("BTC/EUR", "roi", "2015-01")
Getting ROI for BTC against EUR, from Kraken, for the last quarter of 2015:
=CRYPTOFINANCE("KRAKEN:BTC/EUR", "roi", "2015Q4")