How to use =CS.PRICE or =CSPRICE in Cryptosheets for Excel of Googlesheets

see the full Cryptosheets docs page here

In its simplest form, the PRICE function says

=CS.PRICE(what base asset, what quoted asset, at what date or time, from what exchange, which type of price)



Use Case Scenarios

When you need to quickly pull in the latest price for specific assets pairs or the historical price at specific times

PRICE - Syntax

Function arguments

Arguments: =CS.PRICE("base","quote","time", "exchange", "returnValue")

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





Function argument descriptions

  • base: The cryptocurrency symbol of interest. [string] required

  • quote: Cryptocurrency symbol to convert into [string] required

  • time: Time at which exchange rate is calculated. (Optional, if not supplied then current rate is returned) [string] optional

  • exchange: Exchange to retrieve rate from. (Optional, if not supplied then current vwap rate is returned) [string] optional

  • returnValue: Return value of rate. (Optional, when is exchange is specified. If not supplied, the mid price is returned. Possible values include mid, ask, bid.) [string] optional

PARAMETERS - Absolute vs. Relative

Absolute Parameter Values

Formulas using absolute values for arguments with multiple parameters must be referenced inside an array using {"curly_brackets"} and will look like this:

Excel =CS.PRICE("BTC","USD","1/1/2020")
Googlesheets =CSPRICE("BTC","USD","1/1/2020")

Relative Parameter Values

Formulas using referenced values for arguments with multiple parameters must be referenced inside an array using a defined range and will look like this (*Note - {"curly_brackets"} are NOT required when using referenced values):

Excel =CS.PRICE("A1","A2","A3")
Googlesheets =CSPRICE("A1","A2","A3")


Click here to search for data providers and endpoints

PRICE - Examples

TIP: Try copying + pasting the example formulas directly into your worksheet

Example 1:

Excel =CS.PRICE("BTC","USD")
Googlesheets =CSPRICE("BTC","USD")

Example 2:

Excel =CS.PRICE("ETH","USD","2019-01-01")
Googlesheets =CSPRICE("ETH","USD","2019-01-01")

Example 3:

Excel =CS.PRICE("BTC","USD","2011-01-01")
Googlesheets =CSPRICE("BTC","USD","2011-01-01")

Example 4:

Excel =CS.PRICE("BTC","USD","2011-01-01","COINBASE","BID")
Googlsheets =CSPRICE("BTC","USD","2011-01-01","COINBASE","BID")

TAGS: csprice, cs.price. =cs.price, =csprice, #NAME?, #ERROR!, custom functions, exchange, bid, ask, historical, bitcoin price, btc price, exchange rate

Did this answer your question?