I spent some time tonight updating our portfolio spreadsheet and adding a few lines to make it easier to track things. I used to have some accounts like my wife's 401k listed as a single item even though that account holds 2 different funds. Now every fund is listed separately which makes updating easier and also makes tracking asset allocation easier.
Anyway, once I was finished doing all of that, the bottom line was that the total as of today is up by just under $110,000 since 12/31/18. Considering how awful December was, it's very nice to see how quickly things recovered. I feel bad for anyone who sold in a panic 2 months ago. Had I done that, I'd be $110,000 poorer right now.
Portfolio up 110K YTD
February 24th, 2019 at 03:00 am
February 24th, 2019 at 04:11 pm 1551024664
February 24th, 2019 at 06:24 pm 1551032643
It's definitely easier to track account by account. I switched over to doing that myself a couple of years ago. Also it's good for taking advantage of asset location: since you are likely to spend the money in your Roth accounts last (leaving them as a legacy or using them to help manage taxes in retirement), those accounts should be invested the most aggressively. With the money split, you can calculate the return on each type of account (though for those accounts where you are putting money in or taking money out, you probably want to use a time-weighted return to adjust for those cash flows. The "simple Dietz method" is easiest for this.
February 24th, 2019 at 07:55 pm 1551038157
February 24th, 2019 at 08:31 pm 1551040317
Good question. Our balance is up 10.8%. That does include new money that has been added since 12/31 of about $13,500. Remove that and the balance is up about 9.5%.
February 25th, 2019 at 12:40 am 1551055246