Stocks in May 2017 Tracking Portfolio

May 26 2017 Tracking Portfolio Composition

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:

1. 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).
2. New Stocks - these are stocks not in any of my tracking portfolios over the past year.
3. 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:

Dividend

Stock	Initial Price	52 week low	Mkt Cap	Total Dividend	Yield
AMGN	155.01	133.64	114,103	4.60	3.0%
BKE	16.80	16.00	821	1.00	6.0%
BPT	20.20	13.42	432	4.39	21.7%
CSCO	31.50	27.13	157,500	1.16	3.7%
GILD	64.50	63.88	84,302	2.08	3.2%
GME	22.22	20.10	2,251	1.52	6.8%
HPQ	18.47	11.48	31,030	0.53	2.9%
MCFT	18.65	10.25	348	4.00	21.4%
OMC	83.26	75.61	19,533	2.20	2.6%
PBI	14.93	12.31	2,782	0.75	5.0%
SYNT	18.16	15.82	1,519	15.00	82.6%
WILN	1.41	1.27	167	0.04	2.8%

New

Stock	Initial Price	52 week low	Mkt Cap	New
AMGN	155.01	133.64	114,103	1
DISCA	25.87	23.66	15,186	1
FOXA	27.03	23.33	50,029	1
MEET	4.66	3.41	321	1
TIME	12.10	11.65	1,202	1

Dogs

Stock	Initial Price	52 week low	Mkt Cap
BKE	16.80	16.00	821
GILD	64.50	63.88	84,302
PDLI	2.39	1.93	390
SYNT	18.16	15.82	1,519
WILN	1.41	1.27	167

I do find it telling that 4 of the dogs (all but PDLI) are also on the dividend list.