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% |
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% |
5 | 3.20 | 61 | 16% | 1207% | 9.00% | |
CALL | 6 | 6.79 | 121 | 22% | 450% | 0.00% |
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% |
16 | 50.71 | 1,921 | 11% | 1370% | 0.00% | |
17 | 19.02 | 1,755 | 27% | 152% | 0.00% | |
HLF | 18 | 42.47 | 3,631 | 16% | 191% | 0.00% |
19 | 12.22 | 570 | 11% | 1453% | 2.60% | |
20 | 6.91 | 392 | 12% | 417% | 0.00% | |
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% |
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% |
38 | 7.41 | 425 | 17% | 93% | 5.00% | |
SFUN | 39 | 6.08 | 2,772 | 12% | 142% | 6.70% |
40 | 47.86 | 5,239 | 13% | 117% | 0.30% | |
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% |
54 | 106.87 | 37,896 | 9% | 629% | 0.90% | |
55 | 41.05 | 627 | 12% | 106% | 0.00% | |
56 | 13.92 | 568 | 10% | 211% | 0.00% | |
VIAB | 57 | 67.89 | 28,249 | 10% | 219% | 1.90% |
58 | 23.12 | 1,155 | 14% | 84% | 0.00% | |
59 | 68.20 | 28,378 | 10% | 219% | 1.90% | |
60 | 40.39 | 335,116 | 10% | 207% | 0.00% | |
61 | 50.68 | 2,441 | 11% | 111% | 1.90% | |
PNLYY | 62 | 4.50 | 1,988 | 15% | 78% | 0.00% |
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% |
175 | 13.01 | 250 | 13% | 45% | 3.00% | |
ARESF | 176 | 11.81 | 1,690 | 7% | 10130% | 0.00% |
177 | 49.48 | 954 | 10% | 60% | 1.40% | |
BAH | 178 | 29.08 | 4,382 | 8% | 150% | 1.80% |
179 | 11.58 | 318 | 9% | 89% | 0.00% | |
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% |
184 | 22.72 | 16,559 | 7% | 754% | 1.00% | |
185 | 4.39 | 100 | 9% | 82% | 0.00% | |
186 | 25.46 | 2,353 | 11% | 51% | #VALUE! | |
187 | 25.59 | 52,152 | 8% | 114% | 1.70% | |
CCNMF | 188 | 1.76 | 87 | 9% | 67% | 0.00% |
189 | 37.18 | 131 | 9% | 66% | 0.00% | |
MGLN | 190 | 71.00 | 1,873 | 9% | 79% | 0.00% |
191 | 69.42 | 11,556 | 9% | 70% | 2.30% | |
192 | 34.77 | 2,622 | 8% | 157% | 0.00% | |
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% |
610 | 1-Apr | 55 | 41.05 | 12% | 106% | |
AGX | 527 | 1-Apr | 8 | 36.28 | 15% | 990% |
591 | 1-Apr | 98 | 15.05 | 9% | 157% | |
8,896 | 1-Apr | 21 | 32.32 | 12% | 342% | |
569 | 1-Apr | 56 | 13.92 | 10% | 211% | |
4,978 | 1-Apr | 83 | 11.82 | 10% | 110% | |
2,452 | 1-Apr | 61 | 50.68 | 11% | 111% | |
CPLA | 804 | 1-Apr | 85 | 65.66 | 9% | 179% |
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% |
8,438 | 1-Apr | 65 | 56.77 | 14% | 81% | |
4,069 | 1-Apr | 29 | 37.78 | 16% | 139% | |
146,482 | 1-Apr | 43 | 97.95 | 10% | 377% | |
GORO | 189 | 1-Apr | 78 | 3.49 | 15% | 66% |
57,010 | 1-Apr | 63 | 31.36 | 14% | 83% | |
122 | 1-Apr | 48 | 2.56 | 17% | 77% | |
IQNT | 557 | 1-Apr | 34 | 16.64 | 14% | 140% |
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% |
159 | 1-Apr | #N/A | #N/A | #N/A | #N/A | |
334,637 | 1-Apr | 60 | 40.39 | 10% | 207% | |
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% |
1,156 | 1-Apr | 2 | 7.17 | 33% | 843% | |
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% |
15,307 | 1-Apr | 74 | 65.14 | 11% | 113% | |
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:
Post a Comment