Historical Data
Google Sheet & Excel
Airtable
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).
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.
Getting the price exactly 10 days ago, we use
TODAY()-10
:=CRYPTOFINANCE("BTC/USD", "price", TEXT(TODAY()-10, "yyyy-mm-dd"))
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")
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