Historical Data

Open Cryptowatch Create Account Pricing Contact Us

Search…

Historical Data

Overview
All historical data is sourced from the Cryptowatch API and the CryptoCompare Pro API.
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")
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
Getting 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.
For unlimited data and full historical listing a subscription is available.
OHLCV: Open, High, Low, Close prices and Volume
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")
Volume: =CRYPTOFINANCE("BTC/USD", "volume", "2018-12-25")
You can get the volume in the base currency (ei: BTC in BTC/USD) using =CRYPTOFINANCE("BTC/USD", "volume_base", "2018-12-25")
By default, using price will return the close price.
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")
Copied!
Using Google Sheets TODAY() function:
1
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price", TEXT(TODAY(), "yyyy-mm-dd"))
Copied!

Markets Data - Previous

Trade Data

Next - Markets Data

All-Time-Highs

Last modified 13d ago

Copy link

Contents

Overview

Referencing Cells to Build the Date

Example Using Google Sheets TODAY() Function

Quota and Limitation

OHLCV: Open, High, Low, Close prices and Volume

Exchange Specific