I've been contributing to my employer's 401(k) plan for 2 full years now. I started contributing in Jan. 2010 by allocating 100% of my money into a target retirement mutual fund. Fast forward two years later and I finally am ready to take a little more control on this matter. I started by building my own portfolio, given the funds available in my plan. In December I spent a fair amount of time researching how to build a diversified portfolio for a person of my age (26) and I'm happy with the portfolio I came up with.
Here's where I need help. I'd like to track each investment from month to month so I can see how each one is doing at the end of the year re-evalutate my portfolio to rid myself of any funds that are underperforming. I cannot seem to decide the best way to do this. So far I have just been tracking the cost per share of each fund and the amount of shares I own. I have a spreadsheet that lists the funds down the left side and across the top I have the months listed out. The thing is, this does not seem very informative to me and I'm just curious if anyone has any other ideas about how to do this so at the end of the year I will have a clear picture of what has gone on.
So here are my specific questions:
1. Should I be recording additional information each month, above and beyond the cost per share and amount of shares owned? If so, what information?
2. What is a good layout in a spreadsheet to track this information? Specific examples greatly appreciated.
Normally I am the queen of spreadsheets and I have some great ones that I use all the time, but this particular type of tracking is just beyond me. I've tried researching online, couldn't come up with much though. This is not only for my 401(k). I'd like to do the same for my husband's 401(k) and an IRA we have.