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")
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).
Last modified 19d ago