#HYHRD: 6/4 $AI $BGCP $CMU $CNSL $CXE $DRAD $GLDC $GSB $JPS $MAV $MFM $MHI $NMZ $MSEX $PSEC $SUP

For the most part, I have discontinued using the spreadsheets except to record purchases and sales, as well as 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 reporting from the brokerages. The prices should update close to real-time, however, with a possible slight delay from Google. There are a lot of updates that need to be made because of all the activity on Friday. I hope to get it done this week.

The most up-to-date method 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 the sheet I use to track options (mostly covered calls, only updated when I sell or close a position (and also on Google));

options

Here’s a look at the dates spreadsheet, showing the ex-dividend and pay dates as well as can best be determined the tax status of the dividend. 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, and the tax status of the dividend. YMMV!

dates

And now, the same thing for all of the other CEFs;

cef

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.