MFI Top 200 List - 12/28/14

MFI Top 200 List

It has been 2 weeks since I last created a top 200 list. It does take some time, I do like to create a list concurrent with my tracking portfolio.  As I mentioned last month,  I am expanding the data I bring in... it will take time to build a database, but ten years from now I might be able to tell you something new!

As my readers know, I like to replicate the official MFI site (Magic Formula Investing) every now and then.  I add a few extra elements such as (1) country, (2) yahoo yield, (3) my calculated stats, (4) ranking and (5) 200 stocks.

If anyone could think of any other stats that might be interesting, then let me know.  I have now started using price to tangible book.  The data is from GuruFocus.  I have brought in a ton of other data from Gurufocus as well.

I did have to make some changes this time.  Historically, I have always pulled in my list of all stocks from Finwiz.  However, they have now locked the ability to export under "premium" membership.  So I tried using Gurufocus this time.  In total, it is probably a better approach.  However, some stocks didn't even show up to be calculated (like ADMS, AVID, NHTC) so I had to manually add those to the list to be included. I want to stay away from manual intervention as much as possible, so I will need to figure out why Gurufocus did not have them.  One thing lost from Finwiz was country. So that is no longer in my table.

I think my approach is pretty darned accurate.  I use Compustat as well and formulas that were devised by a team on the Yahoo Groups board and detailed in my blog (MFI Diary: The Calculation).  I also cross reference my list with the official top 50 and they are almost always within my top 100 (I have more on my list as I do not exclude some stocks the official site excludes, such as some stocks in other countries).

Be aware that this is all formula driven, I have tried using Gurufocus for dividend yields - I found it was also unreliable..  The main financials (from Compustat) have seemed very reliable to me.

