Cryptofinance
Open Cryptowatch
Create Account
Pricing
Contact Us
Search…
Getting Started
Best Practices in Google Sheets
How to Refresh Rates with CRYPTOFINANCE in Google Sheets
Things to Know
Advanced Usage and Tips in Google Sheets
Blockchain Data
Bitcoin and Cryptocurrency Network Data in Google Sheets
Markets Data
Cryptowatch Data
Trade Data
Historical Data
Historical OHLCV
All-Time-Highs
Market Macro Data
Return on Investment Data
Order Books Data
Markets Liquidity
Market Order Book
Exchange Data
Exchange Data
Supported Exchanges
Disclaimer & Privacy
Risk Disclaimer
Privacy Statement
Terms of Service
Powered By
GitBook
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!
Markets Data - Previous
Market Macro Data
Next - Order Books Data
Markets Liquidity
Last modified
6d ago
Copy link
Contents
Return on Investment
Exchange Specific ROI
Specifying a Different Period