The Best Free Cryptocurrencies Portfolio Tracking Spreadsheet – Hongkiat

If you ’ re into cryptocurrencies and have a portfolio of assets lying approximately in one or two or more marketplaces, at one point I ’ megabyte indisputable you ’ ve think about having an all-in-one dashboard where you can merely login and see if everything is going to the moon or not .
sure, you can have your telephone appliance or ticker that will show you the price changes in the past hour, or you can just open Binance to check the prices… but will you see how much you have, your assets ’ rate in decree, the daily changes, charts, and early attributes you ’ d like to see at a glance, in one page ? I don ’ thymine think so .
certain, you can build one yourself if you have decent skills with Google Sheets or Excel, but why should you invent the wheel from cancel when you can merely copy these free templates ?
Trying Ethereum ? here are 7 Secure Ethereum Wallets to Start With

Trying Ethereum? Here are 7 Secure Ethereum Wallets to Start With

Ethereum is a quickly growing digital currency that thousands of people are using for trade. however, it ‘s not … Read more
Cyptocurrency spreadsheet tracker Cryptoprices
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 decree .
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 interpretation .
That said, you can compare how altcoins are faring compared to Bitcoin. not lone that, it can besides 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 area that actively taxes your crypto gains .
aside from the rows and columns that you ’ re used to seeing when it comes to spreadsheets, it besides 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.

Cyptocurrency spreadsheet tracker Ahmet BUTUN
Ahmet ’ s crypto tracker is a straightforward tracker that you can use to keep a close determine of your crypto portfolio. The frame-up is a piece technical, but if you have a piece of cognition 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 connection above. You will besides need to edit the script a fiddling bit to adjust the trigger for review, but it shouldn ’ deoxythymidine monophosphate be besides difficult to do .
Key Features:

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

Cyptocurrency spreadsheet tracker using Cryptofinance
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 dislodge trial of 1 workweek .
once that trial expires, you can still use its unblock features to keep track of your coins, but you ’ ll lose access to advanced tools that are utilitarian for active trade. But then again, if you ’ re making money through your trades, a few dollars won ’ triiodothyronine hurt for a premium have, right ?
Key Features:

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

Cyptocurrency spreadsheet tracker Cryptosheets
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 precisely a few clicks .
It besides supports hundreds of crypto exchanges, over 200,000 crypto assets, and derivatives. Compared to early services that tracks crypto for a fee, Cryptosheets ’ free grade is across-the-board enough to keep you felicitous, but if you ’ re taking things badly, then the price for upgrading international relations and security network ’ metric ton bad either .
Key Features:

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

Cyptocurrency spreadsheet tracker Coingecko
Who doesn ’ thymine know CoinGecko ? It ’ south just one of the biggest cryptocurrency trackers in the worldly concern. It tracks over 8,000 cryptocurrencies, supports 400+ exchanges, and aggregates millions of data casual to provide an accurate report to millions of people worldwide.

That said, they besides 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 psychoanalysis of coins where you can track the volume changes, price changes, and other indicators .
If you ’ rhenium not identical familiar with code, you ’ ll credibly need to spend a bite of time understanding CoinGecko ’ s template linked above, but it shouldn ’ thyroxine be besides 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.

Cyptocurrency spreadsheet tracker CoinAtlas
CoinAtlas ’ investment tracker is a free Google Spreadsheet template for crypto and stock investors. That ’ south properly, it ’ s not equitable for cryptocurrencies, but actual stocks. It piggybacks on the Google Finance function where it pulls data directly from the stock marketplace, 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 besides. 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.

Cyptocurrency spreadsheet tracker, visualize risks
Compared to the previous entries, Yogofubi ’ s crypto marketplace 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 hazard of losing money based on the trades that you ’ ll want to make. But of course you ’ ll still need to keep an open thinker and do your research .
think of it as a “ what if I buy x mint at $ 50,000, but days subsequently 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.

Cyptocurrency spreadsheet tracker CryptoBooks
Cryptobooks is a spreadsheet designed by Redditors who are profoundly into cryptocurrencies. It utilizes Google Finance functions and CoinGecko, so you can keep track of both stocks and cryptos with a short piece of tinkering .
It besides hooks up with CryptoCompare, which is a pay service but its unblock history enables users to make up to 100,000 requests, sol if you are a light exploiter, this might precisely be the perfect joyride for you .
Key Features:

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

Cyptocurrency spreadsheet tracker Portfolio tracker
Without going a lot into the technicalities that built this tracker, you can precisely simply create a copy of the spreadsheet and fill in the Config sail with the necessity information so you can get started with pulling your data from diverse 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 traverse 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.

Cyptocurrency spreadsheet tracker WazirX
For cryptocurrency investors in India, WazirX remains to be one of the primary coil crypto marketplaces, but it is not that well known outside of the country so there international relations and security network ’ thyroxine much gamble to create a tracker out of their API unless you make one yourself .
So it ’ randomness truly great that Shan Eapen Koshy published a steer 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 arrant crypto price and craft tracker for you ? Most likely if you ’ ra heavily invested in this, you ’ ll motivation more than the items listed above, but hey, it ’ s a good begin for hobbyists ! While you ’ re at it, you might ampere 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 lunar month !

Leave a Comment

Your email address will not be published.