Letters To S&C  |  MAR 2011

Letters To S&C

The Clear meThod Editor, 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 Sp x.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. Ma r c o al v e s

by Technical Analysis, Inc.