Skip to main content
All CollectionsCustom Functions
What's the difference between CS.EXRATE vs. CS.PRICE vs. CS.PRICEA?
What's the difference between CS.EXRATE vs. CS.PRICE vs. CS.PRICEA?

Learn the differences between CS.EXRATE vs CS.PRICE vs. CS.PRICEA and when to use each one.

C
Written by Chris Ware
Updated over a week ago

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

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")

​

  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)
    ​
    ​

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
    ​

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?