Portfolio Review December 2017

For our portfolios I created a summary view in Google Sheets that updates automatically.  I also “save” performance every month or so (per above) so that you can see performance across time.  Note that this performance also includes additional investments and withdrawals so it isn’t “apples to  apples” but is still useful.  Generally we’ve gone up a lot in total since May along with the total market, and been pretty steady for the last couple of months.

Since moving portfolios to Google Sheets, I also centrally review “all stocks” and update yield (which cannot be determined via a Google Finance formula) manually.  At this time I also go through the stock news and review some of the stocks that may be performance outliers, as well as remove information on stocks that we no longer track (like TTM and SAVE).

Some of the stocks noted:

  • Dow Dupont (DWDP) – the merger has been completed.  The stock is likely to split into three separate companies.  I think we will sell now and take our gains and review the companies later that spin out.  This also saves us from having just a few fractional shares (Portfolio 3)
  • Juniper (JNPR) – there were rumors of a buyout for this network equipment maker.  This company is at risk of remaining independent due to the migration to the cloud.  It went up with the speculation (and back down when it didn’t occur).  Would like to get the sale premium or see it embedded in the stock price.  The problem is that if the sale doesn’t happen, the price usually goes back down (Portfolio 5D)
  • Siemens (SIEGY) – the European conglomerate has held up better than GE in the face of the power meltdown (companies are not buying turbines as often anymore they are moving to solar and wind).  They are likely to spin off their health care business in Europe.  May be a time to sell (Portfolios 3, 5D)
Advertisements

Google Sheets Integration

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).