Tuesday, January 08, 2013

Dividend Portfolio Staying Even

After 5 trading days into 2013, my dividend portfolio is in a dead heat with the Russell 3000. While we always want to "win", I think we can all agree is that the most important thing is not to lose.

My laggards so far have been the refining companies, HFC and MPC.  I am not sure what to do with them.  I do know from past (and at time painful) experience, that refinery stocks can be kind of boom and bust.  I did read HFC's presentation on why they are well-positions (), so I guess for the time being I am drinking the Kool-Aid.  I certainly would like to hold them into February as that is when I bought them a year ago.

Stock Start Last Week Current QTD Change Weekly Change
AAPL         532.17             532.17           525.31 -1.3% -1.3%
BHK           14.90               15.04              15.56 4.4% 3.5%
CIM              2.61                  2.61                2.78 6.5% 6.5%
CSCO           19.65               19.65              20.31 3.4% 3.4%
CSQ              9.81                  9.88              10.34 5.4% 4.7%
FCX           34.20               34.20              34.97 2.3% 2.3%
FSC           10.42               10.42              10.80 3.6% 3.6%
HFC           46.55               46.55              43.52 -6.5% -6.5%
INTC           20.62               20.62              21.09 2.3% 2.3%
JPM           43.97               44.27              45.80 4.2% 3.5%
JQC              9.65                  9.65                9.89 2.5% 2.5%
KMF           28.79               28.79              29.89 3.8% 3.8%
MPC           63.00               63.00              61.55 -2.3% -2.3%
O           40.21               40.21              41.93 4.3% 4.3%
OIBAX              6.58                  6.58                6.58 0.0% 0.0%
PGR           21.10               21.10              21.98 4.2% 4.2%
PRE           80.49               80.49              82.34 2.3% 2.3%
PVD         104.00             104.00           110.60 6.3% 6.3%
SAI           11.32               11.32              11.86 4.8% 4.8%
SLCA           16.73               16.73              18.59 11.1% 11.1%
STO           25.04               25.04              25.15 0.4% 0.4%
VIVHY           22.81               22.81              21.79 -4.5% -4.5%
Totals 2.3% 2.2%
IWV           84.68               84.68              86.54 2.2% 2.2%

Not much else to say!

Monday, January 07, 2013

Seems Like Can Advance

SLCA, one of my dividend holdings, had an eye brow raising day today.  I can not say I understand it, but they were up about 10% on no news that I could see.  Hmm, let me try some of the newer tools in my tool kit.  I am going to search Twitter, to see if anyone is saying anything. Hang on a moment.

Nope.  People commented on it,  but no one had a reason.  As long as I am here, my divvy portfolio was essentially flat, even with out-sized SLCA move. My MFI portfolios were down about a percent, as WU, UIS and VIAB were all down about 2%.  My "all other" portfolio actually fared pretty well as SD (probably a short term trade) was up 3.5% and GNW was up a couple of cents.

Off to watch my Hoosiers play Penn State!

Sunday, January 06, 2013

More Magic Formula Statistics

Statistics 101

Nice Sunday morning here in the Nutmeg state.  My New Year's diet is going okay so far (thanks for asking).  I started the NY at 186.2 pounds and weighed in this morning at 184.0.  I did want to eat some comfort food during the dreary NFL playoff games last night, but resisted.

I continue the blog I started yesterday looking at returns by varying variables in my MFI Tracking Database, which essentially has 50 MFI stocks years by month going back to January 2006.  Each month is a pull from the official MFI website of top 50 stocks over $100m in market cap.

Results by Number of Letters in Ticker

I know this one seems like a total farce, but I ran it once before and it was actually a pretty good predictor.


Letters in Ticker Avg Percent Change Stock Count
                           2 15.7%                  142
                           3 11.7%               1,523
                           4 1.8%               2,434
                           5 5.1%                    18
                           7 -53.6%                    37
                           8 -66.1%                    13
 Grand Total  5.2%               4,167

So, I actually find that a bit stunning.  Of course 7 or 8 letters probably means it is traded on pink sheets or OB. Four letters are generally Nasdaq stocks, though that seems to be changing a bit (think FB).  I wondered if the poor performance by 4 letter tickers was China driven, so table below excludes China, Taiwan and South Africa:


Letters in Ticker Avg Percent Change Stock Count
                    2 15.7%                  142
                    3 13.1%               1,485
                    4 2.4%               2,340
                    5 5.1%                    18
                    7 -46.2%                    27
                    8 -66.1%                    13
 Grand Total  6.3%               4,025

Hmm. That isn't it.  Interesting, isn't it? Hard to think it is just "luck" as the spread is large and it is a lot of stocks.  How about if we also filter out small stocks and just go greater than 700m?

 
Letters in Ticker Avg Percent Change Stock Count
                         2 14.0%                  122
                         3 11.4%               1,020
                         4 0.6%                  809
                         5 10.3%                    11
                         8 -74.2%                    11
 Grand Total  6.7%               1,973

Do not know about you, but two or three letters are looking better to me.

Buy Stock Purchase Month

I generally start my portfolios near the end of the month (say December 31st).  Here are the results by purchase month to see if there is seasonality (though not sure why there would be as we hold for a year).


