October 1, 2013

Which S&P500 stocks to focus on when the SPX has 5 higher closes

Rob Hanna had a good post recently; titled What the String of 5 Higher Closes Under These Circumstances is Suggesting .  With mean reversion trading, you are expecting stock prices to snap back towards their mean, like a rubber band stretched too far.  But, sometimes, that rubber band can be stretched so far that it breaks (and therefore, won’t snapback).  For some time, I have been searching for how to tell when that rubber band is stretched so far that it is broken.  Rob’s post had several key concepts that might help us to solve this puzzle and possibly even be the foundation of a stock strategy.

Let’s walk through the steps I take when examining what looks to be good, solid research.  First, I replicate the results.  If I can do that (and you would be surprised how often I can’t), I then strive to understand the role of each of the rules, and how they affect the final results.  Given Hanna’s research quality, I expected to replicate his results and I did.

The results for this post are from 2001 to the present. The date range was selected because that is when I have historical S&P500 stock data from.

Hanna’s Rules

  • SPX closes up exactly 5 days in a row
  • Close is greater than the 200 day moving average
  • Close is not at a 50 day high of closes
  • Buy on close
  • Sell X day later

We will look at 5, 10, and 15 day returns. First we need a base line to compare future results against.  Here are the average returns of the SPX over these hold times with no other filters.

SPXUp5-1

Right off the bat, it’s obvious that adding the MA200 greatly improves the base line results.  Next, let’s see how adding the SPX “exactly N up days” changes the results.

SPXUp5-2

For all trades in this set, the SPX “exactly up 5 days” are best.  The rubber band appears broken with momentum already up.  The results are between 2.0 times to 3.3 times the base line results.

Not at a N day high

This is the rule I thought would make a big difference.  I tried values of 20, 50 and 80 for N.

SPXUp5-3

And this rule really popped the results.  Not being at a 50 day high, the 5 day hold returns are now 5.7x the baseline, while the 10 day hold and 15 day hold returns are 3.5x and 2.6x the base line, respectively.  The short term momentum seems strong.  However, one caveat we must place with these results is the small sample size of only 17 trades.  This is substantially less than I would like to see. But don’t forget what the goal is here: we are looking for a concept that might transfer well into a stock strategy.  And the concept looks solid.

Testing on S&P500 stocks on SPX signal days

Next we want to see how the S&P500 stocks perform on those 17 signal days.  The focus will be on the 5 day hold because that performed the best with respect to the base line.  On the days that the filter criteria are met for the S&P, we buy the 500 stocks at the close and then hold them for 5 days, selling at the close.

SPXUp5-4

As expected, the results are close to the SPX results of .92%.

Now on to the big question for today’s post.  Can we find a ranking method for the individual stocks that will increase the results further?  I’ve tried many ranking methods (as seen in the table below), and I am open to other ranking method suggestions.

SPXUp5-5

From 425 trades per ranking method, the two highlighted methods stand out.  One thing to look for in a good ranking method is above average results on one end and below average results on the other.  The first, ‘High HV100’ does not surprise me because high HV stocks tend to have higher short term returns.  The increase of the avg. % p/l to 1.52% is nice.  The method that surprised me was the ‘Low ADX10’ ranking.  It has a high win rate and ranking by ‘High ADX10’ produces one of the worst results.  I have no good theory on what is going on here.  Statistical anomaly? Does anyone have a theory that might explain this?

In the next post, we will take Rob Hanna’s concept and apply it to stocks directly without waiting for the SPX to signal.  Maybe we’ll have the start of a short-term momentum system!

Backtesting platform used: AmiBroker. Data provider:Norgate Data (referral link)

Click Here to Leave a Comment Below

Rob Hanna - October 1, 2013 Reply

Nice work Cesar!

I suspect the low ADX 10 securities did not benefit as much from the 5-day run-up. They may have chopped around while those with the high ADX 10 are more likely to have used up much of their energy. The low ADX10 securities can play catch up, or break out of their consolidation, or jump on the momentum train, or whatever you want to call it at that point. If that is the case, other ways you might look to segment it, which could confirm this would be:

1) Low vs. high absolute 5-day % price change.
2) Low versus high 5-day range
3) Low versus high 5-day ATR
4) Perhaps use an ATR ratio to baseline it. So 5-day ATR / 50-day ATR, to see which stocks are “coiling” the best versus their “normal” behavior.
5) Of course the high HV100 suggests you want more volatile stocks. So you may need a 2-step filter. A high HV100, but a low 5-day HV / 100-day HV (or ATR). In other words, typically volatile stocks that have the ability to explode, and have coiled while the market has run higher over the last week.

Anyway, nice work. And I look forward to reading your blog going forward.

Best,
Rob Hanna

My quest to find the best performing S&P 500 stocks after several up days » Alvarez Quant Trading - October 14, 2013 Reply

[…] « Which S&P500 stocks to focus on when the SPX has 5 higher closes […]

Leave a Reply: