I have been using Google Sheets to update these portfolios and it has been an excellent experience. I can share the spreadsheets with the beneficiaries and they can see a real-time view of their portfolios on any device (phone, PC, tablet) through Google Sheets. The only minor updating item is the cash in the money market account which is a product of recent dividends.
It used to take me a long time to update each spreadsheet. I had to do the following items:
- look at the performance of stocks that were sold. Now I use the “Google Finance” formula to get the current price of stocks that have been sold and I have it in a text statement embedded with the purchase and sales price for that stock
- I don’t update the current prices for any stocks; that happens automatically
I try to centralize functions. One item you can’t find via Google Finance is “dividend yield”. I have a central sheet where I update yields once and then can copy that throughout all of the cells. I need to copy a block of text into the spreadsheet so that a VLookup can be applied against the data, with the ticker being the primary key. This also works for the current description of the stock’s status (commentary).