The Data Availability Service ensures you avoid Coinmarketcap or other exchanges APIs ban, overload or any breaking change in their API format. Exchanges ban Google Sheets servers IP addresses when too many requests originate from them, see why here.

Note: The Data Availability proxy offers unlimited requests but Google Sheets will still impose its limit of 20,000 API call per day per sheet. Remember to use the full listings call to avoid hitting this quota.

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 Data Availability API Key
  3. Paste your API key in the box and click Ok
  4. Refresh the cells calling CRYPTOFINANCE():
    • Select cells calling CRYPTOFINANCE, hit Delete key, wait 3sec, and then undo the delete with Cmd+Z. If you’re on Windows use the Ctrl key instead of Cmd.
  5. All your function calls are now being forwarded to the Data Availability proxy.

Supported function calls

All function calls below will use the Data Availability proxy service, note that this is for current spot prices and other data only.

Full listings

  • CoinMarketcap: =CRYPTOFINANCE("COINMARKETCAP")
  • Poloniex (only available under this service): =CRYPTOFINANCE("POLONIEX")
  • IDEX (only available under this service): =CRYPTOFINANCE("IDEX")
  • Binance: =CRYPTOFINANCE("BINANCE")
  • Bittrex: =CRYPTOFINANCE("BITTREX")
  • Cryptopia: =CRYPTOFINANCE("CRYPTOPIA")
  • HitBTC: =CRYPTOFINANCE("HITBTC")
  • Kucoin: =CRYPTOFINANCE("KUCOIN")
  • Gate.io: =CRYPTOFINANCE("GATEIO")

Specific ticker

Coinmarketcap

Regular calls like =CRYPTOFINANCE("BTC/USD") are also all supported by the Data Availability Service.

All fiat quote currencies are available: AUD, BRL, CAD, CHF, CLP, CNY, CZK, DKK, EUR, GBP, HKD, HUF, IDR, ILS, INR, JPY, KRW, MXN, MYR, NOK, NZD, PHP, PKR, PLN, RUB, SEK, SGD, THB, TRY, TWD, USD, ZAR.

BTC, ETH and NEO are also available as quote currency.

Binance

Specific market symbols for Binance are also supported. Syntaxes like this =CRYPTOFINANCE("BINANCE:ETH/BTC") will also make use of the Data Availability Service.

Notes

It is however recommended to setup the cryptodata sheet as explained in the documentation here. This will save you from hitting the Google Sheets imposed quota of 20,000 API calls per day.

Tip: Wrap you cell references with VALUE() to be able to format the cell.

Global stats

  • Total coin market cap: =CRYPTOFINANCE("GLOBAL", "total_marketcap")
  • Total 24h volume: =CRYPTOFINANCE("GLOBAL", "total_24h_volume")
  • Bitcoin percentage of market cap: =CRYPTOFINANCE("GLOBAL", "bitcoin_percentage_of_marketcap")
  • Number of active crypto-currencies: =CRYPTOFINANCE("GLOBAL", "active_currencies")
  • Number of active crypto-currencies: =CRYPTOFINANCE("GLOBAL", "active_currencies")

Troubleshooting

Most issues at first are just a refresh issue. Google Sheets is still running an old version of the add-on code and doesn’t see your API Key setup.

You can force Google Sheets to refresh the code and re-do the API calls in 3 different ways:

  1. The best way remains to setup the manual refresh trigger, see here for more info.
  2. Editing a cell forces a refresh, so you can change the formula call, and revert back to the original syntax.
  3. If all this still doesn’t work, go to File > Make a copy.... Open this new copy file, activate the add-on and refresh the function calls.

If you’re still having issue, just reply to the email your received with the API details. We’ll help you out.