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 streaming but less flexible
  • CS.PRICE is not live but not streaming and is significantly more configurable and flexible
  • CS.PRICEA is the same as CS.PRICE but can also pull current/historical prices for ANY crypto derivatives instruments (ie futures, options etc)

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 306+ 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 306+ 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 306+ 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 306+ 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)
  4. Supports using full string symbolId =CS.PRICEA("
  5. Supports historical prices from any date or time
  6. Supports specific exchange pricing (from the 306+ supported exchanges for core data functions)
  7. Supports specific price type or 'returnType' (ie bid, mid or ask price)
  8. Can be linked to CS.TIME in Excel for real time refresh or custom automatic refresh at anytime and interval
  9. Supported in both Excel & Googlesheets
Did this answer your question?