#HYHRD: spreadsheets for w/e 5/16 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 7% is green, or if it’s less than 7% it’s yellow, or if it’s less than 5% it’s red. In the % return column, anything greater than or equal to 30% is green, or if it’s less than 30% it’s yellow, or if it’s less than 10% it’s red. In the total column, anything greater than or equal to 37% is green, or if it’s less than 37% it’s yellow, or if it’s less than 15% 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; $NRZ, $SPTN, $ANCX, $AOS, $LEG, $APTS, $BANC, $WU, $NWL, $VLGEA, and $HAS, and may initiate a position at some point in the future. In so doing I would most assuredly affect my overall dividend yield, but the annualized total return may be worth that compromise. They must also look good on 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 7% is green, or if it’s less than 7% it’s yellow, or if it’s less than 5% it’s red. In the % return column, anything greater than or equal to 30% is green, or if it’s less than 30% it’s yellow, or if it’s less than 10% it’s red. In the total column, anything greater than or equal to 37% is green, or if it’s less than 37% it’s yellow, or if it’s less than 15% 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.

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