Excel

Google Sheets

> CoinStats is a Crypto Portfolio Manager &amp; DeFi Wallet helping over 1,000,000 active customers manage all their crypto accounts together from one place

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Coinstats">Coinstats</a>** endpoint using **Cryptosheets** through:

- `side panel console`
- `custom functions` (Excel & Googlesheets)
- `templates`

## Excel

<div class="markdown">

| App Url                                                                                 | Docs Url                                                                                 | Name                        | Example                                             | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | --------   | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Coins%20with%20Global%20Average%20Prices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/coins-with-global-average-prices) | **Coins with Global Average Prices** | <inline-code functionvalue='=CS.QUERY("Coinstats","Coins with Global Average Prices",{"skip","0";"limit","20";"currency","USD"})'>=CS.QUERY("Coinstats","Coins with Global Average Prices")</inline-code> | <inline-code>=CS.PARAMETERS("Coinstats","Coins with Global Average Prices")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Coin%20with%20Global%20Average%20Prices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/coin-with-global-average-prices) | **Coin with Global Average Prices** | <inline-code functionvalue='=CS.QUERY("Coinstats","Coin with Global Average Prices",{"currency","USD"})'>=CS.QUERY("Coinstats","Coin with Global Average Prices")</inline-code> | <inline-code>=CS.PARAMETERS("Coinstats","Coin with Global Average Prices")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Historical%20Global%20Average%20Price%20Chart" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/historical-global-average-price-chart) | **Historical Global Average Price Chart** | <inline-code functionvalue='=CS.QUERY("Coinstats","Historical Global Average Price Chart",{"period","1m";"coinId","ethereum"})'>=CS.QUERY("Coinstats","Historical Global Average Price Chart")</inline-code> | <inline-code>=CS.PARAMETERS("Coinstats","Historical Global Average Price Chart")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Get%20Exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/get-exchanges) | **Get Exchanges** | <inline-code functionvalue='=CS.QUERY("Coinstats","Get Exchanges")'>=CS.QUERY("Coinstats","Get Exchanges")</inline-code> | <inline-code>=CS.PARAMETERS("Coinstats","Get Exchanges")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Get%20Markets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/get-markets) | **Get Markets** | <inline-code functionvalue='=CS.QUERY("Coinstats","Get Markets",{"coinId","ethereum"})'>=CS.QUERY("Coinstats","Get Markets")</inline-code> | <inline-code>=CS.PARAMETERS("Coinstats","Get Markets")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Get%20Tickers" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/get-tickers) | **Get Tickers** | <inline-code functionvalue='=CS.QUERY("Coinstats","Get Tickers",{"exchange","binance";"pair","BTC-USD"})'>=CS.QUERY("Coinstats","Get Tickers")</inline-code> | <inline-code>=CS.PARAMETERS("Coinstats","Get Tickers")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Get%20Fiats" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/get-fiats) | **Get Fiats** | <inline-code functionvalue='=CS.QUERY("Coinstats","Get Fiats")'>=CS.QUERY("Coinstats","Get Fiats")</inline-code> | <inline-code>=CS.PARAMETERS("Coinstats","Get Fiats")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Get%20News" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/get-news) | **Get News** | <inline-code functionvalue='=CS.QUERY("Coinstats","Get News",{"skip","0";"limit","20";"toDate","1655508420000";"fromDate","1555508420000"})'>=CS.QUERY("Coinstats","Get News")</inline-code> | <inline-code>=CS.PARAMETERS("Coinstats","Get News")</inline-code> | 4 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Coins%20with%20Global%20Average%20Prices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/coins-with-global-average-prices) | **Coins with Global Average Prices** | <inline-code functionvalue='=CSQUERY("Coinstats","Coins with Global Average Prices",{"skip","0";"limit","20";"currency","USD"})'>=CSQUERY("Coinstats","Coins with Global Average Prices")</inline-code> | <inline-code>=CSPARAMETERS("Coinstats","Coins with Global Average Prices")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Coin%20with%20Global%20Average%20Prices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/coin-with-global-average-prices) | **Coin with Global Average Prices** | <inline-code functionvalue='=CSQUERY("Coinstats","Coin with Global Average Prices",{"currency","USD"})'>=CSQUERY("Coinstats","Coin with Global Average Prices")</inline-code> | <inline-code>=CSPARAMETERS("Coinstats","Coin with Global Average Prices")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Historical%20Global%20Average%20Price%20Chart" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/historical-global-average-price-chart) | **Historical Global Average Price Chart** | <inline-code functionvalue='=CSQUERY("Coinstats","Historical Global Average Price Chart",{"period","1m";"coinId","ethereum"})'>=CSQUERY("Coinstats","Historical Global Average Price Chart")</inline-code> | <inline-code>=CSPARAMETERS("Coinstats","Historical Global Average Price Chart")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Get%20Exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/get-exchanges) | **Get Exchanges** | <inline-code functionvalue='=CSQUERY("Coinstats","Get Exchanges")'>=CSQUERY("Coinstats","Get Exchanges")</inline-code> | <inline-code>=CSPARAMETERS("Coinstats","Get Exchanges")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Get%20Markets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/get-markets) | **Get Markets** | <inline-code functionvalue='=CSQUERY("Coinstats","Get Markets",{"coinId","ethereum"})'>=CSQUERY("Coinstats","Get Markets")</inline-code> | <inline-code>=CSPARAMETERS("Coinstats","Get Markets")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Get%20Tickers" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/get-tickers) | **Get Tickers** | <inline-code functionvalue='=CSQUERY("Coinstats","Get Tickers",{"exchange","binance";"pair","BTC-USD"})'>=CSQUERY("Coinstats","Get Tickers")</inline-code> | <inline-code>=CSPARAMETERS("Coinstats","Get Tickers")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Get%20Fiats" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/get-fiats) | **Get Fiats** | <inline-code functionvalue='=CSQUERY("Coinstats","Get Fiats")'>=CSQUERY("Coinstats","Get Fiats")</inline-code> | <inline-code>=CSPARAMETERS("Coinstats","Get Fiats")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Coinstats/Get%20News" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinstats/get-news) | **Get News** | <inline-code functionvalue='=CSQUERY("Coinstats","Get News",{"skip","0";"limit","20";"toDate","1655508420000";"fromDate","1555508420000"})'>=CSQUERY("Coinstats","Get News")</inline-code> | <inline-code>=CSPARAMETERS("Coinstats","Get News")</inline-code> | 4 |

</div>

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less

**<a href="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=docs-Coinstats">Get Cryptosheets for Microsoft Excel</a>**

**<a href="https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget?src=docs-Coinstats">Get Cryptosheets for Googlesheets</a>**

\*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

**<a href="https://coinstats.app">Click here</a>** for additional documentation from Coinstats

Learn more [here](https://intercom.help/cryptosheets/en/)

---

Tags: `Coinstats` `provider` 


How to pull Coinstats data into Excel and Google Sheets