SYMBOLS

=CS.SYMBOLS

In its simplest form, the SYMBOLS function says

=CS.SYMBOLS(what symbol, what name, what pair, what exchange, what category, what type)

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: =CS.SYMBOLS("exchange","coinbase")

Googlesheets: =CSSYMBOLS("exchange","coinbase")

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

Excel: =CS.SYMBOLS("exchange","coingecko")

Googlesheets: =CSSYMBOLS("exchange","cryptocompare")

Function argument descriptions

• 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 include: SPOT, FUTURES, OPTION, INDEX, PERPETUAL, CREDIT, CONTRACT

Supported Types (Core Market Data)

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)

Click here to search for data providers and endpoints

---

SYMBOLS - Examples

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

Example 1:

Excel:

=CS.SYMBOLS("exchange","coinbase")

Google Sheets:

=CSSYMBOLS("exchange","coinbase")

Example 2:

Excel:

=CS.SYMBOLS("symbol","btc","type","futures")

Google Sheets:

=CSSYMBOLS("symbol","btc","type","futures")

Example 3:

Excel:

=CS.SYMBOLS("symbol","eth","type","options","name","~put")

Google Sheets:

=CSSYMBOLS("symbol","eth","type","options","name","~put")

Example 4:

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

Example 5:

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

Excel:

=CS.SYMBOLS("category","capMarkets","name","~Grayscale")

Google Sheets:

=CSSYMBOLS("category","capMarkets","name","~Grayscale")

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. Check Excels help sections

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

• Web browsers used by add-ins
• Office versions and requirement sets
• How to check your Office version
• Install the latest version of Office
• Custom Function Requirements

For Googlesheets

• Throughput Quotas & Limits