Stocks & Commodities V. 29:3 (8-9, 71): Letters To S&C by Technical Analysis, Inc.
Product Description
Letters To S&C by Technical Analysis, Inc.
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 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.
Marco Alves
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.
—Editor
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 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.
Marco Alves
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.
—Editor
FOR THOSE ORDERING ARTICLES SEPARATELY:
*Note: $2.95-$5.95 Articles are in PDF format only. No hard copy of the article(s) will be delivered. During checkout, click the "Download Now" button to immediately receive your article(s) purchase. STOCKS & COMMODITIES magazine is delivered via mail. After paying for your subscription at store.traders.com users can view the S&C Digital Edition in the subscriber's section on Traders.com.
| Take Control of Your Trading. |
| Professional Traders' Starter Kit |
| All these items shown below only $299.99! |
| Click Here to Order |