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…
But, I did fairly well with that, and harvested over $3,500.00 in gains! (Stopped, now!) I may resume this tactic in the future if prices appreciate enough to warrant another “harvest” of gains.
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 monthly sharebuilder investments (On 1st Tuesday) using all 12 free trade credits. But, I will not be investing equally. Investment amounts will be based on 1/60th of the settled cash in the account so it should last ~five and a half months. This amount will be pro-rated among the top CEFs based on their Total Return. It’s all shown on the equal weight spreadsheet. Or, maybe I’ll do something different. Who knows?
News flash…. I am doing something different. Check out the #Sharebuilder #Update…
Anyway, let’s continue with a look at the dates;