=CS.SYMBOLS

Use Case Scenarios

SYMBOLS - Syntax

Function arguments

Function argume...

Supported Types...

PARAMETERS - Ab...

SYMBOLS - Examples

Troubleshooting

Additional Reso...

## =CS.SYMBOLS

In its simplest form, the SYMBOLS function says
```
=CS.SYMBOLS(what symbol, what name, what pair, what exchange, what category, what type)
```

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

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

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


### Use Case Scenarios
```When you need to quickly pull in a list of available symbols, pairs, exchanges and asset instrument types```

---

## SYMBOLS - Syntax
### Function arguments
	
Arguments: `=CS.SYMBOLS("symbol","name","pair","exchange","category","type")
`
	
Example Values: `=CS.SYMBOLS("BTC","Bitcoin","BTC_USD","Coinbase","crypto","spot")`


*Click + Copy + Paste Examples*

Excel: <inline-code functionvalue='=CS.SYMBOLS("exchange","coinbase")'>=CS.SYMBOLS("exchange","coinbase")</inline-code>

Googlesheets: <inline-code functionvalue='=CSSYMBOLS("exchange","coinbase")'>=CSSYMBOLS("exchange","coinbase")</inline-code>

> For non exchange providers like CoinGecko, CryptoCompare or Messari you can simply use their names instead of an exchange name 

Excel: <inline-code functionvalue='=CS.SYMBOLS("exchange","coingecko")'>=CS.SYMBOLS("exchange","coingecko")</inline-code>

Googlesheets: <inline-code functionvalue='=CSSYMBOLS("exchange","cryptocompare")'>=CSSYMBOLS("exchange","cryptocompare")</inline-code>


### Function argument descriptions

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

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

- **symbol**: Symbol of the asset [string] optional
- **name**: Name of the symbol or asset [string] optional
- **pair**: Trading pair including base symbol and quote symbol [string] optional
- **exchange**: Name of the exchange [string] optional
- **category**: Asset category (crypto, capMarkets, other) [string] optional
- **type**: Asset instrument type (adr,closed ended fund,common stock,contract,etf,futures,index,open ended fund,option,other,perpetual,preferred stock,spot,structured product,unit,warrant) [string] optional

> NOTE: Asset/instrument types supported for ['core' default market data](https://docs.cryptosheets.com/cryptosheets-concepts/data-sources/) include: `SPOT`, `FUTURES`, `OPTION`, `INDEX`, `PERPETUAL`, `CREDIT`, `CONTRACT`


### Supported Types (Core Market Data)

<div class="markdown">

| Type      | Name               | Description                                                                                                                                     |
|-----------|--------------------|--------------------------------------------------------------------------------------------------------------------------------------------------|
| **`SPOT`**      | FX Spot            | Agreement to exchange one asset for another one (e.g. Buy BTC for USD)                                                            |
| **`FUTURES`**   | Futures contract   | FX Spot derivative contract where traders agree to trade fx spot at predetermined future time                                     |
| **`OPTION`**    | Option contract    | FX Spot derivative contract where traders agree to trade right to require buy or sell of fx spot at agreed price on exercise date |
| **`PERPETUAL`** | Perpetual contract | FX Spot derivative contract where traders agree to trade fx spot continously without predetermined future delivery time           |
| **`INDEX`**    | Index              | Statistical composite that measures changes in the economy or markets.                                                            |
| **`CREDIT`**    | Credit/Funding     | Margin funding contract. Order book displays lending offers and borrow bids. Price represents the daily rate.                     |
| **`CONTRACT`**  | Contract           | Represents other types of financial instruments (e.g. spreads, interest rate swap)                                                |

</div>



### 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:

`=CS.SYMBOLS("BTC","Bitcoin","BTC_USD","Coinbase","crypto","spot")`

**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)_:

`=CS.SYMBOLS(A1,B1,A2,B2,A3,B3,A4,B4,A5,B5,A6,B6)`


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

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

<a href="https://app.cryptosheets.com/#/browse" rel="noopener noreferrer" target="_blank">Click here</a> to search for data providers and endpoints

---

## SYMBOLS - Examples

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

**Example 1:**

Excel:

<inline-code functionvalue='=CS.SYMBOLS("exchange","coinbase")'>=CS.SYMBOLS("exchange","coinbase")</inline-code>

Google Sheets:

<inline-code functionvalue='=CSSYMBOLS("exchange","coinbase")'>=CSSYMBOLS("exchange","coinbase")</inline-code>

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

**Example 2:**

Excel:

<inline-code functionvalue='=CS.SYMBOLS("symbol","btc","type","futures")'>=CS.SYMBOLS("symbol","btc","type","futures")</inline-code>

Google Sheets:

<inline-code functionvalue='=CSSYMBOLS("symbol","btc","type","futures")'>=CSSYMBOLS("symbol","btc","type","futures")</inline-code>

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

**Example 3:**

Excel:

<inline-code functionvalue='=CS.SYMBOLS("symbol","eth","type","option","name","~put")'>=CS.SYMBOLS("symbol","eth","type","options","name","~put")</inline-code>

Google Sheets:

<inline-code functionvalue='=CSSYMBOLS("symbol","eth","type","option","name","~put")'>=CSSYMBOLS("symbol","eth","type","options","name","~put")</inline-code>

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

**Example 4:**

Using `CS.SYMBOLS` outputs as dynamic inputs for real time market liquidity using `CS.ORDERBOOKS`

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

**Example 5:**

Using `CS.SYMBOLS` with `~` for fuzzy searches & partial matches to find non crypto assets like the Grayscale Bitcoin Trust (GBTC)

Excel:

<inline-code functionvalue='=CS.SYMBOLS("category","capMarkets","name","~Grayscale")'>=CS.SYMBOLS("category","capMarkets","name","~Grayscale")</inline-code>

Google Sheets:

<inline-code functionvalue='=CSSYMBOLS("category","capMarkets","name","~Grayscale")'>=CSSYMBOLS("category","capMarkets","name","~Grayscale")</inline-code>

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

### 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 SYMBOLS reference function to pull all symbols supported by cryptosheets core and non core functions

Symbols

How to use SYMBOLS in Excel & Googlesheets

SYMBOLS