=CRYPTOFINANCE("BTC/USD")=CRYPTOFINANCE("BTC/USD")
=CRYPTOFINANCE("BTC/USD", "marketcap")
=CRYPTOFINANCE("BTC/USD", "volume")
=CRYPTOFINANCE("BTC/USD", "change", "1h")
=CRYPTOFINANCE("BTC/USD", "change", "24h")
=CRYPTOFINANCE("BTC/USD", "change", "7d")
=CRYPTOFINANCE("BTC/USD", "available_supply")
=CRYPTOFINANCE("BTC/USD", "max_supply")
=CRYPTOFINANCE("BTC/USD", "total_supply")=CRYPTOFINANCE("COINBASE:BTC/USD")
=CRYPTOFINANCE("KRAKEN:BTC/USD")
=CRYPTOFINANCE("KRAKEN:BTC/USD", "bid")
=CRYPTOFINANCE("KUCOIN:KCS/BTC")
=CRYPTOFINANCE("KUCOIN:KCS/BTC", "volume")
=CRYPTOFINANCE("BITHUMB:BTC")
=CRYPTOFINANCE("BITHUMB:BTC", "high")
=CRYPTOFINANCE("BITFINEX:BTC/USD", "last")
=CRYPTOFINANCE("GLOBAL", "total_marketcap")
=CRYPTOFINANCE("GLOBAL", "total_24h_volume")
=CRYPTOFINANCE("GLOBAL", "bitcoin_percentage_of_marketcap")
=CRYPTOFINANCE("GLOBAL", "active_currencies")
=CRYPTOFINANCE("GLOBAL", "active_markets")
For CoinMarketcap and exchanges’ API alike, all the requests come from Google Sheets servers, as a result Sheets users share a small pool of IP addresses, and they often get banned.
The Data Availability Service acts as proxy service between Google Sheets servers and the exchanges, ensuring requests are never banned and that you get your data.
See all featuresAccess the daily market average prices from the 1st day a coin was traded on an exchange. The standard open, high, low, close prices are available. Examples:
=CRYPTOFINANCE("BTC/USD", "price_history")
=CRYPTOFINANCE("BTC/USD", "close", "2015/12/25")
Daily historical marketcap and volume for each coin since their first day of trading. Both volume and marketcap are across all exchanges where the coins are traded. Examples:
=CRYPTOFINANCE("BTC/USD", "marketcap", "2017/11/21")
=CRYPTOFINANCE("ETH/BTC", "volume", "2016/12/25")
Compare any coin against the performance of Bitcoin and Ethereum, or any other cryptocurrency. For any period from 1 day to 300 days. Calculated from the previous closing 24h period. Examples:
=CRYPTOFINANCE("ETH/BTC", "change_30d")
=CRYPTOFINANCE("EOS/ETH", "change_200d")
Get historical change percentage for any pair over a custom period from 1 day to 300 days. Examples:
=CRYPTOFINANCE("ETH/BTC", "change_30d", "2017/01/31")
=CRYPTOFINANCE("EOS/ETH", "change_91d", "2017/03/31")
Track for each coin their highest price per year or ever, the number of days since their ATH, the percentage down since then, and the percentage to realize to get back to ATH price. Examples:
=CRYPTOFINANCE("BTC/USD", "ath", "2017")
=CRYPTOFINANCE("BTC/USD", "ath_since")
=CRYPTOFINANCE("BTC/USD", "ath_change")
Track for each coin their lowest price ever or per year, the number of days since their ATL, the percentage up since ATL and the percentage drop to realize to get back to ATL price. Examples:
=CRYPTOFINANCE("BTC/USD", "atl", "2018")
=CRYPTOFINANCE("BTC/USD", "atl_change")
Returns the volatility % per month. Calculated as the standard deviation for the whole month close prices, to the last close price of the month. Always computed against USD. Examples:
=CRYPTOFINANCE("BTC/USD", "volatility", "2016/05")
=CRYPTOFINANCE("ETH/USD", "volatility", "2017/06")
Get the ROI for each coin per year and quarter. Ideal to compare your trading performance against HODL’ing. Examples:
=CRYPTOFINANCE("BTC/USD", "roi", "2018Q1")
=CRYPTOFINANCE("ETH/USD", "roi", "2017")
A better way to generate sparklines for your sheet. Return a list of daily prices for 1 to 30 days. Use it like this:
=SPARKLINE(CRYPTOFINANCE("BTC/USD", "prices_7d_sparkline"))
=SPARKLINE(CRYPTOFINANCE("BTC/USD", "prices_30d_sparkline"))
Total cryptocurrency marketcap historical data, historical bitcoin % of total marketcap cap, historical marketcap of all altcoins, historical % of bitcoin to altcoins marketcap.
=CRYPTOFINANCE("BTC", "rank", "2016-11-25")
=CRYPTOFINANCE("GLOBAL", "total_marketcap", "2015-06-20")
=CRYPTOFINANCE("GLOBAL", "total_marketcap_alts", "2017-08-20")