Best Free Cryptocurrencies Portfolio Tracking Spreadsheet

If you’re into cryptocurrencies and have a portfolio of assets lying around in one or two or more marketplaces, at one point I’m sure you’ve thought about having an all-in-one dashboard where you can just login and see if everything is going to the moon or not.

Sure, you can have your phone widget or ticker that will show you the price changes in the past hour, or you can simply open Binance to check the prices… but will you see how much you have, your assets’ value in fiat, the daily changes, charts, and other attributes you’d like to see at a glance, in one page? I don’t think so.

Sure, you can build one yourself if you have decent skills with Google Sheets or Excel, but why should you invent the wheel from scratch when you can just copy these free templates?

1. /u/Fly115’s Cryptoprices Spreadsheet

Reddit user /u/Fly115’s live crypto tracker can track up to 5000 cryptocurrencies, and supports moons on /r/cryptocurrency subreddit. With this spreadsheet, you can track your trading gain and loss in BTC and fiat.

The great thing about this? Fly115 has been working on this tracker for a couple of years now, and it is already on its 14th version.

That said, you can compare how altcoins are faring compared to Bitcoin. Not only that, it can also keep track of all the amount of coins you’ve had since you started, and how the balances have worked throughout. This is particularly useful if you live in a country that actively taxes your crypto gains.

Aside from the rows and columns that you’re used to seeing when it comes to spreadsheets, it also has charts so you can visually see the dips and spikes of your coins.

Key Features:

• Can track up to 5,000 coins.
• Tracks trading gain and loss.
• Constantly being updated on Reddit (now on its 14th version).
• Has nice charts for easy visual analysis.

2. Ahmet BUTUN’s Crypto Tracker

Ahmet’s crypto tracker is a straightforward tracker that you can use to keep a close watch of your crypto portfolio. The setup is a bit technical, but if you have a bit of knowledge in Google Sheets or Excel, you will fare well.

The tracker does not give you live tracking, but it is near-live. You can automatically update the prices in increments of 5 minutes or more.

In order to add cryptos, you will have to use Google Sheet functions, which are available for copy/pasting on the link above. You will also need to edit the script a little bit to adjust the trigger for refresh, but it shouldn’t be too difficult to do.

Key Features:

• For technical users since it utilizes Google Sheet functions to make changes.

3. Tario Sultan’s Crypto Tracker (Google Sheet + Add-On)

Tario Sultan’s crypto tracker is another comprehensive portfolio tracker for cryptocurrency investors. The only downside here is that it piggybacks on the paid service Cryptofinance, but it has a free trial of 1 week.

Once that trial expires, you can still use its free features to keep track of your coins, but you’ll lose access to advanced tools that are useful for active trading. But then again, if you’re making money through your trades, a few dollars won’t hurt for a premium experience, right?

Key Features:

• Uses Cryptofinance.
• Tracks trades, volume changes, portfolio value changes.
• Has nice graph indicators at a glance.

4. Cryptosheets (has free tier)

Cryptosheets is a SaaS that does all the grunt work for you. It appeals to both hobbyists, analysts, and investors, so you can imagine how in-depth its features are.

It can integrate with both Google Sheets and Excel, and has pre-built templates and functions that you can use with just a few clicks.

It also supports hundreds of crypto exchanges, over 200,000 crypto assets, and derivatives. Compared to other services that tracks crypto for a fee, Cryptosheets’ free tier is extensive enough to keep you happy, but if you’re taking things seriously, then the price for upgrading isn’t bad either.

Key Features:

• Supports over 200,000 crypto assets.
• Has pre-built templates you can use immediately.
• Uses Cryptosheets’ free plan.

5. CoinGecko

Who doesn’t know CoinGecko? It’s just one of the biggest cryptocurrency trackers in the world. It tracks over 8,000 cryptocurrencies, supports 400+ exchanges, and aggregates millions of data daily to provide an accurate report to millions of people worldwide.

