Cryptowatch Data

Open Cryptowatch Create Account Pricing Contact Us

Search…

Cryptowatch Data

How to Get Cryptocurrency Prices and Data from Cryptowatch.

Full Market Listing
Note: This Cryptowatch data requires a subscription, see here for more info.
This allows your to get all market average data with 1 formula.
1
=CRYPTOFINANCE("CRYPTOWATCH")
Copied!
This will create as many rows as there are coins tracked on Cryptowatch.
You can create sticky references on any data points from this full listing. See here for an example.
These market average prices (VWAP) are computed using prices from all major exchanges.
Market Specific Data
Market Average Prices (VWAP)
Call the function with =CRYPTOFINANCE("XXX/YYY") where XXX is the base currency symbol (eg. BTC , ETH, DASH , etc.), and YYY is the quote currency (eg. USD , EUR , GBP , etc.)
Examples:
=CRYPTOFINANCE("BTC/USD") returns the current rate of Bitcoin in US Dollar, same thing as calling =CRYPTOFINANCE("BTC/USD", "price").
=CRYPTOFINANCE("ETC/EUR") returns the current rate of Ethereum Classic in Euro, same thing as calling =CRYPTOFINANCE("ETC/EUR", "price").
=CRYPTOFINANCE("DASH/CAD") returns the current rate of Dash in Canadian Dollar, same thing as calling =CRYPTOFINANCE("DASH/CAD", "price").
MarketCap
Call the function =CRYPTOFINANCE("XXX/YYY", "marketcap") to get the marketcap of the XXX currency in the YYY currency. By default if YYY is not provided USD will be used.
Examples:
=CRYPTOFINANCE("BTC", "marketcap") will return the Bitcoin marketcap in US Dollar. This is similar to calling =CRYPTOFINANCE("BTC/USD", "marketcap") .
=CRYPTOFINANCE("ETH/EUR", "marketcap") will return the Ethereum marketcap in Euro.
24h Volume
Call the function =CRYPTOFINANCE("XXX/YYY", "volume") to get the volume in the last 24 hours for the currency XXX in the currency YYY . By default if YYY is not provided USD will be used.
Examples:
=CRYPTOFINANCE("LTCEUR", "volume") will return the LiteCoin 24h volume in Euro.
=CRYPTOFINANCE("BTC/USD", "volume") will return the Bitcoin 24h volume in US Dollar. Similar to calling =CRYPTOFINANCE("BTC", "volume") .
Change Percentage
Call the function=CRYPTOFINANCE("XXX", "change", "PERIOD") to get the percentage change over the period PERIOD in USD.
PERIOD can take 6 values: 24h (24 hours), 1w (7 days), 1m (1 month), 6m (6 months), ytd (since Jan 1st of current year), 1y (1 year). If no PERIOD argument is given, the default is 24h.
Examples:
=CRYPTOFINANCE("BTC", "change") will return the change percentage of Bitcoin over the last 24 hours in USD. Similar to calling =CRYPTOFINANCE("BTC", "change", "24h")
=CRYPTOFINANCE("ETH", "change", "ytd") will return the change percentage of Ethereum in USD since January 1st of the current year.
=CRYPTOFINANCE("DASH", "change", "1w") will return the change percentage of Dash over the last 7 days in USD.
Currency Rank
Call the function =CRYPTOFINANCE("XXX", "rank") to get the currency XXX rank, based on its 24h Volume (USD), as returned by Cryptowatch. 
More info on how Cryptowatch ranking works.
Currency Full Name
Call the function =CRYPTOFINANCE("XXX/USD", "name") to get the currency XXX full name, as returned by Cryptowatch.
Examples:
=CRYPTOFINANCE("BTC/USD", "name") will return Bitcoin.
=CRYPTOFINANCE("BCH/USD", "name") will return Bitcoin Cash.
=CRYPTOFINANCE("BSV/USD", "name") will return BitcoinSV.

Blockchain Data - Previous

Bitcoin and Cryptocurrency Network Data in Google Sheets

Next - Markets Data

Exchanges Data

Last modified 1mo ago

Copy link

Contents

Full Market Listing

Market Specific Data

Market Average Prices (VWAP)