Links

Return on Investment Data

Pricing: This data point requires derivative subscription plan.
Google Sheets & Excel
Airtable

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.

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:
=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 Kraken, for the first quarter of 2018:
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "roi", "2018Q1")
Getting ROI for Mutant Ape Yacht Club, from OpenSea, for the first quarter of 2022:
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "roi", "2022Q1")
Getting ROI for BTC against EUR, as an exchange aggregated VWAP, for January 2015:
=CRYPTOFINANCE("BTC/EUR", "roi", "2015-01")
Getting ROI for Mutant Ape Yacht Club for January 2022:
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "roi", "2022-01")
Getting ROI for Mutant Ape Yacht Club for the past 1 month:
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "roi", "1m")
Getting ROI for Mutant Ape Yacht Club for the past 1 year:
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "roi", "1y")
Getting ROI for Mutant Ape Yacht Club for year to date:
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "roi", "ytd")
Getting ROI for BTC against EUR, from Kraken, for the last quarter of 2015:
=CRYPTOFINANCE("KRAKEN:BTC/EUR", "roi", "2015Q4")
Currently not available for Airtable. Coming soon...