Excel

Google Sheets

> The World&#x27;s Fastest Crypto Derivatives Exchange

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/QUME">QUME</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/QUME/Get%20All%20Market%20Stats" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-all-market-stats) | **Get All Market Stats** | <inline-code functionvalue='=CS.QUERY("QUME","Get All Market Stats")'>=CS.QUERY("QUME","Get All Market Stats")</inline-code> | <inline-code>=CS.PARAMETERS("QUME","Get All Market Stats")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Market%20Stats" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-market-stats) | **Get Market Stats** | <inline-code functionvalue='=CS.QUERY("QUME","Get Market Stats",{"symbol","BTCUSDQ"})'>=CS.QUERY("QUME","Get Market Stats")</inline-code> | <inline-code>=CS.PARAMETERS("QUME","Get Market Stats")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Bid%20Asks%20For%20Market" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-bid-asks-for-market) | **Get Bid Asks For Market** | <inline-code functionvalue='=CS.QUERY("QUME","Get Bid Asks For Market",{"symbol","BTCUSDQ"})'>=CS.QUERY("QUME","Get Bid Asks For Market")</inline-code> | <inline-code>=CS.PARAMETERS("QUME","Get Bid Asks For Market")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Trades%20For%20Market" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-trades-for-market) | **Get Trades For Market** | <inline-code functionvalue='=CS.QUERY("QUME","Get Trades For Market",{"symbol","BTCUSDQ"})'>=CS.QUERY("QUME","Get Trades For Market")</inline-code> | <inline-code>=CS.PARAMETERS("QUME","Get Trades For Market")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Funding%20Rate" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-funding-rate) | **Get Funding Rate** | <inline-code functionvalue='=CS.QUERY("QUME","Get Funding Rate",{"symbol","BTCUSDQ"})'>=CS.QUERY("QUME","Get Funding Rate")</inline-code> | <inline-code>=CS.PARAMETERS("QUME","Get Funding Rate")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Current%20Index%20Price" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-current-index-price) | **Get Current Index Price** | <inline-code functionvalue='=CS.QUERY("QUME","Get Current Index Price",{"symbol","BTCUSDQ"})'>=CS.QUERY("QUME","Get Current Index Price")</inline-code> | <inline-code>=CS.PARAMETERS("QUME","Get Current Index Price")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Market%20OHLC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-market-ohlc) | **Get Market OHLC** | <inline-code functionvalue='=CS.QUERY("QUME","Get Market OHLC",{"symbol","BTCUSDQ";"candleWidth","60";"timeStart","1583009135";"timeEnd","1585341946"})'>=CS.QUERY("QUME","Get Market OHLC")</inline-code> | <inline-code>=CS.PARAMETERS("QUME","Get Market OHLC")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Current%20Mark%20Price" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-current-mark-price) | **Get Current Mark Price** | <inline-code functionvalue='=CS.QUERY("QUME","Get Current Mark Price",{"symbol","BTCUSDQ"})'>=CS.QUERY("QUME","Get Current Mark Price")</inline-code> | <inline-code>=CS.PARAMETERS("QUME","Get Current Mark Price")</inline-code> | 1 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20All%20Market%20Stats" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-all-market-stats) | **Get All Market Stats** | <inline-code functionvalue='=CSQUERY("QUME","Get All Market Stats")'>=CSQUERY("QUME","Get All Market Stats")</inline-code> | <inline-code>=CSPARAMETERS("QUME","Get All Market Stats")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Market%20Stats" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-market-stats) | **Get Market Stats** | <inline-code functionvalue='=CSQUERY("QUME","Get Market Stats",{"symbol","BTCUSDQ"})'>=CSQUERY("QUME","Get Market Stats")</inline-code> | <inline-code>=CSPARAMETERS("QUME","Get Market Stats")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Bid%20Asks%20For%20Market" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-bid-asks-for-market) | **Get Bid Asks For Market** | <inline-code functionvalue='=CSQUERY("QUME","Get Bid Asks For Market",{"symbol","BTCUSDQ"})'>=CSQUERY("QUME","Get Bid Asks For Market")</inline-code> | <inline-code>=CSPARAMETERS("QUME","Get Bid Asks For Market")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Trades%20For%20Market" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-trades-for-market) | **Get Trades For Market** | <inline-code functionvalue='=CSQUERY("QUME","Get Trades For Market",{"symbol","BTCUSDQ"})'>=CSQUERY("QUME","Get Trades For Market")</inline-code> | <inline-code>=CSPARAMETERS("QUME","Get Trades For Market")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Funding%20Rate" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-funding-rate) | **Get Funding Rate** | <inline-code functionvalue='=CSQUERY("QUME","Get Funding Rate",{"symbol","BTCUSDQ"})'>=CSQUERY("QUME","Get Funding Rate")</inline-code> | <inline-code>=CSPARAMETERS("QUME","Get Funding Rate")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Current%20Index%20Price" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-current-index-price) | **Get Current Index Price** | <inline-code functionvalue='=CSQUERY("QUME","Get Current Index Price",{"symbol","BTCUSDQ"})'>=CSQUERY("QUME","Get Current Index Price")</inline-code> | <inline-code>=CSPARAMETERS("QUME","Get Current Index Price")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Market%20OHLC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-market-ohlc) | **Get Market OHLC** | <inline-code functionvalue='=CSQUERY("QUME","Get Market OHLC",{"symbol","BTCUSDQ";"candleWidth","60";"timeStart","1583009135";"timeEnd","1585341946"})'>=CSQUERY("QUME","Get Market OHLC")</inline-code> | <inline-code>=CSPARAMETERS("QUME","Get Market OHLC")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/QUME/Get%20Current%20Mark%20Price" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/qume/get-current-mark-price) | **Get Current Mark Price** | <inline-code functionvalue='=CSQUERY("QUME","Get Current Mark Price",{"symbol","BTCUSDQ"})'>=CSQUERY("QUME","Get Current Mark Price")</inline-code> | <inline-code>=CSPARAMETERS("QUME","Get Current Mark Price")</inline-code> | 1 |

</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-QUME">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-QUME">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://exchange.qume.io/register?ref&#x3D;9cf7978284c3065a">Click here</a>** for additional documentation from QUME

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

---

Tags: `QUME` `provider` 


How to pull QUME data into Excel and Google Sheets