#HYHRD: spreadsheets 11/19 $JPC $JPI $JPS $KIO $LDP $LEO $MAV $MFM $MHI $NAD $NMZ $NRO $NVG $NZF $OIA

I have discontinued using the MS Excel spreadsheets except to record dividends, withdrawal amounts, and cash balances. I am now using Google spreadsheets for my holdings. They are as up-to-date as I can manage, but will lag by a day or so due to delays in the reporting from the brokerages. The prices should update close to real-time, however, with a possible slight delay (~20 minutes) from Google.

I used to post the screenshots of dividend pay dates, record dates, declaration dates, dividend amounts, ex-dividend dates, record dates, and tax status as well as option activity. All except tax status & option activity is on my google sheets.

I only post for my holdings, but they’re as accurate as I can make them. The symbols are; ARR-B, BBK, BDJ, BFK, BGH, BKN, BTA, CMU, CSQ, CXE, DFP, DHF, DHY, EAD, EVN, FFC, FHY, FLC, FMN, FPF, GOF, GUT, HHY, HIX, HPF, HPI, HPS, IQI, IVH, JPC, JPI, JPS, KIO, LDP, LEO, MAV, MFM, MHI, NAD, NMZ, NRO, NVG, NZF, OIA, PDT, PFD, PFO, PHK, PHT, PMF, PML, PMM, PMO, PMX, PSF, RFI, RNP, RQI, UTF. Quite a list, eh? (59 total issues held; 0 common stocks, 1 Preferred issue, and 58 CEFs, of which 23 are tax-free muni CEFs.)

This series of blog posts is issued `weekly, but since the majority of our holdings pay dividends near the end and/or beginning of the month it may not always warrant a publishing blitz. There are usually 4 posts in the series when posted. The sharebuilder update is issued weekly and the monthly withdrawal update is issued monthly. I think you should try to catch all 4, plus the sharebuilder update and/or the monthly withdrawal update if you’re so inclined. Occasionally I’ll throw something else up for ridicule or admiration like my post about “Profiting from Preferreds”, so feel free to be entertained! I put another post up titled “Rolling on the #dividend train” and kept that updated until mid-September when the upward climb of prices slowed…

  • I did fairly well with that “Rolling on the #dividend train” thing, and harvested over $3,500.00 in gains! (Sure has stopped, now!) I may resume this tactic in the future if prices appreciate enough to warrant another “harvest” of gains.
  • We made $16,699.71 from preferred shares since March 14, 2016. We continue to earn $49.22 each month from our shares of ARRPRB through at least the first month or 2 of 2018 when ARRPRB shares might get called (the ARRPRA shares might get called next year in June of 2017!).

Of course, if something major happens I might be tempted to throw something up about that. Or not. Like the recession, or whatever…

Like, from now on I think I might make weekly sharebuilder investments (Usually every Tuesday) using all 12 free trade credits, with additional trades under the AIP plan costing $1 each. But, I will not be investing equally. Investment amounts will be based on part of the settled cash in the account so it should at least last a little while. I’ll also add a little each month. This investment amount will be pro-rated among the top CEFs based on their Negative Total Return (i.e.; the bottom 3!). It’s all shown on the equal weight spreadsheet. Or, maybe I’ll do something different. Who knows?

Anyway, let’s continue with a look at the dates;

The most up-to-date method to view our holdings and expected dividends is to look under the “Real Results” tab on my blog, and select the Current Holdings item. Then, click the link for the Google docs spreadsheet.

Or, just click here (will open in a new window).

Here’s a look at the dates spreadsheet, showing the ex-dividend and pay dates of each dividend (also shown on the calendar). I sometimes use info like this to time purchases or sales after a stock goes ex-dividend, due to the anticipated drop in stock price, or to make sure I own a stock before the ex-dividend date to ensure I am entitled to the dividend. I mainly use it to keep track of the dates and amounts of the dividend. YMMV!

Click here for the dates sheet.

Look on the right side and you’ll see a chart (table) sorted by ex-dividend dates.

This is that table;


We were in a string of 8 days in a row where quite a few holdings (56 out of 59) traded ex-dividend. This string ended on October 20th, the same day payouts began; there’s 1 paid on 20th, then 1 paid on 24th, and 1 paid on the 25th, then 2 paid on the 27th, & another 2 paid on the 28th, then 30 paid on the 31st, with the final 20 being paid on the 1st. There’s also the last quarterly payout from CSI on November 2nd, but I didn’t count that one because I sold it and we only hold monthly paying issues in our accounts now. It’s not really a consecutive string of payouts, and they are rather concentrated near the end of the month/beginning of the month, but that’s just fine and dandy with me. Also, I didn’t count the final payout from RSOPRC on the 31st.

Now the ex-dividend days have started again on Nov. 1st!

History is repeating itself. We are mostly following the above trend with some slight variation in ex-dividend dates, etc. Some amounts have changed, as outlined in my post(s) with title(s) beginning with “#HYHRD: Ex-div & pay dates”.

Please see my previous post for more about this;

Most of the ex-dividends this month are from the 9th through the 21st. Non-stop. Dividends start about the same time as the ex-dividends end. It’s not quite consecutive days, but I believe there are now 35 dividends through the end of the month (7 business days, or an average of 5 each day). There’s quite a few next month on the 1st (21!), but no more until 3 on the 15th. So, in the next couple of weeks, we’ll see the majority of our dividends for this month, plus a bit more than a third of next month’s dividends on the first of next month (next Thursday). Ok, let’s see now; that’s 35 more dividends for this month plus 21 for next month for a total of 56 over the next 8 business days (an average of 7 each day). That’s all 59 holdings accounted for, but I like the way the dates seem to run together so that earnings (ex-dividend) days are easy “work”, but the concentration of paydays and holdings making payments is very rewarding. (Estimated @ $1,249.95 per month at the moment. Take a look at the dividends tab on my google spreadsheet.)

But, as always, “Don’t be hasty” as Treebeard would say. 😉


About PandA Trader

I am, I think... "Disobedience, in the eyes of anyone who has read history, is man's original virtue. It is through disobedience and rebellion that progress has been made." -- Oscar Wilde
This entry was posted in dividend portfolio. Bookmark the permalink.