Excel

Google Sheets

>  global market depth, historical market depth analysis, variable level market depths, market depth ratio, crypto sector indices, triple variable trending, user managable fields and so much more.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto">Vantage Crypto</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/Vantage%20Crypto/OrderBook" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/orderbook) | **OrderBook** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","OrderBook",{"dur","30d";"coin","eth";"market","global";"dom","1dom";"api_key","Your_api_key"})'>=CS.QUERY("Vantage Crypto","OrderBook")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","OrderBook")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Orderbook%20at%20Date" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/orderbook-at-date) | **Orderbook at Date** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","Orderbook at Date",{"dur","30d";"coin","eth";"market","global";"timestamp","1597449600";"dom","1dom";"api_key","Your_api_key"})'>=CS.QUERY("Vantage Crypto","Orderbook at Date")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","Orderbook at Date")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/OHLC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/ohlc) | **OHLC** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","OHLC",{"dur","30d";"coin","eth";"candle","D";"api_key","Your_api_key";"market","global"})'>=CS.QUERY("Vantage Crypto","OHLC")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","OHLC")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/OHLC%20at%20Date" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/ohlc-at-date) | **OHLC at Date** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","OHLC at Date",{"dur","30d";"coin","eth";"candle","D";"timestamp","1597449600";"api_key","Your_api_key";"market","global"})'>=CS.QUERY("Vantage Crypto","OHLC at Date")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","OHLC at Date")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Order%20Flow" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/order-flow) | **Order Flow** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","Order Flow",{"dur","30d";"coin","eth";"market","global";"api_key","Your_api_key"})'>=CS.QUERY("Vantage Crypto","Order Flow")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","Order Flow")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Order%20Flow%20at%20Date" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/order-flow-at-date) | **Order Flow at Date** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","Order Flow at Date",{"dur","30d";"coin","eth";"market","global";"timestamp","1597449600";"api_key","Your_api_key"})'>=CS.QUERY("Vantage Crypto","Order Flow at Date")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","Order Flow at Date")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Price" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/price) | **Price** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","Price",{"dur","30d";"coin","eth";"market","global";"api_key","Your_api_key"})'>=CS.QUERY("Vantage Crypto","Price")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","Price")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Price%20at%20Date" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/price-at-date) | **Price at Date** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","Price at Date",{"dur","30d";"coin","eth";"market","global";"timestamp","1597449600";"api_key","Your_api_key"})'>=CS.QUERY("Vantage Crypto","Price at Date")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","Price at Date")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Volume" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/volume) | **Volume** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","Volume",{"dur","30d";"coin","eth";"api_key","Your_api_key";"market","global"})'>=CS.QUERY("Vantage Crypto","Volume")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","Volume")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Volume%20at%20Date" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/volume-at-date) | **Volume at Date** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","Volume at Date",{"dur","30d";"coin","eth";"timestamp","1597449600";"api_key","Your_api_key";"market","global"})'>=CS.QUERY("Vantage Crypto","Volume at Date")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","Volume at Date")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Large%20Order%20Alert" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/large-order-alert) | **Large Order Alert** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","Large Order Alert",{"api_key","Your_api_key";"dur","rt";"market","global";"coin","eth"})'>=CS.QUERY("Vantage Crypto","Large Order Alert")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","Large Order Alert")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/List%20Available%20Calls" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/list-available-calls) | **List Available Calls** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","List Available Calls",{"api_key","Your_api_key"})'>=CS.QUERY("Vantage Crypto","List Available Calls")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","List Available Calls")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/List%20Available%20Markets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/list-available-markets) | **List Available Markets** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","List Available Markets",{"api_key","Your_api_key"})'>=CS.QUERY("Vantage Crypto","List Available Markets")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","List Available Markets")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/List%20Available%20Assets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/list-available-assets) | **List Available Assets** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","List Available Assets",{"market","global";"api_key","Your_api_key"})'>=CS.QUERY("Vantage Crypto","List Available Assets")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","List Available Assets")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Indices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/indices) | **Indices** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","Indices",{"api_key","Your_api_key";"index","baas";"dur","7d";"dom","100dom"})'>=CS.QUERY("Vantage Crypto","Indices")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","Indices")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/List%20All%20Indices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/list-all-indices) | **List All Indices** | <inline-code functionvalue='=CS.QUERY("Vantage Crypto","List All Indices",{"api_key","Your_api_key";"dom","1dom";"coin","eth";"dur","30d"})'>=CS.QUERY("Vantage Crypto","List All Indices")</inline-code> | <inline-code>=CS.PARAMETERS("Vantage Crypto","List All Indices")</inline-code> | 4 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/OrderBook" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/orderbook) | **OrderBook** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","OrderBook",{"dur","30d";"coin","eth";"market","global";"dom","1dom";"api_key","Your_api_key"})'>=CSQUERY("Vantage Crypto","OrderBook")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","OrderBook")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Orderbook%20at%20Date" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/orderbook-at-date) | **Orderbook at Date** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","Orderbook at Date",{"dur","30d";"coin","eth";"market","global";"timestamp","1597449600";"dom","1dom";"api_key","Your_api_key"})'>=CSQUERY("Vantage Crypto","Orderbook at Date")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","Orderbook at Date")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/OHLC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/ohlc) | **OHLC** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","OHLC",{"dur","30d";"coin","eth";"candle","D";"api_key","Your_api_key";"market","global"})'>=CSQUERY("Vantage Crypto","OHLC")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","OHLC")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/OHLC%20at%20Date" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/ohlc-at-date) | **OHLC at Date** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","OHLC at Date",{"dur","30d";"coin","eth";"candle","D";"timestamp","1597449600";"api_key","Your_api_key";"market","global"})'>=CSQUERY("Vantage Crypto","OHLC at Date")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","OHLC at Date")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Order%20Flow" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/order-flow) | **Order Flow** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","Order Flow",{"dur","30d";"coin","eth";"market","global";"api_key","Your_api_key"})'>=CSQUERY("Vantage Crypto","Order Flow")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","Order Flow")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Order%20Flow%20at%20Date" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/order-flow-at-date) | **Order Flow at Date** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","Order Flow at Date",{"dur","30d";"coin","eth";"market","global";"timestamp","1597449600";"api_key","Your_api_key"})'>=CSQUERY("Vantage Crypto","Order Flow at Date")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","Order Flow at Date")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Price" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/price) | **Price** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","Price",{"dur","30d";"coin","eth";"market","global";"api_key","Your_api_key"})'>=CSQUERY("Vantage Crypto","Price")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","Price")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Price%20at%20Date" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/price-at-date) | **Price at Date** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","Price at Date",{"dur","30d";"coin","eth";"market","global";"timestamp","1597449600";"api_key","Your_api_key"})'>=CSQUERY("Vantage Crypto","Price at Date")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","Price at Date")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Volume" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/volume) | **Volume** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","Volume",{"dur","30d";"coin","eth";"api_key","Your_api_key";"market","global"})'>=CSQUERY("Vantage Crypto","Volume")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","Volume")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Volume%20at%20Date" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/volume-at-date) | **Volume at Date** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","Volume at Date",{"dur","30d";"coin","eth";"timestamp","1597449600";"api_key","Your_api_key";"market","global"})'>=CSQUERY("Vantage Crypto","Volume at Date")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","Volume at Date")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Large%20Order%20Alert" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/large-order-alert) | **Large Order Alert** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","Large Order Alert",{"api_key","Your_api_key";"dur","rt";"market","global";"coin","eth"})'>=CSQUERY("Vantage Crypto","Large Order Alert")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","Large Order Alert")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/List%20Available%20Calls" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/list-available-calls) | **List Available Calls** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","List Available Calls",{"api_key","Your_api_key"})'>=CSQUERY("Vantage Crypto","List Available Calls")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","List Available Calls")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/List%20Available%20Markets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/list-available-markets) | **List Available Markets** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","List Available Markets",{"api_key","Your_api_key"})'>=CSQUERY("Vantage Crypto","List Available Markets")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","List Available Markets")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/List%20Available%20Assets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/list-available-assets) | **List Available Assets** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","List Available Assets",{"market","global";"api_key","Your_api_key"})'>=CSQUERY("Vantage Crypto","List Available Assets")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","List Available Assets")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/Indices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/indices) | **Indices** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","Indices",{"api_key","Your_api_key";"index","baas";"dur","7d";"dom","100dom"})'>=CSQUERY("Vantage Crypto","Indices")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","Indices")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Vantage%20Crypto/List%20All%20Indices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/vantage-crypto/list-all-indices) | **List All Indices** | <inline-code functionvalue='=CSQUERY("Vantage Crypto","List All Indices",{"api_key","Your_api_key";"dom","1dom";"coin","eth";"dur","30d"})'>=CSQUERY("Vantage Crypto","List All Indices")</inline-code> | <inline-code>=CSPARAMETERS("Vantage Crypto","List All Indices")</inline-code> | 4 |

</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-Vantage Crypto">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-Vantage Crypto">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://vantagecrypto.com/">Click here</a>** for additional documentation from Vantage Crypto

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

---

Tags: `Vantage Crypto` `provider` 


How to pull Vantage Crypto data into Excel and Google Sheets