=CS.PRICEA

Use Case Scenarios

PRICEA - Syntax

Function arguments

Function argume...

PARAMETERS - Ab...

PRICEA - Examples

Troubleshooting

Additional Reso...

## =CS.PRICEA

In its simplest form, the PRICEA function says
```
=CS.PRICEA(what base asset, what quoted asset, at what date or time, from what exchange, for which price type, for what instrument type, with what details)
```

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-syntax.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-autocomplete.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/google/functions/csPRICEA-autocomplete.png)


### Use Case Scenarios
> Use =CS.PRICEA() when you need maximum flexibility across all available assets, derivative instruments and dimensions. When you need to quickly pull in the latest price for specific assets, pairs or derivative instruments or the historical price at specific times from specific exchanges. This function is a more advanced & flexible version of the original CS.PRICE custom function. The main differences are that **CS.PRICEA allows users to query for current or historical data across ALL crypto spot assets AND derivative instruments**. The other major difference is that CS.PRICEA allows users to specify three additional parameter fields for `type`, `details` and/or `symbolId`. Using `symbolId` gives the additional option of specifying the entire symbol and details as one value instead of multiple parameters which is a common practice with professional derivatives traders.


PRICEA can take any combination of any parameters and/or <linkify text="Global Arguments"></linkify> and in any order as long as each input and value are paired. It also allows you to combine relative and absolute references in the same input and value pairs without having to use a nested array wrapped in {curly brackets}. This seemingly minor detail is incredibly important in the certain situations making CS.PRICEA a powerful tool to have.


---

## PRICEA - Syntax
### Function arguments
	
Arguments: `=CS.PRICEA("base","quote","time","exchange","returnValue","type","details","symbolId","source")
`
	
Example Values: `=CS.PRICEA("base","BTC","quote","USD","time","1/1/2020","exchange","KRAKENFTS","returnValue","ask","type","PERPETUAL")`

### Function argument descriptions

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-syntax-autocomplete.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-syntax-example.gif)

- **base**: [OPTIONAL] The cryptocurrency symbol of interest [string]
- **quote**: [OPTIONAL] Cryptocurrency symbol to convert into [string]
- **time**: [OPTIONAL] Time at which exchange rate is calculated (if not supplied then current rate is returned) [string]
- **exchange**: [OPTIONAL] Name of the supported exchange (ie KRAKENFTS use CS.EXCHANGES for full list) [string]
- **returnValue**: [OPTIONAL] The price type to return (ie bid, mid or ask) Note: this is **required** when specifying an `exchange` explicitly [string]
- **type**: [OPTIONAL] The asset or instrument type (ie FUTURES, OPTION, PERPETUAL etc) [string]
- **details**: [OPTIONAL] Details of the instrument if applicable (ie futures expiration or option strike price) [string]
- **symbolId**: [OPTIONAL] Concatenated symbol string including exchange, base, quote, type & details (ie KRAKENFTS_PERP_ETH_USD) [string]
- **source**: [OPTIONAL] Explicit pricing source including support for CoinGecko, CryptoCompare and Messari [string]
- **address**: [OPTIONAL] Explicit contract address string for the supported network. NOTE: This parameter will only work when `source` is specified as `coingecko` [string]
- **globalArgs** [OPTIONAL] Global arguments available on all functions. See https://docs.cryptosheets.com/functions/common for all available options.

### PARAMETERS - Absolute vs. Relative
**Absolute Parameter Values**

Formulas using absolute values for arguments with multiple parameters using CS.PRICEA can be referenced anywhere in the formula query string as long as they are paired together:

`=CS.PRICEA("base","BTC","quote","USD","time","1/1/2020","exchange","KRAKENFTS","returnValue","ask","type","PERPETUAL")`

**Relative Parameter Values**

Formulas using referenced values for arguments with multiple parameters using CS.PRICEA can be referenced anywhere and in any order within the formula query string as long as they are paired together:

`=CS.PRICEA("A1","B1","A2","B2","C3","C3",...)`

