Stocks & Commodities V. 29:3 (8-9, 71): Letters To S&C by Technical Analysis, Inc.

Stocks & Commodities V. 29:3 (8-9, 71): Letters To S&C by Technical Analysis, Inc.
Item# V29C03-037LETTPDF
Availability: In Stock

Product Description

Letters To S&C by Technical Analysis, Inc.



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 in the Subscriber Area. Login requires your subscriber number and last name.


*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 users can view the S&C Digital Edition in the subscriber's section on

Take Control of Your Trading.
Professional Traders' Starter Kit
All these items shown below only $299.99!
  • 5-year subscription to Technical Analysis of STOCKS & COMMODITIES, The Traders' magazine. (Shipping outside the US is extra. Washington state addresses require sales tax based on your locale.)
  • 5 year access to S&C Archive
  • 5 year access to S&C Digital Edition
  • 5-year subscription to Advantage.
  • 5-year subscription to Working Money.
  • Free book selection.
  • Click Here to Order