Links

Exchange Data

Pricing: The data points exchange volume, exchange rank, currency count, market count, fiat count, fiats, exchange website and exchange twitter requires derivative subscription plan. Other data points require standard subscription plan.
Google Sheet & Excel
Airtable
All examples in this page will substitute "KRAKEN" as the exchange.
Click here to see the list of all compatible exchanges.

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).
  • open interest, the total number of outstanding derivative contracts that have not been settled
  • funding rate, represented as percentage.
  • funding rate date
  • predicted funding rate, the estimate of what the funding rate will be at the end of the current funding interval. Some exchanges refer to this as the real-time funding rate or the next funding rate. Represented as percentage.
  • predicted funding rate date
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")

Open Interest

=CRYPTOFINANCE("kraken-futures:btc/usd-future-multi-perpetual", "open_interest")

Funding Rate

=CRYPTOFINANCE("kraken-futures:btc/usd-future-multi-perpetual", "funding_rate")

Funding Rate Date

=CRYPTOFINANCE("kraken-futures:btc/usd-future-multi-perpetual", "funding_rate_date")

Predicted Funding Rate

=CRYPTOFINANCE("kraken-futures:btc/usd-future-multi-perpetual", "funding_rate_predicted")

Predicted Funding Rate Date

=CRYPTOFINANCE("kraken-futures:btc/usd-future-multi-perpetual", "funding_rate_predicted_date")

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")
Cryptofinance also supports DEX & NFT data.

Full Market Listing

List of all markets on an exchange along with each market's data points.
1. From the sidebar click Exchange Data. 2. Select a CEX. (Click here to see list of CEX) 3. Make sure All Markets is selected as Type. 4. Click run.

Market Specific Data

You can fetch the following data for the specific markets:
  • Price
  • Open
  • High
  • Low
  • Close
  • Change 24H
  • Volume
  • Volume Base
1. From the sidebar click Exchange Data. 2. Select a CEX. (Click here to see list of CEX) 3. Make sure Specific Markets is selected as Type. 4. Select Market Field which points to the field where you entered the market pairs. (Example pair: BTC/USD.) 5. Select the metrics you want to fetch. 6. Click run.