V.14:9 (375-378): SIDEBAR: Standard Error Bands

Sidebar: Standard error bands by Thom Hartle

Microsoft’s Excel comes with statistical formulas that can be used to create the standard error bands and the related indicators (sidebar Figure 1). The following example uses Microsoft stock price series; column A is the date. Column B is a numerical series for representing the X-axis for calculating the statistical indicators. We are not using the date column for the X-axis because the weekends will be counted in the calculation of the statistical indicators. The difference between Friday and Monday is three periods to Excel, not one, and therefore, the statistical indicators will use column B. In cell B2, enter the number “1,” then in cell B3, enter the following formula and copy down: =B2+1

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.

Take Control of Your Trading.

Professional Traders' Starter Kit

All these items shown below only $495!

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.)
S&C on DVD 10.25 plus next year's upgrade FREE!
5-year subscription to Traders.com Advantage.
5-year subscription to Working Money.
Free book selection.

Save up to 54% by purchasing today. Limited time offer. By purchasing today you also receive your choice of one volume from the Professional Traders' Series (Volumes 1-17 or Charting The Stock Market) for FREE!
NOTE: Use the "comment" field during checkout to tell us which book you would like to receive.

Click Here to Order

You save $502.31 plus the value of the book you choose over the regular price of these items. Offer ends soon.