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)







CS.EXRATE

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

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

  1. Streaming market VWAP price taken from whatever exchange(s) actively trade/quote the given pair from the 331+ supported exchanges for core data functions

  2. Fewer parameters (base, quote, refresh) but real time streaming prices

  3. Supported in both Excel & Googlesheets, (but live streaming prices using the refresh parameter is only supported in Excel)

CS.PRICE

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

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

  1. 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

  2. More parameters (base, quote, time, exchange, returnType)

  3. Supports historical prices from any date or time

  4. Supports specific exchange pricing (from the 331+ supported exchanges for core data functions)

  5. Supports specific price type or 'returnType' (ie bid, mid or ask price)

  6. Can be linked to CS.TIME in Excel for real time refresh or custom automatic refresh at anytime and interval

  7. Supported in both Excel & Googlesheets

CS.PRICEA

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

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

  1. 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

  2. Supports spot AND crypto derivatives instruments (ie futures, options, perpetuals, swaps, etc )

  3. More parameters (base, quote, time, exchange, returnType, type, details, symbolId, source)

  4. Supports using full string symbolId
    =CS.PRICEA("symbolId","KRAKENFTS_PERP_BTC_USD")

  5. Supports historical prices from any date or time

  6. Supports specific exchange pricing (from the 331+ supported exchanges for core data functions)

  7. Supports specific overrrides for default pricing source (CoinGecko, CryptoCompare, Messari)

  8. Supports specific price type or 'returnType' (ie bid, mid or ask price)

  9. Can be linked to CS.TIME in Excel for real time refresh or custom automatic refresh at anytime and interval

  10. Supported in both Excel & Googlesheets

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

Did this answer your question?