For 2019, I thought it would be cool to track my main account and see how much it would change on a daily basis. So below is basically $1,000,000 of investments with the data laid out in a simple excel file. Obviously there is the date column. followed by column B showing the gains or loss for the respective date. Finally, column C shows the accumulated gains for the year as time passes in 2019.
They say a picture is worth 1000 words, so I created the chart below to visually show you the ups and downs of this portfolio for all of 2019.
Some interesting things to observe on the above chart. I only had 1 day in the year with a gain of over $20k, while there were 4 days showing a loss of over $20k. As the range tightens down to the $10k range, there are more frequent number of days of +/- $10,000. And the same is true as we tighten the range down to $5,000. Graphically, you can also see the increase in volatility around mid April to late May, and the same from late July to late August. Then surprisingly, starting in September, it was pretty much smooth sailing with a few exceptions.
The following chart shows the accumulated gains throughout the year.
The interesting thing I saw from charting out this data, and didn’t even realize, I was only in the negative area for 2 days in the year. After January 3rd, there really was no looking back. Pretty interesting.
There are a couple of takeaways from looking at the data. The first chart shows lots of fluctuations when you look at investments on a daily basis. When you look at the second chart, you see that it was a great year to be invested. So, had you let the daily ups and downs bother you with investing, you may have missed out on the long term bigger picture.
As a former co-worker used to always say, “don’t trip over dollars to pick up pennies.”Follow me on the social medias: