Blockchain Data
Markets Data
Order Books Data
Exchange Data
Disclaimer & Privacy
Historical Data
Overview
Extending from price syntax, you can get a pair the market average price at a historical date with the following syntax:
1
=CRYPTOFINANCE("BTC/USD", "price", "2014-12-25")
2
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "price", "2022-01-15")
Copied!
The date must be following the format
YYYY-MM-DD, example: 2017-01-13.1
=CRYPTOFINANCE("BTC/USD", "price", "2014-12-25")
Copied!
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:1
=CRYPTOFINANCE(A1 & "/USD", "price", TEXT(A2, "yyyy-mm-dd"))
Copied!
Note: Here we use
& to concatenate (glue together) cells and text to forge the function’s argument.Example Using Google Sheets TODAY() Function
TODAY() FunctionGetting the price exactly 10 days ago, we use
TODAY()-10:1
=CRYPTOFINANCE("BTC/USD", "price", TEXT(TODAY()-10, "yyyy-mm-dd"))
Copied!
Quota and Limitation
Using CRYPTOFINANCE historical data for free and without any plan subscription is possible, but comes with following limitations:
- Historical data are available up to a quota of 100 calls per month per user.
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:1
=CRYPTOFINANCE("KRAKEN:BTC/USD", "open", "2015-11-02")
2
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "open", "2022-01-15")
Copied!
Using Google Sheets
TODAY() function:1
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price", TEXT(TODAY(), "yyyy-mm-dd"))
Copied!
Last modified 6d ago