V. 10:11 (498-498): Traders' Tips by Technical Analysis, Inc.

V. 10:11 (498-498): Traders' Tips by Technical Analysis, Inc.
Item# \V10\C11\TRADTIP.PDF
Availability: In Stock

Product Description

Traders' Tips by Technical Analysis, Inc.


Here's a method to calculate and plot a trendline from the data in a spreadsheet. A trendline is a straight line that is a plot of rise over run. The run calculation is easy to do because the run is equidistant between the values on the X-axis (time). Finding the rise requires identifying the difference between the two highest points (for a downward trendline) or the two lowest points (for an uptrend). Excel can locate these values. Our example will be for a downward trendline (Figure 1). The first step is to plot the data (such as a close-only chart) so you can estimate where the high or low values may be. In our example, using the closing price of the Dow Jones Transportation Average (DJTA), the high closing value appears to be near early June. In my spreadsheet, this is in the range of cells B35 to B53. Return to the spreadsheet and use the following formula for returning the highest value from a range of cells.

*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!
  • 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 Traders.com Advantage.
  • 5-year subscription to Working Money.
  • Free book selection.
  • Click Here to Order