Excel

Google Sheets

> Real-Time Cryptocurrency derivatives trading platform based in Hong Kong

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Bitmex">Bitmex</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/Bitmex/daily" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/daily) | **daily** | <inline-code functionvalue='=CS.QUERY("Bitmex","daily")'>=CS.QUERY("Bitmex","daily")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","daily")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/leaderboard" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/leaderboard) | **leaderboard** | <inline-code functionvalue='=CS.QUERY("Bitmex","leaderboard")'>=CS.QUERY("Bitmex","leaderboard")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","leaderboard")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Funding" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/funding) | **Funding** | <inline-code functionvalue='=CS.QUERY("Bitmex","Funding",{"count","100";"reverse","false";"symbol","ETHXBT";"filter","{"key": "value"}";"columns","";"start","";"startTime","";"endTime",""})'>=CS.QUERY("Bitmex","Funding")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Funding")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Liquidations" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/liquidations) | **Liquidations** | <inline-code functionvalue='=CS.QUERY("Bitmex","Liquidations",{"count","100";"reverse","false";"symbol","ETHXBT";"filter","{"key": "value"}";"columns","";"start","";"startTime","";"endTime",""})'>=CS.QUERY("Bitmex","Liquidations")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Liquidations")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Stats" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/stats) | **Stats** | <inline-code functionvalue='=CS.QUERY("Bitmex","Stats")'>=CS.QUERY("Bitmex","Stats")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Stats")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Stats%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/stats-history) | **Stats History** | <inline-code functionvalue='=CS.QUERY("Bitmex","Stats History")'>=CS.QUERY("Bitmex","Stats History")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Stats History")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Stats%20HistoryUSD" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/stats-historyusd) | **Stats HistoryUSD** | <inline-code functionvalue='=CS.QUERY("Bitmex","Stats HistoryUSD")'>=CS.QUERY("Bitmex","Stats HistoryUSD")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Stats HistoryUSD")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Settlement" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/settlement) | **Settlement** | <inline-code functionvalue='=CS.QUERY("Bitmex","Settlement",{"count","100";"reverse","false";"symbol","ETHXBT";"filter","{"key": "value"}";"columns","";"start","";"startTime","";"endTime",""})'>=CS.QUERY("Bitmex","Settlement")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Settlement")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/trades) | **Trades** | <inline-code functionvalue='=CS.QUERY("Bitmex","Trades",{"count","100";"reverse","false";"symbol","ETHXBT";"filter","{"key": "value"}";"columns","";"start","";"startTime","";"endTime",""})'>=CS.QUERY("Bitmex","Trades")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Trades")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Trades%20Bucketed" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/trades-bucketed) | **Trades Bucketed** | <inline-code functionvalue='=CS.QUERY("Bitmex","Trades Bucketed",{"count","100";"reverse","false";"symbol","ETHXBT";"filter","{"key": "value"}";"columns","";"start","";"startTime","";"endTime","";"binSize","";"partial",""})'>=CS.QUERY("Bitmex","Trades Bucketed")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Trades Bucketed")</inline-code> | 10 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Quotes" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/quotes) | **Quotes** | <inline-code functionvalue='=CS.QUERY("Bitmex","Quotes",{"columns","";"count","100";"endTime","";"filter","{"key": "value"}";"reverse","false";"start","";"startTime","";"symbol","ETHXBT"})'>=CS.QUERY("Bitmex","Quotes")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Quotes")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Orderbook" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/orderbook) | **Orderbook** | <inline-code functionvalue='=CS.QUERY("Bitmex","Orderbook",{"symbol","XBT";"depth","25"})'>=CS.QUERY("Bitmex","Orderbook")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Orderbook")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Instruments" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/instruments) | **Instruments** | <inline-code functionvalue='=CS.QUERY("Bitmex","Instruments",{"columns","";"count","100";"endTime","";"filter","{"key": "value"}";"reverse","false";"start","";"startTime","";"symbol","ETHXBT"})'>=CS.QUERY("Bitmex","Instruments")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Instruments")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Instruments%20Active" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/instruments-active) | **Instruments Active** | <inline-code functionvalue='=CS.QUERY("Bitmex","Instruments Active")'>=CS.QUERY("Bitmex","Instruments Active")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Instruments Active")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Instruments%20Active%20and%20Indices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/instruments-active-and-indices) | **Instruments Active and Indices** | <inline-code functionvalue='=CS.QUERY("Bitmex","Instruments Active and Indices")'>=CS.QUERY("Bitmex","Instruments Active and Indices")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Instruments Active and Indices")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Instruments%20Active%20Intervals" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/instruments-active-intervals) | **Instruments Active Intervals** | <inline-code functionvalue='=CS.QUERY("Bitmex","Instruments Active Intervals")'>=CS.QUERY("Bitmex","Instruments Active Intervals")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Instruments Active Intervals")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Instruments%20Composite%20Index" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/instruments-composite-index) | **Instruments Composite Index** | <inline-code functionvalue='=CS.QUERY("Bitmex","Instruments Composite Index",{"columns","";"count","100";"endTime","";"filter","{"key": "value"}";"reverse","false";"start","";"startTime","";"symbol","ETHXBT"})'>=CS.QUERY("Bitmex","Instruments Composite Index")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Instruments Composite Index")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Instruments%20Indices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/instruments-indices) | **Instruments Indices** | <inline-code functionvalue='=CS.QUERY("Bitmex","Instruments Indices")'>=CS.QUERY("Bitmex","Instruments Indices")</inline-code> | <inline-code>=CS.PARAMETERS("Bitmex","Instruments Indices")</inline-code> | 0 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/daily" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/daily) | **daily** | <inline-code functionvalue='=CSQUERY("Bitmex","daily")'>=CSQUERY("Bitmex","daily")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","daily")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/leaderboard" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/leaderboard) | **leaderboard** | <inline-code functionvalue='=CSQUERY("Bitmex","leaderboard")'>=CSQUERY("Bitmex","leaderboard")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","leaderboard")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Funding" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/funding) | **Funding** | <inline-code functionvalue='=CSQUERY("Bitmex","Funding",{"count","100";"reverse","false";"symbol","ETHXBT";"filter","{"key": "value"}";"columns","";"start","";"startTime","";"endTime",""})'>=CSQUERY("Bitmex","Funding")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Funding")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Liquidations" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/liquidations) | **Liquidations** | <inline-code functionvalue='=CSQUERY("Bitmex","Liquidations",{"count","100";"reverse","false";"symbol","ETHXBT";"filter","{"key": "value"}";"columns","";"start","";"startTime","";"endTime",""})'>=CSQUERY("Bitmex","Liquidations")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Liquidations")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Stats" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/stats) | **Stats** | <inline-code functionvalue='=CSQUERY("Bitmex","Stats")'>=CSQUERY("Bitmex","Stats")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Stats")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Stats%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/stats-history) | **Stats History** | <inline-code functionvalue='=CSQUERY("Bitmex","Stats History")'>=CSQUERY("Bitmex","Stats History")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Stats History")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Stats%20HistoryUSD" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/stats-historyusd) | **Stats HistoryUSD** | <inline-code functionvalue='=CSQUERY("Bitmex","Stats HistoryUSD")'>=CSQUERY("Bitmex","Stats HistoryUSD")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Stats HistoryUSD")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Settlement" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/settlement) | **Settlement** | <inline-code functionvalue='=CSQUERY("Bitmex","Settlement",{"count","100";"reverse","false";"symbol","ETHXBT";"filter","{"key": "value"}";"columns","";"start","";"startTime","";"endTime",""})'>=CSQUERY("Bitmex","Settlement")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Settlement")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/trades) | **Trades** | <inline-code functionvalue='=CSQUERY("Bitmex","Trades",{"count","100";"reverse","false";"symbol","ETHXBT";"filter","{"key": "value"}";"columns","";"start","";"startTime","";"endTime",""})'>=CSQUERY("Bitmex","Trades")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Trades")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Trades%20Bucketed" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/trades-bucketed) | **Trades Bucketed** | <inline-code functionvalue='=CSQUERY("Bitmex","Trades Bucketed",{"count","100";"reverse","false";"symbol","ETHXBT";"filter","{"key": "value"}";"columns","";"start","";"startTime","";"endTime","";"binSize","";"partial",""})'>=CSQUERY("Bitmex","Trades Bucketed")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Trades Bucketed")</inline-code> | 10 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Quotes" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/quotes) | **Quotes** | <inline-code functionvalue='=CSQUERY("Bitmex","Quotes",{"columns","";"count","100";"endTime","";"filter","{"key": "value"}";"reverse","false";"start","";"startTime","";"symbol","ETHXBT"})'>=CSQUERY("Bitmex","Quotes")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Quotes")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Orderbook" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/orderbook) | **Orderbook** | <inline-code functionvalue='=CSQUERY("Bitmex","Orderbook",{"symbol","XBT";"depth","25"})'>=CSQUERY("Bitmex","Orderbook")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Orderbook")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Instruments" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/instruments) | **Instruments** | <inline-code functionvalue='=CSQUERY("Bitmex","Instruments",{"columns","";"count","100";"endTime","";"filter","{"key": "value"}";"reverse","false";"start","";"startTime","";"symbol","ETHXBT"})'>=CSQUERY("Bitmex","Instruments")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Instruments")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Instruments%20Active" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/instruments-active) | **Instruments Active** | <inline-code functionvalue='=CSQUERY("Bitmex","Instruments Active")'>=CSQUERY("Bitmex","Instruments Active")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Instruments Active")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Instruments%20Active%20and%20Indices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/instruments-active-and-indices) | **Instruments Active and Indices** | <inline-code functionvalue='=CSQUERY("Bitmex","Instruments Active and Indices")'>=CSQUERY("Bitmex","Instruments Active and Indices")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Instruments Active and Indices")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Instruments%20Active%20Intervals" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/instruments-active-intervals) | **Instruments Active Intervals** | <inline-code functionvalue='=CSQUERY("Bitmex","Instruments Active Intervals")'>=CSQUERY("Bitmex","Instruments Active Intervals")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Instruments Active Intervals")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Instruments%20Composite%20Index" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/instruments-composite-index) | **Instruments Composite Index** | <inline-code functionvalue='=CSQUERY("Bitmex","Instruments Composite Index",{"columns","";"count","100";"endTime","";"filter","{"key": "value"}";"reverse","false";"start","";"startTime","";"symbol","ETHXBT"})'>=CSQUERY("Bitmex","Instruments Composite Index")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Instruments Composite Index")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Bitmex/Instruments%20Indices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bitmex/instruments-indices) | **Instruments Indices** | <inline-code functionvalue='=CSQUERY("Bitmex","Instruments Indices")'>=CSQUERY("Bitmex","Instruments Indices")</inline-code> | <inline-code>=CSPARAMETERS("Bitmex","Instruments Indices")</inline-code> | 0 |

</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-Bitmex">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-Bitmex">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://www.bitmex.com/app/apiOverview">Click here</a>** for additional documentation from Bitmex

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

---

Tags: `Bitmex` `provider` 


How to pull Bitmex data into Excel and Google Sheets