STOCKS & COMMODITIES magazine. The Traders' Magazine

Register or Log In — Traders.com and STOCKS & COMMODITIES magazine

Sidebar  |  SEP 1996

SIDEBAR: Standard Error Bands - Technical Analysis, Inc.

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

by Technical Analysis, Inc.

Technical Analysis of STOCKS & COMMODITIES
The Traders’ Magazine since 1982
has had over 1,226,237 subscribers from 174 different countries.
37,000 Page Traders’ Archive for $89.99

NOT A SUBSCRIBER?

To continue reading, sign-up for trial access to Traders.com and the S&C Archive37,000 pages of trading ideas!




After verifying your email address, you will have limited access to the S&C Archive, as well as access to a Digital Edition of S&C, and access to Traders.com Advantage and Working Money for 30 days.



DEPARTMENTS: Advertising | Editorial | Circulation | Contact Us | BY PHONE: (206) 938-0570

PTSK — The Professional Traders' Starter Kit
Home — S&C Magazine | Working Money Magazine | Traders.com Advantage | Online Store | Traders’ Resource
Add a Product to Traders’ Resource | Message Boards | Subscribe/Renew | Free Trial Issue | Article Code | Search

Copyright © 1982–2024 Technical Analysis, Inc. All rights reserved. Read our disclaimer & privacy statement.