Blockchain Data
Markets Data
Order Books Data
Exchange Data
Disclaimer & Privacy
Historical OHLCV
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.
Specific exchange
=CRYPTOFINANCE("exchange_name:BTC/USD", "price_history")Example:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history")Note: Default exchange is Kraken when no exchange is specified.
Example below will display results for the
KRAKEN:BTC/USD market:=CRYPTOFINANCE("BTC/USD", "price_history")Specific exchange & period
You can specify a time period to narrow or broaden your results. Compatible time periods are listed below with examples.
"Kraken":BTC/USD" is used as a placeholder for the exchange and market in the examples below.Year:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "2021")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "price_history", "ytd")Returns market price history for 2021.
Quarter (1/4) of a year:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "2020Q3")=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "price_history", "2022Q1")Returns market price history for Q3, 2020.
Month and year:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "2021-01")=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "price_history", "2022-01")Returns market price history for January, 2021.
Last month:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "1m")=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "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")=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "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).
Last modified 6d ago
Copy link