**Combining Relative AND Absolute Parameter Values**

One of the features about CS.PRICEA vs CS.PRICE that makes it so flexible is the ability to combine any configuration of relative and absolute values at any point in the formula query string without being bound by {"nested:arrays"} as long as they are paired together:

`=CS.PRICEA("base","A1","quote","A2","time","A3",...)`


![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-relative-cells.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-relative-example.gif)

<a href="https://docs.cryptosheets.com/metadata/" rel="noopener noreferrer" target="_blank">Click here</a> to search for supported assets & exchanges

---

## PRICEA - Examples

**TIP**: _Try copying + pasting the example formulas directly into your worksheet_

**Example 1:**

_Excel_

> <inline-code functionvalue='=CS.PRICEA("base","ADA","quote","USD","exchange","BINANCEFTSC","type","FUTURES","details","001225")'>=CS.PRICEA("base","ADA","quote","USD","exchange","BINANCEFTSC","type","FUTURES","details","001225")</inline-code>

_Googlesheets_

> <inline-code functionvalue='=CSPRICEA("base","ADA","quote","USD","exchange","BINANCEFTSC","type","FUTURES","details","001225")'>=CSPRICEA("base","ADA","quote","USD","exchange","BINANCEFTSC","type","FUTURES","details","001225")</inline-code>

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-example1.png)

**Example 2:**

_Excel_

> <inline-code functionvalue='=CS.PRICEA("base","ETH","quote","USD","exchange","DERIBIT","type","OPTION","details","200828-400-C")'>=CS.PRICEA("base","ETH","quote","USD","exchange","DERIBIT","type","OPTION","details","200828-400-C")</inline-code>

_Googlesheets_

> <inline-code functionvalue='=CSPRICEA("base","ETH","quote","USD","exchange","DERIBIT","type","OPTION","details","200828-400-C")'>=CSPRICEA("base","ETH","quote","USD","exchange","DERIBIT","type","OPTION","details","200828-400-C")</inline-code>

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-example2.png)

**Example 3:**

_Excel_

> <inline-code functionvalue='=CS.PRICEA("symbolId","KRAKENFTS_PERP_ETH_USD")'>=CS.PRICEA("symbolId","KRAKENFTS_PERP_ETH_USD")</inline-code>

_Googlesheets_

> <inline-code functionvalue='=CSPRICEA("symbolId","KRAKENFTS_PERP_ETH_USD")'>=CSPRICEA("symbolId","KRAKENFTS_PERP_ETH_USD")</inline-code>

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-example3.png)

**Example 4:**

_Excel_

> <inline-code functionvalue='=CS.PRICEA("symbolId","DERIBIT_OPT_ETH_USD_200828_400_C")'>=CS.PRICEA("symbolId","DERIBIT_OPT_ETH_USD_200828_400_C")</inline-code>

_Googlesheets_

> <inline-code functionvalue='=CSPRICEA("symbolId","DERIBIT_OPT_ETH_USD_200828_400_C")'>=CSPRICEA("symbolId","DERIBIT_OPT_ETH_USD_200828_400_C")</inline-code>

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-example4.gif)

**Example 5:**

_Excel_

> <inline-code functionvalue='=CS.PRICEA("symbolId","KRAKENFTS_PERP_ETH_USD")'>=CS.PRICEA("symbolId","KRAKENFTS_PERP_ETH_USD")</inline-code>

_Googlesheets_

> <inline-code functionvalue='=CSPRICEA("symbolId","KRAKENFTS_PERP_ETH_USD")'>=CSPRICEA("symbolId","KRAKENFTS_PERP_ETH_USD")</inline-code>

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-example5.gif)

**Example 6 - Using CryptoCompare for Default Pricing:**

_Excel_

> <inline-code functionvalue='=CS.PRICEA("base","BTC","quote","USD","source","cryptocompare","exchange","coinbase")'>=CS.PRICEA("base","BTC","quote","USD","source","cryptocompare","exchange","coinbase")</inline-code>

