Batch Formula

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)

Last modified 3mo ago