Friday, February 20, 2015

MFI Top 200 List - February 20th, 2015

Top 200 List

I last created a top 200 list on 1/24. It does take some time, I am going to be trying three lists this time: (1) a traditional MFI list, (2) a list showing top 200 based just on earnings yield and (3) a top 200 list based just on ROIC.  As I mentioned a couple months ago,  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
ACHI 1           5.96            590 40% 1463% 0.00%
PDLI 2           7.33        1,223 30% 2143% 8.16%
ADMS 3         17.40            292 23% 8262% 0.00%
PERI 4           3.29            228 34% 570% 0.00%
CALL 5           7.67            137 23% 639% 0.00%
AGX 6         33.12            490 17% 990% 2.17%
GAME 7           5.60        1,523 16% 1001% 0.00%
MTEX 8         23.34              63 29% 303% 0.00%
KING 9         15.91        5,126 18% 380% 2.85%
KZ 10           5.25            245 23% 263% 16.92%
HLF 11         33.87        2,920 19% 219% 0.90%
CTCM 12           4.09            639 46% 167% 17.37%
OKSKF 13         13.44            644 12% 2369% 0.20%
JOE 14         17.41        1,607 30% 157% 0.00%
NHTC 15         13.10            167 11% 4352% 0.23%
NHTC 16         13.10            167 11% 4352% 0.23%
LFVN 17           0.96              97 17% 187% 0.00%
VEC 18         31.90            341 13% 393% 0.00%
RPXC 19         14.13            777 11% 1525% 0.00%
MNDO 20           3.49              66 11% 930% 6.88%
ANTM 21      142.65      40,085 12% 260% 1.24%
PSDV 22           4.58            135 10% 3938% 0.00%
ASPS 23         23.81            563 21% 112% 0.00%
ENTA 24         33.65            649 17% 118% 0.00%
PFMT 25           6.00            294 13% 165% 0.00%
CRT 26         20.63            124 13% 167% 12.43%
TNH 27      149.42        2,764 14% 143% 7.51%
TZOO 28           9.65            142 13% 149% 0.00%
NSR 29         26.55        1,521 14% 144% 0.00%
WTW 30         18.68        1,060 11% 459% 0.00%
NEWT 31         15.90            122 11% 232% 0.00%
DEPO 32         19.70        1,199 10% 1234% 0.00%
PNLYY 33           4.05        1,784 21% 97% 0.00%
GME 34         37.53        4,237 14% 127% 3.52%
ATAI 35           4.38            100 18% 99% 9.34%
SPOK 36         18.83            417 12% 190% 2.62%
LQDT 37           9.83            294 15% 110% 0.00%
NTIP 38           2.33              58 10% 476% 0.00%
GILD 39      102.73    164,060 10% 504% 0.00%
IRS 40         16.59            942 10% 527% 0.71%
HUM 41      153.28      23,540 12% 166% 0.71%
SGU 42           7.41            425 17% 93% 4.69%
IDCC 43         50.32        1,994 10% 479% 1.42%
CJREF 44         17.31        1,488 11% 185% 5.66%
WSTG 45         17.13              81 14% 98% 4.00%
CBI 46         41.67        4,551 13% 110% 0.67%
TSRA 47         39.47        2,115 9% 1365% 2.31%
IQNT 48         18.19            607 12% 142% 2.55%
LUCRF 49           1.65            628 29% 74% 4.28%
BCOR 50         13.40            547 10% 211% 0.00%
PETS 51         15.39            310 11% 141% 4.39%
STRA 52         62.14            667 13% 99% 0.00%
HNT 53         55.95        4,447 9% 379% 0.00%
GCA 54           7.21            481 10% 231% 0.00%
VIAB 55         69.31      28,838 10% 219% 1.89%
ONE 56           3.54            169 15% 80% 0.00%
VIA 57         69.56      28,944 10% 219% 1.89%
PPC 58         27.43        7,119 18% 69% 20.38%
UIS 59         23.23        1,160 13% 84% 0.00%
RGR 60         43.15            860 15% 78% 3.73%
BKE 61         49.51        2,380 12% 100% 7.38%
WILN 62           2.67            322 9% 1168% 6.04%
CSCO 63         29.31    151,240 9% 348% 2.58%
APOL 64         27.01        2,954 14% 80% 0.00%
PBI 65         22.75        4,621 10% 147% 3.30%
FLR 66         59.44        9,285 13% 81% 1.42%
CLCT 67         23.51            200 9% 707% 5.59%
SMT 68           1.25            158 26% 62% 0.00%
TPUB 69         19.43            494 15% 70% 0.90%
SJT 70         15.76            735 8% 1453% 8.05%
FUJHY 71         67.20      26,221 14% 71% 1.40%
GORO 72           3.41            185 16% 66% 3.48%
CPLA 73         65.40            818 9% 179% 2.17%
SFUN 74           7.37        3,360 10% 142% 2.74%
CTP 75           7.30              57 13% 71% 0.00%
USNA 76      101.63        1,313 9% 163% 0.00%
MSFT 77         43.50    360,920 9% 207% 2.71%
RTN 78      108.07      33,469 9% 166% 2.26%
AVID 79         14.52            569 9% 157% 0.00%
COH 80         40.69      11,251 10% 116% 3.41%
BBX 81         15.17            243 35% 54% 0.00%
TMICY 82         31.00        4,159 8% 692% 3.65%
ECYT 83           5.84            243 9% 247% 0.00%
CA 84         32.52      14,341 8% 460% 3.07%
GIB 85         41.42      13,258 8% 309% 0.00%
UEPS 86         13.46            620 19% 55% 0.00%
HPQ 87         38.38      72,768 11% 80% 1.64%
CRWN 88           3.28        1,180 10% 101% 0.00%
CCNMF 89           1.42              70 13% 67% 5.00%
ANIK 90         44.19            682 10% 96% 0.00%
REX 91         57.50            470 30% 50% 0.00%
CDPYF 92         22.38        2,492 8% 7565% 4.65%
PRISY 93           1.16            347 11% 85% 0.00%
HRB 94         35.00        9,629 8% 254% 2.29%
ITRN 95         23.00            482 10% 92% 4.30%
BREUF 96         11.19            106 8% 550% 9.66%
UBNT 97         30.09        2,700 8% 218% 0.58%
QCOM 98         70.98    119,672 8% 337% 2.28%
SLI 99         40.49            170 14% 57% 0.00%
APEI 100         34.48            598 12% 64% 0.00%
KFY 101         30.75        1,530 9% 114% 0.00%
NUS 102         55.09        3,330 12% 61% 2.46%
BRCD 103         12.58        5,556 9% 106% 0.83%
LEE 104           3.03            163 11% 67% 0.00%
MAN 105         79.04        6,307 12% 62% 1.25%
FENG 106           7.71            596 12% 64% 0.00%
KORS 107         69.59      14,311 9% 101% 0.00%
VGR 108         23.05        2,382 8% 254% 6.78%
UNH 109      110.03    107,059 8% 233% 1.28%
LO 110         67.85      24,406 8% 690% 3.58%
DHX 111           8.60            464 8% 291% 0.00%
TUP 112         72.50        3,669 9% 135% 3.74%
EDGW 113           7.25              94 11% 74% 0.00%
PEIX 114           9.99            243 40% 45% 0.00%
AVP 115           8.73        3,795 13% 54% 3.32%
SAFM 116         81.73        1,835 23% 46% 1.59%
CPSI 117         52.69            582 9% 108% 4.46%
KLIC 118         15.92        1,233 15% 49% 0.00%
MGLN 119         61.62        1,679 10% 77% 0.00%
BWC 120         30.36        3,262 14% 51% 1.32%
ORCL 121         44.11    198,716 8% 474% 1.09%
TDC 122         45.17        6,961 8% 302% 0.00%
CTG 123           8.43            136 20% 46% 2.93%
CSC 124         66.89        9,407 12% 60% 1.33%
LCI 125         63.28        2,346 9% 105% 0.00%
ETM 126         12.39            477 9% 96% 0.00%
TSO 127         90.53      11,570 11% 65% 1.26%
NCI 128         14.11            699 11% 66% 0.00%
STRZA 129         31.40        3,489 9% 97% 0.00%
HGT 130           7.74            310 14% 48% 13.77%
NVMI 131         11.17            307 9% 89% 0.00%
LYB 132         91.24      45,529 13% 51% 3.02%
OUTR 133         66.57        1,242 11% 57% 0.00%
IPCM 134         42.71            754 8% 146% 0.00%
RCII 135         29.31        1,562 8% 305% 3.12%
CSVI 136         40.50            572 8% 117% 1.90%
FLWS 137         10.36            695 11% 56% 0.00%
GD 138      139.51      46,847 8% 118% 1.79%
EMMS 139           2.11            100 9% 86% 0.00%
EMR 140         58.69      40,772 10% 73% 3.06%
TIVO 141         10.85        1,214 8% 511% 0.00%
EGY 142           5.44            315 35% 40% 0.00%
MPAA 143         24.03            452 8% 297% 0.00%
NTI 144         21.97        2,033 13% 48% 12.60%
CCUR 145           6.24              57 10% 61% 7.74%
STV 146           3.67            229 12% 51% 13.48%
NATR 147         14.01            250 14% 46% 14.30%
CHE 148      113.94        1,990 8% 162% 0.73%
EME 149         44.21        2,981 9% 72% 0.72%
CSIQ 150         28.39        1,710 15% 43% 0.00%
SNDK 151         82.41      19,349 8% 113% 1.01%
MGIC 152           6.88            306 9% 90% 3.14%
GHM 153         22.64            230 11% 53% 1.05%
FOSL 154         84.91        4,356 12% 49% 0.00%
SCLN 155           7.65            401 9% 87% 0.00%
OMC 156         77.90      19,467 8% 258% 2.46%
NOV 157         54.24      23,215 16% 41% 2.89%
EGL 158         47.25            854 9% 83% 0.00%
IILG 159         25.69        1,482 8% 216% 1.71%
CO 160           5.32            388 20% 40% 0.00%
LEA 161      108.23        8,756 11% 52% 0.74%
COSM 162           0.80            101 8% 120% 0.00%
SWHC 163         12.72            695 14% 44% 0.00%
MBT 164           9.94        9,885 19% 39% 3.15%
LOGI 165         14.77        2,457 8% 112% 3.31%
NCIT 166         11.97            162 11% 53% 0.00%
NVDA 167         22.18      12,342 8% 101% 1.54%
TRW 168      104.12      11,630 11% 51% 0.00%
MYGN 169         33.97        2,561 8% 157% 0.00%
ALDW 170         16.16        1,010 14% 41% 11.27%
SYMC 171         25.60      17,840 8% 126% 1.75%
DISCK 172         29.96      20,433 8% 184% 0.00%
ACN 173         90.27      61,594 7% 562% 2.18%
PNTR 174           8.34              68 10% 62% 0.00%
PLOW 175         22.14            492 11% 50% 3.81%
HRS 176         78.72        8,258 9% 69% 2.27%
PRGS 177         27.07        1,384 8% 150% 0.00%
BBBY 178         76.06      13,979 11% 50% 0.00%
NTAP 179         37.85      12,001 9% 78% 1.71%
FL 180         55.08        8,025 11% 50% 1.64%
CR 181         69.54        4,127 9% 69% 1.84%
NOC 182      170.13      34,741 8% 104% 1.62%
GRMN 183         50.72        9,756 8% 95% 3.73%
FRAN 184         15.18            643 10% 57% 0.00%
BAH 185         30.24        4,557 8% 150% 4.84%
DISCA 186         31.10      21,210 7% 184% 0.00%
IBA 187         50.35        2,518 20% 36% 0.00%
AFOP 188         17.22            322 8% 102% 0.90%
VOC 189           5.73              97 35% 33% 24.51%
GNTX 190         17.68        5,236 8% 107% 1.74%
DOX 191         51.53        8,147 8% 163% 1.21%
EVOL 192           8.74            104 8% 116% 4.82%
WINA 193         80.47            415 7% 258% 0.30%
GSB 194           3.39              71 7% 749% 1.47%
ATVI 195         23.32      16,997 7% 754% 0.85%
JEC 196         43.81        5,694 11% 47% 0.00%
THO 197         59.92        3,202 9% 67% 1.67%
SYNT 198         49.28        4,138 8% 115% 0.00%
CBD 199         32.08        5,317 21% 33% 1.36%
LMT 200      201.71      64,668 8% 113% 2.76%

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 #79 (AVID) is the highest, a "50" would be perfect. So that is really  good.  Not sure why MSB is nowhere to be found. ENZN had 0 working capital and errored out for me. I need to  think about that.


