Excel

Google Sheets

> CoinTracking analyzes your trades and generates real-time reports on profit and loss, the value of your coins, realized and unrealized gains, reports for taxes and more.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Cointracking">Cointracking</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/Cointracking/Get%20Trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-trades) | **Get Trades** | <inline-code functionvalue='=CS.QUERY("Cointracking","Get Trades",{"limit","all";"order","ASC";"trade_prices","0"})'>=CS.QUERY("Cointracking","Get Trades")</inline-code> | <inline-code>=CS.PARAMETERS("Cointracking","Get Trades")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Cointracking/Get%20Balance" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-balance) | **Get Balance** | <inline-code functionvalue='=CS.QUERY("Cointracking","Get Balance")'>=CS.QUERY("Cointracking","Get Balance")</inline-code> | <inline-code>=CS.PARAMETERS("Cointracking","Get Balance")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Cointracking/Get%20Historical%20Summary" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-historical-summary) | **Get Historical Summary** | <inline-code functionvalue='=CS.QUERY("Cointracking","Get Historical Summary")'>=CS.QUERY("Cointracking","Get Historical Summary")</inline-code> | <inline-code>=CS.PARAMETERS("Cointracking","Get Historical Summary")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Cointracking/Get%20Historical%20Currency" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-historical-currency) | **Get Historical Currency** | <inline-code functionvalue='=CS.QUERY("Cointracking","Get Historical Currency",{"currency","ETH";"start","1200000000";"end","1900000000"})'>=CS.QUERY("Cointracking","Get Historical Currency")</inline-code> | <inline-code>=CS.PARAMETERS("Cointracking","Get Historical Currency")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Cointracking/Get%20Grouped%20Balance" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-grouped-balance) | **Get Grouped Balance** | <inline-code functionvalue='=CS.QUERY("Cointracking","Get Grouped Balance",{"group","exchange";"exclude_dep_with","1";"type","Trade"})'>=CS.QUERY("Cointracking","Get Grouped Balance")</inline-code> | <inline-code>=CS.PARAMETERS("Cointracking","Get Grouped Balance")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Cointracking/Get%20Gains" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-gains) | **Get Gains** | <inline-code functionvalue='=CS.QUERY("Cointracking","Get Gains",{"tax_method","FIFO";"price","best";"exclude_dep_with","0";"costbasis","unsold";"btc","0";"tax_method","FIFO"})'>=CS.QUERY("Cointracking","Get Gains")</inline-code> | <inline-code>=CS.PARAMETERS("Cointracking","Get Gains")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/Cointracking/Get%20Ledger" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-ledger) | **Get Ledger** | <inline-code functionvalue='=CS.QUERY("Cointracking","Get Ledger",{"limit","all";"start","1522206363";"end","1622206363";"show_advanced","0"})'>=CS.QUERY("Cointracking","Get Ledger")</inline-code> | <inline-code>=CS.PARAMETERS("Cointracking","Get Ledger")</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/Cointracking/Get%20Trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-trades) | **Get Trades** | <inline-code functionvalue='=CSQUERY("Cointracking","Get Trades",{"limit","all";"order","ASC";"trade_prices","0"})'>=CSQUERY("Cointracking","Get Trades")</inline-code> | <inline-code>=CSPARAMETERS("Cointracking","Get Trades")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Cointracking/Get%20Balance" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-balance) | **Get Balance** | <inline-code functionvalue='=CSQUERY("Cointracking","Get Balance")'>=CSQUERY("Cointracking","Get Balance")</inline-code> | <inline-code>=CSPARAMETERS("Cointracking","Get Balance")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Cointracking/Get%20Historical%20Summary" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-historical-summary) | **Get Historical Summary** | <inline-code functionvalue='=CSQUERY("Cointracking","Get Historical Summary")'>=CSQUERY("Cointracking","Get Historical Summary")</inline-code> | <inline-code>=CSPARAMETERS("Cointracking","Get Historical Summary")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Cointracking/Get%20Historical%20Currency" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-historical-currency) | **Get Historical Currency** | <inline-code functionvalue='=CSQUERY("Cointracking","Get Historical Currency",{"currency","ETH";"start","1200000000";"end","1900000000"})'>=CSQUERY("Cointracking","Get Historical Currency")</inline-code> | <inline-code>=CSPARAMETERS("Cointracking","Get Historical Currency")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Cointracking/Get%20Grouped%20Balance" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-grouped-balance) | **Get Grouped Balance** | <inline-code functionvalue='=CSQUERY("Cointracking","Get Grouped Balance",{"group","exchange";"exclude_dep_with","1";"type","Trade"})'>=CSQUERY("Cointracking","Get Grouped Balance")</inline-code> | <inline-code>=CSPARAMETERS("Cointracking","Get Grouped Balance")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Cointracking/Get%20Gains" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-gains) | **Get Gains** | <inline-code functionvalue='=CSQUERY("Cointracking","Get Gains",{"tax_method","FIFO";"price","best";"exclude_dep_with","0";"costbasis","unsold";"btc","0";"tax_method","FIFO"})'>=CSQUERY("Cointracking","Get Gains")</inline-code> | <inline-code>=CSPARAMETERS("Cointracking","Get Gains")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/Cointracking/Get%20Ledger" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cointracking/get-ledger) | **Get Ledger** | <inline-code functionvalue='=CSQUERY("Cointracking","Get Ledger",{"limit","all";"start","1522206363";"end","1622206363";"show_advanced","0"})'>=CSQUERY("Cointracking","Get Ledger")</inline-code> | <inline-code>=CSPARAMETERS("Cointracking","Get Ledger")</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-Cointracking">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-Cointracking">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://cointracking.info?ref&#x3D;C774061">Click here</a>** for additional documentation from Cointracking

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

---

Tags: `Cointracking` `provider` 


How to pull Cointracking data into Excel and Google Sheets