#HYHRD: spreadsheets for 8/22 q*.!.*p

I have combined all spreadsheets into one workbook (PandAtradelogs.xlsx) to make them easier for me to get the info I need. The spreadsheets that I use mainly in my weekly posts are the Score spreadsheet, Equal Weight (Investment amounts) spreadsheet, the Expected dividend (stock holdings) spreadsheets (parts 1, 2, & 3), the actual yield (‘dividend per invested dollar’) spreadsheet, the dates spreadsheet, and the watch list (screening) spreadsheet. They are all now found in the PandAtradelogs workbook.

The spreadsheet for each individual account, along with the monthly balances and yearly dividends are also found in the PandAtradelogs workbook.

This post will examine the screening spreadsheets and associated scoring, and the dates spreadsheet for all positions held in the accounts (i.e.; positions not held will not appear on the dates spreadsheet).

Here’s the Screening spreadsheet;

Google Drive has the most recent workbooks accessible, in my public files area.

Here’s the newest dividend stock watch list;

watchlist

You might notice the colors in the % yield, % return, and total columns have changed. In the % yield column, anything greater than or equal to 5% is green, or if it’s less than 5% it’s yellow, or if it’s less than 0% it’s red. In the % return column, anything greater than or equal to 20% is green, or if it’s less than 20% it’s yellow, or if it’s less than 0% it’s red. In the total column, anything greater than or equal to 25% is green, or if it’s less than 25% it’s yellow, or if it’s less than 5% it’s red. (Color coding helps in making the decision to buy (green), hold (yellow), or sell (red) much easier to see at a glance.) The color code key is in the lower right corner.

According to this spreadsheet (updated each weekend);

Based solely on the scoring procedure used on this Screening Spreadsheet, I might look into buying; ALK, HAS, SPTN, NEWT, VLGEA, MAS, TGT, DPS, LARK, GSB, WTBA, CAP, TBNK, LMT, GD, NYCB, PLOW, RCC, APTS, PETS, WMC, BRKL, FLXS, AYR, SAIC, GAIN, and ANH, and may initiate a position at some point in the future. These symbols are combined with my curret holdings and then placed on the comparison spreadsheet to see if they qualify for my shopping list, but only after also looking at the charts.

Now let’s look at the SCORE spreadsheet to check out the best performers amongst my current holdings.

score

You might notice the colors in the % yield, % return, and total columns have changed. In the % yield column, anything greater than or equal to 5% is green, or if it’s less than 5% it’s yellow, or if it’s less than 0% it’s red. In the % return column, anything greater than or equal to 20% is green, or if it’s less than 20% it’s yellow, or if it’s less than 0% it’s red. In the total column, anything greater than or equal to 25% is green, or if it’s less than 25% it’s yellow, or if it’s less than 5% it’s red. (Color coding helps in making the decision to buy (green), hold (yellow), or sell (red) much easier to see at a glance.) The color code key is in the lower right corner.

RMDs are something that will have to be looked at in a few years, but for now they do not pose a problem. They will show up on the balances worksheet to show withdrawals for the coming year in the tradelogs workbook beginning in 2016 and again in 2023 (to account for the differences in our ages).

I may remove symbols from the spreadsheet(s) if they do not pass screening and/or perform poorly, and as long as no shares are held in the portfolio.

I decided to stop screening for ETFs/ETNs because I only own one, and am not currently interested in adding more. I am now looking into Preferred Securities. I’ll need to do more DD on that before I start to invest, and/or post my opinions about them.

Here’s a look at the dates spreadsheet, showing the ex-dividend and pay dates as well as can best be determined whether a stock pays a qualified dividend or not. Some might use info like this to time their purchases after a stock goes ex-dividend, due to the anticipated drop in stock price, or to make sure they own a stock before the ex-dividend date to ensure they are entitled to the dividend. I mainly use it to keep track of the dates and amounts, and whether a stock pays a qualified dividend or not. YMMV!

dates

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.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s