> Cryptocurrency Futures & Options Trading Find examples for accessing every **Deribit** endpoint using **Cryptosheets** through: - `side panel console` - `custom functions` (Excel & Googlesheets) - `templates` ## Excel

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | -------- | ----------- | | Try It | [Docs](/providers/deribit/get-book-summary-by-currency) | **Get book summary by currency** | =CS.QUERY("Deribit","Get book summary by currency") | =CS.PARAMETERS("Deribit","Get book summary by currency") | 2 | | Try It | [Docs](/providers/deribit/get-book-summary-by-instrument) | **Get book summary by instrument** | =CS.QUERY("Deribit","Get book summary by instrument") | =CS.PARAMETERS("Deribit","Get book summary by instrument") | 1 | | Try It | [Docs](/providers/deribit/get-contract-size) | **Get contract size** | =CS.QUERY("Deribit","Get contract size") | =CS.PARAMETERS("Deribit","Get contract size") | 1 | | Try It | [Docs](/providers/deribit/get-currencies) | **Get currencies** | =CS.QUERY("Deribit","Get currencies") | =CS.PARAMETERS("Deribit","Get currencies") | 0 | | Try It | [Docs](/providers/deribit/get-funding-chart-data) | **Get funding chart data** | =CS.QUERY("Deribit","Get funding chart data") | =CS.PARAMETERS("Deribit","Get funding chart data") | 2 | | Try It | [Docs](/providers/deribit/get-funding-rate-history) | **Get funding rate history** | =CS.QUERY("Deribit","Get funding rate history") | =CS.PARAMETERS("Deribit","Get funding rate history") | 3 | | Try It | [Docs](/providers/deribit/get-funding-rate-value) | **Get funding rate value** | =CS.QUERY("Deribit","Get funding rate value") | =CS.PARAMETERS("Deribit","Get funding rate value") | 3 | | Try It | [Docs](/providers/deribit/get-historical-volatility) | **Get historical volatility** | =CS.QUERY("Deribit","Get historical volatility") | =CS.PARAMETERS("Deribit","Get historical volatility") | 1 | | Try It | [Docs](/providers/deribit/get-index) | **Get index** | =CS.QUERY("Deribit","Get index") | =CS.PARAMETERS("Deribit","Get index") | 1 | | Try It | [Docs](/providers/deribit/get-instruments) | **Get instruments** | =CS.QUERY("Deribit","Get instruments") | =CS.PARAMETERS("Deribit","Get instruments") | 3 | | Try It | [Docs](/providers/deribit/get-last-settlements-by-currency) | **Get last settlements by currency** | =CS.QUERY("Deribit","Get last settlements by currency") | =CS.PARAMETERS("Deribit","Get last settlements by currency") | 5 | | Try It | [Docs](/providers/deribit/get-last-settlements-by-instrument) | **Get last settlements by instrument** | =CS.QUERY("Deribit","Get last settlements by instrument") | =CS.PARAMETERS("Deribit","Get last settlements by instrument") | 5 | | Try It | [Docs](/providers/deribit/get-last-trades-by-currency) | **Get last trades by currency** | =CS.QUERY("Deribit","Get last trades by currency") | =CS.PARAMETERS("Deribit","Get last trades by currency") | 7 | | Try It | [Docs](/providers/deribit/get-last-trades-by-currency-and-time) | **Get last trades by currency and time** | =CS.QUERY("Deribit","Get last trades by currency and time") | =CS.PARAMETERS("Deribit","Get last trades by currency and time") | 7 | | Try It | [Docs](/providers/deribit/get-last-trades-by-instrument) | **Get last trades by instrument** | =CS.QUERY("Deribit","Get last trades by instrument") | =CS.PARAMETERS("Deribit","Get last trades by instrument") | 6 | | Try It | [Docs](/providers/deribit/get-last-trades-by-instrument-and-time) | **Get last trades by instrument and time** | =CS.QUERY("Deribit","Get last trades by instrument and time") | =CS.PARAMETERS("Deribit","Get last trades by instrument and time") | 6 | | Try It | [Docs](/providers/deribit/get-order-book) | **Get order book** | =CS.QUERY("Deribit","Get order book") | =CS.PARAMETERS("Deribit","Get order book") | 2 | | Try It | [Docs](/providers/deribit/get-trade-volumes) | **Get trade volumes** | =CS.QUERY("Deribit","Get trade volumes") | =CS.PARAMETERS("Deribit","Get trade volumes") | 0 | | Try It | [Docs](/providers/deribit/get-tradingview-chart-data) | **Get tradingview chart data** | =CS.QUERY("Deribit","Get tradingview chart data") | =CS.PARAMETERS("Deribit","Get tradingview chart data") | 4 | | Try It | [Docs](/providers/deribit/ticker) | **Ticker** | =CS.QUERY("Deribit","Ticker") | =CS.PARAMETERS("Deribit","Ticker") | 1 | | Try It | [Docs](/providers/deribit/private-get-positions) | **Private Get Positions** | =CS.QUERY("Deribit","Private Get Positions") | =CS.PARAMETERS("Deribit","Private Get Positions") | 5 | | Try It | [Docs](/providers/deribit/private-get-account-summary) | **Private Get Account Summary** | =CS.QUERY("Deribit","Private Get Account Summary") | =CS.PARAMETERS("Deribit","Private Get Account Summary") | 2 | | Try It | [Docs](/providers/deribit/private-get-affiliate-program-info) | **Private Get Affiliate Program Info** | =CS.QUERY("Deribit","Private Get Affiliate Program Info") | =CS.PARAMETERS("Deribit","Private Get Affiliate Program Info") | 0 | | Try It | [Docs](/providers/deribit/private-get-new-announcements) | **Private Get New Announcements** | =CS.QUERY("Deribit","Private Get New Announcements") | =CS.PARAMETERS("Deribit","Private Get New Announcements") | 0 | | Try It | [Docs](/providers/deribit/private-get-position) | **Private Get Position** | =CS.QUERY("Deribit","Private Get Position") | =CS.PARAMETERS("Deribit","Private Get Position") | 1 | | Try It | [Docs](/providers/deribit/private-get-positions) | **Private Get Positions** | =CS.QUERY("Deribit","Private Get Positions") | =CS.PARAMETERS("Deribit","Private Get Positions") | 2 | | Try It | [Docs](/providers/deribit/private-get-subaccounts) | **Private Get Subaccounts** | =CS.QUERY("Deribit","Private Get Subaccounts") | =CS.PARAMETERS("Deribit","Private Get Subaccounts") | 1 | | Try It | [Docs](/providers/deribit/private-get-block-trade) | **Private Get Block Trade** | =CS.QUERY("Deribit","Private Get Block Trade") | =CS.PARAMETERS("Deribit","Private Get Block Trade") | 1 | | Try It | [Docs](/providers/deribit/private-get-last-block-trades-by-currency) | **Private Get Last Block Trades By Currency** | =CS.QUERY("Deribit","Private Get Last Block Trades By Currency") | =CS.PARAMETERS("Deribit","Private Get Last Block Trades By Currency") | 2 | | Try It | [Docs](/providers/deribit/private-get-margins) | **Private Get Margins** | =CS.QUERY("Deribit","Private Get Margins") | =CS.PARAMETERS("Deribit","Private Get Margins") | 3 | | Try It | [Docs](/providers/deribit/private-get-mmp-config) | **Private Get Mmp Config** | =CS.QUERY("Deribit","Private Get Mmp Config") | =CS.PARAMETERS("Deribit","Private Get Mmp Config") | 1 | | Try It | [Docs](/providers/deribit/private-get-open-orders-by-currency) | **Private Get Open Orders By Currency** | =CS.QUERY("Deribit","Private Get Open Orders By Currency") | =CS.PARAMETERS("Deribit","Private Get Open Orders By Currency") | 3 | | Try It | [Docs](/providers/deribit/private-get-open-orders-by-instrument) | **Private Get Open Orders By Instrument** | =CS.QUERY("Deribit","Private Get Open Orders By Instrument") | =CS.PARAMETERS("Deribit","Private Get Open Orders By Instrument") | 2 | | Try It | [Docs](/providers/deribit/private-get-order-history-by-currency) | **Private Get Order History By Currency** | =CS.QUERY("Deribit","Private Get Order History By Currency") | =CS.PARAMETERS("Deribit","Private Get Order History By Currency") | 3 | | Try It | [Docs](/providers/deribit/private-get-order-history-by-instrument) | **Private Get Order History By Instrument** | =CS.QUERY("Deribit","Private Get Order History By Instrument") | =CS.PARAMETERS("Deribit","Private Get Order History By Instrument") | 5 | | Try It | [Docs](/providers/deribit/private-get-order-margin-by-ids) | **Private Get Order Margin By Ids** | =CS.QUERY("Deribit","Private Get Order Margin By Ids") | =CS.PARAMETERS("Deribit","Private Get Order Margin By Ids") | 1 | | Try It | [Docs](/providers/deribit/private-get-order-state) | **Private Get Order State** | =CS.QUERY("Deribit","Private Get Order State") | =CS.PARAMETERS("Deribit","Private Get Order State") | 1 | | Try It | [Docs](/providers/deribit/private-get-stop-order-history) | **Private Get Stop Order History** | =CS.QUERY("Deribit","Private Get Stop Order History") | =CS.PARAMETERS("Deribit","Private Get Stop Order History") | 4 | | Try It | [Docs](/providers/deribit/private-get-user-trades-by-currency) | **Private Get User Trades By Currency** | =CS.QUERY("Deribit","Private Get User Trades By Currency") | =CS.PARAMETERS("Deribit","Private Get User Trades By Currency") | 7 | | Try It | [Docs](/providers/deribit/private-get-user-trades-by-currency-and-time) | **Private Get User Trades By Currency And Time** | =CS.QUERY("Deribit","Private Get User Trades By Currency And Time") | =CS.PARAMETERS("Deribit","Private Get User Trades By Currency And Time") | 7 | | Try It | [Docs](/providers/deribit/private-get-user-trades-by-instrument) | **Private Get User Trades By Instrument** | =CS.QUERY("Deribit","Private Get User Trades By Instrument") | =CS.PARAMETERS("Deribit","Private Get User Trades By Instrument") | 6 | | Try It | [Docs](/providers/deribit/private-get-user-trades-by-instrument-and-time) | **Private Get User Trades By Instrument And Time** | =CS.QUERY("Deribit","Private Get User Trades By Instrument And Time") | =CS.PARAMETERS("Deribit","Private Get User Trades By Instrument And Time") | 4 | | Try It | [Docs](/providers/deribit/private-get-user-trades-by-order) | **Private Get User Trades By Order** | =CS.QUERY("Deribit","Private Get User Trades By Order") | =CS.PARAMETERS("Deribit","Private Get User Trades By Order") | 2 | | Try It | [Docs](/providers/deribit/private-get-settlement-history-by-instrument) | **Private Get Settlement History By Instrument** | =CS.QUERY("Deribit","Private Get Settlement History By Instrument") | =CS.PARAMETERS("Deribit","Private Get Settlement History By Instrument") | 5 | | Try It | [Docs](/providers/deribit/private-get-settlement-history-by-currency) | **Private Get Settlement History By Currency** | =CS.QUERY("Deribit","Private Get Settlement History By Currency") | =CS.PARAMETERS("Deribit","Private Get Settlement History By Currency") | 3 | | Try It | [Docs](/providers/deribit/private-get-current-deposit-address) | **Private Get Current Deposit Address** | =CS.QUERY("Deribit","Private Get Current Deposit Address") | =CS.PARAMETERS("Deribit","Private Get Current Deposit Address") | 1 | | Try It | [Docs](/providers/deribit/private-get-deposits) | **Private Get Deposits** | =CS.QUERY("Deribit","Private Get Deposits") | =CS.PARAMETERS("Deribit","Private Get Deposits") | 3 | | Try It | [Docs](/providers/deribit/private-get-transfers) | **Private Get Transfers** | =CS.QUERY("Deribit","Private Get Transfers") | =CS.PARAMETERS("Deribit","Private Get Transfers") | 3 | | Try It | [Docs](/providers/deribit/private-get-withdrawals) | **Private Get Withdrawals** | =CS.QUERY("Deribit","Private Get Withdrawals") | =CS.PARAMETERS("Deribit","Private Get Withdrawals") | 3 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/deribit/get-book-summary-by-currency) | **Get book summary by currency** | =CSQUERY("Deribit","Get book summary by currency") | =CSPARAMETERS("Deribit","Get book summary by currency") | 2 | | Try It | [Docs](/providers/deribit/get-book-summary-by-instrument) | **Get book summary by instrument** | =CSQUERY("Deribit","Get book summary by instrument") | =CSPARAMETERS("Deribit","Get book summary by instrument") | 1 | | Try It | [Docs](/providers/deribit/get-contract-size) | **Get contract size** | =CSQUERY("Deribit","Get contract size") | =CSPARAMETERS("Deribit","Get contract size") | 1 | | Try It | [Docs](/providers/deribit/get-currencies) | **Get currencies** | =CSQUERY("Deribit","Get currencies") | =CSPARAMETERS("Deribit","Get currencies") | 0 | | Try It | [Docs](/providers/deribit/get-funding-chart-data) | **Get funding chart data** | =CSQUERY("Deribit","Get funding chart data") | =CSPARAMETERS("Deribit","Get funding chart data") | 2 | | Try It | [Docs](/providers/deribit/get-funding-rate-history) | **Get funding rate history** | =CSQUERY("Deribit","Get funding rate history") | =CSPARAMETERS("Deribit","Get funding rate history") | 3 | | Try It | [Docs](/providers/deribit/get-funding-rate-value) | **Get funding rate value** | =CSQUERY("Deribit","Get funding rate value") | =CSPARAMETERS("Deribit","Get funding rate value") | 3 | | Try It | [Docs](/providers/deribit/get-historical-volatility) | **Get historical volatility** | =CSQUERY("Deribit","Get historical volatility") | =CSPARAMETERS("Deribit","Get historical volatility") | 1 | | Try It | [Docs](/providers/deribit/get-index) | **Get index** | =CSQUERY("Deribit","Get index") | =CSPARAMETERS("Deribit","Get index") | 1 | | Try It | [Docs](/providers/deribit/get-instruments) | **Get instruments** | =CSQUERY("Deribit","Get instruments") | =CSPARAMETERS("Deribit","Get instruments") | 3 | | Try It | [Docs](/providers/deribit/get-last-settlements-by-currency) | **Get last settlements by currency** | =CSQUERY("Deribit","Get last settlements by currency") | =CSPARAMETERS("Deribit","Get last settlements by currency") | 5 | | Try It | [Docs](/providers/deribit/get-last-settlements-by-instrument) | **Get last settlements by instrument** | =CSQUERY("Deribit","Get last settlements by instrument") | =CSPARAMETERS("Deribit","Get last settlements by instrument") | 5 | | Try It | [Docs](/providers/deribit/get-last-trades-by-currency) | **Get last trades by currency** | =CSQUERY("Deribit","Get last trades by currency") | =CSPARAMETERS("Deribit","Get last trades by currency") | 7 | | Try It | [Docs](/providers/deribit/get-last-trades-by-currency-and-time) | **Get last trades by currency and time** | =CSQUERY("Deribit","Get last trades by currency and time") | =CSPARAMETERS("Deribit","Get last trades by currency and time") | 7 | | Try It | [Docs](/providers/deribit/get-last-trades-by-instrument) | **Get last trades by instrument** | =CSQUERY("Deribit","Get last trades by instrument") | =CSPARAMETERS("Deribit","Get last trades by instrument") | 6 | | Try It | [Docs](/providers/deribit/get-last-trades-by-instrument-and-time) | **Get last trades by instrument and time** | =CSQUERY("Deribit","Get last trades by instrument and time") | =CSPARAMETERS("Deribit","Get last trades by instrument and time") | 6 | | Try It | [Docs](/providers/deribit/get-order-book) | **Get order book** | =CSQUERY("Deribit","Get order book") | =CSPARAMETERS("Deribit","Get order book") | 2 | | Try It | [Docs](/providers/deribit/get-trade-volumes) | **Get trade volumes** | =CSQUERY("Deribit","Get trade volumes") | =CSPARAMETERS("Deribit","Get trade volumes") | 0 | | Try It | [Docs](/providers/deribit/get-tradingview-chart-data) | **Get tradingview chart data** | =CSQUERY("Deribit","Get tradingview chart data") | =CSPARAMETERS("Deribit","Get tradingview chart data") | 4 | | Try It | [Docs](/providers/deribit/ticker) | **Ticker** | =CSQUERY("Deribit","Ticker") | =CSPARAMETERS("Deribit","Ticker") | 1 | | Try It | [Docs](/providers/deribit/private-get-positions) | **Private Get Positions** | =CSQUERY("Deribit","Private Get Positions") | =CSPARAMETERS("Deribit","Private Get Positions") | 5 | | Try It | [Docs](/providers/deribit/private-get-account-summary) | **Private Get Account Summary** | =CSQUERY("Deribit","Private Get Account Summary") | =CSPARAMETERS("Deribit","Private Get Account Summary") | 2 | | Try It | [Docs](/providers/deribit/private-get-affiliate-program-info) | **Private Get Affiliate Program Info** | =CSQUERY("Deribit","Private Get Affiliate Program Info") | =CSPARAMETERS("Deribit","Private Get Affiliate Program Info") | 0 | | Try It | [Docs](/providers/deribit/private-get-new-announcements) | **Private Get New Announcements** | =CSQUERY("Deribit","Private Get New Announcements") | =CSPARAMETERS("Deribit","Private Get New Announcements") | 0 | | Try It | [Docs](/providers/deribit/private-get-position) | **Private Get Position** | =CSQUERY("Deribit","Private Get Position") | =CSPARAMETERS("Deribit","Private Get Position") | 1 | | Try It | [Docs](/providers/deribit/private-get-positions) | **Private Get Positions** | =CSQUERY("Deribit","Private Get Positions") | =CSPARAMETERS("Deribit","Private Get Positions") | 2 | | Try It | [Docs](/providers/deribit/private-get-subaccounts) | **Private Get Subaccounts** | =CSQUERY("Deribit","Private Get Subaccounts") | =CSPARAMETERS("Deribit","Private Get Subaccounts") | 1 | | Try It | [Docs](/providers/deribit/private-get-block-trade) | **Private Get Block Trade** | =CSQUERY("Deribit","Private Get Block Trade") | =CSPARAMETERS("Deribit","Private Get Block Trade") | 1 | | Try It | [Docs](/providers/deribit/private-get-last-block-trades-by-currency) | **Private Get Last Block Trades By Currency** | =CSQUERY("Deribit","Private Get Last Block Trades By Currency") | =CSPARAMETERS("Deribit","Private Get Last Block Trades By Currency") | 2 | | Try It | [Docs](/providers/deribit/private-get-margins) | **Private Get Margins** | =CSQUERY("Deribit","Private Get Margins") | =CSPARAMETERS("Deribit","Private Get Margins") | 3 | | Try It | [Docs](/providers/deribit/private-get-mmp-config) | **Private Get Mmp Config** | =CSQUERY("Deribit","Private Get Mmp Config") | =CSPARAMETERS("Deribit","Private Get Mmp Config") | 1 | | Try It | [Docs](/providers/deribit/private-get-open-orders-by-currency) | **Private Get Open Orders By Currency** | =CSQUERY("Deribit","Private Get Open Orders By Currency") | =CSPARAMETERS("Deribit","Private Get Open Orders By Currency") | 3 | | Try It | [Docs](/providers/deribit/private-get-open-orders-by-instrument) | **Private Get Open Orders By Instrument** | =CSQUERY("Deribit","Private Get Open Orders By Instrument") | =CSPARAMETERS("Deribit","Private Get Open Orders By Instrument") | 2 | | Try It | [Docs](/providers/deribit/private-get-order-history-by-currency) | **Private Get Order History By Currency** | =CSQUERY("Deribit","Private Get Order History By Currency") | =CSPARAMETERS("Deribit","Private Get Order History By Currency") | 3 | | Try It | [Docs](/providers/deribit/private-get-order-history-by-instrument) | **Private Get Order History By Instrument** | =CSQUERY("Deribit","Private Get Order History By Instrument") | =CSPARAMETERS("Deribit","Private Get Order History By Instrument") | 5 | | Try It | [Docs](/providers/deribit/private-get-order-margin-by-ids) | **Private Get Order Margin By Ids** | =CSQUERY("Deribit","Private Get Order Margin By Ids") | =CSPARAMETERS("Deribit","Private Get Order Margin By Ids") | 1 | | Try It | [Docs](/providers/deribit/private-get-order-state) | **Private Get Order State** | =CSQUERY("Deribit","Private Get Order State") | =CSPARAMETERS("Deribit","Private Get Order State") | 1 | | Try It | [Docs](/providers/deribit/private-get-stop-order-history) | **Private Get Stop Order History** | =CSQUERY("Deribit","Private Get Stop Order History") | =CSPARAMETERS("Deribit","Private Get Stop Order History") | 4 | | Try It | [Docs](/providers/deribit/private-get-user-trades-by-currency) | **Private Get User Trades By Currency** | =CSQUERY("Deribit","Private Get User Trades By Currency") | =CSPARAMETERS("Deribit","Private Get User Trades By Currency") | 7 | | Try It | [Docs](/providers/deribit/private-get-user-trades-by-currency-and-time) | **Private Get User Trades By Currency And Time** | =CSQUERY("Deribit","Private Get User Trades By Currency And Time") | =CSPARAMETERS("Deribit","Private Get User Trades By Currency And Time") | 7 | | Try It | [Docs](/providers/deribit/private-get-user-trades-by-instrument) | **Private Get User Trades By Instrument** | =CSQUERY("Deribit","Private Get User Trades By Instrument") | =CSPARAMETERS("Deribit","Private Get User Trades By Instrument") | 6 | | Try It | [Docs](/providers/deribit/private-get-user-trades-by-instrument-and-time) | **Private Get User Trades By Instrument And Time** | =CSQUERY("Deribit","Private Get User Trades By Instrument And Time") | =CSPARAMETERS("Deribit","Private Get User Trades By Instrument And Time") | 4 | | Try It | [Docs](/providers/deribit/private-get-user-trades-by-order) | **Private Get User Trades By Order** | =CSQUERY("Deribit","Private Get User Trades By Order") | =CSPARAMETERS("Deribit","Private Get User Trades By Order") | 2 | | Try It | [Docs](/providers/deribit/private-get-settlement-history-by-instrument) | **Private Get Settlement History By Instrument** | =CSQUERY("Deribit","Private Get Settlement History By Instrument") | =CSPARAMETERS("Deribit","Private Get Settlement History By Instrument") | 5 | | Try It | [Docs](/providers/deribit/private-get-settlement-history-by-currency) | **Private Get Settlement History By Currency** | =CSQUERY("Deribit","Private Get Settlement History By Currency") | =CSPARAMETERS("Deribit","Private Get Settlement History By Currency") | 3 | | Try It | [Docs](/providers/deribit/private-get-current-deposit-address) | **Private Get Current Deposit Address** | =CSQUERY("Deribit","Private Get Current Deposit Address") | =CSPARAMETERS("Deribit","Private Get Current Deposit Address") | 1 | | Try It | [Docs](/providers/deribit/private-get-deposits) | **Private Get Deposits** | =CSQUERY("Deribit","Private Get Deposits") | =CSPARAMETERS("Deribit","Private Get Deposits") | 3 | | Try It | [Docs](/providers/deribit/private-get-transfers) | **Private Get Transfers** | =CSQUERY("Deribit","Private Get Transfers") | =CSPARAMETERS("Deribit","Private Get Transfers") | 3 | | Try It | [Docs](/providers/deribit/private-get-withdrawals) | **Private Get Withdrawals** | =CSQUERY("Deribit","Private Get Withdrawals") | =CSPARAMETERS("Deribit","Private Get Withdrawals") | 3 |

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less **Get Cryptosheets for Microsoft Excel** **Get Cryptosheets for Googlesheets** \*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 **Click here** for additional documentation from Deribit Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `Deribit` `provider`