_Googlesheets_

> <inline-code functionvalue='=CSPRICEA("base","BTC","quote","USD","source","cryptocompare","exchange","coinbase")'>=CSPRICEA("base","BTC","quote","USD","source","cryptocompare","exchange","coinbase")</inline-code>

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-cryptocompare.gif)

**Example 7 - Using CoinGecko for Default Pricing:**

_Excel_

> <inline-code functionvalue='=CS.PRICEA("base","BTC","quote","USD","source","coingecko","exchange","ftx_spot")'>=CS.PRICEA("base","BTC","quote","USD","source","coingecko","exchange","ftx_spot")</inline-code>

_Googlesheets_

> <inline-code functionvalue='=CSPRICEA("base","BTC","quote","USD","source","coingecko","exchange","ftx_spot")'>=CSPRICEA("base","BTC","quote","USD","source","coingecko","exchange","ftx_spot")</inline-code>

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-coingecko.gif)

**Example 8 - Using CoinGecko by Contract Address for Default Pricing:**

_Excel_

> <inline-code functionvalue='=CS.PRICEA("base","ETH","quote","USD","source","coingecko","address","0xc00e94cb662c3520282e6f5717214004a7f26888")'>=CS.PRICEA("base","ETH","quote","USD","source","coingecko","address","0xc00e94cb662c3520282e6f5717214004a7f26888")</inline-code>

_Googlesheets_

> <inline-code functionvalue='=CSPRICEA("base","ETH","quote","USD","source","coingecko","address","0xc00e94cb662c3520282e6f5717214004a7f26888")'>=CSPRICEA("base","ETH","quote","USD","source","coingecko","address","0xc00e94cb662c3520282e6f5717214004a7f26888")</inline-code>

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-coingecko-contract-address.gif)

**Example 9 - Using Messari for Default Pricing:**

_Excel_

> <inline-code functionvalue='=CS.PRICEA("base","ETH","source","messari")'>=CS.PRICEA("base","ETH","source","messari")</inline-code>

_Googlesheets_

> <inline-code functionvalue='=CSPRICEA("base","ETH","source","messari")'>=CSPRICEA("base","ETH","source","messari")</inline-code>

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPRICEA-messari.gif)

### Troubleshooting

1. Check your formula syntax for carefully, different functions for the same data may have slightly different required syntax
2. Check the **required arguments** for your function vs the **optional arguments**
3. Check your data & API quotas and limits
4. Check your formulas carefully
5. Check your relative references
6. Use Excels **error checking tools**
7. <a href="https://support.office.com/en-us/article/function-arguments-65b29fb5-ec7b-4c0b-a54b-a67923571519" rel="noopener noreferrer" target="_blank">Check Excels help sections</a>
8. Error Response Codes Reference

   - **#N/A** OK – Everything worked as expected
   - **#BUSY** Heavy query and/or unauthorized – Your User/Password API Keys are incorrect
   - **#LIMIT** Forbidden – You are not subscribed to the data feed requested
   - **Other** Something else? Reach out to us directly

## Additional Resources

_For Microsoft Excel_

- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/browsers-used-by-office-web-add-ins" rel="noopener noreferrer" target="_blank">Web browsers used by add-ins</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets" rel="noopener noreferrer" target="_blank">Office versions and requirement sets</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets#how-to-check-your-office-version" rel="noopener noreferrer" target="_blank">How to check your Office version</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/install-latest-office-version" rel="noopener noreferrer" target="_blank">Install the latest version of Office</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture" rel="noopener noreferrer" target="_blank">Custom Function Requirements</a>

_For Googlesheets_

- <a href="https://developers.google.com/apps-script/guides/services/quotas" rel="noopener noreferrer" target="_blank">Throughput Quotas & Limits</a>

Use the PRICEA function to get the current or historical bid, mid or ask exchange rate between a pair of requested assets or derivative including futures, options & perpetuals at a specific date or timestamp and from a specific exchange

How to use PRICEA in Excel & Googlesheets

PRICEA