Dividend Meter > Meter Updates
My dividend spreadsheet is broken. Today is April Fool’s Day, but this is no joke. Myself and others have been experiencing problems this past week with the IMPORTDATA formula properly updating the annual dividend figure in the spreadsheet. Yesterday, changing the small case “d” to an upper case “D” in the following column G formula did improve performance for me:
I remember this same problem happening a few months ago, and performance cleared up on its own despite changing anything from lower to upper case. This appears to be a frustrating recurring reliability issue with Google Sheets. Another tip: add another tab to your spreadsheet to duplicate your Dividend Meter, and replace the IMPORTDATA formula in column G with the actual annual dividend amount. Unfortunately, this tab won’t automatically update with dividends raises or cuts, but everything else should update fine.
This is a good time to solicit any app developers out there who might want to partner with me to create a “Dividend Meter” app. How cool would be to have a Dividend Meter app that could instantly show a reliable meter reading, and provide buy and sell notifications based on your custom yield triggers? If you’re interested in helping with this endeavor visit the Contact page and drop me a line.
Anyway, let’s talk about happened in March to the Dividend Meter. Despite the poor spreadsheet performance, my Buy/Sell indicators worked fantastic this month for exposing three trade opportunities that contributed to raising the overall annual meter reading by $235.46. In March, one new position, OHI (Omega Healthcare Investors Inc.), was added to the spreadsheet and acquired. Here’s a summary of March’s activity:
|3/3/2016||$5,492.99||Bought 8 shares DFS with accumulated dividends in IRA Rollover#1|
|3/3/2016||$5,513.69||WM dividend increase, raises meter reading $20.70|
|3/8/2016||$5,550.69||Sold 100 GIS, bought 142 MET|
|3/12/2016||$5,565.57||GIS Dividend increase, raises meter reading $14.88|
|3/21/2016||$5,661.17||Sold 100 COP, bought 326 F, raises meter $95.60|
|3/24/2016||$5,668.37||Added $500.00 new savings to TradeKing account, bought 9 SBUX|
|3/29/2016||$5,719.49||Sold 100 CALM, bought 154 OHI|
To view a snapshot of the entire Dividend Meter spreadsheet at the end of March, visit the Member’s Club page.