Excel

Google Sheets

> Manage your portfolio in real time with Shrimpy

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Shrimpy">Shrimpy</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/Shrimpy/Get%20Ticker" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/get-ticker) | **Get Ticker** | <inline-code functionvalue='=CS.QUERY("Shrimpy","Get Ticker",{"exchange","kucoin"})'>=CS.QUERY("Shrimpy","Get Ticker")</inline-code> | <inline-code>=CS.PARAMETERS("Shrimpy","Get Ticker")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Orderbooks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/orderbooks) | **Orderbooks** | <inline-code functionvalue='=CS.QUERY("Shrimpy","Orderbooks",{"exchange","bittrex";"baseSymbol","BTC";"quoteSymbol","USD";"limit","10"})'>=CS.QUERY("Shrimpy","Orderbooks")</inline-code> | <inline-code>=CS.PARAMETERS("Shrimpy","Orderbooks")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Candles" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/candles) | **Candles** | <inline-code functionvalue='=CS.QUERY("Shrimpy","Candles",{"exchange","coinbasepro";"baseTradingSymbol","BTC";"quoteTradingSymbol","USD";"interval","1H";"startTime","2019-05-24T23:00:00.000Z"})'>=CS.QUERY("Shrimpy","Candles")</inline-code> | <inline-code>=CS.PARAMETERS("Shrimpy","Candles")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/exchanges) | **Exchanges** | <inline-code functionvalue='=CS.QUERY("Shrimpy","Exchanges")'>=CS.QUERY("Shrimpy","Exchanges")</inline-code> | <inline-code>=CS.PARAMETERS("Shrimpy","Exchanges")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Trading%20Pairs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/trading-pairs) | **Trading Pairs** | <inline-code functionvalue='=CS.QUERY("Shrimpy","Trading Pairs",{"exchange","kucoin"})'>=CS.QUERY("Shrimpy","Trading Pairs")</inline-code> | <inline-code>=CS.PARAMETERS("Shrimpy","Trading Pairs")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Exchange%20Assets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/exchange-assets) | **Exchange Assets** | <inline-code functionvalue='=CS.QUERY("Shrimpy","Exchange Assets",{"exchange","kucoin"})'>=CS.QUERY("Shrimpy","Exchange Assets")</inline-code> | <inline-code>=CS.PARAMETERS("Shrimpy","Exchange Assets")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Historical%20Candles" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/historical-candles) | **Historical Candles** | <inline-code functionvalue='=CS.QUERY("Shrimpy","Historical Candles",{"exchange","bittrex";"baseTradingSymbol","LTC";"quoteTradingSymbol","BTC";"startTime","2019-09-01";"endTime","2019-09-02";"limit","100";"interval","15m";"publicKey",""})'>=CS.QUERY("Shrimpy","Historical Candles")</inline-code> | <inline-code>=CS.PARAMETERS("Shrimpy","Historical Candles")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Historical%20Instruments" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/historical-instruments) | **Historical Instruments** | <inline-code functionvalue='=CS.QUERY("Shrimpy","Historical Instruments")'>=CS.QUERY("Shrimpy","Historical Instruments")</inline-code> | <inline-code>=CS.PARAMETERS("Shrimpy","Historical Instruments")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Historical%20Orderbooks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/historical-orderbooks) | **Historical Orderbooks** | <inline-code functionvalue='=CS.QUERY("Shrimpy","Historical Orderbooks")'>=CS.QUERY("Shrimpy","Historical Orderbooks")</inline-code> | <inline-code>=CS.PARAMETERS("Shrimpy","Historical Orderbooks")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Historical%20Trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/historical-trades) | **Historical Trades** | <inline-code functionvalue='=CS.QUERY("Shrimpy","Historical Trades")'>=CS.QUERY("Shrimpy","Historical Trades")</inline-code> | <inline-code>=CS.PARAMETERS("Shrimpy","Historical Trades")</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/Shrimpy/Get%20Ticker" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/get-ticker) | **Get Ticker** | <inline-code functionvalue='=CSQUERY("Shrimpy","Get Ticker",{"exchange","kucoin"})'>=CSQUERY("Shrimpy","Get Ticker")</inline-code> | <inline-code>=CSPARAMETERS("Shrimpy","Get Ticker")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Orderbooks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/orderbooks) | **Orderbooks** | <inline-code functionvalue='=CSQUERY("Shrimpy","Orderbooks",{"exchange","bittrex";"baseSymbol","BTC";"quoteSymbol","USD";"limit","10"})'>=CSQUERY("Shrimpy","Orderbooks")</inline-code> | <inline-code>=CSPARAMETERS("Shrimpy","Orderbooks")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Candles" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/candles) | **Candles** | <inline-code functionvalue='=CSQUERY("Shrimpy","Candles",{"exchange","coinbasepro";"baseTradingSymbol","BTC";"quoteTradingSymbol","USD";"interval","1H";"startTime","2019-05-24T23:00:00.000Z"})'>=CSQUERY("Shrimpy","Candles")</inline-code> | <inline-code>=CSPARAMETERS("Shrimpy","Candles")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/exchanges) | **Exchanges** | <inline-code functionvalue='=CSQUERY("Shrimpy","Exchanges")'>=CSQUERY("Shrimpy","Exchanges")</inline-code> | <inline-code>=CSPARAMETERS("Shrimpy","Exchanges")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Trading%20Pairs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/trading-pairs) | **Trading Pairs** | <inline-code functionvalue='=CSQUERY("Shrimpy","Trading Pairs",{"exchange","kucoin"})'>=CSQUERY("Shrimpy","Trading Pairs")</inline-code> | <inline-code>=CSPARAMETERS("Shrimpy","Trading Pairs")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Exchange%20Assets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/exchange-assets) | **Exchange Assets** | <inline-code functionvalue='=CSQUERY("Shrimpy","Exchange Assets",{"exchange","kucoin"})'>=CSQUERY("Shrimpy","Exchange Assets")</inline-code> | <inline-code>=CSPARAMETERS("Shrimpy","Exchange Assets")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Historical%20Candles" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/historical-candles) | **Historical Candles** | <inline-code functionvalue='=CSQUERY("Shrimpy","Historical Candles",{"exchange","bittrex";"baseTradingSymbol","LTC";"quoteTradingSymbol","BTC";"startTime","2019-09-01";"endTime","2019-09-02";"limit","100";"interval","15m";"publicKey",""})'>=CSQUERY("Shrimpy","Historical Candles")</inline-code> | <inline-code>=CSPARAMETERS("Shrimpy","Historical Candles")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Historical%20Instruments" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/historical-instruments) | **Historical Instruments** | <inline-code functionvalue='=CSQUERY("Shrimpy","Historical Instruments")'>=CSQUERY("Shrimpy","Historical Instruments")</inline-code> | <inline-code>=CSPARAMETERS("Shrimpy","Historical Instruments")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Historical%20Orderbooks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/historical-orderbooks) | **Historical Orderbooks** | <inline-code functionvalue='=CSQUERY("Shrimpy","Historical Orderbooks")'>=CSQUERY("Shrimpy","Historical Orderbooks")</inline-code> | <inline-code>=CSPARAMETERS("Shrimpy","Historical Orderbooks")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Shrimpy/Historical%20Trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/shrimpy/historical-trades) | **Historical Trades** | <inline-code functionvalue='=CSQUERY("Shrimpy","Historical Trades")'>=CSQUERY("Shrimpy","Historical Trades")</inline-code> | <inline-code>=CSPARAMETERS("Shrimpy","Historical Trades")</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-Shrimpy">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-Shrimpy">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://developers.shrimpy.io/docs">Click here</a>** for additional documentation from Shrimpy

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

---

Tags: `Shrimpy` `provider` 


How to pull Shrimpy data into Excel and Google Sheets