Saturday, January 24, 2015

Top 200 List - January 24th, 2015

Top 200 List

Always a good idea to create a top 200 list just before I buy a new tranche. Sometimes there may be a stock that isn't on the official list.

I last created a top 200 list on 12/28. It does take some time, I do like to create a list concurrent with my tracking portfolio or a new tranche.  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
PTIE 1           1.95              88 48% 32807% 0.00%
ADMS 2         17.01            286 24% 8262% 0.00%
PDLI 3           7.57        1,263 30% 2143% 7.91%
KING 4         13.40        4,255 23% 2194% 3.43%
TTWO 5         29.86        2,399 25% 809% 0.00%
PERI 6           3.28            228 34% 570% 0.00%
CALL 7           7.28            130 25% 639% 0.00%
AGX 8         31.65            468 18% 990% 2.20%
GAME 9           5.69        1,548 16% 1001% 0.00%
MTEX 10         20.76              56 34% 303% 0.00%
KZ 11           5.47            255 20% 263% 15.66%
HLF 12         30.54        2,633 21% 219% 0.96%
CTCM 13           3.94            615 49% 167% 16.51%
VEC 14         27.45            294 14% 393% 0.00%
JOE 15         16.56        1,528 32% 157% 0.00%
NHTC 16         12.75            163 12% 4352% 0.24%
RPXC 17         12.77            703 12% 1378% 0.00%
BCOR 18         13.95            572 13% 350% 0.00%
LFVN 19           1.22            127 15% 212% 0.00%
TNH 20      122.10        2,259 18% 159% 7.73%
LQDT 21           7.49            222 21% 122% 0.00%
UIS 22         27.14        1,368 17% 124% 0.00%
SGU 23           6.25            359 18% 119% 5.49%
TZOO 24           9.17            135 14% 149% 0.00%
DEPO 25         18.72        1,139 11% 1234% 0.00%
ASPS 26         21.29            503 22% 112% 0.00%
CRT 27         19.95            120 14% 167% 13.41%
NEWT 28         14.21            109 12% 232% 0.00%
PFMT 29           5.90            289 14% 165% 0.00%
MNDO 30           3.67              70 10% 930% 6.59%
WTW 31         17.31            983 11% 459% 0.00%
SPOK 32         18.12            401 12% 190% 2.73%
ECYT 33           5.13            213 12% 247% 0.00%
PNLYY 34           3.51        1,546 23% 97% 0.00%
AET 35         94.48      33,710 10% 639% 0.96%
GME 36         37.40        4,222 14% 127% 3.56%
AVG 37         19.97        1,042 10% 692% 0.00%
ATAI 38           4.85            111 15% 99% 8.46%
NTIP 39           2.35              59 10% 476% 0.00%
NSR 40         27.92        1,596 12% 129% 0.00%
IQNT 41         17.92            598 12% 142% 2.51%
AWRE 42           4.59            105 12% 120% 38.38%
CBI 43         38.79        4,236 13% 110% 0.72%
SJT 44         14.28            666 9% 1453% 8.39%
VIAB 45         67.80      28,910 10% 326% 1.88%
GCA 46           6.71            448 10% 231% 0.00%
VIA 47         68.18      29,072 10% 326% 1.87%
HNT 48         55.95        4,489 10% 355% 0.00%
NUS 49         42.52        2,584 19% 73% 3.06%
SFUN 50           6.84        3,194 11% 151% 2.81%
RGR 51         38.71            772 17% 78% 4.11%
IDCC 52         52.23        2,069 9% 479% 1.33%
COH 53         37.62      10,398 12% 106% 3.53%
CJREF 54         18.41        1,583 10% 192% 5.34%
APOL 55         25.99        2,843 14% 80% 0.00%
ONE 56           3.79            181 14% 80% 0.00%
PETS 57         16.06            324 11% 141% 4.23%
STRA 58         67.98            725 12% 99% 0.00%
BKE 59         50.39        2,423 12% 100% 7.32%
CCUR 60           6.96              63 13% 79% 6.93%
FLR 61         54.31        8,660 14% 76% 1.53%
WSTG 62         17.08              81 14% 76% 3.97%
ANIK 63         39.60            611 12% 96% 0.00%
CSCO 64         28.21    145,451 9% 335% 2.67%
HUM 65      151.47      23,664 10% 147% 0.72%
ITRN 66         21.03            441 11% 99% 4.56%
GORO 67           3.49            189 15% 66% 3.25%
TPUB 68         21.08            536 14% 70% 0.86%
WILN 69           3.13            376 9% 1353% 5.11%
WCG 70         77.85        3,440 10% 162% 0.00%
AVID 71         13.91            545 10% 157% 0.00%
CA 72         31.01      13,675 9% 460% 3.27%
BBX 73         14.53            233 37% 54% 0.00%
CTP 74           7.55              59 13% 71% 0.00%
PBI 75         24.29        4,954 10% 149% 3.08%
TDC 76         43.35        6,810 9% 352% 0.00%
SKYEY 77           4.08            268 14% 66% 0.00%
IRS 78         15.69            891 9% 418% 0.76%
MGIC 79           5.81            258 11% 86% 3.73%
AFOP 80         14.63            279 10% 104% 1.01%
UBNT 81         28.72        2,582 9% 338% 0.58%
SMT 82           1.53            194 20% 53% 0.00%
BRCD 83         11.58        5,114 10% 106% 0.91%
REX 84         55.48            453 32% 50% 0.00%
GIB 85         38.90      12,430 9% 290% 0.00%
CRWN 86           3.30        1,187 10% 101% 0.00%
UEPS 87         11.80            553 19% 51% 0.00%
MYGN 88         36.20        2,754 9% 179% 0.00%
PENN 89         15.32        1,364 16% 54% 0.00%
USNA 90         98.84        1,311 9% 170% 0.00%
KFY 91         29.54        1,469 10% 114% 0.00%
HRB 92         34.23        9,417 9% 254% 2.35%
HPQ 93         40.08      75,992 11% 80% 1.56%
LXK 94         38.52        2,438 16% 52% 3.47%
APEI 95         34.41            597 12% 64% 0.00%
STV 96           2.99            187 15% 51% 16.72%
MAN 97         67.67        5,488 14% 57% 1.43%
SLI 98         42.02            177 13% 57% 0.00%
PEIX 99           8.98            218 45% 45% 0.00%
BWC 100         27.72        2,978 15% 51% 1.44%
EDGW 101           7.12              92 11% 74% 0.00%
RTN 102      106.80      33,258 9% 145% 2.25%
IILG 103         22.90        1,321 9% 216% 1.89%
SAFM 104         83.40        1,872 22% 46% 1.57%
LEE 105           3.10            167 11% 68% 0.00%
VGR 106         22.65        2,340 8% 254% 6.85%
LCI 107         45.68        1,689 10% 86% 0.00%
STRZA 108         28.91        3,212 10% 97% 0.00%
CTG 109           8.04            130 21% 46% 2.96%
XLS 110         17.84        3,447 12% 57% 2.21%
MGLN 111         61.22        1,668 10% 77% 0.00%
PPC 112         35.45        9,200 12% 58% 0.00%
CIMT 113           8.80              95 8% 627% 0.00%
ETM 114         11.90            458 9% 96% 0.00%
ORCL 115         44.19    199,076 8% 474% 1.09%
K 116         68.68      24,725 10% 79% 2.72%
TSRA 117         37.26        1,985 8% 2780% 2.45%
TUP 118         61.38        3,130 10% 74% 4.34%
DNB 119      118.32        4,319 8% 1260% 1.49%
CSIQ 120         19.30        1,163 21% 43% 0.00%
HGT 121           7.76            310 14% 48% 13.39%
CPSI 122         59.27            654 9% 110% 3.84%
LO 123         66.02      23,746 8% 652% 3.72%
HRS 124         69.70        7,374 10% 72% 2.58%
NOC 125      156.19      32,675 9% 113% 1.73%
IPCM 126         41.77            737 8% 146% 0.00%
NVMI 127         10.84            301 10% 68% 0.00%
MSFT 128         47.18    394,000 8% 213% 2.44%
EME 129         41.68        2,810 10% 72% 0.77%
PLUS 130         68.81            505 14% 48% 0.00%
EGL 131         42.69            771 9% 83% 0.00%
OMC 132         74.36      18,768 8% 254% 2.52%
QCOM 133         72.18    122,770 8% 335% 2.24%
NOK 134           7.90      31,748 8% 250% 6.49%
PM 135         82.82    129,199 8% 161% 4.56%
NTI 136         20.83        1,927 13% 48% 13.27%
EGY 137           5.70            330 33% 40% 0.00%
SNDK 138         79.68      18,708 9% 120% 1.33%
AVP 139           7.98        3,468 14% 46% 2.77%
CPLA 140         69.84            873 8% 168% 2.04%
EMMS 141           2.04              97 9% 86% 0.00%
CO 142           4.50            329 28% 40% 0.00%
OUTR 143         63.88        1,223 11% 55% 0.00%
EMR 144         58.12      40,661 10% 74% 2.94%
SCLN 145           7.41            388 9% 87% 0.00%
SYNT 146         45.17        3,793 9% 115% 0.00%
TIVO 147         10.82        1,210 8% 511% 0.00%
XLNX 148         39.28      10,755 8% 133% 2.13%
FENG 149           8.50            657 10% 64% 0.00%
MTRX 150         19.22            522 13% 46% 0.00%
ALDW 151         13.31            832 17% 41% 10.29%
PLOW 152         20.06            446 12% 50% 4.27%
PRGS 153         25.75        1,316 8% 150% 0.00%
GCI 154         31.77        7,374 10% 61% 2.50%
SWHC 155         12.37            676 14% 44% 0.00%
NTCT 156         34.92        1,450 8% 428% 0.00%
MBT 157           8.62        8,573 21% 39% 3.60%
NATR 158         14.52            259 13% 46% 13.65%
GPS 159         42.20      18,441 11% 56% 2.09%
KORS 160         69.33      14,381 9% 92% 0.00%
CHE 161      104.14        1,836 8% 158% 0.79%
DISCK 162         28.98      19,764 8% 184% 0.00%
NOV 163         57.15      24,632 16% 41% 2.74%
APSA 164         23.00            724 13% 44% 6.31%
DOV 165         69.76      11,744 10% 67% 2.15%
NCR 166         26.50        4,539 10% 62% 0.00%
PCP 167      207.85      29,764 8% 107% 0.06%
LYB 168         80.80      41,370 13% 44% 3.32%
ACN 169         89.22      60,878 7% 562% 2.18%
MANT 170         31.90        1,190 9% 72% 2.66%
THO 171         55.38        2,959 9% 67% 1.80%
FL 172         53.45        7,788 11% 50% 1.65%
DISCA 173         29.84      20,351 8% 184% 0.00%
BBY 174         35.01      12,394 12% 47% 2.06%
AAPL 175      112.98    674,726 8% 255% 1.64%
BAH 176         29.05        4,369 8% 169% 8.39%
OSK 177         41.42        3,467 13% 43% 1.50%
RMCF 178         13.57              87 9% 73% 3.30%
LOGI 179         14.94        2,485 8% 119% 21.20%
JEC 180         39.79        5,261 11% 47% 0.00%
ENSG 181         43.12        1,000 10% 61% 0.59%
PNTR 182           8.38              69 9% 62% 0.00%
BBBY 183         76.62      14,082 11% 50% 0.00%
CR 184         57.42        3,440 10% 58% 2.19%
VOC 185           5.19              88 39% 33% 35.24%
MD 186         65.53        6,563 7% 301% 0.00%
SAP 187         64.52      77,295 7% 227% 2.14%
SYMC 188         26.65      18,545 8% 129% 2.25%
CI 189      109.97      29,240 11% 47% 0.04%
UCTT 190           9.40            281 13% 40% 0.00%
CSGS 191         25.32            861 9% 62% 2.51%
CACI 192         88.29        2,128 8% 90% 0.00%
CCF 193         36.14            333 11% 44% 1.64%
NCIT 194         11.21            155 10% 49% 0.00%
DOX 195         48.11        7,682 8% 143% 1.28%
TEO 196         20.76        4,024 14% 37% 5.55%
MLHR 197         28.59        1,716 9% 64% 1.96%
UNH 198      112.00    108,976 9% 72% 1.23%
GD 199      141.32      47,792 8% 114% 1.76%
CBD 200         36.30        6,016 19% 33% 1.18%

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 #90 (USNA) 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 289 23-Jan 2       17.01 24% 8262%
ANIK 586 23-Jan 63       39.60 12% 96%
APOL 2,817 23-Jan 55       25.99 14% 80%
AGX 460 23-Jan 8       31.65 18% 990%
AVID 545 23-Jan 71       13.91 10% 157%
AWRE 105 23-Jan 42          4.59 12% 120%
BCOR 572 23-Jan 18       13.95 13% 350%
BKE 2,438 23-Jan 59       50.39 12% 100%
CA 13,592 23-Jan 72       31.01 9% 460%
CSCO 142,912 23-Jan 64       28.21 9% 335%
COH 10,368 23-Jan 53       37.62 12% 106%
CCUR 63 23-Jan 60          6.96 13% 79%
CTP 55 23-Jan 74          7.55 13% 71%
DEPO 1,099 23-Jan 25       18.72 11% 1234%
FLR 8,501 23-Jan 61       54.31 14% 76%
GME 4,088 23-Jan 36       37.40 14% 127%
GORO 189 23-Jan 67          3.49 15% 66%
ONE 181 23-Jan 56          3.79 14% 80%
IQNT 593 23-Jan 41       17.92 12% 142%
IDCC 2,010 23-Jan 52       52.23 9% 479%
ITRN 441 23-Jan 66       21.03 11% 99%
KING 4,310 23-Jan 4       13.40 23% 2194%
LFVN 123 23-Jan 19          1.22 15% 212%
LQDT 222 23-Jan 21          7.49 21% 122%
MSB 233 23-Jan #N/A #N/A #N/A #N/A
MNDO 69 23-Jan 30          3.67 10% 930%
NHTC 163 23-Jan 16       12.75 12% 4352%
NSR 1,800 23-Jan 40       27.92 12% 129%
NUS 2,521 23-Jan 49       42.52 19% 73%
PTIE 89 23-Jan 1          1.95 48% 32807%
PDLI 1,263 23-Jan 3          7.57 30% 2143%
PFMT 291 23-Jan 29          5.90 14% 165%
PETS 325 23-Jan 57       16.06 11% 141%
PBI 4,882 23-Jan 75       24.29 10% 149%
RPXC 719 23-Jan 17       12.77 12% 1378%
SPOK 393 23-Jan 32       18.12 12% 190%
STRA 741 23-Jan 58       67.98 12% 99%
RGR 752 23-Jan 51       38.71 17% 78%
TTWO 3,431 23-Jan 5       29.86 25% 809%
TDC 6,646 23-Jan 76       43.35 9% 352%
TZOO 135 23-Jan 24          9.17 14% 149%
TPUB 536 23-Jan 68       21.08 14% 70%
UBNT 2,537 23-Jan 81       28.72 9% 338%
UIS 1,355 23-Jan 22       27.14 17% 124%
USNA 1,223 23-Jan 90       98.84 9% 170%
VEC 288 23-Jan 14       27.45 14% 393%
VIAB 28,083 23-Jan 45       67.80 10% 326%
WSTG 83 23-Jan 62       17.08 14% 76%
WTW 981 23-Jan 31       17.31 11% 459%
WILN 376 23-Jan 69          3.13 9% 1353%


No comments: