Tracking my investments on a spreadsheet

I am going to tell you about my idea and what I have implemented that I think works for me for tracking my personal investments.

My spreadsheet is updated weekly with the week ending closing price. There are 11 main columns and then 52 more for each week of the year.

Column A is the stock symbol, B is the purchase date, C is the purchase price, D is the current price, E is the expected gain since bought, F is the high since bought, G is the low, H is the percent of gain or loss since bought, I is the loss from it's high since bought, J is the # of weeks below 12%, K is the maximum price in the past year and L is the minimum price in the past year. The remaining 52 columns are the price for the end of that week.

Column A through D don't need explanation. Well maybe the current price (D). This is the week ending price. It is also copied to the appropriate week.

Column E is what the minimum return of 5% I expect per year. It is just simply a 1% increase every 73 days since the investment was purchased. Maybe it is not scientific but that is how I do it.

Column F is the highest week ending since purchased and G is the low. This is from Columns K to the end of the year (BL).

Column H is the percentage of gain or loss based on current price verses the purchase price (columns C and D).

Column I is the loss in percent from the high (column F) since purchased.

Column J is the number of weeks the price was below 12% of the maximum week ending price since bought. This I enter myself based on the column I.

Column K is the maximum week ending price from previous years if owned that long and L is the minimum.

I use this for two reasons. Obviously to track the gain and see when an investment is not gaining but losing. This would be columns I and J. I can also use this to see if an investment has gained appropriately in the long term, maybe a year or more. Columns E and H.