#HYHRD: spreadsheets 12/1 $RCKY $RFI $RNP $SAR $SPXX $STK $TPZ $UTF $UTG

Howdy, Y’all!


I’m Pat Rosenheim, a.k.a. the PandA Trader.

I took last week off to celebrate Thanksgiving with our family in the frozen north. When we left our home near Tampa, Fl on Thanksgiving morning it was 71 degrees and when we landed at Boston’s Logan airport it was 15 degrees. Right there we decided to never visit in the winter months again. But, we got our rental mini-van from Enterprise which was a fairly painless exercise and held a few delightful surprises for us. It was a 2018 Dodge Grand Caravan, black and not much to look at from the outside even though it was fairly clean save for the rather large seagull dropping on the right front fender. The rest of the vehicle was almost spotless, however. We loaded ourselves into the van and I was delighted to find that there were 3 heat zones (driver, passenger, and rear), both front seats were power adjustable and also heated, and the steering wheel was also heated. Wowza! We were ecstatic! It didn’t take long to adjust mirrors, seats, etc. and we were soon on our way to the hotel. We picked a new hotel about halfway between our 2 sons, at the intersection of Rt. 1 & Rt. 128 in Peabody, MA. This Holiday Inn was more expensive than our old favorite Holiday Inn in Tewksbury, presumably because it was closer to Boston. We checked in, got our room key, and trudged the long walk down the hall to our room. We went in and it was just as cold in the room as it was outside! We also noticed there were no blankets on the beds! WTFF?!?! We went down to the front desk and told them about it and the slack-jawed yokel behind the desk said “Uh, I only have sheets here” and threw 2 on the counter. I said “Could you ask housekeeping to make the beds up *with blankets” and send maintenance to the room to fix the heat, please?”. He said, “Uh, sure”. We left and drove the 10 miles to one son’s house to have turkey dinner. Dinner was lovely and so was dessert, 6 pies and ice cream and homemade charlotte russe (a family tradition and not at all as you would imagine – cake, crabapple jelly, bananas, cool whip, etc. left to percolate for a day or so in the fridge with other ingredients I am totally unfamiliar with). Daughter-in-law’s mother came and brought her signature sweet potato casserole with marshmallows on top (a huge hit!). We all sat around a huge table and the food was being heaped on our plates with near reckless abandon and my plate was filled to the brim when I realized I didn’t have any turkey! Hold the phone! Some minor re-arranging and the turkey was added twixt the stuffing and taters and gravy was poured on the above, followed by a couple of dollops of cranberry jelly. I have to say, the best part of Thanksgiving dinner is how quickly you forget the rest of the year and any troubles you may have. Our second son and his family joined us for dessert as did our friends who recently bought a home in our park. Conversations were lively and laughter was frequent. Offers to refill your plate were ever-present and must be politely refused.

But, all good things must come to an end and so, after dessert (1st and 2nd!) we bade farewell to our family & friends and made plans to see Fantastic Beasts: The Crimes of Grindelwald on Saturday at the Imax theater in Reading, Mass.

We went back to our hotel and found there was still no heat. There was now a girl at the front desk who must have been born of saccharine because she made me sick when I spoke to her because she was indeed sickeningly sweet. I won’t go into full detail but the maintenance man came and took the cover off the a/c & heat unit and dust flew everywhere. He wiggled the plug on the side and there were a few little sparks and the unit came to life briefly and died again. We commented on the dust flying around the room but he just looked at us and did not respond. He wiggled the plug and then he wiggled the junction box and then finally the unit came to life with a grinding squeal. He replaced the unit cover and left the room. We looked at each other through the cloud of dust and said “We can’t stay here” and called the front desk.

Saccharine invited us down to the front desk to have a conversation. I explained that my wife uses a walker and I have COPD and neither of cannot walk too far, so we need a room close to the elevator. Sac gave us a key to a room on the 4th floor and told us it was close to the elevator. We still had our luggage on the cart and I loaded my wife and the cart onto the elevator and we went to the 4th floor to examine this new room. Turns out this room was at the end of the hallway and the bathroom was filthy so we opted to return to the front desk.

I was starting to get perturbed…

I told Sac that I needed something close to the elevator and she said I gave you one and I explained it was at the end of the hall as far from the elevator as one could possible get. I also explained about the bathroom being filthy and again asked for another room. She look at the floor map and said to herself “Oh, I see it now. I was looking at it wrong.” and typed something into the computer and handed me another set of keys to a room on the 3rd floor. She assured me this room was right next to the elevator, that I should get off the elevator and turn right and the room would be on my right. Silently I took the keys and we made our way back to the elevator and up to the 3rd floor. We found that if we instead turned left the room was on our left. Seems that Sac didn’t know left from right.

