Article Archive For Keyword: Excel

Download
Article

• ADX Excel Spreadsheet

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

AUTHOR: Dennis D. PetersonDATE: AUG 2000

Download
Article

Excel File January 2000 Issue

AUTHOR: Technical Analysis, Inc.DATE: JAN 2000

Download
Article

Quick Scan: Mathematica Link for Excel

AUTHOR: Technical Analysis, Inc.DATE:  1999

Download
Article

• 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

AUTHOR: Technical Analysis, Inc.DATE: JAN 1994

Download
Article

• 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

AUTHOR: Technical Analysis, Inc.DATE: APR 1994

Download
Article

SIDEBAR: EXCEL FUNCTIONS

AUTHOR: Technical Analysis, Inc.DATE: JUN 1992

Download
Article

• 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

AUTHOR: Technical Analysis, Inc.DATE: MAY 1993

Download
Article

• 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

AUTHOR: Scott W. BarrieDATE: JUL 1995

Download
Article

• 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

AUTHOR: Technical Analysis, Inc.DATE: MAY 1992

Download
Article

• Setting Up an Excel Spreadsheet for the Forecast Oscillator

  ARTICLE SYNOPSIS...This article is reprinted from Technical Analysis of Stocks & Commodities magazine, Volume 10, Issue 5 to supplement my recent article "Forecast Oscillator".

AUTHOR: Dennis D. PetersonDATE: OCT 2000

Download
Article

• 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

AUTHOR: M.H. PeeDATE: DEC 2004

Download
Article

• 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

AUTHOR: Stephan BisseDATE: FEB 2005