Cryptowatch Data
How to Get Cryptocurrency Prices and Data from Cryptowatch.
Google Sheet & Excel
Airtable
This allows you to get all market average data (
price
, volume
, & market_cap
) with 1 formula:=CRYPTOFINANCE("CRYPTOWATCH")
The default currency is
USD
. You can specify a different quote currency (fiat or crypto).
Examples:
=CRYPTOFINANCE("CRYPTOWATCH", "EUR")
=CRYPTOFINANCE("CRYPTOWATCH", "ADA")
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.

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")
.
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.
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")
.
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.
Call the function
=CRYPTOFINANCE("XXX", "rank")
to get the currency XXX
rank, based on its 24h Volume (USD), as returned by Cryptowatch.
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.
This allows you to get all volume weighted average price, market cap, change, rank and liquidity across multiple exchanges.
1. From the sidebar click Asset Data.
2. Make sure All Markets is selected as Type.
3. Click run.

You can fetch the following data for the specific assets:
- Price
- Market cap
- Volume 24H
- Name
- Rank
- Change 1 month
- Change 1 week
- Change 1 year
- Change 24 hour
- Change 6 month
- Change YTD
- Liquidity Ask
- Liquidity Bid
- Liquidity ratio
1. From the sidebar click Asset Data.
2. Make sure Specific Markets is selected as Type.
3. Select Market Field which points to the field where you entered the asset symbols.
4. Select the metrics you want to fetch.
5. Click run.

Quickly convert the price of any crypto asset from one currency to another.
1. From the sidebar click Currency Convert.
2. Select From Currency Field which points to the field where you entered the base asset symbols.
3. Select To Currency Field which points to the field where you entered the quote asset symbols.
4. Click run.

Last modified 1mo ago