> The top crypto trading terminal to track your portfolio, analyze price charts, and place trades. Find examples for accessing every **Cryptowatch** 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/cryptowatch/performance-1m) | **Performance 1M** | =CS.QUERY("Cryptowatch","Performance 1M") | =CS.PARAMETERS("Cryptowatch","Performance 1M") | 0 | | Try It | [Docs](/providers/cryptowatch/performance-24h) | **Performance 24H** | =CS.QUERY("Cryptowatch","Performance 24H") | =CS.PARAMETERS("Cryptowatch","Performance 24H") | 0 | | Try It | [Docs](/providers/cryptowatch/performance-1w) | **Performance 1W** | =CS.QUERY("Cryptowatch","Performance 1W") | =CS.PARAMETERS("Cryptowatch","Performance 1W") | 0 | | Try It | [Docs](/providers/cryptowatch/performance-1y) | **Performance 1Y** | =CS.QUERY("Cryptowatch","Performance 1Y") | =CS.PARAMETERS("Cryptowatch","Performance 1Y") | 0 | | Try It | [Docs](/providers/cryptowatch/reddit-posts) | **Reddit Posts** | =CS.QUERY("Cryptowatch","Reddit Posts") | =CS.PARAMETERS("Cryptowatch","Reddit Posts") | 0 | | Try It | [Docs](/providers/cryptowatch/performance-1m) | **Performance 1M** | =CS.QUERY("Cryptowatch","Performance 1M") | =CS.PARAMETERS("Cryptowatch","Performance 1M") | 0 | | Try It | [Docs](/providers/cryptowatch/watchlist) | **Watchlist** | =CS.QUERY("Cryptowatch","Watchlist") | =CS.PARAMETERS("Cryptowatch","Watchlist") | 0 | | Try It | [Docs](/providers/cryptowatch/events) | **Events** | =CS.QUERY("Cryptowatch","Events") | =CS.PARAMETERS("Cryptowatch","Events") | 0 | | Try It | [Docs](/providers/cryptowatch/assets) | **Assets** | =CS.QUERY("Cryptowatch","Assets") | =CS.PARAMETERS("Cryptowatch","Assets") | 0 | | Try It | [Docs](/providers/cryptowatch/asset-details) | **Asset Details** | =CS.QUERY("Cryptowatch","Asset Details") | =CS.PARAMETERS("Cryptowatch","Asset Details") | 1 | | Try It | [Docs](/providers/cryptowatch/pairs) | **Pairs** | =CS.QUERY("Cryptowatch","Pairs") | =CS.PARAMETERS("Cryptowatch","Pairs") | 0 | | Try It | [Docs](/providers/cryptowatch/pair-details) | **Pair Details** | =CS.QUERY("Cryptowatch","Pair Details") | =CS.PARAMETERS("Cryptowatch","Pair Details") | 1 | | Try It | [Docs](/providers/cryptowatch/markets) | **Markets** | =CS.QUERY("Cryptowatch","Markets") | =CS.PARAMETERS("Cryptowatch","Markets") | 0 | | Try It | [Docs](/providers/cryptowatch/market-details) | **Market Details** | =CS.QUERY("Cryptowatch","Market Details") | =CS.PARAMETERS("Cryptowatch","Market Details") | 2 | | Try It | [Docs](/providers/cryptowatch/market-price) | **Market Price** | =CS.QUERY("Cryptowatch","Market Price") | =CS.PARAMETERS("Cryptowatch","Market Price") | 0 | | Try It | [Docs](/providers/cryptowatch/trades) | **Trades** | =CS.QUERY("Cryptowatch","Trades") | =CS.PARAMETERS("Cryptowatch","Trades") | 4 | | Try It | [Docs](/providers/cryptowatch/24hour-pair-summary) | **24Hour Pair Summary** | =CS.QUERY("Cryptowatch","24Hour Pair Summary") | =CS.PARAMETERS("Cryptowatch","24Hour Pair Summary") | 2 | | Try It | [Docs](/providers/cryptowatch/order-book) | **Order Book** | =CS.QUERY("Cryptowatch","Order Book") | =CS.PARAMETERS("Cryptowatch","Order Book") | 5 | | Try It | [Docs](/providers/cryptowatch/ohlc-candlesticks) | **OHLC Candlesticks** | =CS.QUERY("Cryptowatch","OHLC Candlesticks") | =CS.PARAMETERS("Cryptowatch","OHLC Candlesticks") | 2 | | Try It | [Docs](/providers/cryptowatch/exchanges) | **Exchanges** | =CS.QUERY("Cryptowatch","Exchanges") | =CS.PARAMETERS("Cryptowatch","Exchanges") | 0 | | Try It | [Docs](/providers/cryptowatch/exchanges-detail) | **Exchanges Detail** | =CS.QUERY("Cryptowatch","Exchanges Detail") | =CS.PARAMETERS("Cryptowatch","Exchanges Detail") | 1 | | Try It | [Docs](/providers/cryptowatch/exchange-markets) | **Exchange Markets** | =CS.QUERY("Cryptowatch","Exchange Markets") | =CS.PARAMETERS("Cryptowatch","Exchange Markets") | 1 | | Try It | [Docs](/providers/cryptowatch/all-market-prices) | **All Market Prices** | =CS.QUERY("Cryptowatch","All Market Prices") | =CS.PARAMETERS("Cryptowatch","All Market Prices") | 0 | | Try It | [Docs](/providers/cryptowatch/all-24hour-summaries) | **All 24Hour Summaries** | =CS.QUERY("Cryptowatch","All 24Hour Summaries") | =CS.PARAMETERS("Cryptowatch","All 24Hour Summaries") | 1 | | Try It | [Docs](/providers/cryptowatch/order-book-liquidity) | **Order Book Liquidity** | =CS.QUERY("Cryptowatch","Order Book Liquidity") | =CS.PARAMETERS("Cryptowatch","Order Book Liquidity") | 2 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/cryptowatch/performance-1m) | **Performance 1M** | =CSQUERY("Cryptowatch","Performance 1M") | =CSPARAMETERS("Cryptowatch","Performance 1M") | 0 | | Try It | [Docs](/providers/cryptowatch/performance-24h) | **Performance 24H** | =CSQUERY("Cryptowatch","Performance 24H") | =CSPARAMETERS("Cryptowatch","Performance 24H") | 0 | | Try It | [Docs](/providers/cryptowatch/performance-1w) | **Performance 1W** | =CSQUERY("Cryptowatch","Performance 1W") | =CSPARAMETERS("Cryptowatch","Performance 1W") | 0 | | Try It | [Docs](/providers/cryptowatch/performance-1y) | **Performance 1Y** | =CSQUERY("Cryptowatch","Performance 1Y") | =CSPARAMETERS("Cryptowatch","Performance 1Y") | 0 | | Try It | [Docs](/providers/cryptowatch/reddit-posts) | **Reddit Posts** | =CSQUERY("Cryptowatch","Reddit Posts") | =CSPARAMETERS("Cryptowatch","Reddit Posts") | 0 | | Try It | [Docs](/providers/cryptowatch/performance-1m) | **Performance 1M** | =CSQUERY("Cryptowatch","Performance 1M") | =CSPARAMETERS("Cryptowatch","Performance 1M") | 0 | | Try It | [Docs](/providers/cryptowatch/watchlist) | **Watchlist** | =CSQUERY("Cryptowatch","Watchlist") | =CSPARAMETERS("Cryptowatch","Watchlist") | 0 | | Try It | [Docs](/providers/cryptowatch/events) | **Events** | =CSQUERY("Cryptowatch","Events") | =CSPARAMETERS("Cryptowatch","Events") | 0 | | Try It | [Docs](/providers/cryptowatch/assets) | **Assets** | =CSQUERY("Cryptowatch","Assets") | =CSPARAMETERS("Cryptowatch","Assets") | 0 | | Try It | [Docs](/providers/cryptowatch/asset-details) | **Asset Details** | =CSQUERY("Cryptowatch","Asset Details") | =CSPARAMETERS("Cryptowatch","Asset Details") | 1 | | Try It | [Docs](/providers/cryptowatch/pairs) | **Pairs** | =CSQUERY("Cryptowatch","Pairs") | =CSPARAMETERS("Cryptowatch","Pairs") | 0 | | Try It | [Docs](/providers/cryptowatch/pair-details) | **Pair Details** | =CSQUERY("Cryptowatch","Pair Details") | =CSPARAMETERS("Cryptowatch","Pair Details") | 1 | | Try It | [Docs](/providers/cryptowatch/markets) | **Markets** | =CSQUERY("Cryptowatch","Markets") | =CSPARAMETERS("Cryptowatch","Markets") | 0 | | Try It | [Docs](/providers/cryptowatch/market-details) | **Market Details** | =CSQUERY("Cryptowatch","Market Details") | =CSPARAMETERS("Cryptowatch","Market Details") | 2 | | Try It | [Docs](/providers/cryptowatch/market-price) | **Market Price** | =CSQUERY("Cryptowatch","Market Price") | =CSPARAMETERS("Cryptowatch","Market Price") | 0 | | Try It | [Docs](/providers/cryptowatch/trades) | **Trades** | =CSQUERY("Cryptowatch","Trades") | =CSPARAMETERS("Cryptowatch","Trades") | 4 | | Try It | [Docs](/providers/cryptowatch/24hour-pair-summary) | **24Hour Pair Summary** | =CSQUERY("Cryptowatch","24Hour Pair Summary") | =CSPARAMETERS("Cryptowatch","24Hour Pair Summary") | 2 | | Try It | [Docs](/providers/cryptowatch/order-book) | **Order Book** | =CSQUERY("Cryptowatch","Order Book") | =CSPARAMETERS("Cryptowatch","Order Book") | 5 | | Try It | [Docs](/providers/cryptowatch/ohlc-candlesticks) | **OHLC Candlesticks** | =CSQUERY("Cryptowatch","OHLC Candlesticks") | =CSPARAMETERS("Cryptowatch","OHLC Candlesticks") | 2 | | Try It | [Docs](/providers/cryptowatch/exchanges) | **Exchanges** | =CSQUERY("Cryptowatch","Exchanges") | =CSPARAMETERS("Cryptowatch","Exchanges") | 0 | | Try It | [Docs](/providers/cryptowatch/exchanges-detail) | **Exchanges Detail** | =CSQUERY("Cryptowatch","Exchanges Detail") | =CSPARAMETERS("Cryptowatch","Exchanges Detail") | 1 | | Try It | [Docs](/providers/cryptowatch/exchange-markets) | **Exchange Markets** | =CSQUERY("Cryptowatch","Exchange Markets") | =CSPARAMETERS("Cryptowatch","Exchange Markets") | 1 | | Try It | [Docs](/providers/cryptowatch/all-market-prices) | **All Market Prices** | =CSQUERY("Cryptowatch","All Market Prices") | =CSPARAMETERS("Cryptowatch","All Market Prices") | 0 | | Try It | [Docs](/providers/cryptowatch/all-24hour-summaries) | **All 24Hour Summaries** | =CSQUERY("Cryptowatch","All 24Hour Summaries") | =CSPARAMETERS("Cryptowatch","All 24Hour Summaries") | 1 | | Try It | [Docs](/providers/cryptowatch/order-book-liquidity) | **Order Book Liquidity** | =CSQUERY("Cryptowatch","Order Book Liquidity") | =CSPARAMETERS("Cryptowatch","Order Book Liquidity") | 2 |

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