Hello Billionaires gang! Long time no see, heh. Or should I say penniless gang, muahaha. These are dark times, depending on the geographical location some of you have it extremely bad. Looking at you my Ukrainian friends, stay strong! For others it might be not so bad, but still turbulent. We all see what is happening on the markets so this post is not about dollar cost averaging, the future of bitcoin or a motivational speech that You can make it, there is plenty of content explaining why current events are happening and what you should be doing. This post is about one of the tools that we all should be using in one form or the other. At the end of last year, when everything was so bright and Russia stayed in the limits of, well, Russia, I started tracking my crypto trades. Because, you know, crypto trader baby. There are multiple reasons to track your portfolio, even in cases where you only buy, buy and buy. For me those reasons are:

• How much money have I put into crypto?
• At what price did I enter the position?
• How has the token or coin moved within the last day, week or month?
• How much have I earned or lost in a given position?

There are tons of positive reasons to track your portfolio. So in this post I’ll cover what I track, how I track and where I track price movements. Fyi I’m a lazy ass bitch who doesn't want to pay for any such service, at least at the very start of my investing career. Let’s be honest, 2-3 years of experience is close to nothing, compared to the masters that have done so for their whole lifetime.

First things first

I am a true believer in excel, this picture pretty much sums it up:

So as you can imagine when I thought about a tool I was in reality thinking of an excel or google spreadsheet, which is pretty much the same. So after a while I found a very good guide for creating one for me check here —>>> How to get Bitcoin or Cryptocurrency Prices in Google Sheets there are included copies of the original file, so please for guidance on how to do create a file for yourself please proceed to the original post. 

What do I track and why

Let’s assume you where all good boyz and grillz, checked the original post and now are thinking: “I wonder what is PressF tracking”. He he:

• Ticker - for obvious reasons as ticker is usually the symbol all exchanges use to filter coins.
• Name - again for obvious reasons.
• Amount bought - this is the size of the entered position or the amount of crypto I bought. IF I should sell less than the amount bought, I alter this cell accordingly!
• Price at purchase - coin price at time of the transaction, it is necessary for the next point.
• Position value at purchase - when we have the amount and the price of one coin, we can calculate how much money we actually put in the transaction.
• Fee on purchase - until the size of purchase is in the tens of hundreds of dollars the fee is rather irrelevant, but once you accumulate bigger and bigger transactions fees will take a rather big portion of the transaction, so it’s better to track those bastards down right away. BTW! It’s wise to track fees at selling moment as well, as ROI will be affected by this as well.
• Price live - coin live price, again pretty self explanatory.
• Position value - needed to calculate ROI.
• Return on investment(ROI) - I’d say this is one of the most important information to track. Here you will see whether the position has increased or decreased. Here you will understand at what point and how much of the position you will want to sell. Do not forget that ROI is impacted by all of the fees AND if for instance you put your coins into staking then you might want to add staking into ROI as well.
• 24h/7d/30d variation - if you want you can track more. For instance you might be interested to see how the price has moved from the start of the year or how the price has changed compared to last year's same time. But since crypto is so volatile, I find 30 days enough to track.

Conclusion:

Well that’s it folks. Hopefully this helps you track your positions, don’t be shy and ask me questions in the comments section if some part of it is unclear. Aaand don’t forget to check the original authors post if you want to create a similar spreadsheet on your own!