Well, I felt like running a top 200 list this morning. We've been in correction territory, so some stocks are probably starting to look like pretty good buys.
This is my version of the official magic formula screener from 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.
Ticker | Rank | Stock Price | Market Cap | Earnings Yield | ROIC | Dividend Yield |
SIGA | 1 | 6.38 | 529 | 72% | 71876% | 0.00% |
FNJN | 2 | 2.65 | 135 | 55% | 20682% | 0.00% |
IMMR | 3 | 8.53 | 263 | 34% | 1811% | 0.00% |
LTRPA | 4 | 18.98 | 1,424 | 87% | 792% | 0.00% |
NHTC | 5 | 23.07 | 261 | 23% | 3713% | 2.52% |
AKG | 6 | 0.70 | 158 | 22% | 16301% | 0.00% |
CMCM | 7 | 6.68 | 962 | 20% | 921% | 0.00% |
BPT | 8 | 26.97 | 577 | 17% | 49074% | 13.48% |
ACOR | 9 | 16.37 | 772 | 25% | 335% | 0.00% |
UIS | 10 | 12.41 | 642 | 30% | 233% | 0.00% |
NKTR | 11 | 36.97 | 6,385 | 15% | 1729% | 0.00% |
AGX | 12 | 41.19 | 646 | 19% | 331% | 1.81% |
MSB | 13 | 26.49 | 348 | 14% | 21815% | #VALUE! |
CJREF | 14 | 3.69 | 777 | 16% | 207% | #VALUE! |
LEXEA | 15 | 42.82 | 2,441 | 22% | 152% | 0.00% |
DLX | 16 | 42.75 | 2,001 | 13% | 336% | 2.81% |
EGOV | 17 | 12.56 | 836 | 12% | 411% | 2.55% |
IDCC | 18 | 73.30 | 2,610 | 11% | 2120% | 1.90% |
UTHR | 19 | 112.01 | 4,928 | 21% | 123% | 0.00% |
YY | 20 | 65.52 | 4,248 | 14% | 190% | 0.00% |
FTSI | 21 | 7.72 | 844 | 34% | 102% | 0.00% |
EGY | 22 | 1.63 | 99 | 35% | 101% | 0.00% |
MCFT | 23 | 21.34 | 401 | 12% | 247% | 0.00% |
MOH | 24 | 141.75 | 9,625 | 11% | 381% | 0.00% |
AEIS | 25 | 42.11 | 1,651 | 16% | 124% | 0.00% |
HRB | 26 | 28.04 | 5,763 | 11% | 313% | 3.52% |
PBT | 27 | 6.48 | 302 | 10% | 15329% | 10.16% |
BPI | 28 | 7.92 | 219 | 18% | 105% | 0.00% |
MSGN | 29 | 24.68 | 1,868 | 11% | 272% | 0.00% |
VIAB | 30 | 29.52 | 11,905 | 13% | 141% | 2.69% |
TVTY | 31 | 28.07 | 1,202 | 10% | 893% | 0.00% |
PETS | 32 | 23.03 | 473 | 14% | 126% | 4.49% |
DHX | 33 | 1.70 | 86 | 15% | 108% | 0.00% |
KLAC | 34 | 93.54 | 14,600 | 12% | 205% | 3.03% |
SQBG | 35 | 0.87 | 56 | 13% | 145% | 0.00% |
LRCX | 36 | 138.45 | 22,890 | 14% | 110% | 2.74% |
AMAT | 37 | 34.20 | 33,653 | 14% | 118% | 2.05% |
GILD | 38 | 68.14 | 89,059 | 11% | 255% | 3.27% |
VIA | 39 | 32.20 | 12,986 | 13% | 141% | 2.49% |
ESIO | 40 | 29.69 | 1,068 | 13% | 120% | 0.00% |
GME | 41 | 13.23 | 1,352 | 26% | 75% | 11.49% |
VEC | 42 | 22.31 | 254 | 17% | 91% | 0.00% |
SJT | 43 | 4.66 | 217 | 10% | 422% | 10.88% |
EAF | 44 | 12.27 | 3,634 | 15% | 95% | 1.91% |
SP | 45 | 28.91 | 654 | 10% | 295% | 0.00% |
STX | 46 | 40.00 | 11,680 | 13% | 109% | 0.00% |
DFIN | 47 | 15.98 | 547 | 12% | 136% | 0.00% |
WDC | 48 | 40.97 | 12,209 | 19% | 76% | 4.89% |
HEAR | 49 | 17.31 | 281 | 15% | 93% | 0.00% |
TUP | 50 | 35.77 | 1,767 | 13% | 102% | 7.60% |
ALSN | 51 | 43.00 | 5,633 | 11% | 161% | 1.38% |
UEPS | 52 | 5.10 | 286 | 20% | 73% | 0.00% |
QIWI | 53 | 14.75 | 902 | 10% | 422% | 0.00% |
INVA | 54 | 17.58 | 1,993 | 10% | 369% | 0.00% |
LEE | 55 | 2.06 | 116 | 15% | 85% | 0.00% |
WU | 56 | 18.54 | 8,324 | 10% | 416% | 4.02% |
CO | 57 | 5.98 | 665 | 118% | 62% | 1.34% |
DXC | 58 | 58.15 | 16,618 | 14% | 91% | 1.29% |
HPQ | 59 | 22.55 | 36,035 | 10% | 196% | 2.48% |
TGS | 60 | 15.74 | 2,477 | 12% | 105% | 3.26% |
HSII | 61 | 34.04 | 660 | 11% | 161% | 1.85% |
MOMO | 62 | 25.58 | 5,703 | 9% | 944% | 0.00% |
TPR | 63 | 36.04 | 143 | 69% | 63% | 0.00% |
GPP | 64 | 14.40 | 458 | 11% | 133% | 13.15% |
STRL | 65 | 11.14 | 304 | 18% | 65% | 0.00% |
MKSI | 66 | 68.08 | 3,741 | 15% | 72% | 1.15% |
THO | 67 | 55.98 | 2,961 | 20% | 63% | 2.67% |
SGH | 68 | 31.23 | 727 | 19% | 63% | 0.00% |
AMCX | 69 | 58.91 | 3,404 | 13% | 89% | 0.00% |
SHI | 70 | 45.00 | 4,872 | 34% | 56% | 10.60% |
OMAB | 71 | 35.26 | 1,734 | 10% | 136% | 4.62% |
BKE | 72 | 19.45 | 945 | 18% | 63% | 5.13% |
NANO | 73 | 29.29 | 717 | 14% | 72% | 0.00% |
LGORF | 74 | 2.29 | 1,484 | 13% | 88% | 0.00% |
ZAGG | 75 | 9.63 | 275 | 19% | 60% | 0.00% |
KORS | 76 | 38.83 | 5,891 | 13% | 76% | 0.00% |
CRTO | 77 | 24.42 | 1,676 | 12% | 86% | 0.00% |
HCC | 78 | 24.30 | 1,281 | 27% | 56% | 0.84% |
KLIC | 79 | 19.81 | 1,360 | 22% | 57% | 1.22% |
CELG | 80 | 70.90 | 51,027 | 9% | 356% | 0.00% |
PFMT | 81 | 1.51 | 79 | 18% | 61% | 0.00% |
IPG | 82 | 23.92 | 9,291 | 10% | 176% | 3.52% |
MU | 83 | 36.03 | 43,812 | 36% | 53% | 0.00% |
LPX | 84 | 21.25 | 3,058 | 28% | 53% | 2.45% |
VGR | 85 | 10.94 | 1,526 | 9% | 255% | 14.12% |
OMC | 86 | 77.59 | 17,528 | 9% | 294% | 3.10% |
TGNA | 87 | 13.08 | 2,830 | 10% | 118% | 2.15% |
WGO | 88 | 21.13 | 671 | 17% | 58% | 1.90% |
MAN | 89 | 72.04 | 4,683 | 17% | 58% | 2.82% |
MO | 90 | 53.33 | 100,420 | 8% | 509% | 5.35% |
BBY | 91 | 58.98 | 16,473 | 12% | 78% | 3.05% |
MTOR | 92 | 16.45 | 1,464 | 16% | 56% | 0.00% |
LEA | 93 | 125.27 | 8,251 | 19% | 54% | 2.25% |
FUJHY | 94 | 10.94 | 16,776 | 31% | 49% | 5.91% |
CECO | 95 | 13.27 | 953 | 9% | 234% | 0.00% |
TARO | 96 | 89.73 | 3,518 | 13% | 63% | 0.00% |
NVMI | 97 | 24.15 | 695 | 11% | 86% | 0.00% |
ESRX | 98 | 96.93 | 55,047 | 8% | 1151% | 0.00% |
TUSK | 99 | 21.66 | 976 | 38% | 47% | 1.16% |
ICHR | 100 | 16.65 | 411 | 15% | 55% | 0.00% |
SNE | 101 | 52.62 | 68,225 | 10% | 113% | 0.52% |
MIK | 102 | 15.06 | 2,509 | 12% | 65% | 0.00% |
JILL | 103 | 5.45 | 242 | 16% | 53% | 0.00% |
KFY | 104 | 44.88 | 2,524 | 10% | 97% | 0.91% |
CBS | 105 | 48.66 | 18,442 | 10% | 83% | 0.00% |
MBUU | 106 | 39.38 | 817 | 9% | 142% | 0.68% |
OSB | 107 | 25.06 | 2,185 | 29% | 44% | 19.18% |
SWKS | 108 | 69.31 | 12,490 | 12% | 67% | 2.02% |
CRT | 109 | 13.80 | 83 | 10% | 100% | 10.17% |
CCE | 110 | - | - | 32% | 42% | 0.00% |
EME | 111 | 65.81 | 3,853 | 10% | 76% | 0.48% |
MD | 112 | 38.30 | 3,499 | 9% | 166% | 0.00% |
GENC | 113 | 10.96 | 161 | 23% | 43% | 0.00% |
CVS | 114 | 74.50 | 76,139 | 10% | 75% | 2.68% |
CASA | 115 | 14.96 | 1,377 | 9% | 162% | 0.00% |
DNB | 116 | 143.74 | 5,362 | 8% | 1574% | 1.44% |
BIIB | 117 | 322.61 | 65,135 | 9% | 122% | 0.00% |
TNET | 118 | 42.93 | 3,117 | 8% | 329% | 0.00% |
PBH | 119 | 33.57 | 1,751 | 9% | 157% | 0.00% |
ODP | 120 | 2.94 | 1,658 | 15% | 49% | 3.40% |
CDK | 121 | 48.64 | 6,343 | 8% | 447% | 1.23% |
VHI | 122 | 1.78 | 609 | 29% | 39% | 4.49% |
SBR | 123 | 39.82 | 581 | 7% | 21099% | 24.04% |
GTN | 124 | 17.51 | 1,551 | 10% | 67% | 0.00% |
BTI | 125 | 34.33 | 78,650 | 8% | 160% | 7.48% |
AVP | 126 | 1.88 | 832 | 13% | 52% | 0.00% |
NATH | 127 | 68.65 | 290 | 7% | 528% | 1.10% |
HUM | 128 | 310.52 | 43,062 | 8% | 189% | 0.61% |
AMGN | 129 | 196.41 | 127,470 | 8% | 177% | 2.69% |
WTW | 130 | 48.66 | 3,422 | 7% | 746% | 0.00% |
KRO | 131 | 11.69 | 1,355 | 29% | 36% | 5.83% |
MCK | 132 | 123.33 | 24,543 | 9% | 107% | 1.19% |
SEDG | 133 | 38.76 | 1,871 | 10% | 71% | 0.00% |
CKHUY | 134 | 10.04 | 38,731 | 14% | 45% | 3.74% |
FF | 135 | 15.71 | 687 | 14% | 44% | 1.54% |
NLS | 136 | 11.80 | 359 | 10% | 63% | 0.00% |
AAPL | 137 | 169.10 | 819,720 | 8% | 171% | 0.00% |
ABBV | 138 | 88.60 | 134,229 | 7% | 416% | 4.05% |
EBIX | 139 | 45.48 | 1,438 | 7% | 314% | 0.66% |
LCI | 140 | 5.27 | 198 | 19% | 37% | 0.00% |
DMLP | 141 | 17.03 | 550 | 10% | 75% | 10.19% |
REGI | 142 | 25.84 | 1,176 | 22% | 36% | 0.00% |
BLBD | 143 | 17.32 | 495 | 9% | 87% | 0.00% |
MAS | 144 | 29.62 | 9,064 | 10% | 62% | 1.47% |
CC | 145 | 26.65 | 4,847 | 19% | 37% | 3.15% |
PBI | 146 | 7.10 | 1,338 | 10% | 68% | 10.55% |
CLF | 147 | 8.37 | 2,596 | 15% | 40% | 0.56% |
JEC | 148 | 60.83 | 8,650 | 9% | 84% | 0.99% |
HOLI | 149 | 19.25 | 1,179 | 17% | 38% | 0.96% |
SIMO | 150 | 34.26 | 1,239 | 12% | 48% | 3.51% |
SBH | 151 | 19.29 | 2,323 | 11% | 51% | 0.00% |
AE | 152 | 38.83 | 164 | 23% | 35% | 2.26% |
AYI | 153 | 116.57 | 4,674 | 10% | 68% | 0.44% |
GNTX | 154 | 21.09 | 5,644 | 10% | 64% | 2.04% |
ATLKY | 155 | 24.20 | 29,403 | 8% | 120% | 7.06% |
HI | 156 | 41.42 | 2,634 | 8% | 128% | 2.01% |
TER | 157 | 33.36 | 6,355 | 9% | 96% | 1.06% |
ATEYY | 158 | 18.59 | 3,689 | 12% | 49% | 3.50% |
MGLN | 159 | 58.63 | 1,462 | 9% | 69% | 0.00% |
RHI | 160 | 59.68 | 7,248 | 8% | 115% | 1.88% |
TSQ | 161 | 5.66 | 158 | 11% | 53% | 3.98% |
PATK | 162 | 32.18 | 780 | 13% | 44% | 0.00% |
FL | 163 | 51.92 | 5,971 | 13% | 41% | 2.61% |
JAZZ | 164 | 140.81 | 8,710 | 7% | 228% | 0.00% |
APEI | 165 | 29.39 | 490 | 12% | 45% | 0.00% |
PTN | 166 | 0.77 | 158 | 7% | 4532% | 0.00% |
VSM | 167 | 29.27 | 3,214 | 10% | 57% | 0.83% |
NCMI | 168 | 7.47 | 579 | 8% | 160% | 9.09% |
EBF | 169 | 17.92 | 460 | 12% | 46% | 4.75% |
COHR | 170 | 117.64 | 2,881 | 13% | 40% | 0.00% |
ALV | 171 | 77.99 | 6,816 | 12% | 44% | 3.16% |
VC | 172 | 64.13 | 1,892 | 13% | 40% | 0.00% |
ANTM | 173 | 278.50 | 73,914 | 7% | 219% | 1.08% |
IMBBY | 174 | 30.52 | 29,470 | 8% | 140% | 7.99% |
XRX | 175 | 25.17 | 6,395 | 11% | 48% | 3.98% |
FCN | 176 | 63.09 | 2,445 | 9% | 66% | 0.00% |
YUM | 177 | 90.46 | 29,400 | 7% | 204% | 1.60% |
ORCL | 178 | 47.32 | 189,233 | 7% | 238% | 1.62% |
YRD | 179 | 14.03 | 876 | 25% | 31% | 1.99% |
ACCO | 180 | 7.03 | 744 | 13% | 38% | 3.41% |
TLYS | 181 | 10.78 | 324 | 16% | 35% | 0.00% |
KBAL | 182 | 14.89 | 557 | 10% | 54% | 1.93% |
RTN | 183 | 171.81 | 49,138 | 8% | 97% | 0.00% |
GPRK | 184 | 14.72 | 969 | 16% | 35% | 0.00% |
KNMCY | 185 | 43.38 | 5,957 | 9% | 65% | 2.04% |
COHU | 186 | 17.62 | 525 | 12% | 42% | 1.37% |
CSVI | 187 | 53.10 | 740 | 8% | 129% | 2.52% |
OSK | 188 | 64.56 | 4,762 | 12% | 40% | 1.53% |
BEVFF | 189 | 2.10 | 227 | 7% | 874% | 8.20% |
DLPH | 190 | 15.33 | 1,364 | 22% | 31% | 0.00% |
SUPN | 191 | 37.20 | 2,018 | 7% | 2005% | 0.00% |
CVGI | 192 | 6.30 | 193 | 20% | 31% | 0.00% |
IPGP | 193 | 122.30 | 6,689 | 10% | 51% | 0.00% |
BLD | 194 | 47.76 | 1,709 | 9% | 61% | 0.00% |
PM | 195 | 83.82 | 130,340 | 7% | 138% | 5.28% |
SVA | 196 | 7.07 | 415 | 13% | 36% | 0.00% |
LYB | 197 | 85.44 | 33,322 | 14% | 35% | 4.68% |
SNA | 198 | 148.39 | 8,508 | 10% | 53% | 2.29% |
SERV | 199 | 38.20 | 5,195 | 7% | 221% | 0.00% |
CTSH | 200 | 68.03 | 39,457 | 8% | 96% | 0.00% |
Here is official top 50, so you can see where each one sits on my list:
Ticker | Mkt Cap | Date | My Ranking | Price | EY | ROIC |
ACOR | 772 | 12-Dec | 9 | 16.37 | 25% | 335% |
AEIS | 1,630 | 12-Dec | 25 | 42.11 | 16% | 124% |
ALSN | 5,574 | 12-Dec | 51 | 43.00 | 11% | 161% |
AMCX | 3,329 | 12-Dec | 69 | 58.91 | 13% | 89% |
AMAT | 33,003 | 12-Dec | 37 | 34.20 | 14% | 118% |
AGX | 641 | 12-Dec | 12 | 41.19 | 19% | 331% |
AKG | 158 | 12-Dec | 6 | 0.70 | 22% | 16301% |
HRB | 5,763 | 12-Dec | 26 | 28.04 | 11% | 313% |
BPT | 577 | 12-Dec | 8 | 26.97 | 17% | 49074% |
CELG | 49,552 | 12-Dec | 80 | 70.90 | 9% | 356% |
CJREF | 783 | 12-Dec | 14 | 3.69 | 16% | 207% |
DLX | 1,980 | 12-Dec | 16 | 42.75 | 13% | 336% |
DXC | 16,356 | 12-Dec | 58 | 58.15 | 14% | 91% |
ESIO | 1,030 | 12-Dec | 40 | 29.69 | 13% | 120% |
FTSI | 844 | 12-Dec | 21 | 7.72 | 34% | 102% |
GME | 1,352 | 12-Dec | 41 | 13.23 | 26% | 75% |
GILD | 88,309 | 12-Dec | 38 | 68.14 | 11% | 255% |
EAF | 3,565 | 12-Dec | 44 | 12.27 | 15% | 95% |
HSII | 645 | 12-Dec | 61 | 34.04 | 11% | 161% |
HPQ | 35,088 | 12-Dec | 59 | 22.55 | 10% | 196% |
IMMR | 263 | 12-Dec | 3 | 8.53 | 34% | 1811% |
INVA | 1,994 | 12-Dec | 54 | 17.58 | 10% | 369% |
IDCC | 2,540 | 12-Dec | 18 | 73.30 | 11% | 2120% |
KLAC | 14,319 | 12-Dec | 34 | 93.54 | 12% | 205% |
LRCX | 22,214 | 12-Dec | 36 | 138.45 | 14% | 110% |
LGORF | 1,198 | 12-Dec | 74 | 2.29 | 13% | 88% |
LTRPA | 1,425 | 12-Dec | 4 | 18.98 | 87% | 792% |
TUSK | 969 | 12-Dec | 99 | 21.66 | 38% | 47% |
MCFT | 400 | 12-Dec | 23 | 21.34 | 12% | 247% |
MSB | 348 | 12-Dec | 13 | 26.49 | 14% | 21815% |
MKSI | 3,675 | 12-Dec | 66 | 68.08 | 15% | 72% |
MSGN | 1,847 | 12-Dec | 29 | 24.68 | 11% | 272% |
NHTC | 262 | 12-Dec | 5 | 23.07 | 23% | 3713% |
NKTR | 6,398 | 12-Dec | 11 | 36.97 | 15% | 1729% |
EGOV | 824 | 12-Dec | 17 | 12.56 | 12% | 411% |
OMC | 17,442 | 12-Dec | 86 | 77.59 | 9% | 294% |
PETS | 476 | 12-Dec | 32 | 23.03 | 14% | 126% |
STX | 11,445 | 12-Dec | 46 | 40.00 | 13% | 109% |
SIGA | 512 | 12-Dec | 1 | 6.38 | 72% | 71876% |
SGH | 696 | 12-Dec | 68 | 31.23 | 19% | 63% |
SP | 648 | 12-Dec | 45 | 28.91 | 10% | 295% |
STRL | 302 | 12-Dec | 65 | 11.14 | 18% | 65% |
TVTY | 1,124 | 12-Dec | 31 | 28.07 | 10% | 893% |
TUP | 1,738 | 12-Dec | 50 | 35.77 | 13% | 102% |
HEAR | 246 | 12-Dec | 49 | 17.31 | 15% | 93% |
UIS | 633 | 12-Dec | 10 | 12.41 | 30% | 233% |
UTHR | 5,269 | 12-Dec | 19 | 112.01 | 21% | 123% |
VEC | 251 | 12-Dec | 42 | 22.31 | 17% | 91% |
VIAB | 11,900 | 12-Dec | 30 | 29.52 | 13% | 141% |
WDC | 11,840 | 12-Dec | 48 | 40.97 | 19% | 76% |
You can see they are all in top 100, so that is pretty good.
No comments:
Post a Comment