If you're like me, you have crypto investments all over the place. I, for example, have investments in three different platforms: Exodus, Steemit, and Binance.
It is great to see the price of your cryptos go up (or down), but can you actually track how much you are making?
Having cryptos in three different places makes growth difficult to accurately measure. To solve this problem, I created a simple excel file to track my personal growth. And I will show you exactly how to do it.
Want to give it a try? Here's a step-by-step process how to make your own:
1. Create a regular old excel file.
2. Create a column for each of your crypto platforms (Example: Columns D, E & F).
3. In G2, create a simple formula to add up the daily values that are in your platforms (=D2+E2+F2). Copy the formula by pulling down on the corner.
4. Create a column for the date. In A2, type today's date (12/24/17) and drag down from the corner to the desired end date. You can always add more.
5. In column B, create a column for your total wallet value.
6. In B2, create a cell reference to the cell that previously added your total (=G2). Drag down from the corner to copy the formula in the cells below.
7. In column C, create a column to calculate your percentage change for the last 24 hours.
8. In C3, type in the following formula: =((B3-B2)/B2). This will calculate the percentage growth or loss from the day before. Drag down from the corner to copy the formula into cells below.
9. Lastly, create a graph for your data. In the chart group within the insert tab, select the line chart tool. From there, you can format the table in any way you want by selecting the filter icon next to the chart.
10. Personalize your worksheet however you'd like!
Just like that, you're done!
Now, you can track your personal investment growth from across all of your platforms by simply entering the total value from each of your platforms once a day.
This is a simple fix to a frustrating problem that crypto investments create. Doing this will allow you to accurately measure your personal growth leading to more informed decisions regarding your investments.
Congratulations @natethoreson! You received a personal award!
Click here to view your Board of Honor
Congratulations @natethoreson! You received a personal award!
You can view your badges on your Steem Board and compare to others on the Steem Ranking
Vote for @Steemitboard as a witness to get one more award and increased upvotes!