Excel

Google Sheets

> Cryptocurrencies Exchange

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Gemini">Gemini</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/Gemini/symbols" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/symbols) | **symbols** | <inline-code functionvalue='=CS.QUERY("Gemini","symbols")'>=CS.QUERY("Gemini","symbols")</inline-code> | <inline-code>=CS.PARAMETERS("Gemini","symbols")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/ticker" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/ticker) | **ticker** | <inline-code functionvalue='=CS.QUERY("Gemini","ticker",{"symbol","btcusd"})'>=CS.QUERY("Gemini","ticker")</inline-code> | <inline-code>=CS.PARAMETERS("Gemini","ticker")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Current%20Order%20Book" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/current-order-book) | **Current Order Book** | <inline-code functionvalue='=CS.QUERY("Gemini","Current Order Book",{"symbol","btcusd"})'>=CS.QUERY("Gemini","Current Order Book")</inline-code> | <inline-code>=CS.PARAMETERS("Gemini","Current Order Book")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Trade%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/trade-history) | **Trade History** | <inline-code functionvalue='=CS.QUERY("Gemini","Trade History",{"symbol","btcusd"})'>=CS.QUERY("Gemini","Trade History")</inline-code> | <inline-code>=CS.PARAMETERS("Gemini","Trade History")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Current%20Auction" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/current-auction) | **Current Auction** | <inline-code functionvalue='=CS.QUERY("Gemini","Current Auction",{"symbol","btcusd"})'>=CS.QUERY("Gemini","Current Auction")</inline-code> | <inline-code>=CS.PARAMETERS("Gemini","Current Auction")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Auction%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/auction-history) | **Auction History** | <inline-code functionvalue='=CS.QUERY("Gemini","Auction History",{"symbol","btcusd"})'>=CS.QUERY("Gemini","Auction History")</inline-code> | <inline-code>=CS.PARAMETERS("Gemini","Auction History")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Ticker%20V2" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/ticker-v2) | **Ticker V2** | <inline-code functionvalue='=CS.QUERY("Gemini","Ticker V2",{"symbol","btcusd"})'>=CS.QUERY("Gemini","Ticker V2")</inline-code> | <inline-code>=CS.PARAMETERS("Gemini","Ticker V2")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Candles" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/candles) | **Candles** | <inline-code functionvalue='=CS.QUERY("Gemini","Candles",{"symbol","btcusd";"time_frame","1m"})'>=CS.QUERY("Gemini","Candles")</inline-code> | <inline-code>=CS.PARAMETERS("Gemini","Candles")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Price%20Feed" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/price-feed) | **Price Feed** | <inline-code functionvalue='=CS.QUERY("Gemini","Price Feed")'>=CS.QUERY("Gemini","Price Feed")</inline-code> | <inline-code>=CS.PARAMETERS("Gemini","Price Feed")</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/Gemini/symbols" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/symbols) | **symbols** | <inline-code functionvalue='=CSQUERY("Gemini","symbols")'>=CSQUERY("Gemini","symbols")</inline-code> | <inline-code>=CSPARAMETERS("Gemini","symbols")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/ticker" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/ticker) | **ticker** | <inline-code functionvalue='=CSQUERY("Gemini","ticker",{"symbol","btcusd"})'>=CSQUERY("Gemini","ticker")</inline-code> | <inline-code>=CSPARAMETERS("Gemini","ticker")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Current%20Order%20Book" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/current-order-book) | **Current Order Book** | <inline-code functionvalue='=CSQUERY("Gemini","Current Order Book",{"symbol","btcusd"})'>=CSQUERY("Gemini","Current Order Book")</inline-code> | <inline-code>=CSPARAMETERS("Gemini","Current Order Book")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Trade%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/trade-history) | **Trade History** | <inline-code functionvalue='=CSQUERY("Gemini","Trade History",{"symbol","btcusd"})'>=CSQUERY("Gemini","Trade History")</inline-code> | <inline-code>=CSPARAMETERS("Gemini","Trade History")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Current%20Auction" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/current-auction) | **Current Auction** | <inline-code functionvalue='=CSQUERY("Gemini","Current Auction",{"symbol","btcusd"})'>=CSQUERY("Gemini","Current Auction")</inline-code> | <inline-code>=CSPARAMETERS("Gemini","Current Auction")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Auction%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/auction-history) | **Auction History** | <inline-code functionvalue='=CSQUERY("Gemini","Auction History",{"symbol","btcusd"})'>=CSQUERY("Gemini","Auction History")</inline-code> | <inline-code>=CSPARAMETERS("Gemini","Auction History")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Ticker%20V2" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/ticker-v2) | **Ticker V2** | <inline-code functionvalue='=CSQUERY("Gemini","Ticker V2",{"symbol","btcusd"})'>=CSQUERY("Gemini","Ticker V2")</inline-code> | <inline-code>=CSPARAMETERS("Gemini","Ticker V2")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Candles" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/candles) | **Candles** | <inline-code functionvalue='=CSQUERY("Gemini","Candles",{"symbol","btcusd";"time_frame","1m"})'>=CSQUERY("Gemini","Candles")</inline-code> | <inline-code>=CSPARAMETERS("Gemini","Candles")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Gemini/Price%20Feed" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/gemini/price-feed) | **Price Feed** | <inline-code functionvalue='=CSQUERY("Gemini","Price Feed")'>=CSQUERY("Gemini","Price Feed")</inline-code> | <inline-code>=CSPARAMETERS("Gemini","Price Feed")</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-Gemini">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-Gemini">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.gemini.com/rest-api/">Click here</a>** for additional documentation from Gemini

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

---

Tags: `Gemini` `provider` 


How to pull Gemini data into Excel and Google Sheets