Ticker Mkt Cap Date My Ranking Price EY ROIC
ACHI 571 18-Feb 1          5.96 40% 1463%
ADMS 298 18-Feb 3       17.40 23% 8262%
APOL 2,937 18-Feb 64       27.01 14% 80%
AGX 481 18-Feb 6       33.12 17% 990%
AVID 570 18-Feb 79       14.52 9% 157%
BCOR 534 18-Feb 50       13.40 10% 211%
BKE 2,396 18-Feb 61       49.51 12% 100%
CPLA 806 18-Feb 73       65.40 9% 179%
CSCO 147,270 18-Feb 63       29.31 9% 348%
CTP 53 18-Feb 75          7.30 13% 71%
DEPO 1,165 18-Feb 32       19.70 10% 1234%
ENTA 630 18-Feb 24       33.65 17% 118%
ENZN 54 18-Feb #N/A #N/A #N/A #N/A
FLR 8,814 18-Feb 66       59.44 13% 81%
GME 4,099 18-Feb 34       37.53 14% 127%
GORO 187 18-Feb 72          3.41 16% 66%
ONE 166 18-Feb 56          3.54 15% 80%
IQNT 605 18-Feb 48       18.19 12% 142%
IDCC 1,961 18-Feb 43       50.32 10% 479%
KING 5,151 18-Feb 9       15.91 18% 380%
LFVN 96 18-Feb 17          0.96 17% 187%
LQDT 294 18-Feb 37          9.83 15% 110%
MTEX 64 18-Feb 8       23.34 29% 303%
MSB 232 18-Feb #N/A #N/A #N/A #N/A
MSFT 356,908 18-Feb 77       43.50 9% 207%
MNDO 66 18-Feb 20          3.49 11% 930%
NHTC 166 18-Feb 15       13.10 11% 4352%
NSR 1,455 18-Feb 29       26.55 14% 144%
PDLI 1,228 18-Feb 2          7.33 30% 2143%
PFMT 296 18-Feb 25          6.00 13% 165%
PETS 312 18-Feb 51       15.39 11% 141%
PPC 7,185 18-Feb 58       27.43 18% 69%
PBI 4,585 18-Feb 65       22.75 10% 147%
PSDV 134 18-Feb 22          4.58 10% 3938%
RTN 33,185 18-Feb 78     108.07 9% 166%
RPXC 803 18-Feb 19       14.13 11% 1525%
SMT 153 18-Feb 68          1.25 26% 62%
SPOK 411 18-Feb 36       18.83 12% 190%
STRA 680 18-Feb 52       62.14 13% 99%
RGR 845 18-Feb 60       43.15 15% 78%
TSRA 2,097 18-Feb 47       39.47 9% 1365%
TZOO 143 18-Feb 28          9.65 13% 149%
TPUB 494 18-Feb 69       19.43 15% 70%
UIS 1,161 18-Feb 59       23.23 13% 84%
USNA 1,255 18-Feb 76     101.63 9% 163%
VEC 337 18-Feb 18       31.90 13% 393%
VIAB 28,291 18-Feb 55       69.31 10% 219%
WSTG 84 18-Feb 45       17.13 14% 98%
WTW 1,057 18-Feb 30       18.68 11% 459%
WILN 323 18-Feb 62          2.67 9% 1168%

No comments: