I’m Pat Rosenheim, a.k.a. the PandA Trader.
I only use MS Excel spreadsheets now 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 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.
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 may move the dividend record and withdrawal amounts to the Google spreadsheets (I am already mirroring the cash spreadsheet).
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, FIF, FLC, FMN, FPF, GOF, GUT, HIX, HPF, HPI, HPS, HYB, IQI, IVH, JPC, JPI, JPS, KIO, LDP, LEO, MAV, MFM, MHI, NAD, NHF, NMZ, NRO, NVG, NZF, OIA, ORC, PDT, PFD, PFO, PHK, PHT, PMF, PML, PMM, PMO, PMX, PSEC, PSF, RA, RFI, RNP, RQI, TICC, TLI, TPZ, & UTF. Quite a list, eh? (67 total issues held; 3 common stocks, 1 Preferred issue, and 63 CEFs, of which 23 are tax-free muni CEFs.) Three ETNs (BDCL, CEFL, & MORL) will start being added when the partial transfer of our Roth accounts to Capital One Investing (ShareBuilder) has been completed. Most pay monthly!
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 of last year 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, though!) I may resume this tactic in the future if prices appreciate enough to warrant another “harvest” of gains.
- We’ve made $23.12 ST Capital Gains in our regular brokerage account, & $791.62 LT Capital Gains in our IRA accounts, for a total of $814.74 of harvested gains YTD.
- We’ve made $16,798.15 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 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, depression, World War III, or whatever…
From now on I will make weekly sharebuilder investments (Usually every Tuesday) using 3 of 12 ‘free’ trade credits each month, with additional trades under the AIP plan costing $1 each. But, I will not be investing equally. This investment amount will be pro-rated among the CEFs based on their performance. It’s all shown on the cash tab on my Google spreadsheet. Or, maybe I’ll do something different. Who knows?
I am partially moving our Roth accounts from Fidelity to Capital One Investing (ShareBuilder), initiating the transfer around March 1st. When that transfer is effected, I will begin making weekly sharebuilder investments (Usually every Tuesday) using 3 of 12 ‘free’ trade credits each month, with additional trades under the SIP plan costing $1 each. I will initially be investing equally and will be based on adding 3 ETNs to the account (BDCL, CEFL, MORL). Later, after a sufficient amount has been invested in these 3 ETNs, another tactic may come forward, such as investing in the poorest performers in an effort to buy at a discount. It will all be shown on the individual Roth account tabs on my Google 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 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!
Look on the right side and you’ll see a chart (table) sorted by ex-dividend dates.
This is that table;
But, as always, “Don’t be hasty” as Treebeard would say. 😉