That said, they also have their own API which can be integrated with Google Sheets. With their API, you can build your own cryptocurrency portfolio tracker, crypto tracker (of coins you own or are planning on buying), and analysis of coins where you can track the volume changes, price changes, and other indicators.

If you’re not very familiar with coding, you’ll probably need to spend a bit of time understanding CoinGecko’s guide linked above, but it shouldn’t be too difficult!

Key Features:

• One of the biggest crypto tracker in the world.
• An actual dashboard that will help you analyze risks, price changes, volume changes, etc.

6. CoinAtlas’ Investment Tracker

CoinAtlas’ investment tracker is a free Google Spreadsheet template for crypto and stock investors. That’s right, it’s not just for cryptocurrencies, but actual stocks. It piggybacks on the Google Finance function where it pulls data directly from the stock market, and from CoinGecko for cryptocurrencies.

It is a 100% free tool that does calculations automatically and updates your history and the coins you are tracking dynamically.

The setup is relatively easy too. The template itself has the guide you’ll need to set up everything.

Key Features:

• Pretty spreadsheet with charts and graphs.
• Can be used for both Cryptocurrencies and the Stock Market.

7. Yogofubi’s Crypto Market Cycle “What If” Spreadsheet

Compared to the previous entries, Yogofubi’s crypto market spreadsheet is not a tracker of your trades, history, and coins, but more like a tool that helps you visualize your risks.

If used correctly, it will help you decide whether it’s time to sell or buy, or if you’re at risk of losing money based on the trades that you’ll want to make. But of course you’ll still need to keep an open mind and do your research.

Think of it as a “what if I buy X coin at $50,000, but days later it goes up to $60,000, how much would I be losing or earning then?” kind of thing.

Key Features:

• Not a trade or asset tracker, but a risk assessment spreadsheet.
• Prediction spreadsheet.

8. Transilvlad and MindupLife’s CryptoBooks

Cryptobooks is a spreadsheet designed by Redditors who are deeply into cryptocurrencies. It utilizes Google Finance functions and CoinGecko, so you can keep track of both stocks and cryptos with a little bit of tinkering.

It also hooks up with CryptoCompare, which is a paid service but its free account enables users to make up to 100,000 requests, so if you are a light user, this might just be the perfect tool for you.

Key Features:

• Has an in-depth structure with graphs, colors, etc.
• Utilizes CyptoCompare. Allows for 100,000 requests for free users.

9. Emmte’s Cryptocurrency Portfolio Tracker

Without going much into the technicalities that built this tracker, you can just simply create a copy of the spreadsheet and fill in the Config sheet with the necessary information so you can get started with pulling your data from various marketplaces.

It supports Kraken, Bittrex, Poloniex, Binance, Cryptopia, Kucoin, and Bitstamp. You just have to get your Key and Secret from your accounts in those marketplaces and the spreadsheet will start keeping track of your coins for you, including your deposits, gains and losses, etc.

Key Features:

• Supports 7 of the biggest marketplaces: Binance, Kraken, Bittrex, Poloniex, Bitstamp, and others.
• Tracks deposits, gains, losses, trades.

10. Shan Eapen Koshy’s Crypto Portfolio Tracker

For cryptocurrency investors in India, WazirX remains to be one of the primary crypto marketplaces, but it is not that well known outside of the country so there isn’t much chance to create a tracker out of their API unless you make one yourself.

So it’s really great that Shan Eapen Koshy published a guide on how to make one, and provided a free template to keep track of your portfolio in WazirX through Google Sheets.

Key Features:

• Built for WazirX users in India.
• Straightforward tracker of assets.

To End

So, did you find the perfect crypto price and trade tracker for you? Most likely if you’re heavily invested in this, you’ll need more than the items listed above, but hey, it’s a good start for hobbyists! While you’re at it, you might as well start tinkering and learn how to work with spreadsheets – it will come a long way!

In any case, I hope your portfolio goes to the moon!