Excel

Google Sheets

> All cryptocurrency exchanges integrated under a single unified API

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/CoinAPI">CoinAPI</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/CoinAPI/exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/exchanges) | **exchanges** | <inline-code functionvalue='=CS.QUERY("CoinAPI","exchanges")'>=CS.QUERY("CoinAPI","exchanges")</inline-code> | <inline-code>=CS.PARAMETERS("CoinAPI","exchanges")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/symbols" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/symbols) | **symbols** | <inline-code functionvalue='=CS.QUERY("CoinAPI","symbols",{"filter_symbol_id","BITSTAMP_SPOT_BTC_USD";"apikey","YOUR API KEY"})'>=CS.QUERY("CoinAPI","symbols")</inline-code> | <inline-code>=CS.PARAMETERS("CoinAPI","symbols")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/assets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/assets) | **assets** | <inline-code functionvalue='=CS.QUERY("CoinAPI","assets")'>=CS.QUERY("CoinAPI","assets")</inline-code> | <inline-code>=CS.PARAMETERS("CoinAPI","assets")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/exchangerate" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/exchangerate) | **exchangerate** | <inline-code functionvalue='=CS.QUERY("CoinAPI","exchangerate",{"asset_id_base","BTC";"asset_id_quote","USD";"time","2017-08-09T14:31:18.3150000Z";"apikey","YOUR_API_KEY"})'>=CS.QUERY("CoinAPI","exchangerate")</inline-code> | <inline-code>=CS.PARAMETERS("CoinAPI","exchangerate")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/trades) | **trades** | <inline-code functionvalue='=CS.QUERY("CoinAPI","trades",{"filter_symbol_id","COINBASE_SPOT_BTC_USD";"limit","100";"apikey","YOUR_API_KEY"})'>=CS.QUERY("CoinAPI","trades")</inline-code> | <inline-code>=CS.PARAMETERS("CoinAPI","trades")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/quotes" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/quotes) | **quotes** | <inline-code functionvalue='=CS.QUERY("CoinAPI","quotes",{"filter_symbol_id","BITSTAMP_SPOT_BTC_USD";"apikey","YOUR_API_KEY";"limit_levels","5";"limit","5"})'>=CS.QUERY("CoinAPI","quotes")</inline-code> | <inline-code>=CS.PARAMETERS("CoinAPI","quotes")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/orderbooks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/orderbooks) | **orderbooks** | <inline-code functionvalue='=CS.QUERY("CoinAPI","orderbooks",{"filter_symbol_id","COINBASE_SPOT_BTC_USD";"limit_levels","5";"apikey","YOUR_API_KEY"})'>=CS.QUERY("CoinAPI","orderbooks")</inline-code> | <inline-code>=CS.PARAMETERS("CoinAPI","orderbooks")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/ohlcv" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/ohlcv) | **ohlcv** | <inline-code functionvalue='=CS.QUERY("CoinAPI","ohlcv",{"apikey","YOUR_API_KEY";"symbol_id","COINBASE_SPOT_BTC_USD";"period_id","1DAY";"limit","10";"include_empty_items","false"})'>=CS.QUERY("CoinAPI","ohlcv")</inline-code> | <inline-code>=CS.PARAMETERS("CoinAPI","ohlcv")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/tradesh" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/tradesh) | **tradesh** | <inline-code functionvalue='=CS.QUERY("CoinAPI","tradesh")'>=CS.QUERY("CoinAPI","tradesh")</inline-code> | <inline-code>=CS.PARAMETERS("CoinAPI","tradesh")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/ohlcvh" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/ohlcvh) | **ohlcvh** | <inline-code functionvalue='=CS.QUERY("CoinAPI","ohlcvh",{"apikey","YOUR_API_KEY";"symbol_id","COINBASE_SPOT_BTC_USD";"period_id","1DAY";"limit","10";"include_empty_items","false";"time_start","2019-10-01T00:00:00.0000000Z";"time_end",""})'>=CS.QUERY("CoinAPI","ohlcvh")</inline-code> | <inline-code>=CS.PARAMETERS("CoinAPI","ohlcvh")</inline-code> | 7 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/exchanges) | **exchanges** | <inline-code functionvalue='=CSQUERY("CoinAPI","exchanges")'>=CSQUERY("CoinAPI","exchanges")</inline-code> | <inline-code>=CSPARAMETERS("CoinAPI","exchanges")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/symbols" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/symbols) | **symbols** | <inline-code functionvalue='=CSQUERY("CoinAPI","symbols",{"filter_symbol_id","BITSTAMP_SPOT_BTC_USD";"apikey","YOUR API KEY"})'>=CSQUERY("CoinAPI","symbols")</inline-code> | <inline-code>=CSPARAMETERS("CoinAPI","symbols")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/assets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/assets) | **assets** | <inline-code functionvalue='=CSQUERY("CoinAPI","assets")'>=CSQUERY("CoinAPI","assets")</inline-code> | <inline-code>=CSPARAMETERS("CoinAPI","assets")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/exchangerate" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/exchangerate) | **exchangerate** | <inline-code functionvalue='=CSQUERY("CoinAPI","exchangerate",{"asset_id_base","BTC";"asset_id_quote","USD";"time","2017-08-09T14:31:18.3150000Z";"apikey","YOUR_API_KEY"})'>=CSQUERY("CoinAPI","exchangerate")</inline-code> | <inline-code>=CSPARAMETERS("CoinAPI","exchangerate")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/trades) | **trades** | <inline-code functionvalue='=CSQUERY("CoinAPI","trades",{"filter_symbol_id","COINBASE_SPOT_BTC_USD";"limit","100";"apikey","YOUR_API_KEY"})'>=CSQUERY("CoinAPI","trades")</inline-code> | <inline-code>=CSPARAMETERS("CoinAPI","trades")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/quotes" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/quotes) | **quotes** | <inline-code functionvalue='=CSQUERY("CoinAPI","quotes",{"filter_symbol_id","BITSTAMP_SPOT_BTC_USD";"apikey","YOUR_API_KEY";"limit_levels","5";"limit","5"})'>=CSQUERY("CoinAPI","quotes")</inline-code> | <inline-code>=CSPARAMETERS("CoinAPI","quotes")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/orderbooks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/orderbooks) | **orderbooks** | <inline-code functionvalue='=CSQUERY("CoinAPI","orderbooks",{"filter_symbol_id","COINBASE_SPOT_BTC_USD";"limit_levels","5";"apikey","YOUR_API_KEY"})'>=CSQUERY("CoinAPI","orderbooks")</inline-code> | <inline-code>=CSPARAMETERS("CoinAPI","orderbooks")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/ohlcv" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/ohlcv) | **ohlcv** | <inline-code functionvalue='=CSQUERY("CoinAPI","ohlcv",{"apikey","YOUR_API_KEY";"symbol_id","COINBASE_SPOT_BTC_USD";"period_id","1DAY";"limit","10";"include_empty_items","false"})'>=CSQUERY("CoinAPI","ohlcv")</inline-code> | <inline-code>=CSPARAMETERS("CoinAPI","ohlcv")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/tradesh" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/tradesh) | **tradesh** | <inline-code functionvalue='=CSQUERY("CoinAPI","tradesh")'>=CSQUERY("CoinAPI","tradesh")</inline-code> | <inline-code>=CSPARAMETERS("CoinAPI","tradesh")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinAPI/ohlcvh" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinapi/ohlcvh) | **ohlcvh** | <inline-code functionvalue='=CSQUERY("CoinAPI","ohlcvh",{"apikey","YOUR_API_KEY";"symbol_id","COINBASE_SPOT_BTC_USD";"period_id","1DAY";"limit","10";"include_empty_items","false";"time_start","2019-10-01T00:00:00.0000000Z";"time_end",""})'>=CSQUERY("CoinAPI","ohlcvh")</inline-code> | <inline-code>=CSPARAMETERS("CoinAPI","ohlcvh")</inline-code> | 7 |

</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-CoinAPI">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-CoinAPI">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://docs.coinapi.io/">Click here</a>** for additional documentation from CoinAPI

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

---

Tags: `CoinAPI` `provider` 


How to pull CoinAPI data into Excel and Google Sheets