> Latest streaming pricing data in the world of cryptocurrencies. Find examples for accessing every **CryptoCompare** 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/cryptocompare/mining-equipment) | **Mining Equipment** | =CS.QUERY("CryptoCompare","Mining Equipment") | =CS.PARAMETERS("CryptoCompare","Mining Equipment") | 0 | | Try It | [Docs](/providers/cryptocompare/mining-contracts) | **Mining Contracts** | =CS.QUERY("CryptoCompare","Mining Contracts") | =CS.PARAMETERS("CryptoCompare","Mining Contracts") | 0 | | Try It | [Docs](/providers/cryptocompare/price) | **Price** | =CS.QUERY("CryptoCompare","Price") | =CS.PARAMETERS("CryptoCompare","Price") | 7 | | Try It | [Docs](/providers/cryptocompare/pricemulti) | **Pricemulti** | =CS.QUERY("CryptoCompare","Pricemulti") | =CS.PARAMETERS("CryptoCompare","Pricemulti") | 7 | | Try It | [Docs](/providers/cryptocompare/pricemultifull) | **Pricemultifull** | =CS.QUERY("CryptoCompare","Pricemultifull") | =CS.PARAMETERS("CryptoCompare","Pricemultifull") | 7 | | Try It | [Docs](/providers/cryptocompare/generateavg) | **Generateavg** | =CS.QUERY("CryptoCompare","Generateavg") | =CS.PARAMETERS("CryptoCompare","Generateavg") | 5 | | Try It | [Docs](/providers/cryptocompare/v2-histoday) | **V2 Histoday** | =CS.QUERY("CryptoCompare","V2 Histoday") | =CS.PARAMETERS("CryptoCompare","V2 Histoday") | 13 | | Try It | [Docs](/providers/cryptocompare/v2-histohour) | **V2 Histohour** | =CS.QUERY("CryptoCompare","V2 Histohour") | =CS.PARAMETERS("CryptoCompare","V2 Histohour") | 12 | | Try It | [Docs](/providers/cryptocompare/v2-histominute) | **V2 Histominute** | =CS.QUERY("CryptoCompare","V2 Histominute") | =CS.PARAMETERS("CryptoCompare","V2 Histominute") | 12 | | Try It | [Docs](/providers/cryptocompare/daily-market-close) | **Daily Market Close** | =CS.QUERY("CryptoCompare","Daily Market Close") | =CS.PARAMETERS("CryptoCompare","Daily Market Close") | 1 | | Try It | [Docs](/providers/cryptocompare/histoday) | **Histoday** | =CS.QUERY("CryptoCompare","Histoday") | =CS.PARAMETERS("CryptoCompare","Histoday") | 11 | | Try It | [Docs](/providers/cryptocompare/histohour) | **Histohour** | =CS.QUERY("CryptoCompare","Histohour") | =CS.PARAMETERS("CryptoCompare","Histohour") | 10 | | Try It | [Docs](/providers/cryptocompare/histominute) | **Histominute** | =CS.QUERY("CryptoCompare","Histominute") | =CS.PARAMETERS("CryptoCompare","Histominute") | 10 | | Try It | [Docs](/providers/cryptocompare/pricehistorical) | **Pricehistorical** | =CS.QUERY("CryptoCompare","Pricehistorical") | =CS.PARAMETERS("CryptoCompare","Pricehistorical") | 8 | | Try It | [Docs](/providers/cryptocompare/dayavg) | **Dayavg** | =CS.QUERY("CryptoCompare","Dayavg") | =CS.PARAMETERS("CryptoCompare","Dayavg") | 9 | | Try It | [Docs](/providers/cryptocompare/exchange-histoday) | **Exchange Histoday** | =CS.QUERY("CryptoCompare","Exchange Histoday") | =CS.PARAMETERS("CryptoCompare","Exchange Histoday") | 8 | | Try It | [Docs](/providers/cryptocompare/exchange-histohour) | **Exchange Histohour** | =CS.QUERY("CryptoCompare","Exchange Histohour") | =CS.PARAMETERS("CryptoCompare","Exchange Histohour") | 8 | | Try It | [Docs](/providers/cryptocompare/pair-mapping-fsym) | **Pair Mapping Fsym** | =CS.QUERY("CryptoCompare","Pair Mapping Fsym") | =CS.PARAMETERS("CryptoCompare","Pair Mapping Fsym") | 4 | | Try It | [Docs](/providers/cryptocompare/pair-mapping-exchange) | **Pair Mapping Exchange** | =CS.QUERY("CryptoCompare","Pair Mapping Exchange") | =CS.PARAMETERS("CryptoCompare","Pair Mapping Exchange") | 3 | | Try It | [Docs](/providers/cryptocompare/pair-mapping-exchange-fsym) | **Pair Mapping Exchange Fsym** | =CS.QUERY("CryptoCompare","Pair Mapping Exchange Fsym") | =CS.PARAMETERS("CryptoCompare","Pair Mapping Exchange Fsym") | 4 | | Try It | [Docs](/providers/cryptocompare/pair-mapping-planned-updates) | **Pair Mapping Planned Updates** | =CS.QUERY("CryptoCompare","Pair Mapping Planned Updates") | =CS.PARAMETERS("CryptoCompare","Pair Mapping Planned Updates") | 2 | | Try It | [Docs](/providers/cryptocompare/top-totalvolfull) | **Top Totalvolfull** | =CS.QUERY("CryptoCompare","Top Totalvolfull") | =CS.PARAMETERS("CryptoCompare","Top Totalvolfull") | 5 | | Try It | [Docs](/providers/cryptocompare/top-totaltoptiervolfull) | **Top Totaltoptiervolfull** | =CS.QUERY("CryptoCompare","Top Totaltoptiervolfull") | =CS.PARAMETERS("CryptoCompare","Top Totaltoptiervolfull") | 5 | | Try It | [Docs](/providers/cryptocompare/top-mktcapfull) | **Top Mktcapfull** | =CS.QUERY("CryptoCompare","Top Mktcapfull") | =CS.PARAMETERS("CryptoCompare","Top Mktcapfull") | 5 | | Try It | [Docs](/providers/cryptocompare/top-exchanges) | **Top Exchanges** | =CS.QUERY("CryptoCompare","Top Exchanges") | =CS.PARAMETERS("CryptoCompare","Top Exchanges") | 5 | | Try It | [Docs](/providers/cryptocompare/top-exchanges-full) | **Top Exchanges Full** | =CS.QUERY("CryptoCompare","Top Exchanges Full") | =CS.PARAMETERS("CryptoCompare","Top Exchanges Full") | 5 | | Try It | [Docs](/providers/cryptocompare/top-volumes) | **Top Volumes** | =CS.QUERY("CryptoCompare","Top Volumes") | =CS.PARAMETERS("CryptoCompare","Top Volumes") | 4 | | Try It | [Docs](/providers/cryptocompare/top-pairs) | **Top Pairs** | =CS.QUERY("CryptoCompare","Top Pairs") | =CS.PARAMETERS("CryptoCompare","Top Pairs") | 4 | | Try It | [Docs](/providers/cryptocompare/social-coin-latest) | **Social Coin Latest** | =CS.QUERY("CryptoCompare","Social Coin Latest") | =CS.PARAMETERS("CryptoCompare","Social Coin Latest") | 4 | | Try It | [Docs](/providers/cryptocompare/social-coin-histo-day) | **Social Coin Histo Day** | =CS.QUERY("CryptoCompare","Social Coin Histo Day") | =CS.PARAMETERS("CryptoCompare","Social Coin Histo Day") | 8 | | Try It | [Docs](/providers/cryptocompare/social-coin-histo-hour) | **Social Coin Histo Hour** | =CS.QUERY("CryptoCompare","Social Coin Histo Hour") | =CS.PARAMETERS("CryptoCompare","Social Coin Histo Hour") | 8 | | Try It | [Docs](/providers/cryptocompare/v2-news) | **V2 News** | =CS.QUERY("CryptoCompare","V2 News") | =CS.PARAMETERS("CryptoCompare","V2 News") | 8 | | Try It | [Docs](/providers/cryptocompare/news-feeds) | **News Feeds** | =CS.QUERY("CryptoCompare","News Feeds") | =CS.PARAMETERS("CryptoCompare","News Feeds") | 2 | | Try It | [Docs](/providers/cryptocompare/news-categories) | **News Categories** | =CS.QUERY("CryptoCompare","News Categories") | =CS.PARAMETERS("CryptoCompare","News Categories") | 2 | | Try It | [Docs](/providers/cryptocompare/news-feedsandcategories) | **News Feedsandcategories** | =CS.QUERY("CryptoCompare","News Feedsandcategories") | =CS.PARAMETERS("CryptoCompare","News Feedsandcategories") | 2 | | Try It | [Docs](/providers/cryptocompare/ob-l2-exchanges) | **Ob L2 Exchanges** | =CS.QUERY("CryptoCompare","Ob L2 Exchanges") | =CS.PARAMETERS("CryptoCompare","Ob L2 Exchanges") | 3 | | Try It | [Docs](/providers/cryptocompare/ob-l1-top) | **Ob L1 Top** | =CS.QUERY("CryptoCompare","Ob L1 Top") | =CS.PARAMETERS("CryptoCompare","Ob L1 Top") | 5 | | Try It | [Docs](/providers/cryptocompare/ob-l2-snapshot) | **Ob L2 Snapshot** | =CS.QUERY("CryptoCompare","Ob L2 Snapshot") | =CS.PARAMETERS("CryptoCompare","Ob L2 Snapshot") | 6 | | Try It | [Docs](/providers/cryptocompare/v3-all-exchanges) | **V3 All Exchanges** | =CS.QUERY("CryptoCompare","V3 All Exchanges") | =CS.PARAMETERS("CryptoCompare","V3 All Exchanges") | 5 | | Try It | [Docs](/providers/cryptocompare/all-includedexchanges) | **All Includedexchanges** | =CS.QUERY("CryptoCompare","All Includedexchanges") | =CS.PARAMETERS("CryptoCompare","All Includedexchanges") | 3 | | Try It | [Docs](/providers/cryptocompare/cccagg-pairs) | **Cccagg Pairs** | =CS.QUERY("CryptoCompare","Cccagg Pairs") | =CS.PARAMETERS("CryptoCompare","Cccagg Pairs") | 3 | | Try It | [Docs](/providers/cryptocompare/cccagg-pairs-excluded) | **Cccagg Pairs Excluded** | =CS.QUERY("CryptoCompare","Cccagg Pairs Excluded") | =CS.PARAMETERS("CryptoCompare","Cccagg Pairs Excluded") | 3 | | Try It | [Docs](/providers/cryptocompare/cccagg-pairs-absent) | **Cccagg Pairs Absent** | =CS.QUERY("CryptoCompare","Cccagg Pairs Absent") | =CS.PARAMETERS("CryptoCompare","Cccagg Pairs Absent") | 3 | | Try It | [Docs](/providers/cryptocompare/cccagg-coins-absent) | **Cccagg Coins Absent** | =CS.QUERY("CryptoCompare","Cccagg Coins Absent") | =CS.PARAMETERS("CryptoCompare","Cccagg Coins Absent") | 3 | | Try It | [Docs](/providers/cryptocompare/all-coinlist) | **All Coinlist** | =CS.QUERY("CryptoCompare","All Coinlist") | =CS.PARAMETERS("CryptoCompare","All Coinlist") | 4 | | Try It | [Docs](/providers/cryptocompare/exchanges) | **Exchanges** | =CS.QUERY("CryptoCompare","Exchanges") | =CS.PARAMETERS("CryptoCompare","Exchanges") | 3 | | Try It | [Docs](/providers/cryptocompare/gambling) | **Gambling** | =CS.QUERY("CryptoCompare","Gambling") | =CS.PARAMETERS("CryptoCompare","Gambling") | 2 | | Try It | [Docs](/providers/cryptocompare/wallets) | **Wallets** | =CS.QUERY("CryptoCompare","Wallets") | =CS.PARAMETERS("CryptoCompare","Wallets") | 2 | | Try It | [Docs](/providers/cryptocompare/cards) | **Cards** | =CS.QUERY("CryptoCompare","Cards") | =CS.PARAMETERS("CryptoCompare","Cards") | 2 | | Try It | [Docs](/providers/cryptocompare/mining-contracts) | **Mining Contracts** | =CS.QUERY("CryptoCompare","Mining Contracts") | =CS.PARAMETERS("CryptoCompare","Mining Contracts") | 2 | | Try It | [Docs](/providers/cryptocompare/mining-companies) | **Mining Companies** | =CS.QUERY("CryptoCompare","Mining Companies") | =CS.PARAMETERS("CryptoCompare","Mining Companies") | 2 | | Try It | [Docs](/providers/cryptocompare/mining-equipment) | **Mining Equipment** | =CS.QUERY("CryptoCompare","Mining Equipment") | =CS.PARAMETERS("CryptoCompare","Mining Equipment") | 2 | | Try It | [Docs](/providers/cryptocompare/mining-pools) | **Mining Pools** | =CS.QUERY("CryptoCompare","Mining Pools") | =CS.PARAMETERS("CryptoCompare","Mining Pools") | 2 | | Try It | [Docs](/providers/cryptocompare/recommended-all) | **Recommended All** | =CS.QUERY("CryptoCompare","Recommended All") | =CS.PARAMETERS("CryptoCompare","Recommended All") | 3 | | Try It | [Docs](/providers/cryptocompare/top-totalvol) | **Top Totalvol** | =CS.QUERY("CryptoCompare","Top Totalvol") | =CS.PARAMETERS("CryptoCompare","Top Totalvol") | 5 | | Try It | [Docs](/providers/cryptocompare/top-totaltoptiervol) | **Top Totaltoptiervol** | =CS.QUERY("CryptoCompare","Top Totaltoptiervol") | =CS.PARAMETERS("CryptoCompare","Top Totaltoptiervol") | 5 | | Try It | [Docs](/providers/cryptocompare/top-mktcap) | **Top Mktcap** | =CS.QUERY("CryptoCompare","Top Mktcap") | =CS.PARAMETERS("CryptoCompare","Top Mktcap") | 5 | | Try It | [Docs](/providers/cryptocompare/subs) | **Subs** | =CS.QUERY("CryptoCompare","Subs") | =CS.PARAMETERS("CryptoCompare","Subs") | 4 | | Try It | [Docs](/providers/cryptocompare/subswatchlist) | **Subswatchlist** | =CS.QUERY("CryptoCompare","Subswatchlist") | =CS.PARAMETERS("CryptoCompare","Subswatchlist") | 4 | | Try It | [Docs](/providers/cryptocompare/coininfo) | **Coininfo** | =CS.QUERY("CryptoCompare","Coininfo") | =CS.PARAMETERS("CryptoCompare","Coininfo") | 4 | | Try It | [Docs](/providers/cryptocompare/daily-symbol-vol-single-exchange) | **Daily Symbol Vol Single Exchange** | =CS.QUERY("CryptoCompare","Daily Symbol Vol Single Exchange") | =CS.PARAMETERS("CryptoCompare","Daily Symbol Vol Single Exchange") | 8 | | Try It | [Docs](/providers/cryptocompare/list-available-indices) | **List available indices** | =CS.QUERY("CryptoCompare","List available indices") | =CS.PARAMETERS("CryptoCompare","List available indices") | 1 | | Try It | [Docs](/providers/cryptocompare/single-index-value) | **Single index value** | =CS.QUERY("CryptoCompare","Single index value") | =CS.PARAMETERS("CryptoCompare","Single index value") | 6 | | Try It | [Docs](/providers/cryptocompare/historical-index-ohlc-minute) | **Historical Index OHLC Minute** | =CS.QUERY("CryptoCompare","Historical Index OHLC Minute") | =CS.PARAMETERS("CryptoCompare","Historical Index OHLC Minute") | 6 | | Try It | [Docs](/providers/cryptocompare/historical-index-ohlc-hourly) | **Historical Index OHLC Hourly** | =CS.QUERY("CryptoCompare","Historical Index OHLC Hourly") | =CS.PARAMETERS("CryptoCompare","Historical Index OHLC Hourly") | 6 | | Try It | [Docs](/providers/cryptocompare/historical-index-ohlc-daily) | **Historical Index OHLC Daily** | =CS.QUERY("CryptoCompare","Historical Index OHLC Daily") | =CS.PARAMETERS("CryptoCompare","Historical Index OHLC Daily") | 6 | | Try It | [Docs](/providers/cryptocompare/available-coin-list) | **Available Coin List** | =CS.QUERY("CryptoCompare","Available Coin List") | =CS.PARAMETERS("CryptoCompare","Available Coin List") | 1 | | Try It | [Docs](/providers/cryptocompare/latest) | **Latest** | =CS.QUERY("CryptoCompare","Latest") | =CS.PARAMETERS("CryptoCompare","Latest") | 2 | | Try It | [Docs](/providers/cryptocompare/historical-daily) | **Historical Daily** | =CS.QUERY("CryptoCompare","Historical Daily") | =CS.PARAMETERS("CryptoCompare","Historical Daily") | 4 | | Try It | [Docs](/providers/cryptocompare/trading-signals) | **Trading Signals** | =CS.QUERY("CryptoCompare","Trading Signals") | =CS.PARAMETERS("CryptoCompare","Trading Signals") | 2 | | Try It | [Docs](/providers/cryptocompare/daily-symbol-vol) | **Daily Symbol Vol** | =CS.QUERY("CryptoCompare","Daily Symbol Vol") | =CS.PARAMETERS("CryptoCompare","Daily Symbol Vol") | 8 | | Try It | [Docs](/providers/cryptocompare/hourly-symbol-vol) | **Hourly Symbol Vol** | =CS.QUERY("CryptoCompare","Hourly Symbol Vol") | =CS.PARAMETERS("CryptoCompare","Hourly Symbol Vol") | 8 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/cryptocompare/mining-equipment) | **Mining Equipment** | =CSQUERY("CryptoCompare","Mining Equipment") | =CSPARAMETERS("CryptoCompare","Mining Equipment") | 0 | | Try It | [Docs](/providers/cryptocompare/mining-contracts) | **Mining Contracts** | =CSQUERY("CryptoCompare","Mining Contracts") | =CSPARAMETERS("CryptoCompare","Mining Contracts") | 0 | | Try It | [Docs](/providers/cryptocompare/price) | **Price** | =CSQUERY("CryptoCompare","Price") | =CSPARAMETERS("CryptoCompare","Price") | 7 | | Try It | [Docs](/providers/cryptocompare/pricemulti) | **Pricemulti** | =CSQUERY("CryptoCompare","Pricemulti") | =CSPARAMETERS("CryptoCompare","Pricemulti") | 7 | | Try It | [Docs](/providers/cryptocompare/pricemultifull) | **Pricemultifull** | =CSQUERY("CryptoCompare","Pricemultifull") | =CSPARAMETERS("CryptoCompare","Pricemultifull") | 7 | | Try It | [Docs](/providers/cryptocompare/generateavg) | **Generateavg** | =CSQUERY("CryptoCompare","Generateavg") | =CSPARAMETERS("CryptoCompare","Generateavg") | 5 | | Try It | [Docs](/providers/cryptocompare/v2-histoday) | **V2 Histoday** | =CSQUERY("CryptoCompare","V2 Histoday") | =CSPARAMETERS("CryptoCompare","V2 Histoday") | 13 | | Try It | [Docs](/providers/cryptocompare/v2-histohour) | **V2 Histohour** | =CSQUERY("CryptoCompare","V2 Histohour") | =CSPARAMETERS("CryptoCompare","V2 Histohour") | 12 | | Try It | [Docs](/providers/cryptocompare/v2-histominute) | **V2 Histominute** | =CSQUERY("CryptoCompare","V2 Histominute") | =CSPARAMETERS("CryptoCompare","V2 Histominute") | 12 | | Try It | [Docs](/providers/cryptocompare/daily-market-close) | **Daily Market Close** | =CSQUERY("CryptoCompare","Daily Market Close") | =CSPARAMETERS("CryptoCompare","Daily Market Close") | 1 | | Try It | [Docs](/providers/cryptocompare/histoday) | **Histoday** | =CSQUERY("CryptoCompare","Histoday") | =CSPARAMETERS("CryptoCompare","Histoday") | 11 | | Try It | [Docs](/providers/cryptocompare/histohour) | **Histohour** | =CSQUERY("CryptoCompare","Histohour") | =CSPARAMETERS("CryptoCompare","Histohour") | 10 | | Try It | [Docs](/providers/cryptocompare/histominute) | **Histominute** | =CSQUERY("CryptoCompare","Histominute") | =CSPARAMETERS("CryptoCompare","Histominute") | 10 | | Try It | [Docs](/providers/cryptocompare/pricehistorical) | **Pricehistorical** | =CSQUERY("CryptoCompare","Pricehistorical") | =CSPARAMETERS("CryptoCompare","Pricehistorical") | 8 | | Try It | [Docs](/providers/cryptocompare/dayavg) | **Dayavg** | =CSQUERY("CryptoCompare","Dayavg") | =CSPARAMETERS("CryptoCompare","Dayavg") | 9 | | Try It | [Docs](/providers/cryptocompare/exchange-histoday) | **Exchange Histoday** | =CSQUERY("CryptoCompare","Exchange Histoday") | =CSPARAMETERS("CryptoCompare","Exchange Histoday") | 8 | | Try It | [Docs](/providers/cryptocompare/exchange-histohour) | **Exchange Histohour** | =CSQUERY("CryptoCompare","Exchange Histohour") | =CSPARAMETERS("CryptoCompare","Exchange Histohour") | 8 | | Try It | [Docs](/providers/cryptocompare/pair-mapping-fsym) | **Pair Mapping Fsym** | =CSQUERY("CryptoCompare","Pair Mapping Fsym") | =CSPARAMETERS("CryptoCompare","Pair Mapping Fsym") | 4 | | Try It | [Docs](/providers/cryptocompare/pair-mapping-exchange) | **Pair Mapping Exchange** | =CSQUERY("CryptoCompare","Pair Mapping Exchange") | =CSPARAMETERS("CryptoCompare","Pair Mapping Exchange") | 3 | | Try It | [Docs](/providers/cryptocompare/pair-mapping-exchange-fsym) | **Pair Mapping Exchange Fsym** | =CSQUERY("CryptoCompare","Pair Mapping Exchange Fsym") | =CSPARAMETERS("CryptoCompare","Pair Mapping Exchange Fsym") | 4 | | Try It | [Docs](/providers/cryptocompare/pair-mapping-planned-updates) | **Pair Mapping Planned Updates** | =CSQUERY("CryptoCompare","Pair Mapping Planned Updates") | =CSPARAMETERS("CryptoCompare","Pair Mapping Planned Updates") | 2 | | Try It | [Docs](/providers/cryptocompare/top-totalvolfull) | **Top Totalvolfull** | =CSQUERY("CryptoCompare","Top Totalvolfull") | =CSPARAMETERS("CryptoCompare","Top Totalvolfull") | 5 | | Try It | [Docs](/providers/cryptocompare/top-totaltoptiervolfull) | **Top Totaltoptiervolfull** | =CSQUERY("CryptoCompare","Top Totaltoptiervolfull") | =CSPARAMETERS("CryptoCompare","Top Totaltoptiervolfull") | 5 | | Try It | [Docs](/providers/cryptocompare/top-mktcapfull) | **Top Mktcapfull** | =CSQUERY("CryptoCompare","Top Mktcapfull") | =CSPARAMETERS("CryptoCompare","Top Mktcapfull") | 5 | | Try It | [Docs](/providers/cryptocompare/top-exchanges) | **Top Exchanges** | =CSQUERY("CryptoCompare","Top Exchanges") | =CSPARAMETERS("CryptoCompare","Top Exchanges") | 5 | | Try It | [Docs](/providers/cryptocompare/top-exchanges-full) | **Top Exchanges Full** | =CSQUERY("CryptoCompare","Top Exchanges Full") | =CSPARAMETERS("CryptoCompare","Top Exchanges Full") | 5 | | Try It | [Docs](/providers/cryptocompare/top-volumes) | **Top Volumes** | =CSQUERY("CryptoCompare","Top Volumes") | =CSPARAMETERS("CryptoCompare","Top Volumes") | 4 | | Try It | [Docs](/providers/cryptocompare/top-pairs) | **Top Pairs** | =CSQUERY("CryptoCompare","Top Pairs") | =CSPARAMETERS("CryptoCompare","Top Pairs") | 4 | | Try It | [Docs](/providers/cryptocompare/social-coin-latest) | **Social Coin Latest** | =CSQUERY("CryptoCompare","Social Coin Latest") | =CSPARAMETERS("CryptoCompare","Social Coin Latest") | 4 | | Try It | [Docs](/providers/cryptocompare/social-coin-histo-day) | **Social Coin Histo Day** | =CSQUERY("CryptoCompare","Social Coin Histo Day") | =CSPARAMETERS("CryptoCompare","Social Coin Histo Day") | 8 | | Try It | [Docs](/providers/cryptocompare/social-coin-histo-hour) | **Social Coin Histo Hour** | =CSQUERY("CryptoCompare","Social Coin Histo Hour") | =CSPARAMETERS("CryptoCompare","Social Coin Histo Hour") | 8 | | Try It | [Docs](/providers/cryptocompare/v2-news) | **V2 News** | =CSQUERY("CryptoCompare","V2 News") | =CSPARAMETERS("CryptoCompare","V2 News") | 8 | | Try It | [Docs](/providers/cryptocompare/news-feeds) | **News Feeds** | =CSQUERY("CryptoCompare","News Feeds") | =CSPARAMETERS("CryptoCompare","News Feeds") | 2 | | Try It | [Docs](/providers/cryptocompare/news-categories) | **News Categories** | =CSQUERY("CryptoCompare","News Categories") | =CSPARAMETERS("CryptoCompare","News Categories") | 2 | | Try It | [Docs](/providers/cryptocompare/news-feedsandcategories) | **News Feedsandcategories** | =CSQUERY("CryptoCompare","News Feedsandcategories") | =CSPARAMETERS("CryptoCompare","News Feedsandcategories") | 2 | | Try It | [Docs](/providers/cryptocompare/ob-l2-exchanges) | **Ob L2 Exchanges** | =CSQUERY("CryptoCompare","Ob L2 Exchanges") | =CSPARAMETERS("CryptoCompare","Ob L2 Exchanges") | 3 | | Try It | [Docs](/providers/cryptocompare/ob-l1-top) | **Ob L1 Top** | =CSQUERY("CryptoCompare","Ob L1 Top") | =CSPARAMETERS("CryptoCompare","Ob L1 Top") | 5 | | Try It | [Docs](/providers/cryptocompare/ob-l2-snapshot) | **Ob L2 Snapshot** | =CSQUERY("CryptoCompare","Ob L2 Snapshot") | =CSPARAMETERS("CryptoCompare","Ob L2 Snapshot") | 6 | | Try It | [Docs](/providers/cryptocompare/v3-all-exchanges) | **V3 All Exchanges** | =CSQUERY("CryptoCompare","V3 All Exchanges") | =CSPARAMETERS("CryptoCompare","V3 All Exchanges") | 5 | | Try It | [Docs](/providers/cryptocompare/all-includedexchanges) | **All Includedexchanges** | =CSQUERY("CryptoCompare","All Includedexchanges") | =CSPARAMETERS("CryptoCompare","All Includedexchanges") | 3 | | Try It | [Docs](/providers/cryptocompare/cccagg-pairs) | **Cccagg Pairs** | =CSQUERY("CryptoCompare","Cccagg Pairs") | =CSPARAMETERS("CryptoCompare","Cccagg Pairs") | 3 | | Try It | [Docs](/providers/cryptocompare/cccagg-pairs-excluded) | **Cccagg Pairs Excluded** | =CSQUERY("CryptoCompare","Cccagg Pairs Excluded") | =CSPARAMETERS("CryptoCompare","Cccagg Pairs Excluded") | 3 | | Try It | [Docs](/providers/cryptocompare/cccagg-pairs-absent) | **Cccagg Pairs Absent** | =CSQUERY("CryptoCompare","Cccagg Pairs Absent") | =CSPARAMETERS("CryptoCompare","Cccagg Pairs Absent") | 3 | | Try It | [Docs](/providers/cryptocompare/cccagg-coins-absent) | **Cccagg Coins Absent** | =CSQUERY("CryptoCompare","Cccagg Coins Absent") | =CSPARAMETERS("CryptoCompare","Cccagg Coins Absent") | 3 | | Try It | [Docs](/providers/cryptocompare/all-coinlist) | **All Coinlist** | =CSQUERY("CryptoCompare","All Coinlist") | =CSPARAMETERS("CryptoCompare","All Coinlist") | 4 | | Try It | [Docs](/providers/cryptocompare/exchanges) | **Exchanges** | =CSQUERY("CryptoCompare","Exchanges") | =CSPARAMETERS("CryptoCompare","Exchanges") | 3 | | Try It | [Docs](/providers/cryptocompare/gambling) | **Gambling** | =CSQUERY("CryptoCompare","Gambling") | =CSPARAMETERS("CryptoCompare","Gambling") | 2 | | Try It | [Docs](/providers/cryptocompare/wallets) | **Wallets** | =CSQUERY("CryptoCompare","Wallets") | =CSPARAMETERS("CryptoCompare","Wallets") | 2 | | Try It | [Docs](/providers/cryptocompare/cards) | **Cards** | =CSQUERY("CryptoCompare","Cards") | =CSPARAMETERS("CryptoCompare","Cards") | 2 | | Try It | [Docs](/providers/cryptocompare/mining-contracts) | **Mining Contracts** | =CSQUERY("CryptoCompare","Mining Contracts") | =CSPARAMETERS("CryptoCompare","Mining Contracts") | 2 | | Try It | [Docs](/providers/cryptocompare/mining-companies) | **Mining Companies** | =CSQUERY("CryptoCompare","Mining Companies") | =CSPARAMETERS("CryptoCompare","Mining Companies") | 2 | | Try It | [Docs](/providers/cryptocompare/mining-equipment) | **Mining Equipment** | =CSQUERY("CryptoCompare","Mining Equipment") | =CSPARAMETERS("CryptoCompare","Mining Equipment") | 2 | | Try It | [Docs](/providers/cryptocompare/mining-pools) | **Mining Pools** | =CSQUERY("CryptoCompare","Mining Pools") | =CSPARAMETERS("CryptoCompare","Mining Pools") | 2 | | Try It | [Docs](/providers/cryptocompare/recommended-all) | **Recommended All** | =CSQUERY("CryptoCompare","Recommended All") | =CSPARAMETERS("CryptoCompare","Recommended All") | 3 | | Try It | [Docs](/providers/cryptocompare/top-totalvol) | **Top Totalvol** | =CSQUERY("CryptoCompare","Top Totalvol") | =CSPARAMETERS("CryptoCompare","Top Totalvol") | 5 | | Try It | [Docs](/providers/cryptocompare/top-totaltoptiervol) | **Top Totaltoptiervol** | =CSQUERY("CryptoCompare","Top Totaltoptiervol") | =CSPARAMETERS("CryptoCompare","Top Totaltoptiervol") | 5 | | Try It | [Docs](/providers/cryptocompare/top-mktcap) | **Top Mktcap** | =CSQUERY("CryptoCompare","Top Mktcap") | =CSPARAMETERS("CryptoCompare","Top Mktcap") | 5 | | Try It | [Docs](/providers/cryptocompare/subs) | **Subs** | =CSQUERY("CryptoCompare","Subs") | =CSPARAMETERS("CryptoCompare","Subs") | 4 | | Try It | [Docs](/providers/cryptocompare/subswatchlist) | **Subswatchlist** | =CSQUERY("CryptoCompare","Subswatchlist") | =CSPARAMETERS("CryptoCompare","Subswatchlist") | 4 | | Try It | [Docs](/providers/cryptocompare/coininfo) | **Coininfo** | =CSQUERY("CryptoCompare","Coininfo") | =CSPARAMETERS("CryptoCompare","Coininfo") | 4 | | Try It | [Docs](/providers/cryptocompare/daily-symbol-vol-single-exchange) | **Daily Symbol Vol Single Exchange** | =CSQUERY("CryptoCompare","Daily Symbol Vol Single Exchange") | =CSPARAMETERS("CryptoCompare","Daily Symbol Vol Single Exchange") | 8 | | Try It | [Docs](/providers/cryptocompare/list-available-indices) | **List available indices** | =CSQUERY("CryptoCompare","List available indices") | =CSPARAMETERS("CryptoCompare","List available indices") | 1 | | Try It | [Docs](/providers/cryptocompare/single-index-value) | **Single index value** | =CSQUERY("CryptoCompare","Single index value") | =CSPARAMETERS("CryptoCompare","Single index value") | 6 | | Try It | [Docs](/providers/cryptocompare/historical-index-ohlc-minute) | **Historical Index OHLC Minute** | =CSQUERY("CryptoCompare","Historical Index OHLC Minute") | =CSPARAMETERS("CryptoCompare","Historical Index OHLC Minute") | 6 | | Try It | [Docs](/providers/cryptocompare/historical-index-ohlc-hourly) | **Historical Index OHLC Hourly** | =CSQUERY("CryptoCompare","Historical Index OHLC Hourly") | =CSPARAMETERS("CryptoCompare","Historical Index OHLC Hourly") | 6 | | Try It | [Docs](/providers/cryptocompare/historical-index-ohlc-daily) | **Historical Index OHLC Daily** | =CSQUERY("CryptoCompare","Historical Index OHLC Daily") | =CSPARAMETERS("CryptoCompare","Historical Index OHLC Daily") | 6 | | Try It | [Docs](/providers/cryptocompare/available-coin-list) | **Available Coin List** | =CSQUERY("CryptoCompare","Available Coin List") | =CSPARAMETERS("CryptoCompare","Available Coin List") | 1 | | Try It | [Docs](/providers/cryptocompare/latest) | **Latest** | =CSQUERY("CryptoCompare","Latest") | =CSPARAMETERS("CryptoCompare","Latest") | 2 | | Try It | [Docs](/providers/cryptocompare/historical-daily) | **Historical Daily** | =CSQUERY("CryptoCompare","Historical Daily") | =CSPARAMETERS("CryptoCompare","Historical Daily") | 4 | | Try It | [Docs](/providers/cryptocompare/trading-signals) | **Trading Signals** | =CSQUERY("CryptoCompare","Trading Signals") | =CSPARAMETERS("CryptoCompare","Trading Signals") | 2 | | Try It | [Docs](/providers/cryptocompare/daily-symbol-vol) | **Daily Symbol Vol** | =CSQUERY("CryptoCompare","Daily Symbol Vol") | =CSPARAMETERS("CryptoCompare","Daily Symbol Vol") | 8 | | Try It | [Docs](/providers/cryptocompare/hourly-symbol-vol) | **Hourly Symbol Vol** | =CSQUERY("CryptoCompare","Hourly Symbol Vol") | =CSPARAMETERS("CryptoCompare","Hourly Symbol Vol") | 8 |

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