We checked in and found the heat worked, and there were blankets on the bed. Good enough. It was now 1AM and we wanted to go to sleep.


I use Google spreadsheets for my holdings and to record dividends. They are as up-to-date as I can manage, but will lag by a day or so due to delays in the cost basis reporting from the brokerages. The share prices should update close to real-time, however, with a possible slight delay (~20 minutes) from Google. Also, there now appears to be a very real existential threat to these spreadsheets; Google has “updated” the Finance portion of their website, and all financial functions ceased functioning on the Google sheets recently. It has since started functioning again. I may stop using these sheets altogether, but they are still there. For now…

Here’s an update: The pricing updates for QQQX (and some others) has failed again in other areas of the spreadsheets. Thanks, Google! NOT!!!

531147_389388761142977_154361047_nb NOTE: (Google will soon discontinue some parts of Google Finance, so there is an existential threat to my Google spreadsheets. They have given no warning, only that some of it will stop working “to enhance the user experience”. Assholes!)

From the Silver Lining Dept.: Since I use the TDM dividend and Investment Tracking Software, I don’t worry about Google’s asinine decisions anymore. This TDM software pulls all the dates and dividend amounts into the program automatically so all I need to do is input any buys and sells and the dividends are calculated automatically for me! I can pull up the ex-dividend list and it even shows ones in the past month I may have missed on my sheets and calendar. Mostly, though, I just use it now to forecast a week ahead for the ex-dividend dates, and subsequently the dividend amounts. The program will forecast several months into the future, based on historical amounts, but I’m only concerned with what I have earned (ex-dividend dates and amounts) and what I will receive (dividend projections) for the next 7 days (or 14 days, or 21 days, or 28 days, etc.) Also, I can select only what has been declared and omit the historical guess that the program makes, even though they’re pretty damned accurate.

It should be noted that the sources Dustin uses to get dividend information has changed a few times recently but he has quickly responded with updates.

On my Google spreadsheets, you can find portfolio holdings, dividend amounts, dates (dividend pay dates, record dates, declaration dates, dividend amounts, ex-dividend dates, etc.). I have moved the cash and withdrawal amounts to the Google spreadsheets as well as the dividends spreadsheet. I will still post screenshots on the Dividends Received page. I have recently added most of the CEF NAV values that I could find, and a column to show amount of premium/discount.

I only post for my holdings, but they’re as accurate as I can make them. The symbols are; AGD, ARCC, ARR, AWP, BGH, BST, BXMX, CLM, CRF, CSQ, DIAX, DNP, ECC, FLC, FTF, GAIN, GLOP, GOF, HTD, IFN, IIF, JPC, JPI, KIO, KRP, LDP, LGI, LOAN, LOR, MAIN, MITT, NEWT, NHF, NRO, NRZ, NVG, NZF, OIA, OXLC, PCI, PDI, PDT, PFO, PHK, PHT, PMF, PML, PSF, QQQX, RA, RCKY, RFI, RNP, SAR, SPXX, STK, TPZ, UTF, & UTG. Quite a list, eh? (59 total issues held; 12 common stocks and 47 CEFs, of which 5 are tax-free muni CEFs.) Most pay monthly! Only ARCC, BXMX, DIAX, GLOP, IFN, KRP, LOAN, MITT, NEWT, NRZ, QQQX, RCKY, SAR, SPXX, & STK pay quarterly. IIF pays semi-annually.

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 6 posts in the series when posted. The withdrawal update is issued monthly. I think you should try to catch all 6, plus the monthly withdrawal update if you’re so inclined. Occasionally I’ll throw something else up for ridicule or admiration like my recent final posting about “Profiting from Preferreds”, so feel free to be entertained!

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

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 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 last declared ex-dividend dates.

This is that table;


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


I’m not telling anyone to buy anything or giving anyone any advice, because that’s illegal. You see, I have no letters after my name, like RIA, CFA, etc. I SIMPLY DO NOT GIVE ADVICE. I only tell (and show!) what I do. You, like me, are all alone in this.

And remember, always do your own due diligence!

panda_wildePat Rosenheim
(PandA Trader)
High Yield, High Return Dividend



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.

Don't be shy! Leave a Reply...

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s