Hi Conrad, while waiting for Don to answer you. Have you looked at the TA indicator Williams %R. http://stockcharts.com/education/What/IndicatorAnalysis/indic_williamsR.html I believe the formula is what Don used, but don't use the negative sign. . As far as the midpoint that would be (High price- Low price)/2+ Low price. You could use the 20% and 80% as your bands, or some other percent. As I remember it Don's spreadsheet did not do anything when the stock went out of the bands. I think the hardest thing to determine will be the time period to use. I think one should look at a chart and add all the cycle's up and get a average and then divide by two . I think that would give you the proper period to use.