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
DEX (Decentralized Exchange) Data
NFT 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
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.
=CRYPTOFINANCE("KRAKEN", "exchange_volume")

Historical Exchange Volume

“Historical Exchange Volume” supports all the exchanges listed here except kraken-futures.
The syntax is as follows:
=CRYPTOFINANCE("KRAKEN", "exchange_volume", "2018-01-23")

Referencing date from a cell:

Say you have 2018-02-22 in cell B12:
=CRYPTOFINANCE("KRAKEN", "exchange_volume", TEXT(B12, "yyyy-mm-dd"))
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.
=CRYPTOFINANCE("KRAKEN", "exchange_rank")

Exchange Number of Markets

Returns the number of markets traded on the exchanges.
=CRYPTOFINANCE("KRAKEN", "market_count")

Exchange Number of Cryptocurrencies

Returns the number of cryptocurrencies being traded on the exchange.
=CRYPTOFINANCE("KRAKEN", "currency_count")

Exchange Number of Fiat Currencies

Returns the number of Fiat currencies being accepted on the exchange.
=CRYPTOFINANCE("KRAKEN", "fiat_count")

Exchange Website

Returns the exchange website address.
=CRYPTOFINANCE("KRAKEN", "exchange_website")

Exchange Twitter Account

Returns the exchange Twitter account.
=CRYPTOFINANCE("KRAKEN", "exchange_twitter")

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.
=CRYPTOFINANCE("exchange name here")
Example:
=CRYPTOFINANCE("KRAKEN")
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:
=CRYPTOFINANCE("KRAKEN:ETH/BTC")
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:
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "ask")

Best Bid Price

This will return the best Ethereum bid price in Bitcoin as currently available on the exchange's order book:
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "bid")

Last Trade Price

This call will return the Ethereum last-trade price in Bitcoin as it just happened on the exchange:
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "last")

24h Price Change

This call will return the Ethereum price change percentage in Bitcoin over the last 24h:
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "change")

Open Price

This call will return the Ethereum open price in Bitcoin as of 24h ago on the exchange:
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "open")

24h Highest Price

This call will return the highest Ethereum price in Bitcoin over the last 24h on the exchange:
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "high")

24h Lowest Price

This call will return the lowest Ethereum price in Bitcoin over the last 24h on the exchange:
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "low")

Close Price

This call will return the Ethereum last-trade price in Bitcoin as it just happened on the exchange:
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "close")
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:
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "volume")

Market Base Volume

This call will return the Ethereum trade volume in ETH over the last 24h on the exchange:
=CRYPTOFINANCE("KRAKEN:ETH/BTC", "volume_base")

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

=CRYPTOFINANCE("KRAKEN:ETH/BTC", "price", "2017-12-25")
Same thing as calling close.

Historical Open Price

=CRYPTOFINANCE("KRAKEN:ETH/BTC", "open", "2017-12-25")

Historical High Price

=CRYPTOFINANCE("KRAKEN:ETH/BTC", "high", "2017-12-25")

Historical Low Price

=CRYPTOFINANCE("KRAKEN:ETH/BTC", "low", "2017-12-25")

Historical Close Price

=CRYPTOFINANCE("KRAKEN:ETH/BTC", "close", "2017-12-25")

Historical Market Volume

=CRYPTOFINANCE("KRAKEN:ETH/BTC", "volume", "2017-12-25")

Historical Market Base Volume

=CRYPTOFINANCE("KRAKEN:ETH/BTC", "volume_base", "2017-12-25")

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"
  • "okx" (priorly "okex" — both work)
  • "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.
​

Decentralized Exchange (DEX) Data

Cryptofinance also supports DEX data. Click here for more information.
Markets Data - Previous
Return on Investment Data
Next
DEX (Decentralized Exchange) Data
Last modified 3mo ago
Copy link
Outline
Exchange Volume
Historical Exchange Volume
Exchange Rank
Exchange Number of Markets
Exchange Number of Cryptocurrencies
Exchange Number of Fiat Currencies
Exchange Website
Exchange Twitter Account
All Markets in One Listing
Exchange Market Data
Market Current Price
Best Ask Price
Best Bid Price
Last Trade Price
24h Price Change
Open Price
24h Highest Price
24h Lowest Price
Close Price
Market Volume
Market Base Volume
Exchange Historical Data
Historical Price
Historical Open Price
Historical High Price
Historical Low Price
Historical Close Price
Historical Market Volume
Historical Market Base Volume
Supported Exchanges
Decentralized Exchange (DEX) Data