Ticker	Rank	Stock Price	Market Cap	Earnings Yield	ROIC	Dividend Yield
PTIE	1	2.04	93	44%	32807%	0.00%
ADMS	2	17.01	286	24%	8262%	0.00%
PDLI	3	7.86	1,312	29%	2143%	7.88%
TTWO	4	28.99	2,329	26%	809%	0.00%
KING	5	15.99	5,078	19%	2194%	2.83%
CALL	6	7.84	140	22%	639%	0.00%
PERI	7	4.59	319	23%	570%	0.00%
AGX	8	34.27	507	16%	990%	2.01%
GAME	9	5.86	1,594	15%	1001%	0.00%
NHTC	10	11.30	144	13%	4352%	0.27%
DEPO	11	15.69	955	14%	1234%	0.00%
MTEX	12	28.67	77	21%	303%	0.00%
KZ	13	5.70	266	18%	263%	15.38%
VEC	14	28.71	307	14%	393%	0.00%
CTCM	15	4.90	765	37%	167%	14.31%
HLF	16	38.42	3,312	17%	219%	0.79%
BCOR	17	14.03	576	13%	350%	0.00%
JOE	18	18.46	1,704	29%	157%	0.00%
TNH	19	103.74	1,919	21%	159%	10.23%
LFVN	20	1.34	139	14%	212%	0.00%
CRT	21	18.89	113	14%	167%	12.92%
NTIP	22	2.23	56	11%	476%	0.00%
LQDT	23	8.27	245	19%	122%	0.00%
SGU	24	5.90	339	19%	119%	5.67%
RPXC	25	13.96	768	10%	1378%	0.00%
SPOK	26	17.74	393	13%	190%	2.87%
UIS	27	29.63	1,494	16%	124%	0.00%
GME	28	33.65	3,799	15%	127%	3.95%
TZOO	29	13.24	196	12%	194%	0.00%
ATAI	30	3.80	87	24%	99%	11.45%
ASPS	31	33.40	790	17%	112%	0.00%
AVG	32	20.33	1,061	10%	692%	0.00%
SJT	33	13.81	644	10%	1453%	8.61%
PFMT	34	6.93	340	12%	165%	0.00%
MNDO	35	3.91	74	10%	930%	6.63%
AWRE	36	4.48	103	13%	120%	39.33%
NSR	37	27.75	1,586	12%	129%	0.00%
PETS	38	14.33	289	12%	135%	4.78%
APOL	39	33.94	3,762	14%	104%	0.00%
CBI	40	42.48	4,639	12%	110%	0.67%
RGR	41	34.91	696	18%	78%	4.57%
DLX	42	62.99	3,152	9%	367%	1.83%
IQNT	43	19.20	640	11%	142%	2.46%
WTW	44	26.71	1,516	9%	459%	0.00%
COH	45	37.12	10,260	12%	106%	3.66%
GCA	46	7.09	473	10%	231%	0.00%
NUS	47	46.01	2,796	18%	73%	3.05%
IDCC	48	54.36	2,154	9%	479%	1.10%
WILN	49	3.09	371	9%	1353%	5.51%
VIAB	50	76.91	32,794	9%	326%	1.68%
ANIK	51	39.04	603	12%	96%	0.00%
VIA	52	76.94	32,807	9%	326%	1.68%
CSCO	53	28.35	146,173	9%	335%	2.61%
SFUN	54	7.47	3,488	10%	151%	2.79%
BKE	55	52.38	2,518	11%	100%	3.99%
ONE	56	4.37	208	13%	80%	0.00%
CCUR	57	7.10	65	13%	79%	6.88%
EBIX	58	17.01	651	9%	190%	1.77%
GORO	59	3.18	172	17%	66%	3.92%
WSTG	60	17.81	84	13%	76%	3.93%
CA	61	31.21	13,764	9%	438%	3.19%
IILG	62	20.90	1,206	9%	216%	2.11%
STRA	63	74.27	792	11%	99%	0.00%
ITRN	64	22.09	463	11%	99%	4.43%
AVID	65	14.38	564	9%	157%	0.00%
PBI	66	25.09	5,118	9%	149%	2.98%
FLR	67	60.53	9,652	12%	76%	1.39%
GIB	68	38.71	12,369	9%	290%	0.00%
HRB	69	33.64	9,255	9%	254%	2.37%
VGR	70	21.59	2,231	9%	254%	7.22%
LCI	71	42.13	1,558	11%	86%	0.00%
BBX	72	16.29	261	32%	54%	0.00%
TDC	73	44.97	7,065	8%	352%	0.00%
AFOP	74	14.95	286	10%	104%	1.03%
LBMH	75	2.90	157	9%	255%	4.47%
BRCD	76	11.86	5,238	10%	106%	0.88%
SMT	77	1.32	167	22%	53%	0.00%
MYGN	78	36.65	2,789	9%	179%	0.00%
KFY	79	29.48	1,466	10%	114%	0.00%
NVMI	80	10.00	278	12%	68%	0.00%
SLI	81	38.68	163	15%	57%	0.00%
REX	82	63.57	519	26%	50%	0.00%
HPQ	83	40.70	77,167	11%	80%	1.54%
PENN	84	13.63	1,213	17%	54%	0.00%
LO	85	63.79	22,944	8%	652%	3.87%
UEPS	86	11.71	549	19%	51%	0.00%
IBM	87	162.34	161,967	10%	90%	2.63%
MAN	88	69.08	5,602	13%	57%	1.41%
BRLI	89	31.73	884	9%	126%	0.00%
TSRA	90	36.84	1,963	8%	2780%	2.53%
NOC	91	151.55	31,704	9%	113%	1.79%
USNA	92	103.72	1,376	9%	170%	0.00%
STV	93	3.05	190	15%	51%	16.29%
LXK	94	42.29	2,677	15%	52%	3.28%
CRWN	95	3.60	1,295	9%	101%	0.00%
CIMT	96	8.82	95	8%	627%	0.00%
UBNT	97	31.12	2,798	8%	338%	0.54%
STRZA	98	29.90	3,322	9%	97%	0.00%
RTN	99	110.08	34,279	9%	145%	2.14%
APEI	100	36.51	634	11%	64%	0.00%
PPC	101	34.07	8,842	12%	58%	0.00%
K	102	67.01	24,124	10%	79%	2.83%
PEIX	103	11.13	271	36%	45%	0.00%
XLS	104	17.78	3,435	12%	57%	2.20%
LEE	105	3.74	202	11%	68%	0.00%
MGIC	106	6.38	284	10%	86%	3.33%
SAFM	107	85.65	1,923	21%	46%	1.56%
BWC	108	30.32	3,258	14%	51%	1.32%
SHOO	109	31.60	1,998	10%	71%	0.00%
PM	110	83.34	130,010	8%	161%	4.67%
ETM	111	12.48	480	9%	96%	0.00%
MSFT	112	47.88	399,846	8%	213%	2.39%
GILD	113	93.79	153,490	8%	378%	0.00%
BAH	114	27.09	4,074	8%	169%	8.97%
HGT	115	7.74	310	14%	48%	13.24%
CTG	116	9.60	155	17%	46%	2.52%
EGL	117	42.92	775	9%	83%	0.00%
TUP	118	63.68	3,248	10%	74%	4.32%
DNB	119	122.54	4,473	7%	1260%	1.43%
PDFS	120	15.00	481	9%	99%	0.00%
CPSI	121	61.46	678	9%	110%	3.73%
GPS	122	41.42	18,101	11%	56%	2.07%
SYNT	123	45.74	3,841	8%	115%	0.00%
ORCL	124	46.10	207,681	8%	474%	1.04%
CSIQ	125	23.44	1,412	18%	43%	0.00%
HRS	126	73.78	7,806	10%	72%	2.42%
EDGW	127	7.77	101	10%	74%	0.00%
MANT	128	30.56	1,140	10%	72%	2.75%
SWHC	129	9.91	542	17%	44%	0.00%
OMC	130	77.46	19,551	8%	254%	2.46%
PLUS	131	72.20	530	13%	48%	0.00%
CLCT	132	21.67	184	7%	555%	6.07%
EXLS	133	28.68	966	9%	92%	0.00%
GCI	134	31.76	7,371	10%	61%	2.53%
NOK	135	8.17	32,833	8%	250%	6.32%
EGY	136	4.80	278	42%	40%	0.00%
NTI	137	22.24	2,058	13%	48%	12.12%
NTES	138	101.60	13,332	7%	447%	2.45%
CO	139	4.42	323	29%	40%	0.00%
PNTR	140	7.95	65	10%	62%	0.00%
APSA	141	22.00	693	14%	44%	6.48%
FENG	142	8.68	671	10%	64%	0.00%
ALDW	143	12.61	788	17%	41%	10.87%
NATR	144	14.72	262	13%	46%	13.47%
BBBY	145	76.58	14,665	11%	56%	0.00%
EME	146	44.56	3,004	9%	72%	0.72%
CHE	147	106.82	1,883	8%	158%	0.79%
AVP	148	9.26	4,024	13%	46%	2.60%
MBT	149	8.18	8,135	21%	39%	3.85%
NCIT	150	10.43	144	11%	49%	0.00%
QCOM	151	75.62	128,630	7%	335%	2.16%
THO	152	55.72	2,977	9%	67%	1.79%
OUTR	153	72.68	1,392	10%	55%	0.00%
KRFT	154	63.93	38,230	9%	83%	3.36%
PLOW	155	22.14	492	11%	50%	4.02%
EMR	156	62.78	43,921	9%	74%	2.81%
SYMC	157	26.54	18,472	8%	129%	2.26%
DOX	158	47.16	7,530	8%	143%	0.98%
LYB	159	80.98	41,462	13%	44%	3.32%
AAPL	160	113.99	680,758	7%	255%	1.65%
MRVL	161	14.37	7,471	9%	84%	1.67%
DOV	162	73.83	12,429	9%	67%	2.09%
CACI	163	88.07	2,123	8%	90%	0.00%
ACN	164	91.26	62,270	7%	562%	2.14%
IPCM	165	46.00	812	8%	146%	0.00%
FL	166	55.46	8,081	11%	50%	1.55%
GD	167	141.39	47,815	8%	114%	1.71%
MTRX	168	22.06	599	11%	46%	0.00%
NVDA	169	20.59	11,493	8%	96%	1.65%
NCR	170	29.73	5,093	9%	62%	0.00%
CPLA	171	75.25	941	8%	168%	1.90%
SAP	172	71.70	85,897	7%	270%	1.93%
RAI	173	65.71	35,018	7%	246%	4.09%
NOV	174	66.70	28,748	13%	41%	2.44%
CR	175	59.17	3,544	10%	58%	2.14%
CSGS	176	25.50	867	9%	62%	2.44%
CBS	177	55.98	30,285	8%	84%	0.97%
TARO	178	145.01	6,211	8%	97%	0.00%
MD	179	66.69	6,679	7%	301%	0.00%
LOGI	180	13.99	2,323	8%	99%	1.61%
ENG	181	1.85	51	13%	40%	0.00%
UCTT	182	9.38	281	13%	40%	0.00%
KORS	183	75.21	15,601	8%	92%	0.00%
VOC	184	5.42	92	37%	33%	33.04%
LEA	185	98.51	8,019	11%	44%	0.81%
ENSG	186	45.72	1,060	9%	61%	0.39%
MLHR	187	29.62	1,778	9%	64%	1.92%
RMCF	188	13.21	85	9%	68%	3.34%
UG	189	19.55	90	7%	160%	4.05%
TEO	190	20.27	3,929	15%	37%	5.63%
ERIC	191	12.33	40,319	10%	53%	3.76%
KLIC	192	14.53	1,132	15%	36%	0.00%
OSK	193	48.65	4,072	11%	43%	1.28%
MHFI	194	89.92	24,764	7%	841%	1.32%
CBD	195	36.47	6,045	19%	33%	1.20%
ATVI	196	20.42	14,662	7%	575%	0.98%
NSU	197	3.81	766	40%	31%	2.83%
JEC	198	44.56	5,892	10%	47%	0.00%
CSC	199	64.15	9,340	11%	43%	1.03%
BBY	200	39.14	13,856	10%	47%	1.85%

