Blog

When $SPY 20 day range goes below 2%

ENTER YOUR EMAIL &
GET POWERFUL IDEAS & MARKET INSIGHTS
DELIVERED DIRECTLY TO YOUR INBOX

Here is an interesting article which analyzes how the SPY performs after it consolidates in a tight (under 2%) trading range for more than 20 sessions:
Summary: ( 92% ) times $SPY closed higher over the next 5 trading day at some close , when $SPY 20 trading day’s range contracts below 2% , since Mar 1993 , 
All data as of Wed’s (1/22/14’s) close:
With $SPY 20 day range as in (20 day intra high – 20 day intra low ) / (Average (20 day intra high ,20 day intra low ) printing a value of 1.97% -> (184.94-181.34)*100/(184.94+181.34)/2

below the previous  instances of $SPY 20 day rage less than 2% , since Mar 1993 , and the next 1/2/3/4/5/10/20 trading days ..
Exit#Wins% WinsAvg%Med%Avg Win %Avg Loss %Pay OffMax Loss %
t+113861.50.160.160.47-0.341.39-1.30
t+213969.20.350.560.70-0.451.57-1.31
t+3131076.90.480.600.80-0.601.34-1.32
t+4131184.60.550.520.76-0.651.18-1.10
t+5131184.60.560.460.79-0.721.10-1.10
t+10131076.91.131.131.65-0.602.75-1.72
t+20131292.31.981.872.16-0.1316.62-0.13
Swing High131292.30.330.440.45-1.100.41-1.10

that Swing High, column , is made with the assumption that, one goes long at close and exits at first higher close than current close in the next five trading days , or exit at the end of the fifth trading day with loss
12/13  ( 92% ) times $SPY closed higher over the next 5 trading day at some close , when $SPY 20 trading day’s range contracts below 2% , since Mar 1993 , 
Whilst the sample size is too low , suggests an upside in the next trading days !!
here are the $SPY 20 day rage less than 2% , since Mar 1993  and the next 1/2/3/4/5/10/20 trading returns ,

Date20 Day Range %t+1t+2t+3t+4t+5t+10t+20
22-Jan-141.97??????????????
11-Jan-071.960.760.560.60.260.46-0.021.25
10-Jan-071.960.441.21.011.050.70.512.46
15-Aug-051.97-1.3-1.31-1.32-1.1-1.1-1.72-0.13
23-Dec-931.870.520.710.580.18-0.340.581.35
22-Dec-931.81-0.060.460.650.520.12-0.061.48
21-Dec-931.940.680.621.141.331.210.621.89
13-Aug-931.930.550.91.451.451.522.482.9
12-Aug-931.930.160.711.071.611.612.713
11-Aug-931.93-0.29-0.130.420.771.322.351.8
10-Aug-931.930-0.29-0.130.420.772.291.61
09-Aug-931.93-0.06-0.06-0.35-0.190.351.131.87
06-Aug-931.670.550.490.490.190.361.883.14
05-Aug-931.670.130.680.620.620.321.943.18
02-Feb-931.431.061.51.431.430.73-2.031.8
01-Feb-931.140.21.271.71.631.63-1.771.57
avg0.220.490.620.680.640.731.94
med0.20.620.620.620.70.621.8
%wins67738087876793

highlighted in the red is the only instance ( 15th Aug 2005) , when $SPY is not able to produce a higher close in the next five days ( a loss of 1.1% , and failed to close higher in the next 20 days ( a loss of -0.13% )

Source: Here