Use Case

Syntax

Sample Usage

Troubleshooting

Additional Reso...

> Get detailed level 3 live &amp; historical order book and spread data for any pair, derivative and exchange







## Use Case

> ****

## Syntax

```
=CS.ORDERBOOKSL3A( [parameters])
```

<div class="markdown">

**Parameter**|**Description**|**Required?**|**Example**
:-----:|:-----:|:-----:|:-----:
`parameters` | A repeating single value parameter, in the format name1, value1...nameN, valueN. | false | `base, btc, quote, usd`

</div>


## Sample Usage

**ORDERBOOKSL3-A (FUTURES)**

ORDERBOOKSL3-A custom function example for FUTURES.

*Excel*
> <typography-paragraph code copyable>&#x3D;CS.ORDERBOOKSL3A(&quot;base&quot;,&quot;BTC&quot;,&quot;quote&quot;,&quot;USD&quot;,&quot;type&quot;,&quot;FUTURES&quot;,&quot;exchange&quot;,&quot;KRAKENFTS&quot;,&quot;limitLevels&quot;,&quot;1&quot;,&quot;details&quot;,&quot;200828&quot;)</typography-paragraph>

*Google Sheets*
> <typography-paragraph code copyable>&#x3D;CSORDERBOOKSL3A(&quot;base&quot;,&quot;BTC&quot;,&quot;quote&quot;,&quot;USD&quot;,&quot;type&quot;,&quot;FUTURES&quot;,&quot;exchange&quot;,&quot;KRAKENFTS&quot;,&quot;limitLevels&quot;,&quot;1&quot;,&quot;details&quot;,&quot;200828&quot;)</typography-paragraph>


**ORDERBOOKSL3-A (OPTIONS)**

ORDERBOOKSL3-A custom function example for OPTIONS

*Excel*
> <typography-paragraph code copyable>&#x3D;CS.ORDERBOOKSL3A(&quot;base&quot;,&quot;ETH&quot;,&quot;exchange&quot;,&quot;DERIBIT&quot;,&quot;limitLevels&quot;,&quot;1&quot;,&quot;quote&quot;,&quot;USD&quot;,&quot;type&quot;,&quot;OPTION&quot;,&quot;timeStart&quot;,&quot;44069&quot;,&quot;details&quot;,&quot;200828-400-C&quot;)</typography-paragraph>

*Google Sheets*
> <typography-paragraph code copyable>&#x3D;CSORDERBOOKSL3A(&quot;base&quot;,&quot;ETH&quot;,&quot;exchange&quot;,&quot;DERIBIT&quot;,&quot;limitLevels&quot;,&quot;1&quot;,&quot;quote&quot;,&quot;USD&quot;,&quot;type&quot;,&quot;OPTION&quot;,&quot;timeStart&quot;,&quot;44069&quot;,&quot;details&quot;,&quot;200828-400-C&quot;)</typography-paragraph>


**ORDERBOOKSL3-A (CREDIT)**

ORDERBOOKSL3-A custom function example for CREDIT

*Excel*
> <typography-paragraph code copyable>&#x3D;CS.ORDERBOOKSL3A(&quot;base&quot;,&quot;EOS&quot;,&quot;quote&quot;,&quot;USD&quot;,&quot;type&quot;,&quot;CREDIT&quot;,&quot;limitLevels&quot;,&quot;1&quot;,&quot;exchange&quot;,&quot;BITFINEX&quot;)</typography-paragraph>

*Google Sheets*
> <typography-paragraph code copyable>&#x3D;CSORDERBOOKSL3A(&quot;base&quot;,&quot;EOS&quot;,&quot;quote&quot;,&quot;USD&quot;,&quot;type&quot;,&quot;CREDIT&quot;,&quot;limitLevels&quot;,&quot;1&quot;,&quot;exchange&quot;,&quot;BITFINEX&quot;)</typography-paragraph>


**ORDERBOOKSL3-A (PERPETUAL)**

ORDERBOOKSL3-A custom function example for PERPETUALS

*Excel*
> <typography-paragraph code copyable>&#x3D;CS.ORDERBOOKSL3A(&quot;base&quot;,&quot;ETH&quot;,&quot;quote&quot;,&quot;USD&quot;,&quot;exchange&quot;,&quot;KRAKENFTS&quot;,&quot;type&quot;,&quot;PERPETUAL&quot;,&quot;limitLevels&quot;,&quot;1&quot;)</typography-paragraph>

