## Article Archive For Keyword: Excel

ARTICLE SYNOPSIS...Constructing an Excel spreadsheet requires that each step of the ADX computation be stated. Shown are each of the calculations.

• ### SIDEBAR: DEMA1 EXCEL SPREADSHEET by Technical Analysis, Inc.

ARTICLE SYNOPSIS...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

• ### SIDEBAR: EXCEL FAST FOURIER TRANSFORMS, DECEMBER COPPER DATA by Technical Analysis, Inc.

ARTICLE SYNOPSIS...EXCEL FAST FOURIER TRANSFORMS, DECEMBER COPPER DATA by Technical Analysis, Inc. Here is the layout for preprocessing data and running a fast Fourier transform (FFT) in Excel. Column A of the spreadsheet (sidebar Figure 8) is the date column. Our first d

• ### SIDEBAR: EXCEL SPREADSHEET Thom Hartle, Editor

ARTICLE SYNOPSIS...EXCEL SPREADSHEET --Thom Hartle, Editor The Excel 3.0 spreadsheet presented here in sidebar Figure 1 shows the indicators described in ""Volume variations."" The daily high, low and close of the Standard & Poor's 500 index along with the daily total NYSE

• ### SIDEBAR: Filtering in Excel by Scott Barrie

ARTICLE SYNOPSIS...V.13:07 (286): SIDEBAR: Filtering in Excel by Scott Barrie Here are the Excel 4.0 formulas to perform individual market filters. For our example, we'll use the December 1994 Treasury bond futures market (sidebar Figures 1 and 2) with a 1% filter. The sp

• ### SIDEBAR: SETTING UP AN EXCEL SPREADSHEET

ARTICLE SYNOPSIS...SETTING UP AN EXCEL SPREADSHEET Following is an example of setting up an Excel spreadsheet for creating a forecast using a five-day linear regression for tomorrow's close. Sidebar Figure 1, Column A, lists the dates and Column D lists the closing prices

• ### Sidebar: Excel codes for trend trigger factor by M.H. Pee

ARTICLE SYNOPSIS...Stocks & Commodities V. 22:12 (28-36): Sidebar: Excel codes for trend trigger factor by M.H. Pee EXCEL CODES FOR TREND TRIGGER FACTOR The Excel spreadsheet in sidebar Figure 1 shows all the required calculations for the 15-day trend trigger factor (TTF

• ### Sidebar: MOMA and Excel by Stephan Bisse

ARTICLE SYNOPSIS...Stocks & Commodities V. 23:2 (22-27): Sidebar: MOMA and Excel by Stephan Bisse Simple moving averages are great tools for filtering out noise from time series, but all they can do is show where a time series has been. The only way that a moving average