Conrad, I think you are trying to decipher my highlowdemo spreadsheet. you can download it from the link in the header, I just now posted it. the spreadsheet is not based on AIM it is based on (William %R), %R = (Highest High - Close)/(Highest High - Lowest Low) * -100.
I did change it a bit though, I know that I used a positive 100. Also instead of going between 0 and 100 percent my formula goes between the the high and low percentages you set it up with. I think I used if statements for that. I did not come up with this idea on my own. In her book Practical Formulas for Successful Investing by Lucile Tomlinson, she talks about her compromise plan. If you can find it the book is worth reading.
Come see me at Systematic Investing group #board-966 lets talk formula plans.
