The current data are from CryptoCompare historical price API and often return error due to the large number of users.

The Pro plan will include historical prices and other data, more info here.


Extending from price syntax, you can get a pair the market average price at a historical date with the following syntax:

=CRYPTOFINANCE("BTC/USD", "price", "2014-12-25")

The last argument, the date, must be a 10 characters long string following the format YYYY-MM-DD. Where the year is written in 4 digits, then the month in 2 digits (add a padding zero for months January to September), then the day in 2 digits (add a padding zero for 1st to 9th). Each group being separated by a single hyphen -.

Note: If no price data is available for the date, 0 is returned. The prices returned are the close prices at end of day GMT.

Exchange specific

You can prepend an exchange name, to return not the market average but this exchange price. 77 exchanges are supported, you can find the list here, along with their supported pairs.

Example getting Kraken BTC/USD price for November 2nd 2015:

=CRYPTOFINANCE("KRAKEN:BTC/USD", "price", "2015-11-02")

Using Google Sheets TODAY() function:

=CRYPTOFINANCE("KRAKEN:BTC/USD", "price", TEXT(TODAY(), "yyyy-mm-dd"))

Referencing cells to build the timestamp:

Say A1 contains BTC and A2 contains 2016–10–22:

First make sure to format A2 and A3 in plain text, go to Format > Number > Plain text to do this. Then, call:

=CRYPTOFINANCE(A1 & "/USD", "price", TEXT(A2, "yyyy-mm-dd"))

Open, high, low, close and volume info

Other data are available: open, high, low, close and volume info:

=CRYPTOFINANCE("KRAKEN:BTC/USD", "open", "2015-11-02")

=CRYPTOFINANCE("KRAKEN:BTC/USD", "high", "2015-11-02")

=CRYPTOFINANCE("KRAKEN:BTC/USD", "low", "2015-11-02")

=CRYPTOFINANCE("KRAKEN:BTC/USD", "close", "2015-11-02")

=CRYPTOFINANCE("KRAKEN:BTC/USD", "volume_from", "2015-11-02")

=CRYPTOFINANCE("KRAKEN:BTC/USD", "volume_to", "2015-11-02")