Here is the Cross Reference List.  After a couple of runs where I had a few mis-matches, this one looks actually better than the official list! I think #73 (TDC) is the highest, a "50" would be perfect. So that is really  good.  Not sure why MSB is nowhere to be found.

Ticker	Mkt Cap	Date	My Ranking	Price	EY	ROIC
ADMS	288.68	26-Dec	2	17.01	24%	8262%
ANIK	577.79	26-Dec	51	39.04	12%	96%
APOL	3,695.96	26-Dec	39	33.94	14%	104%
AGX	497.91	26-Dec	8	34.27	16%	990%
AVID	563.90	26-Dec	65	14.38	9%	157%
AWRE	102.17	26-Dec	36	4.48	13%	120%
BCOR	575.78	26-Dec	17	14.03	13%	350%
BKE	2,533.88	26-Dec	55	52.38	11%	100%
CA	13,742.85	26-Dec	61	31.21	9%	438%
CSCO	########	26-Dec	53	28.35	9%	335%
COH	10,230.27	26-Dec	45	37.12	12%	106%
CCUR	64.30	26-Dec	57	7.10	13%	79%
DLX	3,128.71	26-Dec	42	62.99	9%	367%
DEPO	920.96	26-Dec	11	15.69	14%	1234%
EBIX	631.94	26-Dec	58	17.01	9%	190%
FLR	9,474.64	26-Dec	67	60.53	12%	76%
GME	3,677.95	26-Dec	28	33.65	15%	127%
GORO	172.29	26-Dec	59	3.18	17%	66%
ONE	208.17	26-Dec	56	4.37	13%	80%
IQNT	635.87	26-Dec	43	19.20	11%	142%
IDCC	2,091.45	26-Dec	48	54.36	9%	479%
IILG	1,193.31	26-Dec	62	20.90	9%	216%
ITRN	463.18	26-Dec	64	22.09	11%	99%
KING	5,142.83	26-Dec	5	15.99	19%	2194%
LCI	1,502.10	26-Dec	71	42.13	11%	86%
LBMH	154.18	26-Dec	75	2.90	9%	255%
LFVN	135.09	26-Dec	20	1.34	14%	212%
LQDT	245.35	26-Dec	23	8.27	19%	122%
MSB	238.78	26-Dec	#N/A	#N/A	#N/A	#N/A
MNDO	73.84	26-Dec	35	3.91	10%	930%
NHTC	144.70	26-Dec	10	11.30	13%	4352%
NSR	1,789.40	26-Dec	37	27.75	12%	129%
NUS	2,728.39	26-Dec	47	46.01	18%	73%
PTIE	93.34	26-Dec	1	2.04	44%	32807%
PDLI	1,311.79	26-Dec	3	7.86	29%	2143%
PFMT	341.82	26-Dec	34	6.93	12%	165%
PETS	290.44	26-Dec	38	14.33	12%	135%
PBI	5,042.81	26-Dec	66	25.09	9%	149%
RPXC	785.92	26-Dec	25	13.96	10%	1378%
SPOK	384.66	26-Dec	26	17.74	13%	190%
RGR	677.85	26-Dec	41	34.91	18%	78%
TTWO	3,330.86	26-Dec	4	28.99	26%	809%
TDC	6,893.90	26-Dec	73	44.97	8%	352%
TZOO	195.03	26-Dec	29	13.24	12%	194%
UIS	1,479.34	26-Dec	27	29.63	16%	124%
VEC	301.46	26-Dec	14	28.71	14%	393%
VIAB	31,856.12	26-Dec	50	76.91	9%	326%
WSTG	86.95	26-Dec	60	17.81	13%	76%
WTW	1,513.98	26-Dec	44	26.71	9%	459%
WILN	371.43	26-Dec	49	3.09	9%	1353%