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...
Last modified 9d ago