Letters To S&C by Technical Analysis, Inc.
THE CLEAR METHOD
It was with great interest that I read Ron Black’s article in the September 2010 issue of your magazine, “Getting Clear With Short-Term Swings.” The concept is simple and signals are easy to follow (the best starting point for any indicator!).
In the article, the author provided the EasyLanguage code for displaying the swing line. But since many readers want to implement indicators using a spreadsheet, I decided to translate the Clear method to Excel.
I am providing a spreadsheet with the Clear method applied to the S&P 500 (“Clear Spx.xls”) as well as a Word document explaining how to enter formulas in Excel. I have contacted the author, Ron Black, as a check, and he has now also contributed a macro code listing (SwingLine.xls) for those who may want to use it.
I hope this helps those readers who rely on Excel to exercise technical analysis.
Thank you for providing this Excel spreadsheet translation to share with other readers.
Readers will find these Excel files (Clear Spx.xls and SwingLine.xls) and Word file (“Implementing the Clear Method_Excel(R).doc”) available at our website at www.Traders.com in the Subscriber Area. Login requires your subscriber number and last name.