Posted 08 March 2010 - 08:09 PM
Will, right, so the logic does not apply, however, in the new summary below Feb 15 and 16 2007 renew the logic. Now, this summary is based on SPY high-low range, and takes into account Arbman's % range consideration. I am much more confident the spy data is correct, as my ES mini data base was adjusted for each rollover, so more of a continuous contract data base and I can not verify the accuracy or assess the percent range using that data. The sort criteria used was 0.004% which is just slightly above the % range for today. The time frame expands back to the inception of the SPY ETF, but I am not sure how it accounts for dividend adjustments, so the data will not be perfect. Most of the data of small ranges is concentrated from 1993 to 1996, then a long 5 year period with no hits. The data from late 2001 until 2007 would then be more interesting and reasonable for analysis. The Aug 2006 to the last occurrence in May 2007 is the most interesting to me, because beginning in Aug 2006 that was Bear Killer advance thru the Seasonal weak period. The issue going forward now, is do we continue to get additional small range days while price grinds a little higher. Good luck!!
Date High Low spy%range
3/16/93 45.44 45.31 0.002869124
3/23/93 44.94 44.81 0.002901138
3/30/93 45.22 45.09 0.002883123
4/14/93 45.06 44.91 0.003340013
4/16/93 45.03 44.88 0.003342246
5/6/93 44.56 44.41 0.003377618
5/12/93 44.59 44.44 0.003375338
5/25/93 45.13 45.03 0.002220742
6/3/93 45.5 45.34 0.003528893
6/14/93 45.19 45.03 0.003553187
6/17/93 45.19 45.03 0.003553187
6/21/93 44.63 44.53 0.002245677
6/22/93 44.66 44.56 0.002244165
6/25/93 44.91 44.75 0.003575419
7/12/93 44.97 44.84 0.002899197
7/19/93 44.75 44.59 0.003588248
7/21/93 44.81 44.66 0.00335871
7/23/93 44.72 44.56 0.003590664
7/28/93 44.94 44.78 0.003573024
8/5/93 45 44.84 0.003568243
8/6/93 45.06 44.91 0.003340013
8/10/93 45.22 45.13 0.001994239
8/11/93 45.31 45.16 0.003321523
8/13/93 45.16 45.09 0.001552451
8/19/93 45.81 45.72 0.001968504
8/20/93 45.81 45.66 0.003285151
8/23/93 45.75 45.63 0.002629849
8/27/93 46.25 46.16 0.00194974
9/1/93 46.59 46.41 0.003878474
9/13/93 46.56 46.44 0.002583979
9/16/93 46.34 46.16 0.00389948
9/17/93 45.91 45.75 0.003497268
9/24/93 45.88 45.72 0.003499563
9/27/93 46.28 46.13 0.00325168
9/28/93 46.31 46.16 0.003249567
10/4/93 46.22 46.09 0.002820568
10/11/93 46.25 46.16 0.00194974
10/12/93 46.25 46.19 0.001298982
10/13/93 46.25 46.16 0.00194974
10/18/93 47.03 46.88 0.003199659
10/21/93 46.69 46.53 0.003438642
10/27/93 46.53 46.41 0.00258565
10/29/93 46.88 46.78 0.002137666
11/19/93 46.38 46.22 0.003461705
11/24/93 46.5 46.34 0.003452741
11/26/93 46.59 46.47 0.002582311
12/2/93 46.56 46.41 0.003232062
12/6/93 46.94 46.78 0.003420265
12/7/93 46.91 46.78 0.002778965
12/8/93 46.84 46.78 0.001282599
12/15/93 46.63 46.47 0.003443082
12/16/93 46.66 46.56 0.002147766
12/20/93 46.66 46.5 0.00344086
12/21/93 46.56 46.41 0.003232062
12/23/93 46.84 46.69 0.003212679
12/29/93 47.16 47 0.003404255
1/6/94 46.84 46.69 0.003212679
1/13/94 47.31 47.16 0.003180662
1/14/94 47.5 47.38 0.002532714
1/17/94 47.47 47.31 0.003381949
1/18/94 47.53 47.38 0.003165893
1/20/94 47.5 47.38 0.002532714
1/25/94 47.25 47.09 0.003397749
1/28/94 48.03 47.88 0.003132832
2/2/94 48.28 48.09 0.003950925
3/7/94 47 46.84 0.003415884
3/23/94 47.06 46.91 0.003197612
4/26/94 45.34 45.19 0.003319318
6/2/94 46.05 45.89 0.003486598
6/9/94 46.03 45.89 0.003050774
6/10/94 46.2 46.08 0.002604167
6/13/94 46.19 46.03 0.003475994
6/16/94 46.47 46.3 0.003671706
7/15/94 45.48 45.33 0.003309067
7/19/94 45.56 45.38 0.003966505
7/22/94 45.41 45.25 0.003535912
7/25/94 45.45 45.31 0.003089826
7/26/94 45.42 45.31 0.00242772
8/3/94 46.23 46.09 0.003037535
8/5/94 45.84 45.66 0.003942181
8/8/94 45.94 45.78 0.003494976
8/15/94 46.48 46.31 0.003670913
8/17/94 46.73 46.58 0.003220266
8/18/94 46.56 46.41 0.003232062
8/22/94 46.44 46.28 0.003457217
10/12/94 46.75 46.58 0.003649635
10/17/94 47.06 46.91 0.003197612
10/31/94 47.59 47.47 0.002527912
1/3/95 45.84 45.69 0.003282994
1/5/95 46.11 45.95 0.003482046
1/9/95 46.09 46 0.001956522
1/24/95 46.75 46.64 0.002358491
2/7/95 48.31 48.14 0.003531367
2/9/95 48.3 48.13 0.003532101
2/13/95 48.47 48.33 0.002896752
2/16/95 48.69 48.5 0.003917526
2/17/95 48.63 48.44 0.003922378
2/21/95 48.53 48.42 0.002271789
3/9/95 48.59 48.42 0.003510946
3/20/95 49.63 49.47 0.003234283
3/28/95 50.42 50.23 0.0037826
4/3/95 50.23 50.06 0.003395925
4/5/95 50.61 50.42 0.003768346
4/12/95 50.8 50.61 0.003754199
4/25/95 51.48 51.31 0.003313194
6/23/95 55.03 54.84 0.003464624
7/3/95 54.61 54.47 0.002570222
8/4/95 56.08 55.92 0.00286123
8/7/95 56.28 56.08 0.003566334
8/30/95 56.42 56.22 0.003557453
8/31/95 56.5 56.3 0.003552398
9/6/95 57.36 57.22 0.002446697
9/7/95 57.39 57.25 0.002445415
9/11/95 57.81 57.64 0.002949341
9/20/95 58.78 58.55 0.003928266
10/4/95 58.28 58.11 0.002925486
10/6/95 58.58 58.39 0.003253982
10/11/95 58.09 57.88 0.003628196
10/13/95 58.86 58.63 0.003922906
10/16/95 58.56 58.34 0.003770998
10/24/95 58.84 58.63 0.003581784
11/3/95 59.25 59.06 0.003217067
11/6/95 59.22 59.02 0.003388682
11/17/95 60.2 60.02 0.002999
11/22/95 60.38 60.17 0.003490111
11/24/95 60.33 60.19 0.002325968
12/1/95 61.08 60.84 0.003944773
12/12/95 62.36 62.14 0.003540393
12/22/95 61.38 61.14 0.003925417
12/26/95 61.53 61.33 0.003261047
1/8/96 61.91 61.73 0.002915924
4/2/96 65.56 65.3 0.003981623
4/4/96 65.72 65.5 0.003358779
8/20/96 66.91 66.67 0.00359982
12/24/01 115.04 114.61 0.003751854
12/30/03 111.27 110.85 0.003788904
6/10/04 114.35 113.93 0.003686474
7/13/04 112.02 111.6 0.003763441
10/11/04 113.02 112.64 0.00337358
12/29/04 121.4 120.95 0.003720546
2/14/05 120.86 120.48 0.00315405
5/27/05 120.25 119.8 0.00375626
8/25/05 121.67 121.21 0.003795066
9/12/05 124.67 124.27 0.003218798
11/25/05 127.22 126.81 0.003233184
12/23/05 126.86 126.42 0.003480462
12/28/05 125.99 125.5 0.003904382
1/30/06 128.81 128.35 0.00358395
3/17/06 130.9 130.38 0.003988342
5/8/06 132.77 132.36 0.003097613
5/9/06 132.77 132.31 0.003476684
8/21/06 130.28 129.8 0.003697997
8/30/06 131.04 130.55 0.003753351
8/31/06 130.99 130.58 0.003139838
9/14/06 132.24 131.75 0.003719165
9/29/06 133.94 133.48 0.003446209
11/21/06 140.67 140.29 0.002708675
2/2/07 144.95 144.38 0.003947915
2/15/07 145.95 145.43 0.003575603
2/16/07 145.76 145.23 0.003649384
7-May-07 151.2 150.81 0.002586035
3-Jul-07 152.5 151.99 0.003355484