Excel

Google Sheets

> The first US regulated and licensed exchange for bitcoin derivatives including options &amp; futures.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/LedgerX">LedgerX</a>** endpoint using **Cryptosheets** through:

- `side panel console`
- `custom functions` (Excel & Googlesheets)
- `templates`

## Excel

<div class="markdown">

| App Url                                                                                 | Docs Url                                                                                 | Name                        | Example                                             | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | --------   | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/LedgerX/LXVX%20Volatility%20Index" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ledgerx/lxvx-volatility-index) | **LXVX Volatility Index** | <inline-code functionvalue='=CS.QUERY("LedgerX","LXVX Volatility Index",{"resolution","3M"})'>=CS.QUERY("LedgerX","LXVX Volatility Index")</inline-code> | <inline-code>=CS.PARAMETERS("LedgerX","LXVX Volatility Index")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/LedgerX/List%20Contracts" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ledgerx/list-contracts) | **List Contracts** | <inline-code functionvalue='=CS.QUERY("LedgerX","List Contracts",{"active","TRUE";"contract_type","call";"derivative_type","options_contract";"before_ts","2021-04-05T00:00";"after_ts","2019-04-05T00:00";"asset","ETH";"limit","100";"offset","0"})'>=CS.QUERY("LedgerX","List Contracts")</inline-code> | <inline-code>=CS.PARAMETERS("LedgerX","List Contracts")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/LedgerX/Retrieve%20Contract" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ledgerx/retrieve-contract) | **Retrieve Contract** | <inline-code functionvalue='=CS.QUERY("LedgerX","Retrieve Contract",{"id","22220842"})'>=CS.QUERY("LedgerX","Retrieve Contract")</inline-code> | <inline-code>=CS.PARAMETERS("LedgerX","Retrieve Contract")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/LedgerX/Get%20Contract%20Ticker" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ledgerx/get-contract-ticker) | **Get Contract Ticker** | <inline-code functionvalue='=CS.QUERY("LedgerX","Get Contract Ticker",{"id","22220842";"time","2021-04-05T00:00";"asset","ETH"})'>=CS.QUERY("LedgerX","Get Contract Ticker")</inline-code> | <inline-code>=CS.PARAMETERS("LedgerX","Get Contract Ticker")</inline-code> | 3 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/LedgerX/LXVX%20Volatility%20Index" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ledgerx/lxvx-volatility-index) | **LXVX Volatility Index** | <inline-code functionvalue='=CSQUERY("LedgerX","LXVX Volatility Index",{"resolution","3M"})'>=CSQUERY("LedgerX","LXVX Volatility Index")</inline-code> | <inline-code>=CSPARAMETERS("LedgerX","LXVX Volatility Index")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/LedgerX/List%20Contracts" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ledgerx/list-contracts) | **List Contracts** | <inline-code functionvalue='=CSQUERY("LedgerX","List Contracts",{"active","TRUE";"contract_type","call";"derivative_type","options_contract";"before_ts","2021-04-05T00:00";"after_ts","2019-04-05T00:00";"asset","ETH";"limit","100";"offset","0"})'>=CSQUERY("LedgerX","List Contracts")</inline-code> | <inline-code>=CSPARAMETERS("LedgerX","List Contracts")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/LedgerX/Retrieve%20Contract" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ledgerx/retrieve-contract) | **Retrieve Contract** | <inline-code functionvalue='=CSQUERY("LedgerX","Retrieve Contract",{"id","22220842"})'>=CSQUERY("LedgerX","Retrieve Contract")</inline-code> | <inline-code>=CSPARAMETERS("LedgerX","Retrieve Contract")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/LedgerX/Get%20Contract%20Ticker" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ledgerx/get-contract-ticker) | **Get Contract Ticker** | <inline-code functionvalue='=CSQUERY("LedgerX","Get Contract Ticker",{"id","22220842";"time","2021-04-05T00:00";"asset","ETH"})'>=CSQUERY("LedgerX","Get Contract Ticker")</inline-code> | <inline-code>=CSPARAMETERS("LedgerX","Get Contract Ticker")</inline-code> | 3 |

</div>

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less

**<a href="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=docs-LedgerX">Get Cryptosheets for Microsoft Excel</a>**

**<a href="https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget?src=docs-LedgerX">Get Cryptosheets for Googlesheets</a>**

\*Note: you must have one of the [supported versions](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture) of Microsoft Office or Excel for custom functions to work

**<a href="https://docs.ledgerx.com/v1.0/reference">Click here</a>** for additional documentation from LedgerX

Learn more [here](https://intercom.help/cryptosheets/en/)

---

Tags: `LedgerX` `provider` 


How to pull LedgerX data into Excel and Google Sheets