Row Labels Average of Percent Change
                    1 3.6%
                    2 11.0%
                    3 8.1%
                    4 5.3%
                    5 7.4%
                    6 12.3%
                    7 -2.7%
                    8 1.5%
                    9 3.7%
                  10 9.1%
                  11 0.8%
                  12 7.5%
 Grand Total  5.2%

Hmm, again more spread than I would expect.  Let us pull out China, Taiwan and South Africa.


Row Labels Average of Percent Change
                    1 4.6%
                    2 12.3%
                    3 9.5%
                    4 6.7%
                    5 8.9%
                    6 14.3%
                    7 -1.8%
                    8 2.1%
                    9 4.8%
                  10 10.1%
                  11 1.5%
                  12 8.0%
 Grand Total  6.3%

Looks like June and February are the best times to start. Sadly, I can not do by dividend yield as I only stared capturing that in January 2010.  If people have an idea how I can backfill (I only flagged greater or smaller that 2.6% before then), let me know.


Saturday, January 05, 2013

Magic Formula Statistics

Some Random Statistics 

As a a person with a degree in mathematics, I always enjoy watching movies where they are in a professor's classroom and they want to put some impressive formulae on the blackboard.  Always a lot of greek notation, integrals (which always look cryptic) and exponents.

I have been involved with MFI now for almost seven years.  Stunning!  While I have enjoyed keeping this blog, I can honestly say I have not had much of a financial payout from TLBTBTSM.  Hard to say if we have just been in an unusual bad streak or whether the formula as published doesn't work.

I have kept a data base that is essentially what JG does in his book where he back-tested for 17 years.  My database has been real time (not back testing) where I track 50 MFI stocks every month and hold for a year.  Now this is not a full-time job for me and I do not have a classroom of MBA students who can help with some of the heavy lifting.  So I am sure my analysis is not perfect, though I do believe it is directionally correct.  The biggest risk in my analysis is when something material happens to a company during the one year holding period, such as a spin-off, extraordinary dividend or a split.  I do look at stocks that perform poorly to try to spot such instances, but it is highly probably I have missed a few (my approach with Yahoo would catch the extraordinary dividend, assuming they catch it).

Results by Market Cap Percentile

Overall, the average MFI stock has gone up 5.2% per year. In the same time period, the Russell 3000 has arithmetically averaged 6.1% per year.  I took all the stocks in my list and grouped them by market cap decile.  Now I have done this on a raw basis (as I am a bit lazy).  The appropriate way to do it would be to somehow inflation-adjust it as over time you would expect market caps to increase.


Percentile Average of Percent Change Min of Mkt Cap Max of Mkt Cap2
                    1 9.2%                6,012               262,943
                    2 5.7%                2,660                   6,953
                    3 6.4%                1,419                   2,870
                    4 9.2%                   947                   1,573
                    5 3.0%                   696                   1,021
                    6 2.9%                   484                     781
                    7 2.8%                   349                     558
                    8 4.3%                   257                     397
                    9 6.4%                   169                     289
                  10 3.0%                    25                     204
 Grand Total  5.2%                    25               262,943

So the table is read in that a "1" are the largest 10% of market cap stocks in my data, running from 6b to Microsoft or Apple.  The obvious conclusion looking at this table is that if you only picked from the top 50 greater than 100m list (my starting point) and then went with market cap > 947m,  you would juice your return to 7.6%.  This why in my re-boot of MFI in August of 2012, I am focusing on $500m+ stocks.

Results by Country

As readers/followers know, China has been problematic for MFI.  I have attempted to pull in stock by country.  Again, as I had thousands of entries and some stocks that do not exist any more, I did the best I could.


Row Labels Average of Percent Change Count of Stock
Bermuda 1.3% 1
British Virgin Islands 26.6% 2
Canada 10.1% 176
Cayman Islands 54.2% 26
China -28.1% 104
Ireland -1.4% 28
Israel 22.2% 30
Netherlands 42.2% 18
Russia 152.5% 9
South Africa -14.1% 14
Switzerland 16.6% 18
Taiwan -27.5% 24
United Kingdom 12.7% 8
USA 5.1% 3,709
Grand Total 5.2% 4,167

China has been very poor.  However, it is (to me) very interesting to note that if you juts went with US stocks, you'd actually do worse than average.  So the maximum approach would be to exclude China, Taiwan and South Africa.  That would take you to 6.3%, which is frankly just average.  So my conclusion is that country code is not a great way to differentiate.

By First Letter

 Obviously, it is silly to think the first letter is an predictor of results.  But here it is for grins:


Row Labels Average of Percent Change Count of Stock
A -3.3% 315
B 5.0% 120
C 2.8% 425
D 23.3% 196
E 5.7% 219
F 16.7% 155
G 5.0% 175
H 6.0% 169
I 8.2% 152
J -6.3% 69
K 2.2% 163
L -0.9% 124
M 11.3% 260
N 4.9% 153
o -6.4% 60
P 4.1% 351
Q 61.3% 33
R 0.8% 101
S -0.7% 207
T 10.7% 221
U -0.4% 214
V 4.6% 209
W 0.1% 55
X -29.8% 14
Y -97.2% 1
Z 15.2% 6
Grand Total 5.2% 4,167

D has been a great pick!

I will look at letters in ticker and by dividend yield in my next post!  Cheers.