Links

Historical Data

Google Sheet & Excel
Airtable

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")
Currently not available for Airtable. Coming soon...