Thursday, April 02, 2015

Top 200 List - April 2nd, 2015

Top 200 List

I last created a top 200 list on 3/8. It does take some time,  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.71            565 42% 1463% 0.00%
PDLI 2           7.17        1,218 33% 843% 8.50%
PERI 3           3.54            246 31% 570% 0.00%
DEPO 4         22.58        1,793 17% 3136% 0.00%
MNDO 5           3.20              61 16% 1207% 9.00%
CALL 6           6.79            121 22% 450% 0.00%
MTEX 7         18.55              51 38% 311% 0.00%
AGX 8         36.28            537 15% 990% 0.00%
PSDV 9           3.85            113 13% 3938% 0.00%
KING 10         16.32        5,258 17% 380% 0.00%
GAME 11           6.45        1,755 14% 1001% 0.00%
KZ 12           5.52            257 20% 263% 0.00%
VEC 13         25.66            274 14% 502% 0.00%
CTCM 14           4.00            625 48% 167% 17.80%
LFVN 15           0.78              79 21% 187% 0.00%
IDCC 16         50.71        1,921 11% 1370% 0.00%
JOE 17         19.02        1,755 27% 152% 0.00%
HLF 18         42.47        3,631 16% 191% 0.00%
SJT 19         12.22            570 11% 1453% 2.60%
WTW 20           6.91            392 12% 417% 0.00%
HRB 21         32.32        8,894 12% 342% 2.50%
ASPS 22         13.26            269 24% 115% 0.00%
NHTC 23         17.80            227 10% 4374% 0.50%
NHTC 24         17.80            227 10% 4374% 0.50%
RPXC 25         14.72            810 10% 1525% 0.00%
ENTA 26         31.29            603 19% 118% 0.00%
CJREF 27         14.79        1,272 13% 211% 0.00%
CRT 28         19.20            115 14% 167% 7.10%
GME 29         37.78        4,137 16% 139% 3.50%
NTIP 30           2.25              56 11% 476% 0.00%
ANTM 31      153.99      43,256 12% 260% 1.60%
NSR 32         25.21        1,445 14% 144% 0.00%
TZOO 33           9.53            140 14% 149% 0.00%
IQNT 34         16.64            562 14% 140% 3.80%
TNH 35      149.80        2,771 14% 143% 6.80%
LQDT 36           9.64            288 15% 110% 0.00%
WILN 37           2.43            293 10% 1168% 6.90%
SGU 38           7.41            425 17% 93% 5.00%
SFUN 39           6.08        2,772 12% 142% 6.70%
CBI 40         47.86        5,239 13% 117% 0.30%
STRA 41         55.00            590 15% 99% 0.00%
LUCRF 42           1.44            551 31% 71% 0.00%
GILD 43         97.95    156,426 10% 377% 0.00%
TAOM 44           2.62              94 52% 69% 0.00%
CSCO 45         27.25    140,584 10% 342% 0.00%
WSTG 46         17.75              84 14% 98% 3.80%
PFMT 47           3.39            167 13% 99% 0.00%
ONE 48           2.56            122 17% 77% 0.00%
FENG 49           5.66            422 18% 74% 0.00%
CLCT 50         22.51            192 9% 707% 6.20%
TSRA 51         40.70        2,181 9% 1365% #VALUE!
PPC 52         23.76        6,165 22% 69% 0.00%
CTP 53           4.58              36 19% 71% 0.00%
AET 54      106.87      37,896 9% 629% 0.90%
ANIK 55         41.05            627 12% 106% 0.00%
BCOR 56         13.92            568 10% 211% 0.00%
VIAB 57         67.89      28,249 10% 219% 1.90%
UIS 58         23.12        1,155 14% 84% 0.00%
VIA 59         68.20      28,378 10% 219% 1.90%
MSFT 60         40.39    335,116 10% 207% 0.00%
BKE 61         50.68        2,441 11% 111% 1.90%
PNLYY 62           4.50        1,988 15% 78% 0.00%
HPQ 63         31.36      58,361 14% 83% 2.20%
PETS 64         16.25            328 10% 141% 4.20%
FLR 65         56.77        8,867 14% 81% 1.50%
HUM 66      177.64      27,281 10% 166% 0.60%
PENN 67         15.56        1,226 20% 65% 0.00%
APOL 68         18.71        2,023 17% 67% 0.00%
SMT 69           1.20            151 27% 62% 0.00%
FUJHY 70         66.18      25,823 15% 71% 0.00%
IRS 71         19.77        1,122 9% 527% 1.20%
MOBI 72           3.83            107 10% 190% 0.00%
DLX 73         68.72        3,436 9% 400% 1.80%
SNDK 74         65.14      15,293 11% 113% 1.80%
ATAI 75           3.93              90 14% 69% 9.80%
CSIQ 76         33.81        2,036 18% 63% 0.00%
BREUF 77         11.10            105 9% 613% 0.00%
GORO 78           3.49            189 15% 66% 4.10%
CTG 79           7.41            119 27% 59% 3.20%
PBI 80         23.59        4,791 10% 147% 3.20%
UBNT 81         27.95        2,508 9% 218% 0.60%
ADMS 82         17.47            340 8% 1508% 0.00%
BRCD 83         11.82        5,191 10% 110% 1.20%
APEI 84         30.12            523 15% 64% 0.00%
CPLA 85         65.66            821 9% 179% 2.20%
HNT 86         60.21        4,785 9% 379% 0.00%
EGL 87         30.62            554 11% 84% 0.00%
CA 88         32.10      14,156 8% 460% 3.10%
KFY 89         33.01        1,641 9% 201% #VALUE!
RTN 90      107.59      33,321 9% 166% #VALUE!
QCOM 91         68.74    115,887 9% 337% 2.50%
KORS 92         64.08      13,178 10% 101% 0.00%
COH 93         41.62      11,508 10% 116% 3.30%
UEPS 94         13.50            622 19% 55% 0.00%
ITRN 95         22.49            472 10% 92% 5.80%
STRZA 96         34.64        3,686 9% 123% 0.00%
REX 97         61.25            488 30% 50% 0.00%
AVID 98         15.05            590 9% 157% 0.00%
PRISY 99           1.22            365 11% 85% 0.00%
GIB 100         42.48      13,597 8% 309% 0.00%
NCI 101         12.99            644 12% 67% 0.00%
LOGI 102         13.13        2,184 10% 112% 2.00%
NLNK 103         53.94        1,691 8% 1127% 0.00%
LO 104         67.39      24,240 8% 690% 4.00%
TDC 105         44.01        6,782 8% 303% 0.00%
SAFM 106         82.34        1,857 26% 49% 1.10%
ORCL 107         42.87    192,658 8% 446% 1.40%
NSU 108           3.43            688 83% 46% 4.60%
SLI 109         43.80            185 13% 57% 0.00%
PLOW 110         22.98            511 11% 67% 4.00%
BBX 111         18.59            301 23% 47% 0.00%
CDPYF 112         23.69        2,653 8% 7652% 0.00%
RWWI 113           2.08              86 8% 424% 0.00%
LEE 114           3.16            170 11% 67% 0.00%
AVP 115           7.95        3,454 14% 54% 0.00%
NATH 116         56.29            259 9% 159% 0.00%
POZN 117           7.69            256 8% 656% 0.00%
HGT 118           5.82            233 19% 48% 7.50%
KLIC 119         15.67        1,213 16% 49% 0.00%
USNA 120      113.19        1,462 8% 163% 0.00%
CSC 121         65.23        9,174 12% 60% 1.40%
BBY 122         37.21      13,254 13% 55% 2.40%
BIRDF 123           7.40            314 15% 50% 0.00%
EME 124         46.46        3,015 9% 90% 0.70%
DHX 125           8.86            478 8% 291% 0.00%
SYMC 126         23.51      16,386 9% 126% 2.50%
NCIT 127           9.86            134 14% 53% 0.00%
NEWT 128         17.29            153 7% 5521% 8.20%
MGIC 129           6.47            288 9% 90% 2.90%
STV 130           3.75            233 13% 53% 0.00%
VGR 131         22.00        2,266 8% 241% 7.20%
NUS 132         59.36        3,588 11% 61% #VALUE!
MED 133         29.89            364 10% 84% 0.00%
ETM 134         12.22            473 9% 90% 0.00%
GD 135      133.98      44,990 9% 118% 2.00%
CRWN 136           4.01        1,442 9% 90% 0.00%
MAN 137         85.40        6,815 11% 63% 1.20%
SPOK 138         20.74            458 8% 170% 2.60%
ALDW 139         18.82        1,176 15% 49% 14.90%
GPS 140         42.48      18,181 11% 60% 2.10%
AAPL 141      124.52    732,402 8% 291% 1.50%
EMR 142         56.10      38,973 10% 73% 0.00%
LYB 143         89.40      44,611 13% 52% 3.20%
PEIX 144         11.15            275 35% 41% 0.00%
NVDA 145         21.04      11,710 9% 100% 1.60%
IBM 146      159.58    158,846 10% 80% 2.70%
GRMN 147         47.07        9,054 9% 95% 3.90%
CPSI 148         54.56            603 9% 108% 4.80%
EMMS 149           1.98              94 9% 86% 0.00%
TMICY 150         32.99        4,564 7% 680% 0.00%
OUTR 151         67.12        1,252 11% 57% 1.80%
CR 152         62.90        3,733 10% 69% 2.10%
FL 153         62.52        9,022 10% 69% 1.60%
UNH 154      117.36    114,191 8% 233% #VALUE!
NTAP 155         35.27      11,184 9% 78% 1.90%
TUP 156         68.90        3,486 9% 82% 3.90%
PM 157         76.90    119,349 8% 144% 5.20%
TARO 158      141.72        6,070 9% 94% 0.00%
LCI 159         66.12        2,451 9% 105% 0.00%
DISCK 160         30.39      20,236 8% 184% 0.00%
NOC 161      160.55      32,784 9% 104% 1.70%
BSQR 162           4.69              56 8% 189% 0.00%
WNR 163         49.50        4,860 18% 41% 0.00%
STX 164         51.79      17,401 10% 66% 4.10%
EDGW 165           6.81              89 10% 63% 0.00%
CSVI 166         41.32            584 8% 117% 0.00%
NOV 167         50.79      21,738 18% 41% 3.70%
OMC 168         77.68      19,412 8% 258% 2.60%
PNTR 169           8.52              68 10% 68% 0.00%
CO 170           5.09            372 21% 40% 0.00%
DNB 171      129.03        4,684 7% 1620% 1.40%
FOSL 172         82.39        4,227 12% 48% 0.00%
CALM 173         39.11        1,895 13% 47% 3.60%
GLAXF 174         23.70      57,591 11% 55% 0.00%
NATR 175         13.01            250 13% 45% 3.00%
ARESF 176         11.81        1,690 7% 10130% 0.00%
RGR 177         49.48            954 10% 60% 1.40%
BAH 178         29.08        4,382 8% 150% 1.80%
NVMI 179         11.58            318 9% 89% 0.00%
CCUR 180           6.37              58 10% 60% 7.40%
TRW 181      104.98      11,726 11% 51% 0.00%
DISCA 182         31.49      20,972 8% 184% 0.00%
LBMH 183           3.47            186 8% 219% 3.70%
ATVI 184         22.72      16,559 7% 754% 1.00%
AWRE 185           4.39            100 9% 82% 0.00%
NTI 186         25.46        2,353 11% 51% #VALUE!
EMC 187         25.59      52,152 8% 114% 1.70%
CCNMF 188           1.76              87 9% 67% 0.00%
MAG 189         37.18            131 9% 66% 0.00%
MGLN 190         71.00        1,873 9% 79% 0.00%
DOV 191         69.42      11,556 9% 70% 2.30%
MYGN 192         34.77        2,622 8% 157% 0.00%
LEA 193      112.05        9,065 11% 52% 0.90%
CHE 194      119.66        2,090 8% 162% 0.70%
HRS 195         78.59        8,244 9% 69% #VALUE!
FLWS 196         11.76            789 10% 56% 0.00%
ACN 197         93.87      63,753 7% 583% 2.20%
NTES 198      107.06      14,073 7% 369% 1.50%
IBA 199         50.91        2,546 19% 36% #VALUE!
BBBY 200         76.33      14,029 11% 50% 0.00%

