> Cryptocurrency Price, Market, and Developer/Social Data Find examples for accessing every **CoinGecko** 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/coingecko/ping) | **Ping** | =CS.QUERY("CoinGecko","Ping") | =CS.PARAMETERS("CoinGecko","Ping") | 0 | | Try It | [Docs](/providers/coingecko/simple-price) | **Simple Price** | =CS.QUERY("CoinGecko","Simple Price") | =CS.PARAMETERS("CoinGecko","Simple Price") | 6 | | Try It | [Docs](/providers/coingecko/simple-token-price-by-contract-address) | **Simple Token Price by Contract Address** | =CS.QUERY("CoinGecko","Simple Token Price by Contract Address") | =CS.PARAMETERS("CoinGecko","Simple Token Price by Contract Address") | 7 | | Try It | [Docs](/providers/coingecko/supported-vs-currencies) | **Supported Vs Currencies** | =CS.QUERY("CoinGecko","Supported Vs Currencies") | =CS.PARAMETERS("CoinGecko","Supported Vs Currencies") | 0 | | Try It | [Docs](/providers/coingecko/coins-list) | **Coins List** | =CS.QUERY("CoinGecko","Coins List") | =CS.PARAMETERS("CoinGecko","Coins List") | 0 | | Try It | [Docs](/providers/coingecko/coins-markets) | **Coins Markets** | =CS.QUERY("CoinGecko","Coins Markets") | =CS.PARAMETERS("CoinGecko","Coins Markets") | 8 | | Try It | [Docs](/providers/coingecko/coins-details) | **Coins Details** | =CS.QUERY("CoinGecko","Coins Details") | =CS.PARAMETERS("CoinGecko","Coins Details") | 7 | | Try It | [Docs](/providers/coingecko/coins-tickers) | **Coins Tickers** | =CS.QUERY("CoinGecko","Coins Tickers") | =CS.PARAMETERS("CoinGecko","Coins Tickers") | 5 | | Try It | [Docs](/providers/coingecko/coins-history) | **Coins History** | =CS.QUERY("CoinGecko","Coins History") | =CS.PARAMETERS("CoinGecko","Coins History") | 3 | | Try It | [Docs](/providers/coingecko/coins-market-chart) | **Coins Market Chart** | =CS.QUERY("CoinGecko","Coins Market Chart") | =CS.PARAMETERS("CoinGecko","Coins Market Chart") | 3 | | Try It | [Docs](/providers/coingecko/coins-market-chart-range) | **Coins Market Chart Range** | =CS.QUERY("CoinGecko","Coins Market Chart Range") | =CS.PARAMETERS("CoinGecko","Coins Market Chart Range") | 4 | | Try It | [Docs](/providers/coingecko/coins-status-updates) | **Coins Status Updates** | =CS.QUERY("CoinGecko","Coins Status Updates") | =CS.PARAMETERS("CoinGecko","Coins Status Updates") | 3 | | Try It | [Docs](/providers/coingecko/coins-by-contract-address) | **Coins by Contract Address** | =CS.QUERY("CoinGecko","Coins by Contract Address") | =CS.PARAMETERS("CoinGecko","Coins by Contract Address") | 2 | | Try It | [Docs](/providers/coingecko/coins-by-contract-address-market-chart) | **Coins by Contract Address Market Chart** | =CS.QUERY("CoinGecko","Coins by Contract Address Market Chart") | =CS.PARAMETERS("CoinGecko","Coins by Contract Address Market Chart") | 4 | | Try It | [Docs](/providers/coingecko/coins-by-contract-address-market-chart-range) | **Coins by Contract Address Market Chart Range** | =CS.QUERY("CoinGecko","Coins by Contract Address Market Chart Range") | =CS.PARAMETERS("CoinGecko","Coins by Contract Address Market Chart Range") | 5 | | Try It | [Docs](/providers/coingecko/coins-ohlc) | **Coins OHLC** | =CS.QUERY("CoinGecko","Coins OHLC") | =CS.PARAMETERS("CoinGecko","Coins OHLC") | 3 | | Try It | [Docs](/providers/coingecko/exchanges) | **Exchanges** | =CS.QUERY("CoinGecko","Exchanges") | =CS.PARAMETERS("CoinGecko","Exchanges") | 2 | | Try It | [Docs](/providers/coingecko/exchanges-list) | **Exchanges List** | =CS.QUERY("CoinGecko","Exchanges List") | =CS.PARAMETERS("CoinGecko","Exchanges List") | 0 | | Try It | [Docs](/providers/coingecko/exchanges-details) | **Exchanges Details** | =CS.QUERY("CoinGecko","Exchanges Details") | =CS.PARAMETERS("CoinGecko","Exchanges Details") | 1 | | Try It | [Docs](/providers/coingecko/exchanges-tickers) | **Exchanges Tickers** | =CS.QUERY("CoinGecko","Exchanges Tickers") | =CS.PARAMETERS("CoinGecko","Exchanges Tickers") | 5 | | Try It | [Docs](/providers/coingecko/finance-platforms) | **Finance Platforms** | =CS.QUERY("CoinGecko","Finance Platforms") | =CS.PARAMETERS("CoinGecko","Finance Platforms") | 2 | | Try It | [Docs](/providers/coingecko/finance-products) | **Finance Products** | =CS.QUERY("CoinGecko","Finance Products") | =CS.PARAMETERS("CoinGecko","Finance Products") | 4 | | Try It | [Docs](/providers/coingecko/indexes) | **Indexes** | =CS.QUERY("CoinGecko","Indexes") | =CS.PARAMETERS("CoinGecko","Indexes") | 2 | | Try It | [Docs](/providers/coingecko/indexes-details) | **Indexes Details** | =CS.QUERY("CoinGecko","Indexes Details") | =CS.PARAMETERS("CoinGecko","Indexes Details") | 1 | | Try It | [Docs](/providers/coingecko/indexes-list) | **Indexes List** | =CS.QUERY("CoinGecko","Indexes List") | =CS.PARAMETERS("CoinGecko","Indexes List") | 0 | | Try It | [Docs](/providers/coingecko/derivatives) | **Derivatives** | =CS.QUERY("CoinGecko","Derivatives") | =CS.PARAMETERS("CoinGecko","Derivatives") | 1 | | Try It | [Docs](/providers/coingecko/derivatives-exchanges) | **Derivatives Exchanges** | =CS.QUERY("CoinGecko","Derivatives Exchanges") | =CS.PARAMETERS("CoinGecko","Derivatives Exchanges") | 3 | | Try It | [Docs](/providers/coingecko/derivatives-exchanges-details) | **Derivatives Exchanges Details** | =CS.QUERY("CoinGecko","Derivatives Exchanges Details") | =CS.PARAMETERS("CoinGecko","Derivatives Exchanges Details") | 2 | | Try It | [Docs](/providers/coingecko/derivatives-exchanges-list) | **Derivatives Exchanges List** | =CS.QUERY("CoinGecko","Derivatives Exchanges List") | =CS.PARAMETERS("CoinGecko","Derivatives Exchanges List") | 0 | | Try It | [Docs](/providers/coingecko/exchanges-status-updates) | **Exchanges Status Updates** | =CS.QUERY("CoinGecko","Exchanges Status Updates") | =CS.PARAMETERS("CoinGecko","Exchanges Status Updates") | 3 | | Try It | [Docs](/providers/coingecko/exchanges-volume-chart) | **Exchanges Volume Chart** | =CS.QUERY("CoinGecko","Exchanges Volume Chart") | =CS.PARAMETERS("CoinGecko","Exchanges Volume Chart") | 2 | | Try It | [Docs](/providers/coingecko/status-updates) | **Status Updates** | =CS.QUERY("CoinGecko","Status Updates") | =CS.PARAMETERS("CoinGecko","Status Updates") | 4 | | Try It | [Docs](/providers/coingecko/events) | **Events** | =CS.QUERY("CoinGecko","Events") | =CS.PARAMETERS("CoinGecko","Events") | 6 | | Try It | [Docs](/providers/coingecko/events-countries) | **Events Countries** | =CS.QUERY("CoinGecko","Events Countries") | =CS.PARAMETERS("CoinGecko","Events Countries") | 0 | | Try It | [Docs](/providers/coingecko/events-types) | **Events Types** | =CS.QUERY("CoinGecko","Events Types") | =CS.PARAMETERS("CoinGecko","Events Types") | 0 | | Try It | [Docs](/providers/coingecko/exchange-rates) | **Exchange Rates** | =CS.QUERY("CoinGecko","Exchange Rates") | =CS.PARAMETERS("CoinGecko","Exchange Rates") | 0 | | Try It | [Docs](/providers/coingecko/global) | **Global** | =CS.QUERY("CoinGecko","Global") | =CS.PARAMETERS("CoinGecko","Global") | 0 | | Try It | [Docs](/providers/coingecko/defi) | **Defi** | =CS.QUERY("CoinGecko","Defi") | =CS.PARAMETERS("CoinGecko","Defi") | 0 | | Try It | [Docs](/providers/coingecko/trending) | **Trending** | =CS.QUERY("CoinGecko","Trending") | =CS.PARAMETERS("CoinGecko","Trending") | 0 | | Try It | [Docs](/providers/coingecko/coins-markets-pro) | **Coins Markets PRO** | =CS.QUERY("CoinGecko","Coins Markets PRO") | =CS.PARAMETERS("CoinGecko","Coins Markets PRO") | 9 | | Try It | [Docs](/providers/coingecko/public-company-crypto-holdings) | **Public Company Crypto Holdings** | =CS.QUERY("CoinGecko","Public Company Crypto Holdings") | =CS.PARAMETERS("CoinGecko","Public Company Crypto Holdings") | 1 | | Try It | [Docs](/providers/coingecko/indexes-by-market-id) | **Indexes by Market ID** | =CS.QUERY("CoinGecko","Indexes by Market ID") | =CS.PARAMETERS("CoinGecko","Indexes by Market ID") | 0 | | Try It | [Docs](/providers/coingecko/categories) | **Categories** | =CS.QUERY("CoinGecko","Categories") | =CS.PARAMETERS("CoinGecko","Categories") | 1 | | Try It | [Docs](/providers/coingecko/categories-list) | **Categories List** | =CS.QUERY("CoinGecko","Categories List") | =CS.PARAMETERS("CoinGecko","Categories List") | 0 | | Try It | [Docs](/providers/coingecko/asset-platforms) | **Asset Platforms** | =CS.QUERY("CoinGecko","Asset Platforms") | =CS.PARAMETERS("CoinGecko","Asset Platforms") | 0 | | Try It | [Docs](/providers/coingecko/ping-pro) | **Ping PRO** | =CS.QUERY("CoinGecko","Ping PRO") | =CS.PARAMETERS("CoinGecko","Ping PRO") | 1 | | Try It | [Docs](/providers/coingecko/simple-price-pro) | **Simple Price PRO** | =CS.QUERY("CoinGecko","Simple Price PRO") | =CS.PARAMETERS("CoinGecko","Simple Price PRO") | 7 | | Try It | [Docs](/providers/coingecko/simple-token-price-by-contract-address-pro) | **Simple Token Price by Contract Address PRO** | =CS.QUERY("CoinGecko","Simple Token Price by Contract Address PRO") | =CS.PARAMETERS("CoinGecko","Simple Token Price by Contract Address PRO") | 8 | | Try It | [Docs](/providers/coingecko/supported-vs-currencies-pro) | **Supported Vs Currencies PRO** | =CS.QUERY("CoinGecko","Supported Vs Currencies PRO") | =CS.PARAMETERS("CoinGecko","Supported Vs Currencies PRO") | 1 | | Try It | [Docs](/providers/coingecko/coins-list-pro) | **Coins List PRO** | =CS.QUERY("CoinGecko","Coins List PRO") | =CS.PARAMETERS("CoinGecko","Coins List PRO") | 1 | | Try It | [Docs](/providers/coingecko/coins-markets-pro) | **Coins Markets PRO** | =CS.QUERY("CoinGecko","Coins Markets PRO") | =CS.PARAMETERS("CoinGecko","Coins Markets PRO") | 9 | | Try It | [Docs](/providers/coingecko/coins-details-pro) | **Coins Details PRO** | =CS.QUERY("CoinGecko","Coins Details PRO") | =CS.PARAMETERS("CoinGecko","Coins Details PRO") | 8 | | Try It | [Docs](/providers/coingecko/coins-tickers-pro) | **Coins Tickers PRO** | =CS.QUERY("CoinGecko","Coins Tickers PRO") | =CS.PARAMETERS("CoinGecko","Coins Tickers PRO") | 6 | | Try It | [Docs](/providers/coingecko/coins-history-pro) | **Coins History PRO** | =CS.QUERY("CoinGecko","Coins History PRO") | =CS.PARAMETERS("CoinGecko","Coins History PRO") | 4 | | Try It | [Docs](/providers/coingecko/coins-market-chart-pro) | **Coins Market Chart PRO** | =CS.QUERY("CoinGecko","Coins Market Chart PRO") | =CS.PARAMETERS("CoinGecko","Coins Market Chart PRO") | 4 | | Try It | [Docs](/providers/coingecko/coins-market-chart-range-pro) | **Coins Market Chart Range PRO** | =CS.QUERY("CoinGecko","Coins Market Chart Range PRO") | =CS.PARAMETERS("CoinGecko","Coins Market Chart Range PRO") | 5 | | Try It | [Docs](/providers/coingecko/coins-status-updates-pro) | **Coins Status Updates PRO** | =CS.QUERY("CoinGecko","Coins Status Updates PRO") | =CS.PARAMETERS("CoinGecko","Coins Status Updates PRO") | 4 | | Try It | [Docs](/providers/coingecko/coins-by-contract-address-pro) | **Coins by Contract Address PRO** | =CS.QUERY("CoinGecko","Coins by Contract Address PRO") | =CS.PARAMETERS("CoinGecko","Coins by Contract Address PRO") | 3 | | Try It | [Docs](/providers/coingecko/coins-by-contract-address-market-chart-pro) | **Coins by Contract Address Market Chart PRO** | =CS.QUERY("CoinGecko","Coins by Contract Address Market Chart PRO") | =CS.PARAMETERS("CoinGecko","Coins by Contract Address Market Chart PRO") | 5 | | Try It | [Docs](/providers/coingecko/coins-by-contract-address-market-chart-range-pro) | **Coins by Contract Address Market Chart Range PRO** | =CS.QUERY("CoinGecko","Coins by Contract Address Market Chart Range PRO") | =CS.PARAMETERS("CoinGecko","Coins by Contract Address Market Chart Range PRO") | 6 | | Try It | [Docs](/providers/coingecko/coins-ohlc-pro) | **Coins OHLC PRO** | =CS.QUERY("CoinGecko","Coins OHLC PRO") | =CS.PARAMETERS("CoinGecko","Coins OHLC PRO") | 4 | | Try It | [Docs](/providers/coingecko/exchanges-pro) | **Exchanges PRO** | =CS.QUERY("CoinGecko","Exchanges PRO") | =CS.PARAMETERS("CoinGecko","Exchanges PRO") | 3 | | Try It | [Docs](/providers/coingecko/exchanges-list-pro) | **Exchanges List PRO** | =CS.QUERY("CoinGecko","Exchanges List PRO") | =CS.PARAMETERS("CoinGecko","Exchanges List PRO") | 1 | | Try It | [Docs](/providers/coingecko/exchanges-details-pro) | **Exchanges Details PRO** | =CS.QUERY("CoinGecko","Exchanges Details PRO") | =CS.PARAMETERS("CoinGecko","Exchanges Details PRO") | 2 | | Try It | [Docs](/providers/coingecko/exchanges-tickers-pro) | **Exchanges Tickers PRO** | =CS.QUERY("CoinGecko","Exchanges Tickers PRO") | =CS.PARAMETERS("CoinGecko","Exchanges Tickers PRO") | 6 | | Try It | [Docs](/providers/coingecko/finance-platforms-pro) | **Finance Platforms PRO** | =CS.QUERY("CoinGecko","Finance Platforms PRO") | =CS.PARAMETERS("CoinGecko","Finance Platforms PRO") | 3 | | Try It | [Docs](/providers/coingecko/finance-products-pro) | **Finance Products PRO** | =CS.QUERY("CoinGecko","Finance Products PRO") | =CS.PARAMETERS("CoinGecko","Finance Products PRO") | 5 | | Try It | [Docs](/providers/coingecko/indexes-pro) | **Indexes PRO** | =CS.QUERY("CoinGecko","Indexes PRO") | =CS.PARAMETERS("CoinGecko","Indexes PRO") | 3 | | Try It | [Docs](/providers/coingecko/indexes-details-pro) | **Indexes Details PRO** | =CS.QUERY("CoinGecko","Indexes Details PRO") | =CS.PARAMETERS("CoinGecko","Indexes Details PRO") | 2 | | Try It | [Docs](/providers/coingecko/indexes-list-pro) | **Indexes List PRO** | =CS.QUERY("CoinGecko","Indexes List PRO") | =CS.PARAMETERS("CoinGecko","Indexes List PRO") | 1 | | Try It | [Docs](/providers/coingecko/derivatives-pro) | **Derivatives PRO** | =CS.QUERY("CoinGecko","Derivatives PRO") | =CS.PARAMETERS("CoinGecko","Derivatives PRO") | 2 | | Try It | [Docs](/providers/coingecko/derivatives-exchanges-pro) | **Derivatives Exchanges PRO** | =CS.QUERY("CoinGecko","Derivatives Exchanges PRO") | =CS.PARAMETERS("CoinGecko","Derivatives Exchanges PRO") | 4 | | Try It | [Docs](/providers/coingecko/derivatives-exchanges-details-pro) | **Derivatives Exchanges Details PRO** | =CS.QUERY("CoinGecko","Derivatives Exchanges Details PRO") | =CS.PARAMETERS("CoinGecko","Derivatives Exchanges Details PRO") | 3 | | Try It | [Docs](/providers/coingecko/derivatives-exchanges-list-pro) | **Derivatives Exchanges List PRO** | =CS.QUERY("CoinGecko","Derivatives Exchanges List PRO") | =CS.PARAMETERS("CoinGecko","Derivatives Exchanges List PRO") | 1 | | Try It | [Docs](/providers/coingecko/exchanges-status-updates-pro) | **Exchanges Status Updates PRO** | =CS.QUERY("CoinGecko","Exchanges Status Updates PRO") | =CS.PARAMETERS("CoinGecko","Exchanges Status Updates PRO") | 4 | | Try It | [Docs](/providers/coingecko/exchanges-volume-chart-pro) | **Exchanges Volume Chart PRO** | =CS.QUERY("CoinGecko","Exchanges Volume Chart PRO") | =CS.PARAMETERS("CoinGecko","Exchanges Volume Chart PRO") | 3 | | Try It | [Docs](/providers/coingecko/status-updates-pro) | **Status Updates PRO** | =CS.QUERY("CoinGecko","Status Updates PRO") | =CS.PARAMETERS("CoinGecko","Status Updates PRO") | 5 | | Try It | [Docs](/providers/coingecko/events-pro) | **Events PRO** | =CS.QUERY("CoinGecko","Events PRO") | =CS.PARAMETERS("CoinGecko","Events PRO") | 7 | | Try It | [Docs](/providers/coingecko/events-countries-pro) | **Events Countries PRO** | =CS.QUERY("CoinGecko","Events Countries PRO") | =CS.PARAMETERS("CoinGecko","Events Countries PRO") | 1 | | Try It | [Docs](/providers/coingecko/events-types-pro) | **Events Types PRO** | =CS.QUERY("CoinGecko","Events Types PRO") | =CS.PARAMETERS("CoinGecko","Events Types PRO") | 1 | | Try It | [Docs](/providers/coingecko/exchange-rates-pro) | **Exchange Rates PRO** | =CS.QUERY("CoinGecko","Exchange Rates PRO") | =CS.PARAMETERS("CoinGecko","Exchange Rates PRO") | 1 | | Try It | [Docs](/providers/coingecko/global-pro) | **Global PRO** | =CS.QUERY("CoinGecko","Global PRO") | =CS.PARAMETERS("CoinGecko","Global PRO") | 1 | | Try It | [Docs](/providers/coingecko/defi-pro) | **Defi PRO** | =CS.QUERY("CoinGecko","Defi PRO") | =CS.PARAMETERS("CoinGecko","Defi PRO") | 1 | | Try It | [Docs](/providers/coingecko/trending-pro) | **Trending PRO** | =CS.QUERY("CoinGecko","Trending PRO") | =CS.PARAMETERS("CoinGecko","Trending PRO") | 1 | | Try It | [Docs](/providers/coingecko/public-company-crypto-holdings-pro) | **Public Company Crypto Holdings PRO** | =CS.QUERY("CoinGecko","Public Company Crypto Holdings PRO") | =CS.PARAMETERS("CoinGecko","Public Company Crypto Holdings PRO") | 2 | | Try It | [Docs](/providers/coingecko/indexes-by-market-id-pro) | **Indexes by Market ID PRO** | =CS.QUERY("CoinGecko","Indexes by Market ID PRO") | =CS.PARAMETERS("CoinGecko","Indexes by Market ID PRO") | 1 | | Try It | [Docs](/providers/coingecko/categories-pro) | **Categories PRO** | =CS.QUERY("CoinGecko","Categories PRO") | =CS.PARAMETERS("CoinGecko","Categories PRO") | 2 | | Try It | [Docs](/providers/coingecko/categories-list-pro) | **Categories List PRO** | =CS.QUERY("CoinGecko","Categories List PRO") | =CS.PARAMETERS("CoinGecko","Categories List PRO") | 1 | | Try It | [Docs](/providers/coingecko/asset-platforms-pro) | **Asset Platforms PRO** | =CS.QUERY("CoinGecko","Asset Platforms PRO") | =CS.PARAMETERS("CoinGecko","Asset Platforms PRO") | 1 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/coingecko/ping) | **Ping** | =CSQUERY("CoinGecko","Ping") | =CSPARAMETERS("CoinGecko","Ping") | 0 | | Try It | [Docs](/providers/coingecko/simple-price) | **Simple Price** | =CSQUERY("CoinGecko","Simple Price") | =CSPARAMETERS("CoinGecko","Simple Price") | 6 | | Try It | [Docs](/providers/coingecko/simple-token-price-by-contract-address) | **Simple Token Price by Contract Address** | =CSQUERY("CoinGecko","Simple Token Price by Contract Address") | =CSPARAMETERS("CoinGecko","Simple Token Price by Contract Address") | 7 | | Try It | [Docs](/providers/coingecko/supported-vs-currencies) | **Supported Vs Currencies** | =CSQUERY("CoinGecko","Supported Vs Currencies") | =CSPARAMETERS("CoinGecko","Supported Vs Currencies") | 0 | | Try It | [Docs](/providers/coingecko/coins-list) | **Coins List** | =CSQUERY("CoinGecko","Coins List") | =CSPARAMETERS("CoinGecko","Coins List") | 0 | | Try It | [Docs](/providers/coingecko/coins-markets) | **Coins Markets** | =CSQUERY("CoinGecko","Coins Markets") | =CSPARAMETERS("CoinGecko","Coins Markets") | 8 | | Try It | [Docs](/providers/coingecko/coins-details) | **Coins Details** | =CSQUERY("CoinGecko","Coins Details") | =CSPARAMETERS("CoinGecko","Coins Details") | 7 | | Try It | [Docs](/providers/coingecko/coins-tickers) | **Coins Tickers** | =CSQUERY("CoinGecko","Coins Tickers") | =CSPARAMETERS("CoinGecko","Coins Tickers") | 5 | | Try It | [Docs](/providers/coingecko/coins-history) | **Coins History** | =CSQUERY("CoinGecko","Coins History") | =CSPARAMETERS("CoinGecko","Coins History") | 3 | | Try It | [Docs](/providers/coingecko/coins-market-chart) | **Coins Market Chart** | =CSQUERY("CoinGecko","Coins Market Chart") | =CSPARAMETERS("CoinGecko","Coins Market Chart") | 3 | | Try It | [Docs](/providers/coingecko/coins-market-chart-range) | **Coins Market Chart Range** | =CSQUERY("CoinGecko","Coins Market Chart Range") | =CSPARAMETERS("CoinGecko","Coins Market Chart Range") | 4 | | Try It | [Docs](/providers/coingecko/coins-status-updates) | **Coins Status Updates** | =CSQUERY("CoinGecko","Coins Status Updates") | =CSPARAMETERS("CoinGecko","Coins Status Updates") | 3 | | Try It | [Docs](/providers/coingecko/coins-by-contract-address) | **Coins by Contract Address** | =CSQUERY("CoinGecko","Coins by Contract Address") | =CSPARAMETERS("CoinGecko","Coins by Contract Address") | 2 | | Try It | [Docs](/providers/coingecko/coins-by-contract-address-market-chart) | **Coins by Contract Address Market Chart** | =CSQUERY("CoinGecko","Coins by Contract Address Market Chart") | =CSPARAMETERS("CoinGecko","Coins by Contract Address Market Chart") | 4 | | Try It | [Docs](/providers/coingecko/coins-by-contract-address-market-chart-range) | **Coins by Contract Address Market Chart Range** | =CSQUERY("CoinGecko","Coins by Contract Address Market Chart Range") | =CSPARAMETERS("CoinGecko","Coins by Contract Address Market Chart Range") | 5 | | Try It | [Docs](/providers/coingecko/coins-ohlc) | **Coins OHLC** | =CSQUERY("CoinGecko","Coins OHLC") | =CSPARAMETERS("CoinGecko","Coins OHLC") | 3 | | Try It | [Docs](/providers/coingecko/exchanges) | **Exchanges** | =CSQUERY("CoinGecko","Exchanges") | =CSPARAMETERS("CoinGecko","Exchanges") | 2 | | Try It | [Docs](/providers/coingecko/exchanges-list) | **Exchanges List** | =CSQUERY("CoinGecko","Exchanges List") | =CSPARAMETERS("CoinGecko","Exchanges List") | 0 | | Try It | [Docs](/providers/coingecko/exchanges-details) | **Exchanges Details** | =CSQUERY("CoinGecko","Exchanges Details") | =CSPARAMETERS("CoinGecko","Exchanges Details") | 1 | | Try It | [Docs](/providers/coingecko/exchanges-tickers) | **Exchanges Tickers** | =CSQUERY("CoinGecko","Exchanges Tickers") | =CSPARAMETERS("CoinGecko","Exchanges Tickers") | 5 | | Try It | [Docs](/providers/coingecko/finance-platforms) | **Finance Platforms** | =CSQUERY("CoinGecko","Finance Platforms") | =CSPARAMETERS("CoinGecko","Finance Platforms") | 2 | | Try It | [Docs](/providers/coingecko/finance-products) | **Finance Products** | =CSQUERY("CoinGecko","Finance Products") | =CSPARAMETERS("CoinGecko","Finance Products") | 4 | | Try It | [Docs](/providers/coingecko/indexes) | **Indexes** | =CSQUERY("CoinGecko","Indexes") | =CSPARAMETERS("CoinGecko","Indexes") | 2 | | Try It | [Docs](/providers/coingecko/indexes-details) | **Indexes Details** | =CSQUERY("CoinGecko","Indexes Details") | =CSPARAMETERS("CoinGecko","Indexes Details") | 1 | | Try It | [Docs](/providers/coingecko/indexes-list) | **Indexes List** | =CSQUERY("CoinGecko","Indexes List") | =CSPARAMETERS("CoinGecko","Indexes List") | 0 | | Try It | [Docs](/providers/coingecko/derivatives) | **Derivatives** | =CSQUERY("CoinGecko","Derivatives") | =CSPARAMETERS("CoinGecko","Derivatives") | 1 | | Try It | [Docs](/providers/coingecko/derivatives-exchanges) | **Derivatives Exchanges** | =CSQUERY("CoinGecko","Derivatives Exchanges") | =CSPARAMETERS("CoinGecko","Derivatives Exchanges") | 3 | | Try It | [Docs](/providers/coingecko/derivatives-exchanges-details) | **Derivatives Exchanges Details** | =CSQUERY("CoinGecko","Derivatives Exchanges Details") | =CSPARAMETERS("CoinGecko","Derivatives Exchanges Details") | 2 | | Try It | [Docs](/providers/coingecko/derivatives-exchanges-list) | **Derivatives Exchanges List** | =CSQUERY("CoinGecko","Derivatives Exchanges List") | =CSPARAMETERS("CoinGecko","Derivatives Exchanges List") | 0 | | Try It | [Docs](/providers/coingecko/exchanges-status-updates) | **Exchanges Status Updates** | =CSQUERY("CoinGecko","Exchanges Status Updates") | =CSPARAMETERS("CoinGecko","Exchanges Status Updates") | 3 | | Try It | [Docs](/providers/coingecko/exchanges-volume-chart) | **Exchanges Volume Chart** | =CSQUERY("CoinGecko","Exchanges Volume Chart") | =CSPARAMETERS("CoinGecko","Exchanges Volume Chart") | 2 | | Try It | [Docs](/providers/coingecko/status-updates) | **Status Updates** | =CSQUERY("CoinGecko","Status Updates") | =CSPARAMETERS("CoinGecko","Status Updates") | 4 | | Try It | [Docs](/providers/coingecko/events) | **Events** | =CSQUERY("CoinGecko","Events") | =CSPARAMETERS("CoinGecko","Events") | 6 | | Try It | [Docs](/providers/coingecko/events-countries) | **Events Countries** | =CSQUERY("CoinGecko","Events Countries") | =CSPARAMETERS("CoinGecko","Events Countries") | 0 | | Try It | [Docs](/providers/coingecko/events-types) | **Events Types** | =CSQUERY("CoinGecko","Events Types") | =CSPARAMETERS("CoinGecko","Events Types") | 0 | | Try It | [Docs](/providers/coingecko/exchange-rates) | **Exchange Rates** | =CSQUERY("CoinGecko","Exchange Rates") | =CSPARAMETERS("CoinGecko","Exchange Rates") | 0 | | Try It | [Docs](/providers/coingecko/global) | **Global** | =CSQUERY("CoinGecko","Global") | =CSPARAMETERS("CoinGecko","Global") | 0 | | Try It | [Docs](/providers/coingecko/defi) | **Defi** | =CSQUERY("CoinGecko","Defi") | =CSPARAMETERS("CoinGecko","Defi") | 0 | | Try It | [Docs](/providers/coingecko/trending) | **Trending** | =CSQUERY("CoinGecko","Trending") | =CSPARAMETERS("CoinGecko","Trending") | 0 | | Try It | [Docs](/providers/coingecko/coins-markets-pro) | **Coins Markets PRO** | =CSQUERY("CoinGecko","Coins Markets PRO") | =CSPARAMETERS("CoinGecko","Coins Markets PRO") | 9 | | Try It | [Docs](/providers/coingecko/public-company-crypto-holdings) | **Public Company Crypto Holdings** | =CSQUERY("CoinGecko","Public Company Crypto Holdings") | =CSPARAMETERS("CoinGecko","Public Company Crypto Holdings") | 1 | | Try It | [Docs](/providers/coingecko/indexes-by-market-id) | **Indexes by Market ID** | =CSQUERY("CoinGecko","Indexes by Market ID") | =CSPARAMETERS("CoinGecko","Indexes by Market ID") | 0 | | Try It | [Docs](/providers/coingecko/categories) | **Categories** | =CSQUERY("CoinGecko","Categories") | =CSPARAMETERS("CoinGecko","Categories") | 1 | | Try It | [Docs](/providers/coingecko/categories-list) | **Categories List** | =CSQUERY("CoinGecko","Categories List") | =CSPARAMETERS("CoinGecko","Categories List") | 0 | | Try It | [Docs](/providers/coingecko/asset-platforms) | **Asset Platforms** | =CSQUERY("CoinGecko","Asset Platforms") | =CSPARAMETERS("CoinGecko","Asset Platforms") | 0 | | Try It | [Docs](/providers/coingecko/ping-pro) | **Ping PRO** | =CSQUERY("CoinGecko","Ping PRO") | =CSPARAMETERS("CoinGecko","Ping PRO") | 1 | | Try It | [Docs](/providers/coingecko/simple-price-pro) | **Simple Price PRO** | =CSQUERY("CoinGecko","Simple Price PRO") | =CSPARAMETERS("CoinGecko","Simple Price PRO") | 7 | | Try It | [Docs](/providers/coingecko/simple-token-price-by-contract-address-pro) | **Simple Token Price by Contract Address PRO** | =CSQUERY("CoinGecko","Simple Token Price by Contract Address PRO") | =CSPARAMETERS("CoinGecko","Simple Token Price by Contract Address PRO") | 8 | | Try It | [Docs](/providers/coingecko/supported-vs-currencies-pro) | **Supported Vs Currencies PRO** | =CSQUERY("CoinGecko","Supported Vs Currencies PRO") | =CSPARAMETERS("CoinGecko","Supported Vs Currencies PRO") | 1 | | Try It | [Docs](/providers/coingecko/coins-list-pro) | **Coins List PRO** | =CSQUERY("CoinGecko","Coins List PRO") | =CSPARAMETERS("CoinGecko","Coins List PRO") | 1 | | Try It | [Docs](/providers/coingecko/coins-markets-pro) | **Coins Markets PRO** | =CSQUERY("CoinGecko","Coins Markets PRO") | =CSPARAMETERS("CoinGecko","Coins Markets PRO") | 9 | | Try It | [Docs](/providers/coingecko/coins-details-pro) | **Coins Details PRO** | =CSQUERY("CoinGecko","Coins Details PRO") | =CSPARAMETERS("CoinGecko","Coins Details PRO") | 8 | | Try It | [Docs](/providers/coingecko/coins-tickers-pro) | **Coins Tickers PRO** | =CSQUERY("CoinGecko","Coins Tickers PRO") | =CSPARAMETERS("CoinGecko","Coins Tickers PRO") | 6 | | Try It | [Docs](/providers/coingecko/coins-history-pro) | **Coins History PRO** | =CSQUERY("CoinGecko","Coins History PRO") | =CSPARAMETERS("CoinGecko","Coins History PRO") | 4 | | Try It | [Docs](/providers/coingecko/coins-market-chart-pro) | **Coins Market Chart PRO** | =CSQUERY("CoinGecko","Coins Market Chart PRO") | =CSPARAMETERS("CoinGecko","Coins Market Chart PRO") | 4 | | Try It | [Docs](/providers/coingecko/coins-market-chart-range-pro) | **Coins Market Chart Range PRO** | =CSQUERY("CoinGecko","Coins Market Chart Range PRO") | =CSPARAMETERS("CoinGecko","Coins Market Chart Range PRO") | 5 | | Try It | [Docs](/providers/coingecko/coins-status-updates-pro) | **Coins Status Updates PRO** | =CSQUERY("CoinGecko","Coins Status Updates PRO") | =CSPARAMETERS("CoinGecko","Coins Status Updates PRO") | 4 | | Try It | [Docs](/providers/coingecko/coins-by-contract-address-pro) | **Coins by Contract Address PRO** | =CSQUERY("CoinGecko","Coins by Contract Address PRO") | =CSPARAMETERS("CoinGecko","Coins by Contract Address PRO") | 3 | | Try It | [Docs](/providers/coingecko/coins-by-contract-address-market-chart-pro) | **Coins by Contract Address Market Chart PRO** | =CSQUERY("CoinGecko","Coins by Contract Address Market Chart PRO") | =CSPARAMETERS("CoinGecko","Coins by Contract Address Market Chart PRO") | 5 | | Try It | [Docs](/providers/coingecko/coins-by-contract-address-market-chart-range-pro) | **Coins by Contract Address Market Chart Range PRO** | =CSQUERY("CoinGecko","Coins by Contract Address Market Chart Range PRO") | =CSPARAMETERS("CoinGecko","Coins by Contract Address Market Chart Range PRO") | 6 | | Try It | [Docs](/providers/coingecko/coins-ohlc-pro) | **Coins OHLC PRO** | =CSQUERY("CoinGecko","Coins OHLC PRO") | =CSPARAMETERS("CoinGecko","Coins OHLC PRO") | 4 | | Try It | [Docs](/providers/coingecko/exchanges-pro) | **Exchanges PRO** | =CSQUERY("CoinGecko","Exchanges PRO") | =CSPARAMETERS("CoinGecko","Exchanges PRO") | 3 | | Try It | [Docs](/providers/coingecko/exchanges-list-pro) | **Exchanges List PRO** | =CSQUERY("CoinGecko","Exchanges List PRO") | =CSPARAMETERS("CoinGecko","Exchanges List PRO") | 1 | | Try It | [Docs](/providers/coingecko/exchanges-details-pro) | **Exchanges Details PRO** | =CSQUERY("CoinGecko","Exchanges Details PRO") | =CSPARAMETERS("CoinGecko","Exchanges Details PRO") | 2 | | Try It | [Docs](/providers/coingecko/exchanges-tickers-pro) | **Exchanges Tickers PRO** | =CSQUERY("CoinGecko","Exchanges Tickers PRO") | =CSPARAMETERS("CoinGecko","Exchanges Tickers PRO") | 6 | | Try It | [Docs](/providers/coingecko/finance-platforms-pro) | **Finance Platforms PRO** | =CSQUERY("CoinGecko","Finance Platforms PRO") | =CSPARAMETERS("CoinGecko","Finance Platforms PRO") | 3 | | Try It | [Docs](/providers/coingecko/finance-products-pro) | **Finance Products PRO** | =CSQUERY("CoinGecko","Finance Products PRO") | =CSPARAMETERS("CoinGecko","Finance Products PRO") | 5 | | Try It | [Docs](/providers/coingecko/indexes-pro) | **Indexes PRO** | =CSQUERY("CoinGecko","Indexes PRO") | =CSPARAMETERS("CoinGecko","Indexes PRO") | 3 | | Try It | [Docs](/providers/coingecko/indexes-details-pro) | **Indexes Details PRO** | =CSQUERY("CoinGecko","Indexes Details PRO") | =CSPARAMETERS("CoinGecko","Indexes Details PRO") | 2 | | Try It | [Docs](/providers/coingecko/indexes-list-pro) | **Indexes List PRO** | =CSQUERY("CoinGecko","Indexes List PRO") | =CSPARAMETERS("CoinGecko","Indexes List PRO") | 1 | | Try It | [Docs](/providers/coingecko/derivatives-pro) | **Derivatives PRO** | =CSQUERY("CoinGecko","Derivatives PRO") | =CSPARAMETERS("CoinGecko","Derivatives PRO") | 2 | | Try It | [Docs](/providers/coingecko/derivatives-exchanges-pro) | **Derivatives Exchanges PRO** | =CSQUERY("CoinGecko","Derivatives Exchanges PRO") | =CSPARAMETERS("CoinGecko","Derivatives Exchanges PRO") | 4 | | Try It | [Docs](/providers/coingecko/derivatives-exchanges-details-pro) | **Derivatives Exchanges Details PRO** | =CSQUERY("CoinGecko","Derivatives Exchanges Details PRO") | =CSPARAMETERS("CoinGecko","Derivatives Exchanges Details PRO") | 3 | | Try It | [Docs](/providers/coingecko/derivatives-exchanges-list-pro) | **Derivatives Exchanges List PRO** | =CSQUERY("CoinGecko","Derivatives Exchanges List PRO") | =CSPARAMETERS("CoinGecko","Derivatives Exchanges List PRO") | 1 | | Try It | [Docs](/providers/coingecko/exchanges-status-updates-pro) | **Exchanges Status Updates PRO** | =CSQUERY("CoinGecko","Exchanges Status Updates PRO") | =CSPARAMETERS("CoinGecko","Exchanges Status Updates PRO") | 4 | | Try It | [Docs](/providers/coingecko/exchanges-volume-chart-pro) | **Exchanges Volume Chart PRO** | =CSQUERY("CoinGecko","Exchanges Volume Chart PRO") | =CSPARAMETERS("CoinGecko","Exchanges Volume Chart PRO") | 3 | | Try It | [Docs](/providers/coingecko/status-updates-pro) | **Status Updates PRO** | =CSQUERY("CoinGecko","Status Updates PRO") | =CSPARAMETERS("CoinGecko","Status Updates PRO") | 5 | | Try It | [Docs](/providers/coingecko/events-pro) | **Events PRO** | =CSQUERY("CoinGecko","Events PRO") | =CSPARAMETERS("CoinGecko","Events PRO") | 7 | | Try It | [Docs](/providers/coingecko/events-countries-pro) | **Events Countries PRO** | =CSQUERY("CoinGecko","Events Countries PRO") | =CSPARAMETERS("CoinGecko","Events Countries PRO") | 1 | | Try It | [Docs](/providers/coingecko/events-types-pro) | **Events Types PRO** | =CSQUERY("CoinGecko","Events Types PRO") | =CSPARAMETERS("CoinGecko","Events Types PRO") | 1 | | Try It | [Docs](/providers/coingecko/exchange-rates-pro) | **Exchange Rates PRO** | =CSQUERY("CoinGecko","Exchange Rates PRO") | =CSPARAMETERS("CoinGecko","Exchange Rates PRO") | 1 | | Try It | [Docs](/providers/coingecko/global-pro) | **Global PRO** | =CSQUERY("CoinGecko","Global PRO") | =CSPARAMETERS("CoinGecko","Global PRO") | 1 | | Try It | [Docs](/providers/coingecko/defi-pro) | **Defi PRO** | =CSQUERY("CoinGecko","Defi PRO") | =CSPARAMETERS("CoinGecko","Defi PRO") | 1 | | Try It | [Docs](/providers/coingecko/trending-pro) | **Trending PRO** | =CSQUERY("CoinGecko","Trending PRO") | =CSPARAMETERS("CoinGecko","Trending PRO") | 1 | | Try It | [Docs](/providers/coingecko/public-company-crypto-holdings-pro) | **Public Company Crypto Holdings PRO** | =CSQUERY("CoinGecko","Public Company Crypto Holdings PRO") | =CSPARAMETERS("CoinGecko","Public Company Crypto Holdings PRO") | 2 | | Try It | [Docs](/providers/coingecko/indexes-by-market-id-pro) | **Indexes by Market ID PRO** | =CSQUERY("CoinGecko","Indexes by Market ID PRO") | =CSPARAMETERS("CoinGecko","Indexes by Market ID PRO") | 1 | | Try It | [Docs](/providers/coingecko/categories-pro) | **Categories PRO** | =CSQUERY("CoinGecko","Categories PRO") | =CSPARAMETERS("CoinGecko","Categories PRO") | 2 | | Try It | [Docs](/providers/coingecko/categories-list-pro) | **Categories List PRO** | =CSQUERY("CoinGecko","Categories List PRO") | =CSPARAMETERS("CoinGecko","Categories List PRO") | 1 | | Try It | [Docs](/providers/coingecko/asset-platforms-pro) | **Asset Platforms PRO** | =CSQUERY("CoinGecko","Asset Platforms PRO") | =CSPARAMETERS("CoinGecko","Asset Platforms PRO") | 1 |

[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 CoinGecko Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `CoinGecko` `provider`