There has been some good discussion on why Magic Formula Investing has not been "breaking away" from the broader markets, despite now having 7+ years. I commented that subsets have done well, specifically stocks with market caps > $1 billion and stocks that pay a 2.6% dividend or higher. Of course, in JG's back testing, he looked at smaller market cap stocks and they certainly did not drag down the results.
The official website only shows stocks down to $50m market cap, which is actually quite small. I am not a huge investor, but when I try to buy stocks that small, I almost feel like a market mover. You have to be careful and use limit orders.
Here is my typical list of caveats I produce when making my lists:
I decided to use this weekend to update my list. It is never too early to start looking forward to my next tranche (May 6th, 2014) as I approach new tranche. We had a surprising amount of snow here this past week, a bit over a foot.. 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 did add this time price to book value. The data is from FINVIZ. I would actually prefer price to tangible book, if anyone knows where to get that (I am too lazy to calculate it) then please let me know.
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, the dividend yields should definitely be verified as they come from Yahoo Finance which is not always reliable. The main financials (from Compustat) have seemed very reliable to me.
I am too lazy to re-type it, but you get the gist. It may take a while to run my workbook. Hotel wifi is not always blazing fast.
Ticker | Rank | Stock Price | Market Cap | Earnings Yield | ROIC | Dividend Yield | Country |
1 | 1.81 | 8 | 29% | 872% | 0.0% | Israel | |
AEZS | 2 | 1.28 | 38 | 53% | 157% | 0.0% | Canada |
ZA | 3 | 1.92 | 53 | 357% | 89% | 0.0% | China |
DVOX | 4 | 0.10 | 1 | 46% | 113% | 0.0% | USA |
5 | 3.66 | 10 | 135% | 89% | 0.0% | USA | |
LIWA | 6 | 5.14 | 154 | 3209% | 62% | 0.0% | China |
WSTG | 7 | 14.57 | 66 | 19% | 187% | 4.3% | USA |
NTE | 8 | 6.12 | 278 | 632% | 60% | 7.8% | China |
MKTY | 9 | 1.00 | 5 | 25% | 100% | 4.3% | USA |
SPRT | 10 | 2.46 | 134 | 18% | 184% | 0.0% | USA |
STV | 11 | 2.97 | 176 | 19% | 66% | 0.0% | China |
UNTD | 12 | 10.58 | 140 | 16% | 97% | 2.9% | USA |
NATR | 13 | 15.33 | 253 | 15% | 79% | 12.4% | USA |
RFIL | 14 | 6.73 | 58 | 15% | 71% | 4.2% | USA |
GSOL | 15 | 6.76 | 245 | 16% | 62% | 0.0% | Bermuda |
GPRC | 16 | 2.67 | 28 | 125% | 37% | 0.0% | China |
ATAI | 17 | 3.99 | 90 | 14% | 60% | 0.0% | China |
SPU | 18 | 1.92 | 51 | 561% | 33% | 0.0% | China |
MTEX | 19 | 18.51 | 49 | 11% | 111% | 0.0% | USA |
CO | 20 | 3.92 | 286 | 21% | 42% | 0.0% | Hong Kong |
SMTP | 21 | 6.46 | 20 | 10% | 536% | 0.0% | USA |
ZAGG | 22 | 4.06 | 128 | 23% | 40% | 0.0% | USA |
MNDO | 23 | 2.11 | 40 | 10% | 364% | 11.4% | Israel |
INTX | 24 | 6.37 | 115 | 14% | 52% | 0.0% | USA |
SBSA | 25 | 4.43 | 32 | 10% | 118% | 0.0% | USA |
UBIC | 26 | 4.99 | 85 | 12% | 59% | 0.0% | Japan |
CBRX | 27 | 6.90 | 77 | 14% | 47% | 0.0% | USA |
XNY | 28 | 1.30 | 74 | 436% | 27% | 0.0% | China |
AE | 29 | 67.10 | 283 | 19% | 37% | 1.0% | USA |
SLI | 30 | 24.20 | 101 | 17% | 41% | 0.0% | USA |
WLDN | 31 | 4.66 | 35 | 13% | 47% | 0.0% | USA |
CXDC | 32 | 4.78 | 229 | 43% | 29% | 0.0% | China |
GRO | 33 | 1.47 | 81 | 48% | 29% | 0.0% | China |
JCTCF | 34 | 10.00 | 31 | 19% | 35% | 0.0% | USA |
ISIG | 35 | 2.89 | 39 | 11% | 67% | 0.0% | USA |
CEDU | 36 | 6.85 | 64 | 32% | 26% | 0.0% | China |
LEE | 37 | 4.08 | 217 | 10% | 62% | 0.0% | USA |
NVEE | 38 | 7.97 | 33 | 12% | 40% | 0.0% | USA |
DFZ | 39 | 17.84 | 206 | 11% | 49% | 2.1% | USA |
SPAN | 40 | 19.65 | 58 | 12% | 41% | 2.7% | USA |
SGA | 41 | 43.41 | 250 | 11% | 45% | 4.1% | USA |
NEWT | 42 | 2.86 | 109 | 10% | 74% | 0.0% | USA |
AFOP | 43 | 11.55 | 222 | 10% | 77% | 1.3% | USA |
MSN | 44 | 2.16 | 59 | 59% | 22% | 0.0% | USA |
TGD | 45 | 1.59 | 231 | 22% | 25% | 0.0% | Canada |
CHKE | 46 | 14.01 | 118 | 9% | 216% | 2.9% | USA |
CGA | 47 | 3.00 | 95 | 53% | 21% | 0.0% | China |
CRWS | 48 | 8.56 | 85 | 11% | 38% | 4.0% | USA |
CTG | 49 | 16.79 | 284 | 10% | 60% | 1.2% | USA |
INTT | 50 | 3.99 | 42 | 12% | 34% | 0.0% | USA |
KGJI | 51 | 1.77 | 114 | 44% | 22% | 0.0% | USA |
JOEZ | 52 | 1.26 | 85 | 13% | 31% | 0.0% | USA |
BTH | 53 | 9.98 | 160 | 23% | 23% | 2.1% | USA |
GV | 54 | 2.08 | 53 | 18% | 25% | 0.0% | USA |
TGC | 55 | 0.45 | 27 | 19% | 24% | 0.0% | USA |
CLCT | 56 | 19.79 | 163 | 8% | 473% | 6.5% | USA |
ESP | 57 | 28.94 | 66 | 11% | 35% | 6.2% | USA |
VSEC | 58 | 44.18 | 236 | 12% | 31% | 0.8% | USA |
WILC | 59 | 8.08 | 105 | 21% | 23% | 0.0% | Israel |
ASFI | 60 | 8.42 | 111 | 13% | 30% | 0.0% | USA |
GSB | 61 | 2.42 | 47 | 8% | 507% | 1.7% | USA |
NCIT | 62 | 9.31 | 120 | 11% | 34% | 0.0% | USA |
UFPT | 63 | 25.65 | 182 | 11% | 36% | 0.0% | USA |
ZX | 64 | 2.73 | 141 | 69% | 18% | 0.0% | China |
UWN | 65 | 1.39 | 23 | 9% | 59% | 0.0% | USA |
PERI | 66 | 11.42 | 142 | 8% | 772% | 0.0% | Israel |
PHMD | 67 | 14.00 | 286 | 10% | 41% | 0.0% | USA |
TPI | 68 | 0.94 | 28 | 1135% | 17% | 0.0% | China |
EVK | 69 | 6.29 | 93 | 15% | 23% | 0.0% | USA |
LFVN | 70 | 1.33 | 149 | 8% | 201% | 0.0% | USA |
MTR | 71 | 22.50 | 42 | 8% | 112% | 0.0% | USA |
TLF | 72 | 9.51 | 97 | 12% | 28% | 0.0% | USA |
BOLT | 73 | 21.84 | 190 | 9% | 57% | 1.0% | USA |
HNH | 74 | 20.98 | 279 | 12% | 25% | 0.0% | USA |
DQ | 75 | 40.65 | 282 | 19% | 21% | 0.0% | China |
GENC | 76 | 10.78 | 103 | 30% | 18% | 0.0% | USA |
CIMT | 77 | 8.86 | 86 | 7% | 573% | 0.0% | Israel |
MAG | 78 | 24.88 | 83 | 10% | 36% | #VALUE! | USA |
CCF | 79 | 30.50 | 279 | 10% | 34% | 0.0% | USA |
DOM | 80 | 7.28 | 57 | 9% | 57% | 9.4% | USA |
MHH | 81 | 14.06 | 62 | 9% | 62% | 3.5% | USA |
HCKT | 82 | 6.08 | 199 | 9% | 57% | 0.0% | USA |
RLGT | 83 | 3.06 | 112 | 8% | 116% | 0.0% | USA |
MOBI | 84 | 4.53 | 135 | 7% | 239% | 0.0% | China |
CPIX | 85 | 4.76 | 87 | 10% | 31% | 0.0% | USA |
IKGH | 86 | 2.63 | 169 | 18% | 18% | 6.5% | Hong Kong |
VOC | 87 | 14.79 | 251 | 11% | 24% | 10.0% | USA |
CFI | 88 | 19.90 | 247 | 10% | 31% | 0.0% | USA |
FORD | 89 | 1.69 | 14 | 10% | 28% | 0.0% | USA |
OME | 90 | 11.08 | 230 | 18% | 18% | 0.0% | USA |
CRT | 91 | 30.77 | 185 | 7% | 129% | 7.9% | USA |
TRNS | 92 | 9.20 | 66 | 9% | 37% | 0.0% | USA |
CREG | 93 | 3.18 | 175 | 10% | 33% | 0.0% | China |
EVOL | 94 | 9.00 | 106 | 7% | 306% | 4.0% | USA |
CLNT | 95 | 5.63 | 20 | 56% | 15% | 0.0% | China |
INS | 96 | 2.26 | 20 | 9% | 45% | 0.0% | USA |
UTMD | 97 | 54.48 | 206 | 7% | 102% | 0.0% | USA |
STRT | 98 | 55.00 | 192 | 11% | 21% | 2.9% | USA |
GMAN | 99 | 6.42 | 124 | 13% | 19% | 57.9% | USA |
SIMO | 100 | 17.07 | 575 | 9% | 43% | 4.5% | Taiwan |
CNET | 101 | 0.96 | 21 | 28% | 15% | 0.0% | China |
LBMH | 102 | 3.83 | 204 | 7% | 212% | 0.0% | USA |
RICK | 103 | 11.37 | 112 | 11% | 20% | 0.0% | USA |
NUTR | 104 | 25.62 | 252 | 10% | 23% | 0.0% | USA |
AFAM | 105 | 29.00 | 271 | 8% | 48% | 0.0% | USA |
CSS | 106 | 27.27 | 255 | 13% | 17% | 1.0% | USA |
SVLC | 107 | 2.59 | 286 | 10% | 25% | 0.0% | Canada |
GURE | 108 | 2.44 | 95 | 2324% | 11% | 0.0% | China |
KEQU | 109 | 16.64 | 44 | 13% | 16% | 2.5% | USA |
SGOC | 110 | 3.56 | 61 | 22% | 14% | 0.0% | China |
SUTR | 111 | 1.88 | 78 | 37% | 13% | 0.0% | China |
GAGA | 112 | 3.20 | 141 | 23% | 13% | 0.0% | Hong Kong |
BAGL | 113 | 15.89 | 285 | 8% | 48% | 3.3% | USA |
SPCB | 114 | 5.70 | 56 | 6% | 123% | 0.0% | Israel |
RMCF | 115 | 11.57 | 75 | 8% | 41% | 3.9% | USA |
OFLX | 116 | 20.25 | 204 | 7% | 81% | 2.1% | USA |
ALN | 117 | 1.16 | 40 | 33% | 12% | 0.0% | China |
NVEC | 118 | 55.74 | 271 | 6% | 183% | 0.0% | USA |
MNTG | 119 | 5.25 | 149 | 11% | 18% | 0.0% | USA |
JBSS | 120 | 22.35 | 248 | 13% | 15% | 6.7% | USA |
CLRO | 121 | 9.23 | 87 | 8% | 31% | 0.0% | USA |
TACT | 122 | 11.57 | 101 | 8% | 34% | 1.8% | USA |
CVR | 123 | 38.00 | 37 | 11% | 17% | 1.7% | USA |
PFIN | 124 | 7.38 | 29 | 14% | 14% | 0.0% | USA |
MAMS | 125 | 5.40 | 69 | 5% | 273% | #VALUE! | United Kingdom |
MONT | 126 | 15.83 | 414 | 5% | 326% | 0.0% | China |
ROIA | 127 | 4.98 | 236 | 7% | 60% | 0.0% | USA |
VSR | 128 | 3.88 | 38 | 11% | 16% | 0.0% | USA |
HOFT | 129 | 15.40 | 166 | 11% | 17% | 0.0% | USA |
HWCC | 130 | 13.47 | 240 | 9% | 21% | 3.1% | USA |
ROIAK | 131 | 5.09 | 241 | 7% | 60% | 0.0% | USA |
PNTR | 132 | 9.35 | 52 | 7% | 44% | 0.0% | Israel |
SIF | 133 | 27.23 | 147 | 9% | 22% | 0.7% | USA |
CRAI | 134 | 20.90 | 212 | 12% | 15% | 0.0% | USA |
MOC | 135 | 2.04 | 20 | 12% | 15% | 0.0% | USA |
ONP | 136 | 2.44 | 45 | 27% | 11% | 1.3% | China |
RCMT | 137 | 6.43 | 80 | 10% | 17% | 0.0% | USA |
ADUS | 138 | 25.98 | 288 | 7% | 56% | 0.0% | USA |
VDSI | 139 | 6.76 | 265 | 7% | 36% | 0.0% | USA |
PMD | 140 | 18.64 | 100 | 6% | 63% | 1.3% | USA |
SLP | 141 | 5.97 | 98 | 5% | 223% | 2.5% | USA |
NATH | 142 | 50.21 | 232 | 6% | 82% | 0.0% | USA |
NLS | 143 | 8.32 | 262 | 6% | 85% | 0.0% | USA |
WEYS | 144 | 25.66 | 279 | 9% | 20% | 2.1% | USA |
BSTC | 145 | 22.16 | 153 | 5% | 152% | 0.0% | USA |
VIFL | 146 | 7.15 | 21 | 8% | 23% | 0.0% | USA |
AIRT | 147 | 11.57 | 28 | 12% | 14% | 2.6% | USA |
CCUR | 148 | 8.60 | 78 | 6% | 58% | 5.0% | USA |
COCO | 149 | 1.42 | 125 | 14% | 12% | 0.9% | USA |
UG | 150 | 28.18 | 130 | 5% | 141% | 3.5% | USA |
ARKR | 151 | 21.50 | 73 | 8% | 25% | 4.7% | USA |
DATE | 152 | 6.37 | 196 | 7% | 48% | 4.0% | China |
SKBI | 153 | 5.01 | 38 | 24% | 10% | 0.0% | China |
ALSK | 154 | 2.21 | 131 | 10% | 16% | 0.0% | USA |
UNTK | 155 | 1.64 | 31 | 7% | 31% | 0.0% | USA |
CMT | 156 | 13.98 | 104 | 10% | 15% | 0.0% | USA |
MRGE | 157 | 2.21 | 207 | 4% | 241% | 0.0% | USA |
HURC | 158 | 26.13 | 170 | 11% | 14% | 0.6% | USA |
SPNS | 159 | 7.23 | 302 | 4% | 284% | 0.0% | Israel |
ZIGO | 160 | 14.58 | 282 | 9% | 19% | 0.0% | USA |
DCO | 161 | 24.26 | 265 | 9% | 18% | 0.0% | USA |
BIRT | 162 | 5.87 | 301 | 5% | 182% | 3.8% | USA |
XRM | 163 | 16.10 | 258 | 10% | 16% | 0.0% | USA |
EDGW | 164 | 5.98 | 73 | 6% | 53% | 0.0% | USA |
KTCC | 165 | 10.04 | 110 | 11% | 13% | 0.0% | USA |
TWMC | 166 | 3.98 | 130 | 22% | 9% | 0.0% | USA |
TCX | 167 | 13.75 | 159 | 4% | 366% | 0.0% | Canada |
SALM | 168 | 8.45 | 214 | 7% | 30% | 0.0% | USA |
SCLN | 169 | 4.98 | 274 | 6% | 41% | 0.0% | USA |
CEMI | 170 | 3.30 | 32 | 8% | 24% | 0.0% | USA |
ESYS | 171 | 12.80 | 50 | 7% | 27% | #VALUE! | USA |
GORO | 172 | 5.47 | 292 | 6% | 44% | 7.3% | USA |
BORN | 173 | 2.37 | 61 | 19% | 9% | 0.0% | China |
DTLK | 174 | 13.75 | 277 | 6% | 39% | 0.0% | USA |
ZIXI | 175 | 4.43 | 279 | 4% | 380% | 0.0% | USA |
DIT | 176 | 89.00 | 66 | 11% | 13% | #VALUE! | USA |
JOUT | 177 | 23.04 | 229 | 10% | 15% | 0.0% | USA |
178 | 11.16 | 98 | 7% | 24% | 0.9% | USA | |
179 | 10.15 | 276 | 10% | 16% | 0.0% | USA | |
180 | 6.88 | 198 | 4% | 143% | 3.8% | USA | |
APWC | 181 | 3.18 | 44 | 117% | 6% | 0.0% | Taiwan |
NCFT | 182 | 16.76 | 331 | 5% | 61% | 0.0% | USA |
183 | 3.45 | 159 | 6% | 37% | 0.0% | USA | |
184 | 10.41 | 129 | 9% | 16% | 2.6% | USA | |
SKUL | 185 | 7.72 | 215 | 8% | 19% | 0.0% | USA |
186 | 35.54 | 268 | 9% | 16% | 1.7% | USA | |
187 | 6.11 | 138 | 7% | 22% | 0.0% | USA | |
188 | 2.28 | 15 | 9% | 15% | 3.5% | Israel | |
189 | 16.72 | 95 | 6% | 33% | 2.7% | USA | |
190 | 12.09 | 166 | 7% | 20% | 2.8% | USA | |
191 | 14.92 | 195 | 9% | 14% | 0.9% | USA | |
IGLD | 192 | 8.06 | 155 | 9% | 14% | #VALUE! | Israel |
BDL | 193 | 14.93 | 28 | 10% | 11% | 0.0% | USA |
ELSE | 194 | 3.96 | 14 | 9% | 15% | 1.0% | USA |
BTN | 195 | 4.74 | 67 | 11% | 10% | 0.0% | USA |
CVO | 196 | 3.18 | 274 | 7% | 22% | 0.0% | USA |
HIL | 197 | 4.71 | 186 | 8% | 16% | 0.0% | USA |
ARTX | 198 | 2.87 | 48 | 8% | 17% | 0.0% | USA |
NRCIB | 199 | 37.58 | 926 | 3% | 208% | 0.0% | USA |
AMCF | 200 | 1.75 | 17 | 11% | 8% | 0.0% | China |
Certainly an eclectic listing. I would strongly suggest caution on any and all on this list, especially anything in China (ZA for instance). Some names on here I have owned in the past (MTEX was on some of the older MFI portfolios as was CHKE). Wait, I also owned PRLS and WILC at one time.
No comments:
Post a Comment