Here is the Cross Reference List with the official top 50:

Ticker Mkt Cap Date My Ranking Price EY ROIC
ACHI 548 1-Apr 1          5.71 42% 1463%
ADMS 307 1-Apr 82       17.47 8% 1508%
ANIK 610 1-Apr 55       41.05 12% 106%
AGX 527 1-Apr 8       36.28 15% 990%
AVID 591 1-Apr 98       15.05 9% 157%
HRB 8,896 1-Apr 21       32.32 12% 342%
BCOR 569 1-Apr 56       13.92 10% 211%
BRCD 4,978 1-Apr 83       11.82 10% 110%
BKE 2,452 1-Apr 61       50.68 11% 111%
CPLA 804 1-Apr 85       65.66 9% 179%
CSCO 139,166 1-Apr 45       27.25 10% 342%
DEPO 1,339 1-Apr 4       22.58 17% 3136%
ENTA 582 1-Apr 26       31.29 19% 118%
EGL 539 1-Apr 87       30.62 11% 84%
FLR 8,438 1-Apr 65       56.77 14% 81%
GME 4,069 1-Apr 29       37.78 16% 139%
GILD 146,482 1-Apr 43       97.95 10% 377%
GORO 189 1-Apr 78          3.49 15% 66%
HPQ 57,010 1-Apr 63       31.36 14% 83%
ONE 122 1-Apr 48          2.56 17% 77%
IQNT 557 1-Apr 34       16.64 14% 140%
IDCC 1,872 1-Apr 16       50.71 11% 1370%
KING 5,254 1-Apr 10       16.32 17% 380%
LFVN 77 1-Apr 15          0.78 21% 187%
LQDT 289 1-Apr 36          9.64 15% 110%
MSB 159 1-Apr #N/A #N/A #N/A #N/A
MSFT 334,637 1-Apr 60       40.39 10% 207%
MNDO 60 1-Apr 5          3.20 16% 1207%
NHTC 228 1-Apr 23       17.80 10% 4374%
NSR 1,389 1-Apr 32       25.21 14% 144%
NLNK 1,509 1-Apr 103       53.94 8% 1127%
PDLI 1,156 1-Apr 2          7.17 33% 843%
PENN 1,232 1-Apr 67       15.56 20% 65%
PFMT 167 1-Apr 47          3.39 13% 99%
PETS 329 1-Apr 64       16.25 10% 141%
PPC 6,153 1-Apr 52       23.76 22% 69%
PBI 4,742 1-Apr 80       23.59 10% 147%
PSDV 113 1-Apr 9          3.85 13% 3938%
RPXC 829 1-Apr 25       14.72 10% 1525%
SNDK 15,307 1-Apr 74       65.14 11% 113%
STRA 600 1-Apr 41       55.00 15% 99%
TSRA 2,151 1-Apr 51       40.70 9% 1365%
TZOO 140 1-Apr 33          9.53 14% 149%
UBNT 2,455 1-Apr 81       27.95 9% 218%
UIS 1,149 1-Apr 58       23.12 14% 84%
VEC 269 1-Apr 13       25.66 14% 502%
VIAB 27,415 1-Apr 57       67.89 10% 219%
WSTG 87 1-Apr 46       17.75 14% 98%
WTW 392 1-Apr 20          6.91 12% 417%
WILN 292 1-Apr 37          2.43 10% 1168%

It is time for me to start thinking about my next tranche (due May 6th). Stay tuned.

No comments: