Links

Historical Data

Overview

All historical data is sourced from the Cryptowatch API.
Extending from price syntax, you can get a pair the market average price at a historical date time with the following syntax:
Historical data is available at day, hour, minute and second level. You can access to the second, minute and hour level data only for last 2 years. The date must be following the format YYYY-MM-DD (2017-01-13) and date time must be following the format [email protected]:M:S ([email protected]:15:00)
=CRYPTOFINANCE("BTC/USD", "price", "2014-12-25")
=CRYPTOFINANCE("BTC/USD", "price", "[email protected]:00:00")
=CRYPTOFINANCE("BTC/USD", "price", "[email protected]:22:00")
=CRYPTOFINANCE("Kraken:BTC/USD", "price", "[email protected]:22:18")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "price", "2022-01-15")
Note: Second level data is only available for exchange markets.
Timezone is set to UTC time (GMT +00:00).

Referencing Cells to Build the Date

Say A1 contains BTC, and A2 contains 2016–10–22.
First make sure to format A2 as plain text. To do this select cell A2, then go to:
Format > Number > Plain text .
Then in A3 enter this formula:
=CRYPTOFINANCE(A1 & "/USD", "price", TEXT(A2, "yyyy-mm-dd"))
Note: Here we use & to concatenate (glue together) cells and text to forge the function’s argument.

Example Using Google Sheets TODAY() Function

Getting the price exactly 10 days ago, we use TODAY()-10:
=CRYPTOFINANCE("BTC/USD", "price", TEXT(TODAY()-10, "yyyy-mm-dd"))

OHLC: Open, High, Low, Close prices

You can pull any daily price point using the following syntaxes:
  • Open: =CRYPTOFINANCE("BTC/USD", "open", "2018-12-25")
  • High: =CRYPTOFINANCE("BTC/USD", "high", "2018-12-25")
  • Low: =CRYPTOFINANCE("BTC/USD", "low", "2018-12-25")
  • Close: =CRYPTOFINANCE("BTC/USD", "close", "2018-12-25")
By default, using price will return the close price. The above logic works for NFT data as well. Note that with NFT data, you can also pull data without specifying a date. For example:
  • Open: =CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "open")
  • High: =CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "high")
  • Low: =CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "low")
  • Close: =CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "close")

Exchange Specific

You can prefix an exchange name, to return data from a specific exchange, and not the market average. 196 exchanges are supported, you can find the list here, along with their supported pairs.
Example getting Kraken BTC/USD open price for November 2nd 2015:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "open", "2015-11-02")
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price", "[email protected]:00:00")
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price", "[email protected]:22:00")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "open", "2022-01-15")
Using Google Sheets TODAY() function:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price", TEXT(TODAY(), "yyyy-mm-dd"))