Links

Batch Formula

Google Sheets & Excel
Airtable
Batch formula feature allows you to fetch market data for multiple markets and attributes with a single call.

Exchange Market Data

Supported attributes
  • price
  • open
  • high
  • low
  • last
  • close
  • change
  • volume
  • volume_base
Example: Multiple markets with a single attribute CRYPTOFINANCE("kraken:btc/usd, binance:btc/usd", "price")
Example: Multiple markets with multiple attributes =CRYPTOFINANCE("kraken:btc/usd, binance:btc/usd", "price, open, high")
Example: Using Rows & Columns as reference =CRYPTOFINANCE(A2:A6, B1:D1)

VWAP Market Data

Supported attributes
  • price
  • marketcap
  • volume
  • name
  • rank
  • change
  • change_1m
  • change_1w
  • change_1y
  • change_6m
  • change_ytd
  • liquidity_ask
  • liquidity_bid
  • liquidity_ratio
Example: Multiple markets with a single attribute =CRYPTOFINANCE("btc/usd, eth/usd", "price") Example: Multiple markets with multiple attributes: =CRYPTOFINANCE("btc/usd, eth/usd", "price, volume, change")
Example: Using Rows & Columns as reference =CRYPTOFINANCE(A2:A6, B1:D1)
Not available for Airtable.