All Collections
Tutorials
Cointracking.info tutorials
Cointracking.info data in Excel & Googlesheets using Cryptosheets
Cointracking.info data in Excel & Googlesheets using Cryptosheets

How to pull Cointracking.info data into Excel including balance, trades, gains and more

C
Written by Chris Ware
Updated over a week ago

Using Cointracking.info data in Cryptosheets

This article demonstrates two examples of how to pull Cointracking data into your spreadsheet using the side panel console  and custom functions. 

You can currently pull 8 endpoints from Cointracking into Cryptosheets including: 

  • Get Balance

  • Get Gains

  • Get Grouped Balance

  • Get Historical Currency

  • Get Historical Summary

  • Get Trades

  • Get Ledger


    Although Cointracking has 6 available endpoints, we will use Get Trades as our example. The Get Trades  endpoint returns all your CoinTracking trades and transactions. Similar to the Trade List page.

Explore more Cointracking endpoints here

________________________________________________________________

Setup

  1. Install the Cryptosheets add-in from Microsoft AppSource Store

  2. Make sure you are logged into your Cryptosheets account


________________________________________________________________

Using the console

  1. From the Cryptosheets ribbon click data
  2. Type in type in "Cointracking..." then click on Get Trades
  3. Scroll through the console parameters and input your values
  4. Select the cell you want to place the data into
  5. Click make request


________________________________________________________________

Using custom functions

  1. In any cell type (or copy + paste) the following:
=CS.QUERY("Cointracking","Get Trades",{"_limit","100"})

If you need help remembering the exact parameters for any function, you can always just type in any cell:
=CS.PARAMETERS("Cointracking","Get Trades")

-------


*Note: you must have a certain minimum version of Microsoft Office or Excel for custom functions to work - but they now work in full on Excel for Mac/OSX and for the web in Excel online!

Helpful Resources:

  • Visit the API documentation for Cointracking here

Troubleshooting

  • Find tips & tricks on our troubleshooting page

  • Please reference the following troubleshooting code: QUE-1249-366

Learn more here
________________________________________________________________
Tags: portfolio, tracking, trades, Cointracking, Cointracking.info, Excel, Googlesheets, spreadsheet

Did this answer your question?