Return on Investment Data
Google Sheets & Excel
Airtable
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.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")
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...
Last modified 5mo ago