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")