> Derivatives around the crypto world Find examples for accessing every **ContractMarketCap** 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/contractmarketcap/index-feed) | **Index Feed** | =CS.QUERY("ContractMarketCap","Index Feed") | =CS.PARAMETERS("ContractMarketCap","Index Feed") | 0 | | Try It | [Docs](/providers/contractmarketcap/public-system-time-) | **Public System Time ** | =CS.QUERY("ContractMarketCap","Public System Time ") | =CS.PARAMETERS("ContractMarketCap","Public System Time ") | 1 | | Try It | [Docs](/providers/contractmarketcap/public-system-status-) | **Public System Status ** | =CS.QUERY("ContractMarketCap","Public System Status ") | =CS.PARAMETERS("ContractMarketCap","Public System Status ") | 1 | | Try It | [Docs](/providers/contractmarketcap/public-system-limits-) | **Public System Limits ** | =CS.QUERY("ContractMarketCap","Public System Limits ") | =CS.PARAMETERS("ContractMarketCap","Public System Limits ") | 1 | | Try It | [Docs](/providers/contractmarketcap/fx-) | **Fx ** | =CS.QUERY("ContractMarketCap","Fx ") | =CS.PARAMETERS("ContractMarketCap","Fx ") | 1 | | Try It | [Docs](/providers/contractmarketcap/fx-by-symbol) | **Fx by Symbol** | =CS.QUERY("ContractMarketCap","Fx by Symbol") | =CS.PARAMETERS("ContractMarketCap","Fx by Symbol") | 2 | | Try It | [Docs](/providers/contractmarketcap/indices-) | **Indices ** | =CS.QUERY("ContractMarketCap","Indices ") | =CS.PARAMETERS("ContractMarketCap","Indices ") | 1 | | Try It | [Docs](/providers/contractmarketcap/indices-symbols-) | **Indices Symbols ** | =CS.QUERY("ContractMarketCap","Indices Symbols ") | =CS.PARAMETERS("ContractMarketCap","Indices Symbols ") | 1 | | Try It | [Docs](/providers/contractmarketcap/indices-by-excode) | **Indices by Excode** | =CS.QUERY("ContractMarketCap","Indices by Excode") | =CS.PARAMETERS("ContractMarketCap","Indices by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/index-by-symbol) | **Index by Symbol** | =CS.QUERY("ContractMarketCap","Index by Symbol") | =CS.PARAMETERS("ContractMarketCap","Index by Symbol") | 2 | | Try It | [Docs](/providers/contractmarketcap/index-history-by-symbol) | **Index History by Symbol** | =CS.QUERY("ContractMarketCap","Index History by Symbol") | =CS.PARAMETERS("ContractMarketCap","Index History by Symbol") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchanges-) | **Exchanges ** | =CS.QUERY("ContractMarketCap","Exchanges ") | =CS.PARAMETERS("ContractMarketCap","Exchanges ") | 1 | | Try It | [Docs](/providers/contractmarketcap/exchange-by-excode) | **Exchange by Excode** | =CS.QUERY("ContractMarketCap","Exchange by Excode") | =CS.PARAMETERS("ContractMarketCap","Exchange by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-info-by-excode) | **Exchange Info by Excode** | =CS.QUERY("ContractMarketCap","Exchange Info by Excode") | =CS.PARAMETERS("ContractMarketCap","Exchange Info by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-contracts-by-excode) | **Exchange Contracts by Excode** | =CS.QUERY("ContractMarketCap","Exchange Contracts by Excode") | =CS.PARAMETERS("ContractMarketCap","Exchange Contracts by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-indices-by-excode) | **Exchange Indices by Excode** | =CS.QUERY("ContractMarketCap","Exchange Indices by Excode") | =CS.PARAMETERS("ContractMarketCap","Exchange Indices by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-stats-by-excode) | **Exchange Stats by Excode** | =CS.QUERY("ContractMarketCap","Exchange Stats by Excode") | =CS.PARAMETERS("ContractMarketCap","Exchange Stats by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-history-by-excode) | **Exchange History by Excode** | =CS.QUERY("ContractMarketCap","Exchange History by Excode") | =CS.PARAMETERS("ContractMarketCap","Exchange History by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-reports-by-excode) | **Exchange Reports by Excode** | =CS.QUERY("ContractMarketCap","Exchange Reports by Excode") | =CS.PARAMETERS("ContractMarketCap","Exchange Reports by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-news-by-excode) | **Exchange News by Excode** | =CS.QUERY("ContractMarketCap","Exchange News by Excode") | =CS.PARAMETERS("ContractMarketCap","Exchange News by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/contracts-) | **Contracts ** | =CS.QUERY("ContractMarketCap","Contracts ") | =CS.PARAMETERS("ContractMarketCap","Contracts ") | 1 | | Try It | [Docs](/providers/contractmarketcap/contracts-traded-) | **Contracts Traded ** | =CS.QUERY("ContractMarketCap","Contracts Traded ") | =CS.PARAMETERS("ContractMarketCap","Contracts Traded ") | 1 | | Try It | [Docs](/providers/contractmarketcap/contracts-expired-) | **Contracts Expired ** | =CS.QUERY("ContractMarketCap","Contracts Expired ") | =CS.PARAMETERS("ContractMarketCap","Contracts Expired ") | 1 | | Try It | [Docs](/providers/contractmarketcap/contracts-perpetual-) | **Contracts Perpetual ** | =CS.QUERY("ContractMarketCap","Contracts Perpetual ") | =CS.PARAMETERS("ContractMarketCap","Contracts Perpetual ") | 1 | | Try It | [Docs](/providers/contractmarketcap/contracts-tod-) | **Contracts Tod ** | =CS.QUERY("ContractMarketCap","Contracts Tod ") | =CS.PARAMETERS("ContractMarketCap","Contracts Tod ") | 1 | | Try It | [Docs](/providers/contractmarketcap/contracts-tom-) | **Contracts Tom ** | =CS.QUERY("ContractMarketCap","Contracts Tom ") | =CS.PARAMETERS("ContractMarketCap","Contracts Tom ") | 1 | | Try It | [Docs](/providers/contractmarketcap/contracts-by-excode) | **Contracts by Excode** | =CS.QUERY("ContractMarketCap","Contracts by Excode") | =CS.PARAMETERS("ContractMarketCap","Contracts by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/contract-by-id) | **Contract by Id** | =CS.QUERY("ContractMarketCap","Contract by Id") | =CS.PARAMETERS("ContractMarketCap","Contract by Id") | 2 | | Try It | [Docs](/providers/contractmarketcap/marketdata-summary-) | **Marketdata Summary ** | =CS.QUERY("ContractMarketCap","Marketdata Summary ") | =CS.PARAMETERS("ContractMarketCap","Marketdata Summary ") | 1 | | Try It | [Docs](/providers/contractmarketcap/marketdata-summary-by-period) | **Marketdata Summary by Period** | =CS.QUERY("ContractMarketCap","Marketdata Summary by Period") | =CS.PARAMETERS("ContractMarketCap","Marketdata Summary by Period") | 2 | | Try It | [Docs](/providers/contractmarketcap/marketdata-exchange-by-excode) | **Marketdata Exchange by Excode** | =CS.QUERY("ContractMarketCap","Marketdata Exchange by Excode") | =CS.PARAMETERS("ContractMarketCap","Marketdata Exchange by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/marketdata-contract-by-id) | **Marketdata Contract by Id** | =CS.QUERY("ContractMarketCap","Marketdata Contract by Id") | =CS.PARAMETERS("ContractMarketCap","Marketdata Contract by Id") | 2 | | Try It | [Docs](/providers/contractmarketcap/marketdata-contract-history-eod-by-id) | **Marketdata Contract History Eod by Id** | =CS.QUERY("ContractMarketCap","Marketdata Contract History Eod by Id") | =CS.PARAMETERS("ContractMarketCap","Marketdata Contract History Eod by Id") | 2 | | Try It | [Docs](/providers/contractmarketcap/marketdata-contracts-) | **Marketdata Contracts ** | =CS.QUERY("ContractMarketCap","Marketdata Contracts ") | =CS.PARAMETERS("ContractMarketCap","Marketdata Contracts ") | 2 | | Try It | [Docs](/providers/contractmarketcap/global-summary-) | **Global Summary ** | =CS.QUERY("ContractMarketCap","Global Summary ") | =CS.PARAMETERS("ContractMarketCap","Global Summary ") | 1 | | Try It | [Docs](/providers/contractmarketcap/global-summary-by-symbol) | **Global Summary by Symbol** | =CS.QUERY("ContractMarketCap","Global Summary by Symbol") | =CS.PARAMETERS("ContractMarketCap","Global Summary by Symbol") | 3 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/contractmarketcap/index-feed) | **Index Feed** | =CSQUERY("ContractMarketCap","Index Feed") | =CSPARAMETERS("ContractMarketCap","Index Feed") | 0 | | Try It | [Docs](/providers/contractmarketcap/public-system-time-) | **Public System Time ** | =CSQUERY("ContractMarketCap","Public System Time ") | =CSPARAMETERS("ContractMarketCap","Public System Time ") | 1 | | Try It | [Docs](/providers/contractmarketcap/public-system-status-) | **Public System Status ** | =CSQUERY("ContractMarketCap","Public System Status ") | =CSPARAMETERS("ContractMarketCap","Public System Status ") | 1 | | Try It | [Docs](/providers/contractmarketcap/public-system-limits-) | **Public System Limits ** | =CSQUERY("ContractMarketCap","Public System Limits ") | =CSPARAMETERS("ContractMarketCap","Public System Limits ") | 1 | | Try It | [Docs](/providers/contractmarketcap/fx-) | **Fx ** | =CSQUERY("ContractMarketCap","Fx ") | =CSPARAMETERS("ContractMarketCap","Fx ") | 1 | | Try It | [Docs](/providers/contractmarketcap/fx-by-symbol) | **Fx by Symbol** | =CSQUERY("ContractMarketCap","Fx by Symbol") | =CSPARAMETERS("ContractMarketCap","Fx by Symbol") | 2 | | Try It | [Docs](/providers/contractmarketcap/indices-) | **Indices ** | =CSQUERY("ContractMarketCap","Indices ") | =CSPARAMETERS("ContractMarketCap","Indices ") | 1 | | Try It | [Docs](/providers/contractmarketcap/indices-symbols-) | **Indices Symbols ** | =CSQUERY("ContractMarketCap","Indices Symbols ") | =CSPARAMETERS("ContractMarketCap","Indices Symbols ") | 1 | | Try It | [Docs](/providers/contractmarketcap/indices-by-excode) | **Indices by Excode** | =CSQUERY("ContractMarketCap","Indices by Excode") | =CSPARAMETERS("ContractMarketCap","Indices by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/index-by-symbol) | **Index by Symbol** | =CSQUERY("ContractMarketCap","Index by Symbol") | =CSPARAMETERS("ContractMarketCap","Index by Symbol") | 2 | | Try It | [Docs](/providers/contractmarketcap/index-history-by-symbol) | **Index History by Symbol** | =CSQUERY("ContractMarketCap","Index History by Symbol") | =CSPARAMETERS("ContractMarketCap","Index History by Symbol") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchanges-) | **Exchanges ** | =CSQUERY("ContractMarketCap","Exchanges ") | =CSPARAMETERS("ContractMarketCap","Exchanges ") | 1 | | Try It | [Docs](/providers/contractmarketcap/exchange-by-excode) | **Exchange by Excode** | =CSQUERY("ContractMarketCap","Exchange by Excode") | =CSPARAMETERS("ContractMarketCap","Exchange by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-info-by-excode) | **Exchange Info by Excode** | =CSQUERY("ContractMarketCap","Exchange Info by Excode") | =CSPARAMETERS("ContractMarketCap","Exchange Info by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-contracts-by-excode) | **Exchange Contracts by Excode** | =CSQUERY("ContractMarketCap","Exchange Contracts by Excode") | =CSPARAMETERS("ContractMarketCap","Exchange Contracts by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-indices-by-excode) | **Exchange Indices by Excode** | =CSQUERY("ContractMarketCap","Exchange Indices by Excode") | =CSPARAMETERS("ContractMarketCap","Exchange Indices by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-stats-by-excode) | **Exchange Stats by Excode** | =CSQUERY("ContractMarketCap","Exchange Stats by Excode") | =CSPARAMETERS("ContractMarketCap","Exchange Stats by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-history-by-excode) | **Exchange History by Excode** | =CSQUERY("ContractMarketCap","Exchange History by Excode") | =CSPARAMETERS("ContractMarketCap","Exchange History by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-reports-by-excode) | **Exchange Reports by Excode** | =CSQUERY("ContractMarketCap","Exchange Reports by Excode") | =CSPARAMETERS("ContractMarketCap","Exchange Reports by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/exchange-news-by-excode) | **Exchange News by Excode** | =CSQUERY("ContractMarketCap","Exchange News by Excode") | =CSPARAMETERS("ContractMarketCap","Exchange News by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/contracts-) | **Contracts ** | =CSQUERY("ContractMarketCap","Contracts ") | =CSPARAMETERS("ContractMarketCap","Contracts ") | 1 | | Try It | [Docs](/providers/contractmarketcap/contracts-traded-) | **Contracts Traded ** | =CSQUERY("ContractMarketCap","Contracts Traded ") | =CSPARAMETERS("ContractMarketCap","Contracts Traded ") | 1 | | Try It | [Docs](/providers/contractmarketcap/contracts-expired-) | **Contracts Expired ** | =CSQUERY("ContractMarketCap","Contracts Expired ") | =CSPARAMETERS("ContractMarketCap","Contracts Expired ") | 1 | | Try It | [Docs](/providers/contractmarketcap/contracts-perpetual-) | **Contracts Perpetual ** | =CSQUERY("ContractMarketCap","Contracts Perpetual ") | =CSPARAMETERS("ContractMarketCap","Contracts Perpetual ") | 1 | | Try It | [Docs](/providers/contractmarketcap/contracts-tod-) | **Contracts Tod ** | =CSQUERY("ContractMarketCap","Contracts Tod ") | =CSPARAMETERS("ContractMarketCap","Contracts Tod ") | 1 | | Try It | [Docs](/providers/contractmarketcap/contracts-tom-) | **Contracts Tom ** | =CSQUERY("ContractMarketCap","Contracts Tom ") | =CSPARAMETERS("ContractMarketCap","Contracts Tom ") | 1 | | Try It | [Docs](/providers/contractmarketcap/contracts-by-excode) | **Contracts by Excode** | =CSQUERY("ContractMarketCap","Contracts by Excode") | =CSPARAMETERS("ContractMarketCap","Contracts by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/contract-by-id) | **Contract by Id** | =CSQUERY("ContractMarketCap","Contract by Id") | =CSPARAMETERS("ContractMarketCap","Contract by Id") | 2 | | Try It | [Docs](/providers/contractmarketcap/marketdata-summary-) | **Marketdata Summary ** | =CSQUERY("ContractMarketCap","Marketdata Summary ") | =CSPARAMETERS("ContractMarketCap","Marketdata Summary ") | 1 | | Try It | [Docs](/providers/contractmarketcap/marketdata-summary-by-period) | **Marketdata Summary by Period** | =CSQUERY("ContractMarketCap","Marketdata Summary by Period") | =CSPARAMETERS("ContractMarketCap","Marketdata Summary by Period") | 2 | | Try It | [Docs](/providers/contractmarketcap/marketdata-exchange-by-excode) | **Marketdata Exchange by Excode** | =CSQUERY("ContractMarketCap","Marketdata Exchange by Excode") | =CSPARAMETERS("ContractMarketCap","Marketdata Exchange by Excode") | 2 | | Try It | [Docs](/providers/contractmarketcap/marketdata-contract-by-id) | **Marketdata Contract by Id** | =CSQUERY("ContractMarketCap","Marketdata Contract by Id") | =CSPARAMETERS("ContractMarketCap","Marketdata Contract by Id") | 2 | | Try It | [Docs](/providers/contractmarketcap/marketdata-contract-history-eod-by-id) | **Marketdata Contract History Eod by Id** | =CSQUERY("ContractMarketCap","Marketdata Contract History Eod by Id") | =CSPARAMETERS("ContractMarketCap","Marketdata Contract History Eod by Id") | 2 | | Try It | [Docs](/providers/contractmarketcap/marketdata-contracts-) | **Marketdata Contracts ** | =CSQUERY("ContractMarketCap","Marketdata Contracts ") | =CSPARAMETERS("ContractMarketCap","Marketdata Contracts ") | 2 | | Try It | [Docs](/providers/contractmarketcap/global-summary-) | **Global Summary ** | =CSQUERY("ContractMarketCap","Global Summary ") | =CSPARAMETERS("ContractMarketCap","Global Summary ") | 1 | | Try It | [Docs](/providers/contractmarketcap/global-summary-by-symbol) | **Global Summary by Symbol** | =CSQUERY("ContractMarketCap","Global Summary by Symbol") | =CSPARAMETERS("ContractMarketCap","Global Summary by Symbol") | 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 ContractMarketCap Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `ContractMarketCap` `provider`