What's the difference between CS.EXRATE vs CS.PRICE vs. CS.PRICEA?

Great question! We designed our custom functions to maximize ease of use and be flexible for different user case scenarios. TLDR:

CS.EXRATE is live and real-time streaming but less flexible
CS.PRICE is not live but not streaming, can pull current/historical prices, specific market price type and is significantly more configurable and flexible
CS.PRICEA can do all the same things CS.PRICE can do but can also pull current/historical prices for ANY crypto derivatives instruments (ie futures, options etc) and supports the efficient symbolId parameter for advanced users;
👉 PRICEA also now supports default source overrides for CoinGecko, CryptoCompre & Messari

Overview Comparison

functionality	EXRATE	PRICE	PRICEA
live, current price	✅	✅	✅
live, streaming prices	✅ (streaming only in Excel)*	❌	❌
live, automatic refresh (using CS.TIME)	❌	✅ (CS.TIME in Excel only)*	✅ (CS.TIME in Excel only)*
global VWAP as default/fallback	✅	✅	✅
specific pricing from over 331+ exchanges	❌	✅	✅
default price source overrides (for CoinGecko, CryptoCompare, Messari)	❌	❌	✅
historical prices by date/time	❌	✅	✅
supports single string `symbolId` parameter	❌	❌	✅
supports the `source` parameter	❌	❌	✅
market price type (bid/mid/ask)	❌	✅	✅
derivatives live, current pricing (futures, options, perpetuals, swaps, index, credit)	❌	❌	✅
derivatives historical pricing by date/time (futures, options, perpetuals, swaps, index, credit)	❌	❌	✅

Excel: =CS.EXRATE("BTC","USDT","1")

Googlesheets: =CSEXRATE("BTC","USDT")

Streaming market VWAP price taken from whatever exchange(s) actively trade/quote the given pair from the 331+ supported exchanges for core data functions
Fewer parameters (base, quote, refresh) but real time streaming prices
Supported in both Excel & Googlesheets, (but live streaming prices using the refresh parameter is only supported in Excel)

Excel: =CS.PRICE("BTC","USD","1/1/2020","COINBASE","BID")

Googlesheets: =CSPRICE("BTC","USD","1/1/2020","COINBASE","BID")

Current/most recent prices including a market VWAP by default with pricing taken from whatever exchange(s) actively trade/quote the given pair from the 331+ supported exchanges for core data functions
More parameters (base, quote, time, exchange, returnType)
Supports historical prices from any date or time
Supports specific exchange pricing (from the 331+ supported exchanges for core data functions)
Supports specific price type or 'returnType' (ie bid, mid or ask price)
Can be linked to CS.TIME in Excel for real time refresh or custom automatic refresh at anytime and interval
Supported in both Excel & Googlesheets

Excel: =CS.PRICEA("symbolId","KRAKENFTS_PERP_ETH_USD")

Googlesheets: =CS.PRICEA("symbolId","KRAKENFTS_PERP_ETH_USD")

Current/most recent prices including a market VWAP by default with pricing taken from whatever exchange(s) actively trade/quote the given pair from the 331+ supported exchanges for core data functions
Supports spot AND crypto derivatives instruments (ie futures, options, perpetuals, swaps, etc )
More parameters (base, quote, time, exchange, returnType, type, details, symbolId, source)
Supports using full string symbolId
=CS.PRICEA("symbolId","KRAKENFTS_PERP_BTC_USD")
Supports historical prices from any date or time
Supports specific exchange pricing (from the 331+ supported exchanges for core data functions)
Supports specific overrrides for default pricing source (CoinGecko, CryptoCompare, Messari)
Supports specific price type or 'returnType' (ie bid, mid or ask price)
Can be linked to CS.TIME in Excel for real time refresh or custom automatic refresh at anytime and interval
Supported in both Excel & Googlesheets

TAGS: #csprice, #cs.price, #cs.exrate, #exrate, #csexrate, #cspricea, #streaming, #refresh, #cs.pricea, #live