Exchange Data

Open Cryptowatch Create Account Pricing Contact Us
Search…
Exchange Data
All examples in this page will substitute "KRAKEN" as the exchange. 
The list of all compatible exchanges is at the end of this page.
Exchange Volume
Returns the 24h volume traded on the exchange, as reported by the exchange, in USD.
1
=CRYPTOFINANCE("KRAKEN", "exchange_volume")
Copied!
Historical Exchange Volume
“Historical Exchange Volume” supports all the exchanges listed here except kraken-futures. 
The syntax is as follows:
1
=CRYPTOFINANCE("KRAKEN", "exchange_volume", "2018-01-23")
Copied!
Referencing date from a cell:
Say you have 2018-02-22 in cell B12:
1
=CRYPTOFINANCE("KRAKEN", "exchange_volume", TEXT(B12, "yyyy-mm-dd"))
Copied!
Note: Historical data falls into the Historical Data quota of 25 calls per day per user.
Exchange Rank
Returns the exchange rank, computed from its marketcap relative to other exchanges.
1
=CRYPTOFINANCE("KRAKEN", "exchange_rank")
Copied!
Exchange Number of Markets
Returns the number of markets traded on the exchanges.
1
=CRYPTOFINANCE("KRAKEN", "market_count")
Copied!
Exchange Number of Cryptocurrencies
Returns the number of cryptocurrencies being traded on the exchange.
1
=CRYPTOFINANCE("KRAKEN", "currency_count")
Copied!
Exchange Number of Fiat Currencies
Returns the number of Fiat currencies being accepted on the exchange.
1
=CRYPTOFINANCE("KRAKEN", "fiat_count")
Copied!
Exchange Website
Returns the exchange website address.
1
=CRYPTOFINANCE("KRAKEN", "exchange_website")
Copied!
Exchange Twitter Account
Returns the exchange Twitter account.
1
=CRYPTOFINANCE("KRAKEN", "exchange_twitter")
Copied!
All Markets in One Listing
This function call will return the list of all markets on an exchange along with each market's data points. It is recommended to use this to avoid the Google Sheets imposed API call quota.
1
=CRYPTOFINANCE("exchange name here")
Copied!
Example:
1
=CRYPTOFINANCE("KRAKEN")
Copied!
The following market data will be returned:
last_updated, when the data has been fetched from the exchange, timezone is UTC time.
market, the market name following the syntax BASE/QUOTE.
price, the current price, either the last trade price when available or the current ask price.
open, the 24h open price.
high, the 24h high price.
low, the 24h low price.
close, the 24h close price, often the same as the last price.
last, the price of the last trade.
change 24h, the price change in percentage over the last 24h.
volume, the volume traded over the last 24h in quote currency (USD in BTC/USD).
volume_base, the volume traded over the last 24h in base currency (BTC in BTC/USD).
Notes:
 When the exchange doesn’t provide a given market data, a hyphen (-) will be shown.
Exchange Market Data
The following examples will use "KRAKEN" as the queried exchange. 
The full list of available exchanges is at the end of this page.
Market Current Price
This will return the Ethereum price in Bitcoin on the exchange:
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC")
Copied!
This gives the same result as calling =CRYPTOFINANCE("KRAKEN:ETH/BTC", "price").
Best Ask Price
This will return the best Ethereum ask price in Bitcoin as currently available on the exchange's order book:
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "ask")
Copied!
Best Bid Price
This will return the best Ethereum bid price in Bitcoin as currently available on the exchange's order book:
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "bid")
Copied!
Last Trade Price
This call will return the Ethereum last-trade price in Bitcoin as it just happened on the exchange:
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "last")
Copied!
24h Price Change
This call will return the Ethereum price change percentage in Bitcoin over the last 24h:
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "change")
Copied!
Open Price
This call will return the Ethereum open price in Bitcoin as of 24h ago on the exchange:
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "open")
Copied!
24h Highest Price
This call will return the highest Ethereum price in Bitcoin over the last 24h on the exchange:
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "high")
Copied!
24h Lowest Price
This call will return the lowest Ethereum price in Bitcoin over the last 24h on the exchange:
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "low")
Copied!
Close Price
This call will return the Ethereum last-trade price in Bitcoin as it just happened on the exchange:
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "close")
Copied!
This gives the same result as calling =CRYPTOFINANCE("KRAKEN:ETH/BTC", "last").
Market Volume
This call will return the Ethereum trade volume in Bitcoin over the last 24h on the exchange:
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "volume")
Copied!
Market Base Volume
This call will return the Ethereum trade volume in ETH over the last 24h on the exchange:
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "volume_base")
Copied!
Exchange Historical Data
The following examples will use "KRAKEN" as the queried exchange. 
The full list of available exchanges is at the end of this page.
Historical prices are available on daily and hourly candles, including open, high, low, close, volume and volume_base.
ProTip: See here for how to reference other cells to build the date or specifying the hour.
Historical Price
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "price", "2017-12-25")
Copied!
Same thing as calling close.
Historical Open Price
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "open", "2017-12-25")
Copied!
Historical High Price
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "high", "2017-12-25")
Copied!
Historical Low Price
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "low", "2017-12-25")
Copied!
Historical Close Price
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "close", "2017-12-25")
Copied!
Historical Market Volume
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "volume", "2017-12-25")
Copied!
Historical Market Base Volume
1
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "volume_base", "2017-12-25")
Copied!
Supported Exchanges
"binance"
"binance-us"
"bisq"
"bitbay"
"bitfinex"
"bitflyer"
"bithumb"
"bitmex"
"bitstamp"
"bittrex"
"cexio"
"coinbase-pro" (coinbase is transparently mapped to coinbase-pro)
"coinone"
"deribit"
"ftx"
"ftx-us"
"gateio"
"gemini"
"hitbtc"
"huobi"
"kraken"
"kraken-futures"
"kucoin"
"liquid"
"luno"
"okcoin"
"okex"
"poloniex"
"uniswap-v2"
"zonda" (priorly "bitbay" — both work)
Coinbase is like a brokerage with a virtual wallet, whereas Coinbase Pro works as an exchange where people buy and sell from each other. “coinbase” and “coinbase-pro” will return the same results.
Order Books Data - Previous
Market Order Book
Next - Disclaimer & Privacy
Risk Disclaimer
Last modified 20d ago