CoinTracking and Cryptosheets: New Plug-in

30 Mar, 2020 · 3 min read

We’re happy to announce a new features between CoinTracking and Cryptosheets. CoinTracking has always offered crypto beginners the opportunity to create tax reports with us for free. Furthermore, if you only initiated a handful of transactions during the year, you could always generate as many tax reports with us as you like.

CoinTracking and Cryptosheets

We recently released a new feature that lets you to take you crypto trading game to an entirely new level– the ability to use CoinTracking with Cryptosheets.

Now you can build your own custom cryptocurrency charts with CoinTracking and Cryptosheets

What is Cryptosheets?

Cryptosheets is a tool for analyzing a wide variety of cryptocurrency data including real time prices, historical OHLCV, order books, trades, performance, asset profiles, social and blockchain metrics and over 1,300+ other unique datasets. It works with Microsoft Excel and Google Sheets and has all kinds of applications, ranging from technical analysis, to creating mining models to backtesting trading strategies and more.

When used in conjunction with CoinTracking, you can use Cryptosheets to pull all your trades, account balances and capital gains into any spreadsheet. In all, there are six different CoinTracking endpoints that Cryptosheets’ API is capable of accessing.

CoinTracking is just one of over 50 different data sources you can experiment with allowing you to create your own custom data mashups, dashboards, charts and models. The plugin also works with CoinMarketCap, the mining profits calculator WhatToMine, cryptocurrency data provider, Cryptocompare, ParadigmAPI and many other cryptocurrency-related services.

Potential use cases between CoinTracking and Cryptosheets.

  1. Create your own customizable charts. Many cryptocurrency exchanges only offer basic chart features. As a result, traders that prefer to use metrics that aren’t widely used often have to rely on third party sites like Woobull Charts, TradingView, CoinMarketCap and others. These charts are accurate, but they reflect the market as a whole– not specific exchange marketplaces. If you use Cryptosheets with CoinTracking, you can pick your own pricing sources and create whatever type of chart you need.
  2. Develop your mining plan. If you use Cryptosheets with CoinTracking, you can map out all your costs and predict your potential profits in advance. Moreover, the IRS allows cryptocurrency miners to deduct the depreciation of their mining equipment from their overall profits. Other tax breaks may be available as well, all of which can be worked into your mining model at the planning stage.
  3. Design rebalancing scripts. Rebalancing helps you take advantage of sudden price spikes and protects you from being overexposed to risky crypto assets. Furthermore, you can specify whatever thresholds you want within Excel, and then use a trading ‘bot to automate your trades. The CoinTracking plug-in will let you see what you owe in taxes as you go.
  4. Make your own custom crypto indexes. Index funds– like the Nasdaq 100 or Dow Jones Industrial Average– let traders invest in a wide range of assets. With Cryptosheets, you can design your own personalized index fund from scratch– and the CoinTracking integration will let you take estimate your potential tax burden.
  5. Overlay technical analysis indicators on your Cointracking portfolio positions. Create custom screeners in seconds for oversold or overbought conditions using simple formulas like =CS.RSI() or explore dozens of other technical indicator functions
  6. Discover community trends for each asset symbol in your portfolio. Use historical social data including Twitter, Github, Reddit and many other sources to compare and analyze each of your portfolio positions and their relative growth trajectory.
  7. Analyze on-chain crypto metrics for your portfolio. Compare and analyze trends in network activity to help inform portfolio allocation, trading and rebalancing strategies.

Sign-up to CoinTracking today!

Start creating new trading strategies with CoinTracking and Cryptosheets for free

Just like CoinTracking, Cryptosheets lets beginner cryptocurrency traders use their software for free. Cryptosheets’ Free Forever level subscribers can make as many as 1,000 API requests per month. Existing Cointracking users who signup for a paid Cryptosheets subscription will receive a 20% discount by entering the code #ICAMEFROMCOINTRACKING in their Cryptosheets user profiles:

  1. This article shows how to add your Cointracking API key to Cryptosheets for Excel and Googlesheets
  2. This knowledge base article shows how to import CoinTracking data using the Cryptosheets plugin
  3. This page shows how to use custom function formulas to access your Cointracking data using the Cryptosheets plugin

Once you’ve imported your CoinTracking data into a spreadsheet, you can use various pre-made templates to come up with new ways to analyze it. These show you how to do things like re-create the CoinMarketCap front page, use various technical indicators, generate market volatility charts and more.

All you need to know about crypto taxes:

Crypto Tax Guide for the United Kingdom

Crypto Tax Guide for the United States

Crypto Tax Guide for Australia

Crypto Tax Guide for Canada

CoinTracking can help you with more:

  1. Importing (API & CSV) your trades from 110+ exchanges/wallets.
  2. DeFi/DEX, Binance Chain, and Binance Smart Chain.
  3. 25+ advanced reports.
  4. Automatic Gains calculations with 12 accounting methods (FIFO, LIFO, HMRC).
  5. Complete Tax Reports compliant in your country.

If you need personalized help reviewing your transactions or preparing your US tax returns, check out our CoinTracking Full Service. CT Full Service is provided by a team of crypto tax professionals led by Sharon Yip, an expert CPA. Follow our weekly AMAs on Twitter where Sharon Yip answers your crypto tax questions.

Disclaimer: All the information provided above is for informational purposes only and should not be considered as professional investment, legal, or tax advice. You should conduct your own research or consult with a professional financial advisor when investing.

Share this

Luis Schilli: SEO Manager
Content Manager & Crypto Blogger
Crypto trader and blockchain enthusiast with a passion for innovative technologies in the cryptocurrency market.
Crypto trader and blockchain enthusiast with a passion for innovative technologies in the cryptocurrency market.


Check out what's new and exciting

The world of cryptocurrencies is constantly changing – keep up with CoinTracking and get informed!