=CS.PARAMETERS()

Scenario

Function arguments

Function argume...

Examples

Troubleshooting

Additional Reso...


## =CS.PARAMETERS()

In its simplest form, the CS.PARAMETERS function says
**=CS.PARAMETERS(name of provider**, **name of endpoint you want to return all of the possible parameters for**)

### Scenario

Use **=CS.PARAMETERS()** when you need to quickly lookup the custom functions profile of a specific provider's endpoint to check what the parameters are. This function is a helpful reference for beginners learning the particular arguments and syntax of specific provider endpoints. It can also be very handy for advanced users working with multiple providers and endpoints that need a quick reference tool.

### Function arguments

1. _Arguments:_ **=CS.PARAMETERS("provider", "endpoint")**
2. _Values:_ `=CS.PARAMETERS("CryptUnit", "earnings-auto")`

   > **NOTE**: arguments like additional parameters that are wrapped in **brackets** **[like this]** are **optional**, all other arguments should be considered **required**

### Function argument descriptions

- **provider**: Data provider, ex. Cryptunit (required)
- **endpoint**: Data endpoint of provider, ex. 'earnings-auto' (required)

[Click **here**](https://app.cryptosheets.com/#/browse) to search for data providers and endpoints

![image](https://res.cloudinary.com/cryptosheets/image/upload/v1568673449/cryptosheets-docs/cs-custom-functions-parameters2_cdszdf.png)

### Examples

1. Example 1:

   > **`=CS.PARAMETERS("CryptUnit", "earnings-auto")`**

2. Example 2:
   > **`=CS.PARAMETERS("Paradigm", "ico ieo sto")`**

Example 1 - output:

Example 2 - output:

![image](https://res.cloudinary.com/cryptosheets/image/upload/v1568649866/cryptosheets-docs/cs-custom-functions-parameters_no69ws.png)

#### Troubleshooting

1. Check your syntax for **=CS.PARAMETERS()** carefully, different functions for the same data may have slightly different required syntax
2. Check the **required arguments** for **=CS.PARAMETERS()** vs the **optional arguments**
3. Check your data & API quotas and limits
4. Check your formulas carefully
5. Check your relative references (`=CS.PARAMETERS("CryptUnit", "earnings-auto")` vs. `=CS.PARAMETERS("A1", "B1")`)
6. Use Excel's **error checking tools**
7. Check Excel's help sections: https://support.office.com/en-us/article/function-arguments-65b29fb5-ec7b-4c0b-a54b-a67923571519
8. Error Response Codes Reference

   - **#N/A** OK – Everything worked as expected
   - **#BUSY** Unauthorized – Your User/Password API Keys are incorrect
   - **#LIMIT** Forbidden – You are not subscribed to the data feed requested
   - **Other** Something else? – Click [**here**](#) for full list of Excel error explanation

## Additional Resources

_For Microsoft Excel_

- **Web browsers used by add-ins:** https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/browsers-used-by-office-web-add-ins
- **Office versions and requirement sets:** https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets
- **How to check your Office version:** https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets#how-to-check-your-office-version
- **Install the latest version of Office:** https://docs.microsoft.com/en-us/office/dev/add-ins/develop/install-latest-office-version
- **Custom Function Requirements:** https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture

_For Googlesheets_

- **Throughput Quotas & Limits:** https://developers.google.com/apps-script/guides/services/quotas

---


Use the CS.PARAMETERS() function for all parameters related to queries in Cryptosheets.