V.12:1 (11-19): SIDEBAR: DEMA1 EXCEL SPREADSHEET by Technical Analysis, Inc.
Product Description
DEMA1 EXCEL SPREADSHEET by Technical Analysis
This Excel spreadsheet (Figure 4) presents the calculation of the DEMA1 (column G) of the weekly closing price of the NASDAQ (column D). We will be using the regression coefficients for the initialization of the single exponential moving averages (column E) and the double exponential moving averages (column F). Column A is the date, column B is the high and column C is the low for the weekly NASDAQ. The first step in calculating DEMA1 will be calculating the linear regression of the closing price to determine the v (slope) and the u (y-intercept) of the regression line.
This Excel spreadsheet (Figure 4) presents the calculation of the DEMA1 (column G) of the weekly closing price of the NASDAQ (column D). We will be using the regression coefficients for the initialization of the single exponential moving averages (column E) and the double exponential moving averages (column F). Column A is the date, column B is the high and column C is the low for the weekly NASDAQ. The first step in calculating DEMA1 will be calculating the linear regression of the closing price to determine the v (slope) and the u (y-intercept) of the regression line.
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 |