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