Excel

Google Sheets

> Cryptocurrency Trading Platform

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro">Coinbase Pro</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/Coinbase%20Pro/Get%20Products" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-products) | **Get Products** | <inline-code functionvalue='=CS.QUERY("Coinbase Pro","Get Products")'>=CS.QUERY("Coinbase Pro","Get Products")</inline-code> | <inline-code>=CS.PARAMETERS("Coinbase Pro","Get Products")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%20Product%20Order%20Book" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-product-order-book) | **Get Product Order Book** | <inline-code functionvalue='=CS.QUERY("Coinbase Pro","Get Product Order Book",{"product","BTC-USD";"level","1"})'>=CS.QUERY("Coinbase Pro","Get Product Order Book")</inline-code> | <inline-code>=CS.PARAMETERS("Coinbase Pro","Get Product Order Book")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%20Product%20Order%20Ticker" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-product-order-ticker) | **Get Product Order Ticker** | <inline-code functionvalue='=CS.QUERY("Coinbase Pro","Get Product Order Ticker",{"product","BTC-USD"})'>=CS.QUERY("Coinbase Pro","Get Product Order Ticker")</inline-code> | <inline-code>=CS.PARAMETERS("Coinbase Pro","Get Product Order Ticker")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%20Trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-trades) | **Get Trades** | <inline-code functionvalue='=CS.QUERY("Coinbase Pro","Get Trades",{"product","BTC-USD"})'>=CS.QUERY("Coinbase Pro","Get Trades")</inline-code> | <inline-code>=CS.PARAMETERS("Coinbase Pro","Get Trades")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%20Historic%20Rates" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-historic-rates) | **Get Historic Rates** | <inline-code functionvalue='=CS.QUERY("Coinbase Pro","Get Historic Rates",{"product","BTC-USD";"start","";"end","";"granularity","3600"})'>=CS.QUERY("Coinbase Pro","Get Historic Rates")</inline-code> | <inline-code>=CS.PARAMETERS("Coinbase Pro","Get Historic Rates")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%2024hr%20Stats" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-24hr-stats) | **Get 24hr Stats** | <inline-code functionvalue='=CS.QUERY("Coinbase Pro","Get 24hr Stats",{"product","BTC-USD"})'>=CS.QUERY("Coinbase Pro","Get 24hr Stats")</inline-code> | <inline-code>=CS.PARAMETERS("Coinbase Pro","Get 24hr Stats")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%20Currencies" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-currencies) | **Get Currencies** | <inline-code functionvalue='=CS.QUERY("Coinbase Pro","Get Currencies")'>=CS.QUERY("Coinbase Pro","Get Currencies")</inline-code> | <inline-code>=CS.PARAMETERS("Coinbase Pro","Get Currencies")</inline-code> | 0 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%20Products" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-products) | **Get Products** | <inline-code functionvalue='=CSQUERY("Coinbase Pro","Get Products")'>=CSQUERY("Coinbase Pro","Get Products")</inline-code> | <inline-code>=CSPARAMETERS("Coinbase Pro","Get Products")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%20Product%20Order%20Book" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-product-order-book) | **Get Product Order Book** | <inline-code functionvalue='=CSQUERY("Coinbase Pro","Get Product Order Book",{"product","BTC-USD";"level","1"})'>=CSQUERY("Coinbase Pro","Get Product Order Book")</inline-code> | <inline-code>=CSPARAMETERS("Coinbase Pro","Get Product Order Book")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%20Product%20Order%20Ticker" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-product-order-ticker) | **Get Product Order Ticker** | <inline-code functionvalue='=CSQUERY("Coinbase Pro","Get Product Order Ticker",{"product","BTC-USD"})'>=CSQUERY("Coinbase Pro","Get Product Order Ticker")</inline-code> | <inline-code>=CSPARAMETERS("Coinbase Pro","Get Product Order Ticker")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%20Trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-trades) | **Get Trades** | <inline-code functionvalue='=CSQUERY("Coinbase Pro","Get Trades",{"product","BTC-USD"})'>=CSQUERY("Coinbase Pro","Get Trades")</inline-code> | <inline-code>=CSPARAMETERS("Coinbase Pro","Get Trades")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%20Historic%20Rates" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-historic-rates) | **Get Historic Rates** | <inline-code functionvalue='=CSQUERY("Coinbase Pro","Get Historic Rates",{"product","BTC-USD";"start","";"end","";"granularity","3600"})'>=CSQUERY("Coinbase Pro","Get Historic Rates")</inline-code> | <inline-code>=CSPARAMETERS("Coinbase Pro","Get Historic Rates")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%2024hr%20Stats" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-24hr-stats) | **Get 24hr Stats** | <inline-code functionvalue='=CSQUERY("Coinbase Pro","Get 24hr Stats",{"product","BTC-USD"})'>=CSQUERY("Coinbase Pro","Get 24hr Stats")</inline-code> | <inline-code>=CSPARAMETERS("Coinbase Pro","Get 24hr Stats")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Coinbase%20Pro/Get%20Currencies" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinbase-pro/get-currencies) | **Get Currencies** | <inline-code functionvalue='=CSQUERY("Coinbase Pro","Get Currencies")'>=CSQUERY("Coinbase Pro","Get Currencies")</inline-code> | <inline-code>=CSPARAMETERS("Coinbase Pro","Get Currencies")</inline-code> | 0 |

</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-Coinbase Pro">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-Coinbase Pro">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.pro.coinbase.com/#api">Click here</a>** for additional documentation from Coinbase Pro

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

---

Tags: `Coinbase Pro` `provider` 


How to pull Coinbase Pro data into Excel and Google Sheets