*Google Sheets*
> <typography-paragraph code copyable>&#x3D;CSORDERBOOKSL3A(&quot;base&quot;,&quot;ETH&quot;,&quot;quote&quot;,&quot;USD&quot;,&quot;exchange&quot;,&quot;KRAKENFTS&quot;,&quot;type&quot;,&quot;PERPETUAL&quot;,&quot;limitLevels&quot;,&quot;1&quot;)</typography-paragraph>


**ORDERBOOKSL3-A (SPOT)**

ORDERBOOKSL3-A custom function example for SPOT

*Excel*
> <typography-paragraph code copyable>&#x3D;CS.ORDERBOOKSL3A(&quot;base&quot;,&quot;BTC&quot;,&quot;type&quot;,&quot;SPOT&quot;,&quot;exchange&quot;,&quot;COINBASE&quot;,&quot;quote&quot;,&quot;USD&quot;,&quot;limitLevels&quot;,&quot;1&quot;)</typography-paragraph>

*Google Sheets*
> <typography-paragraph code copyable>&#x3D;CSORDERBOOKSL3A(&quot;base&quot;,&quot;BTC&quot;,&quot;type&quot;,&quot;SPOT&quot;,&quot;exchange&quot;,&quot;COINBASE&quot;,&quot;quote&quot;,&quot;USD&quot;,&quot;limitLevels&quot;,&quot;1&quot;)</typography-paragraph>


**ORDERBOOKSL3-A (FUTURES) symbolId**

ORDERBOOKSL3-A custom function example for FUTURES using the symbolId parameter

*Excel*
> <typography-paragraph code copyable>&#x3D;CS.ORDERBOOKSL3A(&quot;limitLevels&quot;,&quot;1&quot;,&quot;symbolId&quot;,&quot;KRAKENFTS_FTS_ETH_USD_200828&quot;)</typography-paragraph>

*Google Sheets*
> <typography-paragraph code copyable>&#x3D;CSORDERBOOKSL3A(&quot;limitLevels&quot;,&quot;1&quot;,&quot;symbolId&quot;,&quot;KRAKENFTS_FTS_ETH_USD_200828&quot;)</typography-paragraph>



> For a full list of global parameters, [Click Here](/functions/common/).



## See Also

[EXRATE](https://docs.cryptosheets.com/functions/exrate/) - Get the real time exchange rate between a pair of requested assets at a specific refresh interval  
[OHLCV](https://docs.cryptosheets.com/functions/ohlcv/) - Get historical open, high, low, close, volume and trades data for any resolution, pair or exchange  
[ORDERBOOKS](https://docs.cryptosheets.com/functions/orderbooks/) - Get live or historical order book and spread data for any pair or exchange, also known as books or passive level 2 data.  
[PRICE](https://docs.cryptosheets.com/functions/price/) - Get the current or historical exchange rate between a pair of requested assets at specific date or timestamp  
[PRICEA](https://docs.cryptosheets.com/functions/pricea/) - Get the current or historical bid, mid or ask exchange rate between a pair of requested assets or derivative including futures, options &amp; perpetuals at a specific date or timestamp and from a specific exchange  
[QUERY](https://docs.cryptosheets.com/functions/query/) - Query function to pull any endpoint from any available provider  
[QUERYA](https://docs.cryptosheets.com/functions/querya/) - Query function to pull any endpoint from any available provider  
[TRADES](https://docs.cryptosheets.com/functions/trades/) - Get historical transactions from specific symbol, returned in time ascending order.  
[ORDERBOOKSL3A](https://docs.cryptosheets.com/functions/orderbooksl3a/) - Get detailed level 3 live &amp; historical order book and spread data for any pair, derivative and exchange  
[OHLCVA](https://docs.cryptosheets.com/functions/ohlcva/) - Get historical open, high, low, close, volume and trades data for any resolution, pair or exchange  
[TRADESA](https://docs.cryptosheets.com/functions/tradesa/) - Get live &amp; historical trades data for any resolution, pair, derivative or exchange.  
[ORDERBOOKSA](https://docs.cryptosheets.com/functions/orderbooksa/) - Get live or historical orderbooks data for any pair, derivative or exchange.  

---

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


How to use the ORDERBOOKSL3A custom function in Excel and Google Sheets