Sunday, February 18, 2018

Top 200 List 2/18/18

Top 200 List 2/18/18

Thought it was time for another top 200 list.  This is my version of the official magic formula screener fro Joel Greenblatt's book.  I believe I come very close to matching the actual calculations.  When I first developed this, the official screen gave more earnings yield and ROIC data - so that is a large reason for confidence.

The formula details can be found in my blog post "The Calculation" if you want to see more.  I had a lot of help developing it from people on the Yahoo MFI board back in the day.  Also Randy Harmelink, of SMF fame, helped me automate workbook once the formulae were all working well.

I do give more info than official site.  I use Fidelity for data source and they use Compustat, so that matches what official website uses.  I do provide earnings yield and ROIC.  I also typically have more names as I do not throw out as many non-US firms and I keep some insurers and investment firms.

Here is my list:


Ticker Rank  Stock Price  Market Cap Earnings Yield ROIC Dividend Yield
OPHT 1            2.86            103 2441% 5362% 0.00%
VVUS 2            0.46               49 147% 1990% 0.00%
NHTC 3         17.25            194 51% 3748% 2.43%
CNCE 4         21.48            503 31% 4417% 0.00%
AVDL 5            7.74            320 33% 2696% 0.00%
AGX 6         40.40            638 37% 838% 2.48%
BPT 7         21.10            452 17% 38570% 13.48%
EVC 8            6.80            627 46% 334% 2.39%
IDCC 9         79.35         2,808 17% 585% 1.64%
ICON 10            1.65               94 22% 427% 0.00%
NTIP 11            2.55               67 34% 284% 3.92%
BPI 12            7.05            209 29% 189% 0.00%
UTHR 13       134.93         5,950 21% 206% 0.00%
MSB 14         26.55            348 10% 16407% #VALUE!
EGOV 15         14.00            929 10% 760% 2.29%
SQBG 16            1.73            109 12% 210% 0.00%
VEC 17         28.13            317 13% 174% 0.00%
MSGN 18         25.05         1,898 10% 265% 0.00%
DHX 19            1.80               87 16% 128% 0.00%
YRD 20         39.60         2,445 12% 185% 0.00%
MPAA 21         22.96            438 10% 244% 0.00%
GME 22         16.40         1,665 26% 109% 9.27%
CJREF 23            6.50         1,344 12% 165% #VALUE!
EGRX 24         64.78         1,021 11% 179% 0.00%
LFVN 25            4.14               58 13% 122% 0.00%
HRB 26         28.04         5,862 10% 270% 3.35%
ESRX 27         75.23       43,235 9% 426% 0.00%
TGNA 28         13.78         3,005 12% 141% 2.54%
WU 29         20.26         9,311 9% 513% 3.46%
QTRH 30            1.68            199 31% 93% 2.33%
TRNC 31         20.24            676 14% 113% 0.00%
NLS 32         11.90            370 14% 106% 0.00%
ACOR 33         25.80         1,193 9% 308% 0.00%
MEET 34            2.70            205 10% 215% 0.00%
VIAB 35         33.50       13,487 12% 128% 2.39%
DISCK 36         22.65       12,933 10% 165% 0.00%
HPQ 37         21.40       36,102 9% 214% 2.51%
DISCA 38         23.86       13,624 10% 165% 0.00%
AMCX 39         52.58         3,389 13% 100% 0.00%
VIA 40         39.90       16,064 11% 128% 2.01%
AEIS 41         65.56         2,626 9% 208% 0.00%
QIWI 42         17.00         1,041 8% 728% 3.65%
LEE 43            2.45            137 14% 81% 0.00%
TARO 44       101.60         4,096 15% 77% 0.00%
OMC 45         78.72       18,287 8% 283% 2.86%
CSVI 46         45.00            628 9% 142% 2.62%
DFIN 47         20.37            689 10% 109% 0.00%
HSII 48         25.25            480 11% 100% 1.85%
SP 49         37.25            839 8% 312% 0.00%
SYNT 50         26.87         2,237 10% 127% 0.00%
KLAC 51       107.52       16,836 9% 195% 2.15%
KLIC 52         22.02         1,554 17% 70% 0.00%
DIN 53         54.67            970 10% 111% 0.00%
NVMI 54         27.10            780 9% 129% 0.00%
WDC 55         84.91       25,133 11% 88% 2.36%
USNA 56         77.15         1,852 9% 142% 0.00%
AMAG 57         18.50            653 8% 381% 0.00%
ANTM 58       235.00       61,876 8% 246% 1.15%
AMGN 59       183.55    132,890 8% 210% 0.00%
ALSN 60         39.32         5,583 9% 146% 1.53%
GPP 61         18.00            573 9% 120% 10.11%
COH 62            0.41            143 69% 63% 0.00%
BIIB 63       291.87       61,876 9% 137% 0.00%
PDLI 64            2.47            376 26% 60% 0.00%
MIK 65         24.58         4,473 10% 83% 0.00%
LRCX 66       187.91       30,279 9% 101% 0.98%
NCR 67         32.63         3,978 10% 89% 0.00%
FUJHY 68         17.47       26,789 18% 58% 3.67%
BKE 69         21.95         1,061 16% 60% 4.56%
CELG 70         95.26       73,684 7% 525% 0.00%
YUM 71         78.25       26,996 8% 167% 1.61%
TWX 72         95.37       75,495 9% 124% 1.69%
CPLA 73         80.85            965 8% 178% 2.05%
UIS 74         11.15            809 10% 75% 0.00%
ENDP 75            6.88         1,536 8% 137% 0.00%
PBH 76         35.21         1,885 8% 149% 0.00%
CRUS 77         41.77         2,738 12% 65% 0.00%
ODP 78            3.18         1,689 23% 54% 3.14%
BOJA 79         12.10            466 9% 100% 0.00%
THO 80       124.83         6,593 10% 81% 1.12%
BSTC 81         39.95            292 7% 345% 0.00%
PTN 82            0.97            195 7% 6550% 0.00%
NATH 83         68.00            285 7% 329% 0.00%
GHC 84       599.80         3,331 9% 101% 0.86%
CVS 85         71.90       73,194 10% 72% 2.78%
RGR 86         50.30            896 11% 64% 2.70%
LEA 87       189.57       12,986 12% 61% 1.06%
SIMO 88         44.77         1,604 9% 80% 2.23%
AMAT 89         55.03       58,937 8% 180% 0.73%
ESIO 90         17.24            621 11% 63% 0.00%
MCFT 91         25.16            471 7% 211% 0.00%
HLF 92         83.72         6,949 8% 157% 0.00%
VVV 93         23.37         4,721 9% 80% 0.95%
HMTV 94         11.25            460 8% 104% 0.00%
TER 95         43.31         8,489 8% 148% 0.65%
NCMI 96            7.05            453 8% 155% 12.48%
SBH 97         17.20         2,213 12% 54% 0.00%
SNE 98         49.55       64,049 9% 88% 0.41%
BBY 99         73.18       22,349 9% 79% 1.86%
PBT 100            9.43            440 7% 14593% 6.80%
TVTY 101         38.80         1,689 7% 1208% 0.00%
EME 102         76.64         4,554 8% 106% 0.42%
PBI 103         12.34         2,320 9% 81% 6.08%
CLCT 104         15.56            139 8% 121% 7.87%
BGSF 105         16.94            154 9% 79% 5.90%
MANH 106         42.97         2,956 7% 1217% 0.00%
FFIV 107       145.03         9,072 7% 496% 0.00%
KBAL 108         16.71            631 10% 65% 1.56%
UCTT 109         19.19            659 12% 51% 0.00%
MAN 110       121.92         8,205 10% 63% 1.53%
EBF 111         20.20            513 11% 55% 3.84%
FL 112         49.17         6,215 15% 45% 2.52%
AYI 113       151.14         6,363 8% 89% 0.34%
ETM 114         10.40            413 9% 68% 3.03%
LPX 115         29.25         4,288 14% 46% 1.78%
SJT 116            9.24            431 7% 13785% 9.37%
AVP 117            2.73         1,202 12% 50% 0.00%
CA 118         35.34       14,595 7% 475% 2.89%
WGO 119         42.70         1,357 9% 72% 0.94%
ABC 120         99.40       21,950 8% 112% 1.50%
CKHUY 121         12.73       49,108 12% 49% 0.00%
MDP 122         55.65         2,538 8% 87% 3.74%
OMAB 123         40.08         1,972 8% 113% 4.21%
CSCO 124         44.33    218,281 7% 406% 2.62%
CRTO 125         31.00         2,101 8% 86% 0.00%
OCLR 126            6.87         1,173 13% 43% 0.00%
TPB 127         21.41            419 8% 81% 0.19%
TNET 128         41.66         2,979 7% 309% 0.00%
RPXC 129         13.07            658 6% 619% 0.38%
ROCK 130         31.80         1,024 9% 61% 0.00%
FRAN 131            5.53            199 24% 39% 0.00%
BAH 132         38.30         5,614 7% 126% 1.83%
GIB 133         58.86       17,162 7% 236% 0.00%
WCG 134       193.21         8,721 7% 182% 0.00%
NTRI 135         42.60         1,291 7% 255% 1.64%
PLUS 136         76.00         1,063 10% 55% 0.00%
SBGI 137         36.30         3,741 8% 77% 1.98%
ENR 138         53.85         3,312 8% 87% 2.10%
SAFM 139       133.41         2,988 17% 38% 0.84%
PMD 140         21.29            118 9% 66% 2.82%
FTD 141            6.07            167 8% 78% 0.00%
SNI 142         87.81       11,526 8% 82% #VALUE!
SHI 143         58.50         6,325 15% 39% 6.20%
BLBD 144         22.45            537 7% 136% 0.00%
HI 145         45.75         2,933 7% 121% 1.80%
TPIC 146         19.48            682 10% 52% 0.00%
EGL 147         26.44            987 7% 110% 0.00%
AAPL 148       172.43    889,357 7% 191% 0.00%
NLSN 149         33.68       12,037 7% 215% 3.95%
TJX 150         77.88       50,068 8% 77% 1.61%
MMS 151         67.26         4,451 7% 92% 0.27%
MU 152         44.21       54,157 15% 36% 0.00%
PPC 153         27.00         6,723 13% 39% 0.00%
OSB 154         36.87         3,189 16% 36% 3.18%
GTS 155         25.48            617 8% 71% 0.00%
SWKS 156       104.11       19,312 7% 85% 1.15%
JMEI 157            2.88            433 70% 34% 0.00%
RECN 158         15.60            477 8% 62% 3.01%
CR 159         94.59         5,619 7% 83% 0.00%
GTN 160         15.00         1,087 9% 54% 0.00%
BC 161         59.04         5,219 10% 49% 0.00%
APEI 162         25.90            424 12% 38% 0.00%
UEPS 163         10.35            579 12% 39% 0.00%
JCOM 164         77.38         3,748 6% 325% 1.96%
ORCL 165         50.71    217,191 6% 230% 1.50%
HCKT 166         16.29            521 7% 106% 1.84%
ATTO 167            9.65            712 11% 40% #VALUE!
MLHR 168         37.25         2,245 9% 59% 1.88%
AAOI 169         31.99            653 15% 34% 0.00%
TNH 170         83.90         1,552 9% 48% 7.10%
LCI 171         17.05            653 13% 36% 0.00%
ACCO 172         13.65         1,491 10% 43% 1.76%
MCK 173       150.50       31,304 7% 77% 0.82%
IMBBY 174         37.94       36,305 7% 140% 5.69%
TVPT 175         13.22         1,668 8% 73% 2.27%
AVID 176            4.84            200 7% 115% 0.00%
SNA 177       160.88         9,315 9% 52% 1.83%
VGR 178         20.29         2,694 6% 254% 7.60%
WINA 179       127.10            548 6% 254% 0.35%
STX 180         51.42       14,963 7% 74% 0.00%
JAZZ 181       145.76         8,955 6% 199% 0.00%
MOMO 182         31.05         6,475 6% 1056% 0.00%
GPS 183         33.27       13,075 10% 40% 0.00%
RL 184       105.59         8,627 9% 47% 1.89%
TSQ 185            7.01            196 10% 41% 0.00%
KNMCY 186         50.20         6,900 8% 66% 1.24%
MAS 187         43.21       13,568 7% 74% 0.95%
FOX 188         37.04       68,709 7% 95% 0.00%
BAYRY 189         30.73       26,811 20% 31% 2.41%
ITRN 190         33.80            709 8% 65% 3.31%
GNC 191            4.36            306 13% 33% 0.00%
FOXA 192         37.46       69,488 7% 95% 0.96%
LYB 193       108.61       42,901 11% 36% 3.27%
CSGS 194         47.68         1,573 7% 83% 1.66%
ORIG 195         25.08            223 1221% 29% 0.00%
AOBC 196         10.74            587 13% 32% 0.00%
SPOK 197         14.60            292 7% 97% 3.42%
CLF 198            7.92         2,383 11% 35% 0.00%
MGLN 199         97.60         2,397 7% 79% 0.00%
DGX 200       104.53       14,530 7% 95% 1.72%



