Excel

Google Sheets

> Cryptocurrency futures trading &amp; information platform with aggregated derivative exchange data including Grayscale Bitcoin trust, Bitcoin futures open interest, funding rates and liquidations

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/ByBt">ByBt</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/ByBt/Futures%20Funding%20Rates" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-funding-rates) | **Futures Funding Rates** | <inline-code functionvalue='=CS.QUERY("ByBt","Futures Funding Rates",{"bybtSecret","Your apiKey";"symbol","BTC"})'>=CS.QUERY("ByBt","Futures Funding Rates")</inline-code> | <inline-code>=CS.PARAMETERS("ByBt","Futures Funding Rates")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Funding%20Rates%20Chart" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-funding-rates-chart) | **Futures Funding Rates Chart** | <inline-code functionvalue='=CS.QUERY("ByBt","Futures Funding Rates Chart",{"bybtSecret","Your apiKey";"symbol","BTC"})'>=CS.QUERY("ByBt","Futures Funding Rates Chart")</inline-code> | <inline-code>=CS.PARAMETERS("ByBt","Futures Funding Rates Chart")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Exchange%20Open%20Interest" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-exchange-open-interest) | **Futures Exchange Open Interest** | <inline-code functionvalue='=CS.QUERY("ByBt","Futures Exchange Open Interest",{"bybtSecret","Your apiKey";"symbol","BTC";"interval","5"})'>=CS.QUERY("ByBt","Futures Exchange Open Interest")</inline-code> | <inline-code>=CS.PARAMETERS("ByBt","Futures Exchange Open Interest")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Exchange%20Open%20Interest%20Chart" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-exchange-open-interest-chart) | **Futures Exchange Open Interest Chart** | <inline-code functionvalue='=CS.QUERY("ByBt","Futures Exchange Open Interest Chart",{"bybtSecret","Your apiKey";"symbol","BTC";"interval","5"})'>=CS.QUERY("ByBt","Futures Exchange Open Interest Chart")</inline-code> | <inline-code>=CS.PARAMETERS("ByBt","Futures Exchange Open Interest Chart")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Liquidation" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-liquidation) | **Futures Liquidation** | <inline-code functionvalue='=CS.QUERY("ByBt","Futures Liquidation",{"bybtSecret","Your apiKey";"exName","binance";"symbol","BTC"})'>=CS.QUERY("ByBt","Futures Liquidation")</inline-code> | <inline-code>=CS.PARAMETERS("ByBt","Futures Liquidation")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Long%20Short%20Chart" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-long-short-chart) | **Futures Long Short Chart** | <inline-code functionvalue='=CS.QUERY("ByBt","Futures Long Short Chart",{"bybtSecret","Your apiKey";"interval","5";"exName","binance";"symbol","BTC"})'>=CS.QUERY("ByBt","Futures Long Short Chart")</inline-code> | <inline-code>=CS.PARAMETERS("ByBt","Futures Long Short Chart")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Exchange%20Vol" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-exchange-vol) | **Futures Exchange Vol** | <inline-code functionvalue='=CS.QUERY("ByBt","Futures Exchange Vol",{"bybtSecret","Your apiKey";"symbol","BTC"})'>=CS.QUERY("ByBt","Futures Exchange Vol")</inline-code> | <inline-code>=CS.PARAMETERS("ByBt","Futures Exchange Vol")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Options%20Exchange%20Open%20Interest" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/options-exchange-open-interest) | **Options Exchange Open Interest** | <inline-code functionvalue='=CS.QUERY("ByBt","Options Exchange Open Interest",{"bybtSecret","Your apiKey";"symbol","BTC";"Authentication","Your authToken"})'>=CS.QUERY("ByBt","Options Exchange Open Interest")</inline-code> | <inline-code>=CS.PARAMETERS("ByBt","Options Exchange Open Interest")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Options%20Exchange%20Open%20Interest%20Chart" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/options-exchange-open-interest-chart) | **Options Exchange Open Interest Chart** | <inline-code functionvalue='=CS.QUERY("ByBt","Options Exchange Open Interest Chart",{"bybtSecret","Your apiKey";"interval","0";"symbol","BTC"})'>=CS.QUERY("ByBt","Options Exchange Open Interest Chart")</inline-code> | <inline-code>=CS.PARAMETERS("ByBt","Options Exchange Open Interest Chart")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Options%20Exchange%20Vol" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/options-exchange-vol) | **Options Exchange Vol** | <inline-code functionvalue='=CS.QUERY("ByBt","Options Exchange Vol",{"bybtSecret","Your apiKey";"symbol","BTC"})'>=CS.QUERY("ByBt","Options Exchange Vol")</inline-code> | <inline-code>=CS.PARAMETERS("ByBt","Options Exchange Vol")</inline-code> | 2 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Funding%20Rates" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-funding-rates) | **Futures Funding Rates** | <inline-code functionvalue='=CSQUERY("ByBt","Futures Funding Rates",{"bybtSecret","Your apiKey";"symbol","BTC"})'>=CSQUERY("ByBt","Futures Funding Rates")</inline-code> | <inline-code>=CSPARAMETERS("ByBt","Futures Funding Rates")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Funding%20Rates%20Chart" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-funding-rates-chart) | **Futures Funding Rates Chart** | <inline-code functionvalue='=CSQUERY("ByBt","Futures Funding Rates Chart",{"bybtSecret","Your apiKey";"symbol","BTC"})'>=CSQUERY("ByBt","Futures Funding Rates Chart")</inline-code> | <inline-code>=CSPARAMETERS("ByBt","Futures Funding Rates Chart")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Exchange%20Open%20Interest" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-exchange-open-interest) | **Futures Exchange Open Interest** | <inline-code functionvalue='=CSQUERY("ByBt","Futures Exchange Open Interest",{"bybtSecret","Your apiKey";"symbol","BTC";"interval","5"})'>=CSQUERY("ByBt","Futures Exchange Open Interest")</inline-code> | <inline-code>=CSPARAMETERS("ByBt","Futures Exchange Open Interest")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Exchange%20Open%20Interest%20Chart" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-exchange-open-interest-chart) | **Futures Exchange Open Interest Chart** | <inline-code functionvalue='=CSQUERY("ByBt","Futures Exchange Open Interest Chart",{"bybtSecret","Your apiKey";"symbol","BTC";"interval","5"})'>=CSQUERY("ByBt","Futures Exchange Open Interest Chart")</inline-code> | <inline-code>=CSPARAMETERS("ByBt","Futures Exchange Open Interest Chart")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Liquidation" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-liquidation) | **Futures Liquidation** | <inline-code functionvalue='=CSQUERY("ByBt","Futures Liquidation",{"bybtSecret","Your apiKey";"exName","binance";"symbol","BTC"})'>=CSQUERY("ByBt","Futures Liquidation")</inline-code> | <inline-code>=CSPARAMETERS("ByBt","Futures Liquidation")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Long%20Short%20Chart" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-long-short-chart) | **Futures Long Short Chart** | <inline-code functionvalue='=CSQUERY("ByBt","Futures Long Short Chart",{"bybtSecret","Your apiKey";"interval","5";"exName","binance";"symbol","BTC"})'>=CSQUERY("ByBt","Futures Long Short Chart")</inline-code> | <inline-code>=CSPARAMETERS("ByBt","Futures Long Short Chart")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Futures%20Exchange%20Vol" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/futures-exchange-vol) | **Futures Exchange Vol** | <inline-code functionvalue='=CSQUERY("ByBt","Futures Exchange Vol",{"bybtSecret","Your apiKey";"symbol","BTC"})'>=CSQUERY("ByBt","Futures Exchange Vol")</inline-code> | <inline-code>=CSPARAMETERS("ByBt","Futures Exchange Vol")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Options%20Exchange%20Open%20Interest" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/options-exchange-open-interest) | **Options Exchange Open Interest** | <inline-code functionvalue='=CSQUERY("ByBt","Options Exchange Open Interest",{"bybtSecret","Your apiKey";"symbol","BTC";"Authentication","Your authToken"})'>=CSQUERY("ByBt","Options Exchange Open Interest")</inline-code> | <inline-code>=CSPARAMETERS("ByBt","Options Exchange Open Interest")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Options%20Exchange%20Open%20Interest%20Chart" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/options-exchange-open-interest-chart) | **Options Exchange Open Interest Chart** | <inline-code functionvalue='=CSQUERY("ByBt","Options Exchange Open Interest Chart",{"bybtSecret","Your apiKey";"interval","0";"symbol","BTC"})'>=CSQUERY("ByBt","Options Exchange Open Interest Chart")</inline-code> | <inline-code>=CSPARAMETERS("ByBt","Options Exchange Open Interest Chart")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/ByBt/Options%20Exchange%20Vol" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bybt/options-exchange-vol) | **Options Exchange Vol** | <inline-code functionvalue='=CSQUERY("ByBt","Options Exchange Vol",{"bybtSecret","Your apiKey";"symbol","BTC"})'>=CSQUERY("ByBt","Options Exchange Vol")</inline-code> | <inline-code>=CSPARAMETERS("ByBt","Options Exchange Vol")</inline-code> | 2 |

</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-ByBt">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-ByBt">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://bybt.gitbook.io/">Click here</a>** for additional documentation from ByBt

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

---

Tags: `ByBt` `provider` 


How to pull ByBt data into Excel and Google Sheets