I last created a top 200 list on 5/1. 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. That being said, I struggled this pull with Gurufocus. It would only let me export data on 1000 stocks, instead of the 4,000 I need. I have sent them a note asking what is up.
As I have mentioned, I have moved to Gurufocus from Finwiz as Finwiz started charging for downloads. Gurufocus may charge as well, but I have a premium membership with 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 |
1 | 6.66 | 1,135 | 37% | 887017% | 9.00% | |
DEPO | 2 | 20.76 | 1,236 | 21% | 2731% | 0.00% |
ENTA | 3 | 40.10 | 773 | 24% | 1586% | 0.00% |
PERI | 4 | 3.40 | 254 | 42% | 677% | 0.00% |
PSDV | 5 | 4.01 | 118 | 13% | 3938% | 0.00% |
CTCM | 6 | 3.48 | 543 | 30% | 301% | 20.60% |
KING | 7 | 15.25 | 4,896 | 18% | 371% | 0.00% |
AGX | 8 | 35.65 | 529 | 13% | 784% | 0.00% |
RPXC | 9 | 16.04 | 885 | 12% | 1813% | 0.00% |
CALL | 10 | 8.10 | 145 | 14% | 330% | 0.00% |
NLNK | 11 | 42.06 | 1,343 | 12% | 514% | 0.00% |
12 | 57.26 | 2,137 | 13% | 363% | 1.40% | |
KZ | 13 | 6.66 | 310 | 13% | 320% | 0.00% |
GAME | 14 | 6.92 | 1,878 | 11% | 873% | 0.00% |
15 | 32.09 | 8,831 | 12% | 342% | 2.50% | |
XENE | 16 | 12.59 | 171 | 11% | 449% | 0.00% |
ANTM | 17 | 164.19 | 46,039 | 12% | 287% | 1.60% |
HLF | 18 | 51.53 | 4,359 | 13% | 196% | 0.00% |
CRT | 19 | 18.10 | 109 | 14% | 159% | 8.60% |
GSK | 20 | 45.26 | 110,004 | 17% | 138% | 5.00% |
SJT | 21 | 11.02 | 514 | 10% | 678% | 3.00% |
GME | 22 | 40.80 | 4,468 | 14% | 139% | 3.60% |
NATH | 23 | 40.06 | 184 | 13% | 159% | 0.00% |
CPLA | 24 | 53.63 | 670 | 12% | 176% | 2.80% |
IQNT | 25 | 17.82 | 605 | 13% | 149% | 3.30% |
NSR | 26 | 27.08 | 1,539 | 15% | 133% | 0.00% |
27 | 111.71 | 175,273 | 10% | 487% | 1.70% | |
28 | 21.33 | 182 | 10% | 665% | 6.00% | |
TSRA | 29 | 38.74 | 2,074 | 9% | 1253% | 2.10% |
30 | 61.20 | 4,796 | 10% | 444% | 0.00% | |
VEC | 31 | 25.71 | 277 | 11% | 158% | 0.00% |
32 | 114.52 | 40,391 | 9% | 668% | 0.90% | |
VIAB | 33 | 66.80 | 26,887 | 10% | 270% | 2.00% |
34 | 67.30 | 27,088 | 10% | 270% | 2.00% | |
35 | 179.00 | 27,270 | 11% | 193% | 0.70% | |
36 | 66.09 | 3,312 | 9% | 413% | 1.80% | |
STRA | 37 | 46.54 | 500 | 17% | 94% | 0.00% |
LQDT | 38 | 10.52 | 315 | 12% | 127% | 0.00% |
TNH | 39 | 133.07 | 2,462 | 14% | 105% | 7.50% |
CBI | 40 | 56.31 | 6,152 | 12% | 129% | 0.30% |
CSCO | 41 | 29.26 | 150,630 | 9% | 342% | 2.90% |
SPOK | 42 | 16.79 | 370 | 10% | 171% | 2.90% |
PPC | 43 | 26.50 | 6,888 | 18% | 78% | 0.00% |
BKE | 44 | 44.07 | 2,124 | 13% | 97% | 2.10% |
CA | 45 | 31.33 | 13,754 | 9% | 486% | 3.20% |
LCI | 46 | 55.39 | 2,061 | 12% | 114% | 0.00% |
PBI | 47 | 22.99 | 4,660 | 10% | 150% | 3.30% |
LBMH | 48 | 2.76 | 148 | 10% | 204% | 4.60% |
QCOM | 49 | 69.51 | 115,873 | 9% | 339% | 2.80% |
PETS | 50 | 16.31 | 329 | 11% | 126% | 4.40% |
UIS | 51 | 21.00 | 1,046 | 13% | 80% | 0.00% |
ONE | 52 | 3.11 | 149 | 15% | 71% | 0.00% |
APOL | 53 | 16.46 | 1,780 | 20% | 67% | 0.00% |
KFY | 54 | 32.87 | 1,634 | 9% | 201% | 1.30% |
SGU | 55 | 8.20 | 470 | 20% | 66% | 5.20% |
SMT | 56 | 1.15 | 145 | 28% | 62% | 0.00% |
MGIC | 57 | 6.53 | 289 | 10% | 119% | 2.40% |
ASPS | 58 | 28.94 | 608 | 13% | 74% | 0.00% |
FLR | 59 | 57.97 | 8,691 | 14% | 68% | 1.40% |
VNCE | 60 | 17.85 | 682 | 9% | 158% | 0.00% |
DHX | 61 | 8.55 | 464 | 8% | 296% | 0.00% |
KORS | 62 | 61.63 | 12,674 | 11% | 101% | 0.00% |
OUTR | 63 | 78.12 | 1,429 | 12% | 73% | 1.60% |
VA | 64 | 28.49 | 1,271 | 12% | 82% | 0.00% |
APEI | 65 | 24.03 | 417 | 20% | 61% | 0.00% |
GORO | 66 | 3.11 | 168 | 20% | 60% | 3.60% |
LEJU | 67 | 8.67 | 1,163 | 8% | 358% | 8.30% |
BRCD | 68 | 12.54 | 5,433 | 10% | 114% | 1.20% |
POZN | 69 | 6.71 | 216 | 8% | 407% | 0.00% |
GIB | 70 | 43.33 | 13,992 | 8% | 335% | 0.00% |
BAH | 71 | 25.11 | 3,763 | 9% | 167% | 1.90% |
PLOW | 72 | 20.73 | 462 | 12% | 69% | 4.20% |
SAIC | 73 | 52.48 | 2,498 | 9% | 154% | 2.20% |
FENG | 74 | 7.36 | 548 | 11% | 74% | 0.00% |
NVDA | 75 | 20.86 | 11,452 | 10% | 111% | 1.60% |
CRWN | 76 | 4.00 | 1,439 | 10% | 100% | 0.00% |
ORCL | 77 | 43.93 | 197,421 | 8% | 446% | 1.40% |
CSIQ | 78 | 33.71 | 2,031 | 19% | 56% | 0.00% |
AAPL | 79 | 132.54 | 773,352 | 8% | 317% | 1.60% |
TDC | 80 | 39.57 | 5,844 | 8% | 282% | 0.00% |
LOV | 81 | 3.06 | 76 | 9% | 151% | 0.00% |
UNH | 82 | 119.59 | 115,883 | 8% | 256% | 1.30% |
COH | 83 | 37.53 | 10,411 | 10% | 104% | 3.50% |
SLI | 84 | 37.94 | 160 | 16% | 57% | 0.00% |
MSFT | 85 | 46.90 | 386,315 | 8% | 195% | 2.60% |
UBNT | 86 | 30.46 | 2,723 | 8% | 196% | 0.60% |
BCOR | 87 | 16.10 | 675 | 8% | 251% | 0.00% |
LO | 88 | 72.01 | 25,917 | 8% | 720% | 3.70% |
UEPS | 89 | 14.46 | 666 | 17% | 55% | 0.00% |
EVOL | 90 | 8.68 | 104 | 9% | 110% | 5.00% |
BBY | 91 | 34.33 | 12,276 | 14% | 56% | 2.50% |
ANIK | 92 | 33.62 | 515 | 11% | 73% | 0.00% |
HGT | 93 | 4.55 | 182 | 24% | 50% | 1.70% |
SAFM | 94 | 84.59 | 1,908 | 25% | 49% | 1.00% |
BBX | 95 | 16.21 | 271 | 24% | 49% | 0.00% |
TIME | 96 | 22.33 | 2,446 | 9% | 99% | 3.40% |
RTN | 97 | 106.70 | 32,928 | 9% | 113% | 2.50% |
WMC | 98 | 15.10 | 628 | 7% | 625% | 18.10% |
TSQ | 99 | 12.62 | 211 | 11% | 68% | 0.00% |
STRZA | 100 | 40.96 | 4,366 | 9% | 123% | 0.00% |
STRZB | 101 | 41.00 | 4,371 | 9% | 123% | 0.00% |
BPI | 102 | 9.11 | 414 | 16% | 50% | 0.00% |
LYB | 103 | 102.90 | 49,495 | 13% | 55% | 2.70% |
LE | 104 | 29.42 | 943 | 12% | 59% | 0.00% |
GD | 105 | 139.64 | 46,735 | 9% | 122% | 2.00% |
AVP | 106 | 7.02 | 3,053 | 14% | 51% | 3.40% |
MAN | 107 | 86.16 | 6,858 | 11% | 64% | 1.90% |
OMC | 108 | 76.97 | 19,042 | 8% | 266% | 2.60% |
RMAX | 109 | 33.73 | 415 | 7% | 1453% | 1.40% |
NUS | 110 | 52.44 | 3,160 | 12% | 57% | 2.80% |
NSU | 111 | 4.06 | 818 | 53% | 44% | 4.00% |
TARO | 112 | 139.17 | 5,961 | 9% | 94% | 0.00% |
NTI | 113 | 24.41 | 2,260 | 13% | 53% | 16.50% |
DISCK | 114 | 30.96 | 20,650 | 8% | 170% | 0.00% |
SUPN | 115 | 13.44 | 603 | 7% | 334% | 0.00% |
IBM | 116 | 172.22 | 170,894 | 9% | 89% | 3.00% |
ITRN | 117 | 24.39 | 511 | 9% | 88% | 5.50% |
HSII | 118 | 25.46 | 473 | 9% | 100% | 2.20% |
CPHR | 119 | 10.23 | 272 | 7% | 415% | 0.00% |
NRCIA | 120 | 14.56 | 358 | 8% | 222% | 1.70% |
SNDK | 121 | 67.08 | 15,029 | 9% | 99% | 1.80% |
GRMN | 122 | 45.95 | 8,838 | 9% | 79% | 4.10% |
WINA | 123 | 92.64 | 479 | 7% | 304% | 0.30% |
KLIC | 124 | 13.19 | 1,023 | 18% | 44% | 0.00% |
KBSF | 125 | 3.96 | 101 | 42% | 42% | 0.00% |
BBBY | 126 | 71.76 | 12,783 | 12% | 53% | 0.00% |
ALDW | 127 | 21.83 | 1,365 | 13% | 48% | 12.90% |
WLKP | 128 | 21.44 | 588 | 52% | 41% | 5.60% |
TUP | 129 | 67.28 | 3,384 | 9% | 81% | 4.10% |
VGR | 130 | 22.00 | 2,455 | 7% | 247% | 7.20% |
NTCT | 131 | 40.41 | 1,678 | 7% | 456% | 0.00% |
LOGI | 132 | 15.19 | 2,528 | 8% | 136% | 1.80% |
IPG | 133 | 20.92 | 8,600 | 8% | 149% | 2.30% |
MIXT | 134 | 6.91 | 222 | 9% | 77% | 0.00% |
NOC | 135 | 160.00 | 32,080 | 8% | 102% | 1.80% |
CPSI | 136 | 54.11 | 598 | 8% | 112% | 4.70% |
FL | 137 | 63.46 | 9,018 | 10% | 59% | 1.60% |
ATVI | 138 | 25.49 | 18,633 | 7% | 822% | 0.90% |
USNA | 139 | 128.59 | 1,683 | 8% | 165% | 0.00% |
EMR | 140 | 61.78 | 42,264 | 9% | 73% | 3.20% |
CTG | 141 | 7.70 | 123 | 20% | 41% | 3.10% |
GCI | 142 | 35.93 | 8,333 | 9% | 67% | 2.30% |
WILN | 143 | 2.01 | 242 | 7% | 682% | 7.80% |
NTAP | 144 | 33.14 | 10,383 | 9% | 70% | 1.90% |
MDP | 145 | 52.35 | 2,376 | 8% | 117% | 3.50% |
FOSL | 146 | 78.42 | 3,958 | 12% | 48% | 0.00% |
HPQ | 147 | 34.76 | 63,819 | 10% | 63% | 2.10% |
HI | 148 | 31.96 | 2,042 | 9% | 71% | 2.80% |
SYNT | 149 | 44.42 | 3,737 | 8% | 100% | 0.00% |
DNB | 150 | 128.97 | 4,695 | 7% | 1589% | 1.50% |
ATAI | 151 | 5.20 | 119 | 9% | 69% | 8.30% |
EME | 152 | 45.49 | 2,894 | 9% | 69% | 0.70% |
DISCB | 153 | 33.03 | 22,031 | 7% | 170% | 0.00% |
GHM | 154 | 23.02 | 234 | 11% | 53% | 1.40% |
CR | 155 | 62.45 | 3,678 | 10% | 63% | 2.20% |
DISCA | 156 | 33.15 | 22,111 | 7% | 170% | 0.00% |
NOK | 157 | 7.22 | 28,577 | 7% | 211% | 2.30% |
IBA | 158 | 54.60 | 2,728 | 20% | 39% | 2.10% |
HRS | 159 | 80.26 | 8,411 | 9% | 69% | 2.40% |
WNR | 160 | 45.82 | 4,384 | 19% | 39% | 3.10% |
ACN | 161 | 96.39 | 65,465 | 7% | 583% | 2.10% |
LMT | 162 | 192.86 | 61,754 | 8% | 109% | 3.20% |
WLDN | 163 | 15.11 | 121 | 8% | 100% | 0.00% |
SYMC | 164 | 24.87 | 17,231 | 8% | 116% | 2.40% |
MLHR | 165 | 27.64 | 1,661 | 10% | 61% | 2.00% |
SFUN | 166 | 8.03 | 3,610 | 8% | 124% | 5.00% |
NCIT | 167 | 11.14 | 152 | 10% | 59% | 0.00% |
REX | 168 | 63.27 | 500 | 23% | 38% | 0.00% |
MED | 169 | 32.67 | 398 | 8% | 86% | 0.00% |
MIK | 170 | 26.94 | 5,604 | 8% | 105% | 0.00% |
ICON | 171 | 26.55 | 1,378 | 7% | 166% | 0.00% |
CO | 172 | 6.16 | 450 | 16% | 40% | 0.00% |
RECN | 173 | 16.21 | 621 | 9% | 61% | 1.90% |
PME | 174 | 1.73 | 137 | 33% | 37% | 2.20% |
CHE | 175 | 123.93 | 2,165 | 8% | 131% | 0.70% |
CI | 176 | 135.86 | 35,493 | 10% | 59% | 0.00% |
177 | 46.33 | 1,161 | 11% | 47% | 0.00% | |
NOV | 178 | 50.71 | 20,740 | 17% | 39% | 3.50% |
179 | 15.25 | 971 | 10% | 50% | 1.60% | |
180 | 54.14 | 8,519 | 7% | 160% | 1.30% | |
PM | 181 | 84.15 | 130,264 | 8% | 133% | 4.80% |
182 | 22.99 | 200 | 7% | 214% | 0.90% | |
183 | 37.32 | 137 | 10% | 57% | 0.00% | |
TPUB | 184 | 15.61 | 403 | 11% | 45% | 4.10% |
185 | 67.16 | 46,421 | 8% | 93% | 1.30% | |
MO | 186 | 51.23 | 100,718 | 7% | 395% | 4.10% |
IOSP | 187 | 43.81 | 1,087 | 10% | 51% | 1.40% |
SPLP | 188 | 17.88 | 502 | 24% | 36% | 0.00% |
189 | 15.46 | 908 | 9% | 64% | 0.00% | |
FF | 190 | 11.68 | 507 | 23% | 35% | 2.30% |
191 | 17.40 | 5,196 | 8% | 69% | 1.80% | |
192 | 9.78 | 634 | 11% | 47% | 0.00% | |
TIVO | 193 | 10.63 | 1,230 | 7% | 536% | 0.00% |
JEC | 194 | 43.57 | 5,541 | 11% | 45% | 0.00% |
THO | 195 | 62.68 | 3,351 | 9% | 64% | 1.80% |
SCLN | 196 | 9.44 | 494 | 8% | 93% | 0.00% |
WSTC | 197 | 31.36 | 2,704 | 8% | 109% | 2.90% |
SAVE | 198 | 62.34 | 4,574 | 9% | 58% | 0.00% |
HCLP | 199 | 29.86 | 1,111 | 11% | 45% | 8.60% |
CRESY | 200 | 13.14 | 659 | 11% | 44% | 0.00% |
Here is the Cross Reference List
ACHI | 515 | 22-May | #N/A | #N/A | #N/A | #N/A |
APEI | 412 | 22-May | 65 | 24.03 | 20% | 61% |
1,772 | 22-May | 53 | 16.46 | 20% | 67% | |
AGX | 522 | 22-May | 8 | 35.65 | 13% | 784% |
8,833 | 22-May | 15 | 32.09 | 12% | 342% | |
2,139 | 22-May | 44 | 44.07 | 13% | 97% | |
CA | 13,644 | 22-May | 45 | 31.33 | 9% | 486% |
CPLA | 656 | 22-May | 24 | 53.63 | 12% | 176% |
148,407 | 22-May | 41 | 29.26 | 9% | 342% | |
189 | 22-May | 28 | 21.33 | 10% | 665% | |
3,300 | 22-May | 36 | 66.09 | 9% | 413% | |
DEPO | 1,245 | 22-May | 2 | 20.76 | 21% | 2731% |
DHX | 447 | 22-May | 61 | 8.55 | 8% | 296% |
PLOW | 461 | 22-May | 72 | 20.73 | 12% | 69% |
ENTA | 749 | 22-May | 3 | 40.10 | 24% | 1586% |
EVOL | 101 | 22-May | 90 | 8.68 | 9% | 110% |
FLR | 8,520 | 22-May | 59 | 57.97 | 14% | 68% |
GME | 4,394 | 22-May | 22 | 40.80 | 14% | 139% |
GILD | 164,996 | 22-May | 27 | 111.71 | 10% | 487% |
GORO | 169 | 22-May | 66 | 3.11 | 20% | 60% |
ONE | 149 | 22-May | 52 | 3.11 | 15% | 71% |
IQNT | 598 | 22-May | 25 | 17.82 | 13% | 149% |
IDCC | 2,057 | 22-May | 12 | 57.26 | 13% | 363% |
KFY | 1,656 | 22-May | 54 | 32.87 | 9% | 201% |
LCI | 2,002 | 22-May | 46 | 55.39 | 12% | 114% |
LQDT | 316 | 22-May | 38 | 10.52 | 12% | 127% |
195 | 22-May | #N/A | #N/A | #N/A | #N/A | |
KORS | 12,389 | 22-May | 62 | 61.63 | 11% | 101% |
180 | 22-May | 23 | 40.06 | 13% | 159% | |
NSR | 1,492 | 22-May | 26 | 27.08 | 15% | 133% |
NSU | 811 | 22-May | 111 | 4.06 | 53% | 44% |
OUTR | 1,445 | 22-May | 63 | 78.12 | 12% | 73% |
1,089 | 22-May | 1 | 6.66 | 37% | 887017% | |
PETS | 330 | 22-May | 50 | 16.31 | 11% | 126% |
PPC | 6,864 | 22-May | 43 | 26.50 | 18% | 78% |
4,621 | 22-May | 47 | 22.99 | 10% | 150% | |
PSDV | 118 | 22-May | 5 | 4.01 | 13% | 3938% |
QCOM | 113,510 | 22-May | 49 | 69.51 | 9% | 339% |
RPXC | 907 | 22-May | 9 | 16.04 | 12% | 1813% |
SAIC | 2,414 | 22-May | 73 | 52.48 | 9% | 154% |
SLI | 157 | 22-May | 84 | 37.94 | 16% | 57% |
SPOK | 368 | 22-May | 42 | 16.79 | 10% | 171% |
STRA | 511 | 22-May | 37 | 46.54 | 17% | 94% |
TDC | 5,615 | 22-May | 80 | 39.57 | 8% | 282% |
TIVO | 1,023 | 22-May | 193 | 10.63 | 7% | 536% |
UIS | 1,048 | 22-May | 51 | 21.00 | 13% | 80% |
VEC | 271 | 22-May | 31 | 25.71 | 11% | 158% |
VIAB | 26,526 | 22-May | 33 | 66.80 | 10% | 270% |
VNCE | 656 | 22-May | 60 | 17.85 | 9% | 158% |
VA | 1,230 | 22-May | 64 | 28.49 | 12% | 82% |
As I often see, a few differences. ACHI just doesn't show up in the gurufocus list. If I put it in manually, it shows up #1 or #2. Investors should be very very cautious around ACHI anyway as their most recent finanical statements are as of 12/31/2013. MSB also never makes the gurufocus cut. If I put them in manually, they are #14. But they are a strange company as they are a trust and have a very unusual balance sheet. I am not really sure they belong in the traditional sense of Jake's Bubble Gum Shop.
TIVO is the strange one. The difference here is market cap. I have it at $1.2b, Yahoo is just over $1b. MFI, which usually agrees with me as a smidgen over $1 billion. I pulled up their most recent earnings release:
Weighted average common and common equivalent shares: Basic 96,287,902 Diluted 115,667,159
So at $10.37 a share, you can see my $1.2 billion as the diluted count x 10.37. Everyone else seems to be using basic share count, but my experience has been to always use diluted as that is a better measure of what it would cost to buy 100% of the company.
I am pretty sure MFI generally uses the diluted count, so who knows.
Final thought, I think VA looks very interesting. I may be a buyer on Tuesday.
1 comment:
Hi Marsh, do you have a WRDS compustat subscription? I've been thinking about doing my own research and was wondering a few things:
1. How much do compustat subscriptions cost?
2. What type of queries do you use with the database?
3. Can I take a look at your code that you use to compute and manage the data you look at?
Thanks!
Post a Comment