Hi Myst, I think the use of a price channel could work with the hilowinvestordemo.xls spreadsheet , for short term investing. The spreadsheet is already using a type of William %R formula. I am more interested in trying to find tools to determine long term hi/low price levels. One that I have read is the NAIC work sheets, from the book Starting and Running a Profitable Investment Club.
Come see me at Systematic Investing group #board-966 lets talk formula plans.
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.