Historical Candles (OHLCV)

Google Sheet & Excel
Airtable
Overview
The "price_history" formula returns a table of the daily Open, High, Low, Close & Volume (OHLCV) values for a given market. Both quote and base volumes are included.
​See supported exchanges.​
​
You can replace price_history with open_time, open, high, low and close to get individual values.

Example: =CRYPTOFINANCE("BTC/USD", "open") will only return the open price history.
​
Asset Pair
=CRYPTOFINANCE("BTC/USD", "price_history")
​
Specific exchange
=CRYPTOFINANCE("exchange_name:BTC/USD", "price_history")
Example:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history")
​
Specific NFT Collection
=CRYPTOFINANCE("market_place:nft_collection", "price_history")
Example:
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "price_history")
​
Specific period
=CRYPTOFINANCE("KRAKEN:BTC/USD:period", "price_history")
Example:
Note: When no exchange is specified, the market average price (VWAP) will be returned.
=CRYPTOFINANCE("KRAKEN:BTC/USD:1w", "price_history")
By default period is 1d.

Available periods:
1m 
3m
5m 
15m 
30m 
1h 
2h 
4h 
6h 
12h 
1d  (default)
3d 
1w
​
Specific time range
You can specify a time range to narrow or broaden your results. Compatible time ranges are listed below with examples. 6m (6 months) by default.
"Kraken":BTC/USD" is used as a placeholder for the exchange and market in the examples below. You can replace the market with Asset Pair (Ex: BTC/USD) or NFT Collection (Ex:OPENSEA:MUTANT-APE-YACHT-CLUB)
price_history is used as a placeholder. You can replace price_history with open_time, open, high, low or close.
Year:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "2021")
Returns market price history for 2021.
Quarter (1/4) of a year:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "2020Q3")
Returns market price history for Q3, 2020.
Month and year:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "2021-01")
Returns market price history for January, 2021.
Last month:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "1m")
Returns market price history for the previous 30 days from current date.
Last 3 months:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "3m")
Returns market price history for the previous 90 days from current date.
Last year: 
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "1y")
Returns market price history over the last 365 days from current date.
Last 2 years:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "2y")
Returns market price history over the last 730 days from current date).

Date range:  -  (space, dash and space) is used as separator between dates.
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "YYYY-MM-DD - YYYY-MM-DD")
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "2023-01-04 - 2023-01-23")
Date time range:  -  (space, dash and space) is used as separator between date times.
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "[email protected]:M - [email protected]:M")
=CRYPTOFINANCE("KRAKEN:BTC/USD:6h", "price_history", "[email protected]:00 - [email protected]:00")
Currently not available for Airtable. Coming soon...
Last modified 21d ago