Batch Formula
Google Sheets & Excel
Airtable
Batch formula feature allows you to fetch market data for multiple markets and attributes with a single call.
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)

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.
Last modified 6mo ago