Thursday, April 26, 2007

More Formula Testing

I created a worksheet to automatically pull in the IS and BS from Fidelity Compustat for a given stock symbol. Worked great. I came very close on 43 of the 46 stocks to matching the MFI calculations. The next step will be to work with a Perl programmer to automate it. Then we'll see how many stocks in the top 100 between the lists match. Even if it isn't one for one (which I don't expect) I do think this will be a feasible alternative. Below is the list comparing the 46 or 47 stocks (three stocks: FDG, TGB and TCK... all Canadian errored out).

Stock Market Cap MFI EY MFI ROIC Date My EY My ROIC
AEO 6,713.96 10% > 100% 24-Apr 10% 122%
ASPV 801.30 24% > 100% 24-Apr 24% 388%
AVCI 115.15 41% > 100% 24-Apr 45% 460%
AXCA 784.59 10% > 100% 24-Apr 10% 155%
BBSI 285.51 10% > 100% 24-Apr 9% 142%
CVCO 232.78 11% 75 - 100% 24-Apr 11% 132%
CLST.PK 54.30 16% 50 - 75% 24-Apr 38% 108%
EPIQ 429.32 12% > 100% 24-Apr 18% 329%
ENDP 3,985.32 9% > 100% 24-Apr 9% 583%
FTAR.OB 186.21 51% 75 - 100% 24-Apr 52% 95%
FCX 13,661.49 19% 75 - 100% 24-Apr 13% 14%
FTO 3,714.18 16% 75 - 100% 24-Apr 15% 87%
GVHR 476.50 10% > 100% 24-Apr 12% 208%
JH 1,355.86 9% > 100% 24-Apr 9% 163%
HOC 3,445.14 11% 75 - 100% 24-Apr 11% 89%
IVAC 512.33 12% > 100% 24-Apr 11% 156%
JAKK 686.09 15% 75 - 100% 24-Apr 15% 98%
KSWS 1,018.83 13% > 100% 24-Apr 12% 149%
KSW 39.73 18% > 100% 24-Apr 19% 1885%
KG 5,081.86 14% > 100% 24-Apr 14% 199%
KFY 1,017.81 10% > 100% 24-Apr 11% 361%
MTEX 384.00 12% > 100% 24-Apr 13% 107%
NATH 87.26 10% > 100% 24-Apr 11% 148%
NOOF 208.03 11% > 100% 24-Apr 12% 185%
NXG 918.39 20% 50 - 75% 24-Apr 19% 72%
OPTI.OB 64.57 14% > 100% 24-Apr 14% 42867%
OVTI 744.50 13% 75 - 100% 24-Apr 14% 54%
OPMR 215.58 22% > 100% 24-Apr 143% 1376%
PDII 132.48 42% 50 - 75% 24-Apr 54% 66%
PWEI 389.34 27% 75 - 100% 24-Apr 28% 92%
PACR 1,002.54 11% > 100% 24-Apr 11% 140%
PNCL 375.82 20% 75 - 100% 24-Apr 20% 92%
PBH 656.07 9% > 100% 24-Apr 9% 308%
PCU 24,396.09 12% 75 - 100% 24-Apr 13% 73%
SHOO 654.29 14% 75 - 100% 24-Apr 14% 94%
THO 2,335.28 11% 75 - 100% 24-Apr 12% 76%
USMO 577.97 13% 75 - 100% 24-Apr 14% 78%
UNTD 936.41 10% > 100% 24-Apr 11% 256%
EGY 333.34 25% > 100% 24-Apr 28% 105%
VCI 911.24 12% 75 - 100% 24-Apr 12% 105%
VALU 490.12 9% > 100% 24-Apr 9% 741%
VGR 1,052.22 10% > 100% 24-Apr 10% 138%
VRGY 1,441.11 10% > 100% 24-Apr 10% 266%
VPHM 1,093.99 12% > 100% 24-Apr 12% 3494%
WNR 2,497.26 14% > 100% 24-Apr 12% 118%
WMCO 125.92 12% 75 - 100% 24-Apr 13% 96%

Note also there is a 2 day timing difference as my calcs were done today and MFI calcs were at close of 4/24.

Not exactly an uplifting day for me. I have now fallen about $4k behind the benchmark. All 3 of my stocks that reported yesterday (TGIS, BBSI and BLDR) were down sharply. GVHR also reported this morning before the bell and was lukewarm as well (Gevity HR Q1 earnings decline).

WSTG (my newest stock) reported their earnings this evening (Wayside Technology Group, Inc. Reports Fifteenth Consecutive Quarter of Double Digit Revenue Growth). They were spectacular! One thing about MFI, one or two stocks can really make a difference (like PNCL). Hopefully this will stem the tide. Their income before tax increased from $991K to $1.65M. That is a huge jump. They were up 3.5% in after dark trading.
Posted by at

1 comment:

Unknown said...

I've fallen behind the benchmark, too, as the Dow has been rocking. My benchmark is the S&P, though, because I've made a deliberate choice to focus more on midcaps to largecaps. I do have a limited # of small caps thrown in, though.

Another, non quantified observation: when the dow dropped 400 points, my MFI hung in there for 2 maybe 3 days. Then it plunged below the benchmark. Seems like you get a little bit of a breather before you get hit along with the rest of the market.

I'll try to remember this if my retirement kitty is in MFI and there's a huge correction. I'm selling, wifey!

I'll have to wait 25 years, ha-ha. Maybe even sooner if this MFI thing works.

10:00 PM

Post a Comment

Subscribe to: Post Comments (Atom)