People should always do their own due diligence as always possible I make mistakes.  The yields should also always be checked as sometimes they are backwards looking, exclude special dividends etc.

Here is the official top 200 list.  I do not match as well as "normal".  I believe this is because we are in the thick of earnings season and it is possible there could be timing differences on balance sheets or income statements.  Like I do not have DLX as my pull from Fidelity shows some balance sheet items as "N/A".  I am sure if I run a week from now, Fidelity will have populated those fields.


Ticker Mkt Cap Date My Ranking Price EY ROIC
ACOR 1,193 16-Feb 33        25.80 9% 308%
AEIS 2,599 16-Feb 41        65.56 9% 208%
ALSN 5,504 16-Feb 60        39.32 9% 146%
AMAG 654 16-Feb 57        18.50 8% 381%
AMCX 3,297 16-Feb 39        52.58 13% 100%
ABC 21,719 16-Feb 120        99.40 8% 112%
AGX 628 16-Feb 6        40.40 37% 838%
HRB 5,862 16-Feb 26        28.04 10% 270%
BPT 452 16-Feb 7        21.10 17% 38570%
CASA 649 16-Feb #N/A #N/A #N/A #N/A
CERC 105 16-Feb #N/A #N/A #N/A #N/A
CNCE 527 16-Feb 4        21.48 31% 4417%
CJREF 1,346 16-Feb 23          6.50 12% 165%
DLX 3,469 16-Feb #N/A #N/A #N/A #N/A
DIN 984 16-Feb 53        54.67 10% 111%
DISCA 13,624 16-Feb 38        23.86 10% 165%
EGRX 1,034 16-Feb 24        64.78 11% 179%
EVC 615 16-Feb 8          6.80 46% 334%
ESRX 42,610 16-Feb 27        75.23 9% 426%
GME 1,661 16-Feb 22        16.40 26% 109%
HSII 474 16-Feb 48        25.25 11% 100%
HPQ 35,224 16-Feb 37        21.40 9% 214%
IDCC 2,754 16-Feb 9        79.35 17% 585%
KLAC 16,840 16-Feb 51      107.52 9% 195%
LEE 140 16-Feb 43          2.45 14% 81%
MSB 348 16-Feb 14        26.55 10% 16407%
MPAA 438 16-Feb 21        22.96 10% 244%
MSGN 1,886 16-Feb 18        25.05 10% 265%
NHTC 196 16-Feb 3        17.25 51% 3748%
NLS 365 16-Feb 32        11.90 14% 106%
EGOV 928 16-Feb 15        14.00 10% 760%
OMC 18,113 16-Feb 45        78.72 8% 283%
OPHT 103 16-Feb 1          2.86 2441% 5362%
PTN 180 16-Feb 82          0.97 7% 6550%
PDLI 381 16-Feb 64          2.47 26% 60%
PCOA 136 16-Feb #N/A #N/A #N/A #N/A
QTRH 199 16-Feb 30          1.68 31% 93%
SQBG 109 16-Feb 16          1.73 12% 210%
SP 827 16-Feb 49        37.25 8% 312%
SYNT 2,226 16-Feb 50        26.87 10% 127%
TGNA 2,965 16-Feb 28        13.78 12% 141%
MEET 194 16-Feb 34          2.70 10% 215%
TRNC 679 16-Feb 31        20.24 14% 113%
TUP 2,598 16-Feb #N/A #N/A #N/A #N/A
UIS 563 16-Feb 74        11.15 10% 75%
UTHR 6,175 16-Feb 13      134.93 21% 206%
USNA 1,847 16-Feb 56        77.15 9% 142%
VEC 312 16-Feb 17        28.13 13% 174%
VIAB 13,484 16-Feb 35        33.50 12% 128%
WDC 25,218 16-Feb 55        84.91 11% 88%

CASA just doesn't show data in Fidelity, they are a recent IPO. CERC is right on the cusp of my 100m market cap pull.  So if they were under $100m when I created my stock list they could be excluded.  DLX is timing.  PCOA, as far as I can tell, has been delisted and no longer trades. TUP is like DLX... but not sure why Fidelity has N/As as they reported 18 days ago.