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.