Every month I create a magic formula investing tracking portfolio from the 50 stocks over $100m market cap from the official screener. I have been doing this since January 2006. It is important to remember that I am just a guy with an Excel spreadsheet and I rely on the notorious unreliable Yahoo Finance for stock prices. I do check for reasonability, but mistakes are possible.
When I start a new tracking portfolio (I do this the last Friday of every month), I also create three subsets from the official list:
- Dividend Stocks - these are stocks from the list with a yield (generally per Yahoo Finance with some overrides) of at least 2.6%. I do try and include special dividends if within past 12 months (like for SYNT).
- New Stocks - these are stocks not in any of my tracking portfolios over the past year.
- Dogs - these are stocks that were the worst performers from the portfolio a year ago (in this case May 2016) and still in the screen. KInd of a Dogs of the Dow approach.
So here are the stocks in each subset:
|Stock||Initial Price||52 week low||Mkt Cap||Total Dividend||Yield|
|Stock||Initial Price||52 week low||Mkt Cap||New|
|Stock||Initial Price||52 week low||Mkt Cap|
I do find it telling that 4 of the dogs (all but PDLI) are also on the dividend list.