A simple syntax to access any market historical prices:
=CRYPTOFINANCE("ETH/BTC", "price", "2017-04-12@11:00")
=CRYPTOFINANCE("BTC/USD", "low", "2017-01-08")
=CRYPTOFINANCE("BINANCE:BNB/USDT", "volume", "2017-01-08")
Any open, high, low, close price and volume data is available from over 196 exchanges on an hourly interval.
ATH prices are available similarly via a simple syntax:
Available both as an aggregated VWAP and for any of the 196 exchanges.
Get any market on any exchange 24h ATH trading volume with
See the doc for all ATH supported data points »
ROI data are provided as a cross-exchange aggregated price (VWAP) and per exchange.
The syntax is as simple as
=CRYPTOFINANCE("BINANCE:BNB/BTC", "roi", '2018Q1')
By default the ROI since Jan 1st is returned. See the doc for more details »
Enrich your sheets with custom sparklines (inlined charts) for price and volume data.
All sparklines are available for all exchange markets over periods of 7, 10, 20 or 30 days.
Sparklines can also be used to compute the average, maximum or anything over price and volume data over a custom period. See the doc for all sparklines possibilities »
No, all plans have a different API key and cannot be used interchangeably. You essentially get 1 API key per subscription.
CoinMarketcap data is available under another plan, and are not included in this Historical Data plan, but aggregate data is still available.
Yes, we use Stripe to process all payments. We never see or store your credit card details.
Right after subscribing you will get an API key to input in the add-on. It is not linked to your Google Account in any way. We’ll also email you your API key.
Just reply to either your CRYPTOFINANCE API key or invoice emails and we’ll cancel your subscription. No questions asked.
Send us an email and we’ll send you a link to a secure form to update your card details.