Cryptofinance
Open CryptowatchCreate AccountPricingContact Us
Search…
Getting Started
Pricing
Markets Data
Cryptowatch Data
Trade Data
Historical Data
Historical OHLCV
All-Time-Highs
Market Macro Data
Return on Investment Data
Exchange Data
Exchange Data
Batch Formula
Supported Exchanges
Cryptowatch Portfolio Data
Holdings
Trades
Orders
Order Books Data
Markets Liquidity
Market Order Book
Blockchain Data
Bitcoin and Cryptocurrency Network Data in Google Sheets
Advanced
Best Practices in Google Sheets
How to Refresh Rates with CRYPTOFINANCE in Google Sheets
Advanced Usage and Tips in Google Sheets
Things to Know
Disclaimer & Privacy
Risk Disclaimer
Privacy Statement
Terms of Service
Powered By GitBook
Historical Data

Overview

All historical data is sourced from the Cryptowatch API.
Extending from price syntax, you can get a pair the market average price at a historical date with the following syntax:
=CRYPTOFINANCE("BTC/USD", "price", "2014-12-25")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "price", "2022-01-15")
The date must be following the format YYYY-MM-DD, example: 2017-01-13.
=CRYPTOFINANCE("BTC/USD", "price", "2014-12-25")
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:
=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.

Example Using Google Sheets TODAY() Function

Getting the price exactly 10 days ago, we use TODAY()-10:
=CRYPTOFINANCE("BTC/USD", "price", TEXT(TODAY()-10, "yyyy-mm-dd"))

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.

OHLC: Open, High, Low, Close prices

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")

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:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "open", "2015-11-02")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "open", "2022-01-15")
Using Google Sheets TODAY() function:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price", TEXT(TODAY(), "yyyy-mm-dd"))
Markets Data - Previous
Trade Data
Next - Markets Data
Historical OHLCV
Last modified 2mo ago
Copy link
Outline
Overview
Referencing Cells to Build the Date
Example Using Google Sheets TODAY() Function
Quota and Limitation
OHLC: Open, High, Low, Close prices
Exchange Specific