I’m Pat Rosenheim, a.k.a. the PandA Trader.
I only use MS Excel spreadsheets now to record dividends. 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 have moved the cash and withdrawal amounts to the Google spreadsheets. Only the dividends spreadsheet is still in excel, but I post screenshots on the Dividends Received page.
I only post for my holdings, but they’re as accurate as I can make them. The symbols are; BBK, BDCL, BDJ, BFK, BGH, BKN, BTA, CEFL, CMU, CSQ, CXE, DFP, DHF, DHY, EAD, EVN, FFC, FHY, FIF, FLC, FMN, FPF, GOF, GUT, HIX, HPF, HPI, HPS, HYB, IQI, JPC, JPI, JPS, LDP, LEO, MAV, MFM, MHI, MORL, 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, 3 ETNs, and 61 CEFs, of which 23 are tax-free muni CEFs.) 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 updates are issued weekly and the monthly withdrawal update is issued monthly. I think you should try to catch all 4, plus the sharebuilder updates and/or the monthly withdrawal update if you’re so inclined. Occasionally I’ll throw something else up for ridicule or admiration like my quarterly 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…
From now on I will make weekly sharebuilder investments (Usually every Tuesday) using 3 of 12 monthly ‘free’ trade credits, with additional trades (if any) under the AIP plan costing $1 each. Now that I think of it, that would be in a month with 5 Tuesdays. But, I will not be investing equally. This investment amount will be skewed among the holdings. It’s all shown on the account tab. Or, maybe I’ll do something different. Who knows?
I have partially moved our Roth accounts from Fidelity to Capital One Investing (ShareBuilder), initiating the first part of the transfer around March 1st. The second and final partial transfer was completed for my wife’s Roth. The 3rd and final partial transfer of my Roth completes the transfers for both Roth IRA accounts. When that first transfer became effective for the 2nd investment day in March, I began to make weekly sharebuilder investments (usually every Tuesday) using 4 of 12 monthly ‘free’ trade credits, with additional trades (if any) under the SIP plan costing $1 each. The next month was a “full” investing monthly, with 4 investment days, so I initially invested equally based on adding 3 ETNs to the account (BDCL, CEFL, MORL). I have now switched to the investment schedule located on each account tab on my Google spreadsheets, and I plan to invest in the top 3 in Annualized Returns in each Roth account. It’s all 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 last declared ex-dividend dates.
This is that table;
But, as always, “Don’t be hasty” as Treebeard would say. 😉
PLEASE TAKE NOTE AND REMEMBER THIS!
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!