The Pro plan offers higher level data to enable you to do more with your sheets. Click here to be notified when the Pro plan become available. Below is a list of what to expect.

Historical prices: open, high, low, close

Access 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:

  • Full listing per coin: =CRYPTOFINANCE("BTC/USD", "price_history")
  • Any OHLC price for a given date: =CRYPTOFINANCE("BTC/USD", "close", "2015/12/25")

Historical marketcap and volume

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:

  • Historical marketcap for all exchanges: =CRYPTOFINANCE("BTC/USD", "marketcap", "2017/11/21")
  • Historical volume for all exchanges: =CRYPTOFINANCE("ETH/BTC", "volume", "2016/12/25")

Custom sparklines (inlined small graphs)

A better way to generate sparklines for your sheet. Return a list of daily prices for 1 to 30 days. Use it like this:

  • 7d BTC price sparkline: =SPARKLINE(CRYPTOFINANCE("BTC/USD", "prices_7d_sparkline")
  • 30d ETH price sparkline: =SPARKLINE(CRYPTOFINANCE("BTC/USD", "prices_30d_sparkline")

Change % against BTC and ETH, or any other crypto

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:

  • 30d change against BTC: =CRYPTOFINANCE("ETH/BTC", "change_30d")
  • 200d change against ETH: =CRYPTOFINANCE("EOS/ETH", "change_200d")

Change % over a custom period

Get historical change percentage for any pair over a custom period from 1 day to 300 days. Examples:

  • Change against BTC for Jan 2017: =CRYPTOFINANCE("ETH/BTC", "change_30d", "2017/01/31")
  • Change against ETH for Q1 2018: =CRYPTOFINANCE("EOS/ETH", "change_91d", "2017/03/31")

ATH: All-Time-Highs data

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:

  • Get BTC ATH for 2017: =CRYPTOFINANCE("BTC/USD", "ath", "2017")
  • Get nb of days since BTC ATH: =CRYPTOFINANCE("BTC/USD", "ath_since")
  • Get % down since BTC ATH: =CRYPTOFINANCE("BTC/USD", "ath_change")

ATL: All-Time-Lows data

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:

  • Get BTC ATL for 2018: =CRYPTOFINANCE("BTC/USD", "atl", "2018")
  • Get % up since BTC ATL: =CRYPTOFINANCE("BTC/USD", "atl_change")

Volatility percentage

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:

  • May 2016 Bitcoin volatility: =CRYPTOFINANCE("BTC/USD", "volatility", "2016/05")
  • June 2017 Ether volatility: =CRYPTOFINANCE("ETH/USD", "volatility", "2017/06")

Return On Investment

Get the ROI for each coin per year and quarter. Ideal to compare your trading performance against HODL’ing. Examples:

  • BTC 2018 Q1 ROI: =CRYPTOFINANCE("BTC/USD", "roi", "2018Q1")
  • ETH 2017 ROI: =CRYPTOFINANCE("ETH/USD", "roi", "2017")

Global historical data

Total cryptocurrency marketcap historical data, historical bitcoin % of total marketcap cap, historical marketcap of all altcoins, historical % of bitcoin to altcoins marketcap.

  • BTC historical rank: =CRYPTOFINANCE("BTC", "rank", "2016-11-25")
  • Total historical crypto marketcap: =CRYPTOFINANCE("GLOBAL", "total_marketcap", "2015-06-20")
  • Total historical altcoins marketcap: =CRYPTOFINANCE("GLOBAL", "total_marketcap_alts", "2017-08-20")

Additional data may include: RSI data, Historical rank by marketcap, Network Value to Transactions (NTV) Ratio, List of coins and markets per exchange, Total volume per exchange, and more.