Plan Overview

The Historical Data Plan extends its free version in 2 ways:

  1. It offers unlimited calls
  2. Full historical listing per market is available

How to Setup Your API Key

Once subscribed, here is how to configure the add-on:

  1. Open a sheet where CRYPTOFINANCE is activated (see step 5 here if you’re unsure).
  2. Go to Add-Ons > CRYPTOFINANCE > Set Historical Data plan API Key
  3. Paste your API key in the box and click Ok
  4. Done! You now have unlimited call and the price_history feature available.

Supported Function Calls

The All-Time-High data, Custom Sparklines and regular Historical Prices calls are now available without any quota.

You also have access to the price_history feature, to return for a given market its full OHLCV data history. Use it like this:

=CRYPTOFINANCE("BINANCE:ETH/BTC", "price_history")

This will return a full sheet of data with the following columns:

  • Exchange
  • Base currency
  • Quota Currency
  • Human Readable Timestamp
  • Open Price
  • High Price
  • Low Price
  • Close Price
  • Volume (in quote currency)
  • Volume (in base currency)

By default 1 year of historical data is returned. You can change this with the following values: 2Y, 1Y, YTD, 6M, 3M, 1M, 20D, 10D, 7D. Where Y stands for year, M for months, and D for days.

Example to pull the last month OHLCV data for ETH/BTC market on Binance:

=CRYPTOFINANCE("BINANCE:ETH/BTC", "price_history", "1M")

Troubleshooting

Most issues at first are just a refresh issue. Google Sheets is still returning data from its internal cache.

You can force a refresh by editing a function call. Or just deleting cells, waiting ~3 seconds and then undo-ing the deletion (with Cmd+Z, or via Edit > Undo menu).

If you still have an issue:

  • Ensure the add-on is activated and your API key is set and showed to be valid.
  • If you see an #ERROR message, put the mouse cursor over the erroneous cell, the error message will provide more context.

If you’re still having issue, contact our support at [email protected] with your API key and the function syntax you’re using. We’ll help you fix the problem.