Article Archive For Keyword: Spreadsheet

Download
Article

• A Spreadsheet For A Trend-Following Approach

  ARTICLE SYNOPSIS...Here's a template for a spreadsheet that anyone can use to set up a simple trend-following system

AUTHOR: Ron McEwanDATE: FEB 2020

Download
Article

• A Spreadsheet For Price Ratio Projection Analysis by Robert Miner

  ARTICLE SYNOPSIS...A Spreadsheet For Price Ratio Projection Analysis by Robert Miner Traders who follow Gann and Elliott wave analysis use ratios of past price movement as guidelines for possible turning points in the future. Here, Robert Miner of Gann/Elliott Educators g

AUTHOR: Robert MinerDATE: JUN 1993

Download
Article

• A Spreadsheet For Time Ratio Analysis by Robert Miner

  ARTICLE SYNOPSIS...A Spreadsheet For Time Ratio Analysis by Robert Miner Traders using ratio of time cycle analysis will find this spreadsheet version of determining target dates of possible cycle highs or lows helpful. The author discusses the use of projected target dat

AUTHOR: Robert MinerDATE: DEC 1992

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

• Equivolume Using A Spreadsheet Program by James Leahy

  ARTICLE SYNOPSIS...Equivolume Using A Spreadsheet Program by James Leahy Equivolume charting, which permits plotting price movements vs. volume instead of time, can be plotted by hand or with one of several charting programs, but a plain spreadsheet program on your person

AUTHOR: James LeahyDATE: JAN 1992

Download
Article

Product Review: WaveWi$e Market spreadsheet, version 6l36

AUTHOR: Technical Analysis, Inc.DATE:  1996

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: DESCRIBING A SPREADSHEET PROGRAM

  ARTICLE SYNOPSIS...DESCRIBING A SPREADSHEET PROGRAM

AUTHOR: Technical Analysis, Inc.DATE: AUG 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: OPTIMUM DETRENDING SPREADSHEET EXAMPLE

  ARTICLE SYNOPSIS...OPTIMUM DETRENDING SPREADSHEET EXAMPLE The following is a spreadsheet example (sidebar Figure 1) and a QuickBasic source code (sidebar Figure 2) of optimum detrending. Our spreadsheet example is for detrending the price data of the bond market example u

AUTHOR: Technical Analysis, Inc.DATE: MAY 1992

Download
Article

• SIDEBAR: Polarized Fractal Efficiency Spreadsheet by Technical Analysis, Inc.

  ARTICLE SYNOPSIS...POLARIZED FRACTAL EFFICIENCY SPREADSHEET by Technical Analysis, Inc. The first step to calculate the 10-period polarized fractal efficiency (PFE) on a percentage basis is to calculate the first-to-last close spacing.

AUTHOR: Technical Analysis, Inc.DATE: JAN 1994

Download
Article

• SIDEBAR: RANDOM WALK INDEX SPREADSHEET by Thom Hartle, Editor

  ARTICLE SYNOPSIS...SIDEBAR: RANDOM WALK INDEX SPREADSHEET by Thom Hartle, Editor Sidebar Figure 1 is a bar chart with 10 days of simulated data; today's current high and low are plotted as if the market is still trading. The random walk index of the lows can measure if to

AUTHOR: Thom HartleDATE: NOV 1993

Download
Article

• SIDEBAR: Random Walk Index Spreadsheet by Technical Analysis, Inc.

  ARTICLE SYNOPSIS...Random Walk Index Spreadsheet by Technical Analysis, Inc. Random Walk index spreadsheet.

AUTHOR: Technical Analysis, Inc.DATE: SEP 1992

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

• SIDEBAR: SPREADSHEET ANALYSIS by Technical Analysis, Inc.

  ARTICLE SYNOPSIS...SPREADSHEET ANALYSIS by Technical Analysis, Inc. Here's a simple way of setting up a return versus leverage analysis in a spreadsheet (sidebar Figure 1). Specifically, this is for Lotus 1-2-3, but you should be able to follow the example and apply it to

AUTHOR: Technical Analysis, Inc.DATE: MAY 1994

Download
Article

• SIDEBAR: Spreadsheet Calculations by Thom Hartle

  ARTICLE SYNOPSIS...SPREADSHEET CALCULATIONS This set of oscillators is easily calculated in a spreadsheet (sidebar Figure 1). The first four column are the date, high, low and closing price of Boeing (BA). Column E is the calculation of the 24-period moving average, the b

AUTHOR: Thom HartleDATE: APR 1993

Download
Article

• SIDEBAR: THE CHL/LLF METHOD SPREADSHEET by Technical Analysis, Inc.

  ARTICLE SYNOPSIS...THE CHL/LLF METHOD SPREADSHEET by Technical Analysis, Inc. Recall that the ""concurrent highest low"" filter (CHL) is a condition set up for the ""largest low to low fall"" trigger (LLF) and that the two are true/false situations. Therefore, the CHL fil

AUTHOR: Technical Analysis, Inc.DATE: NOV 1993

Download
Article

• SIDEBAR: TREND CHANNEL SPREADSHEET

  ARTICLE SYNOPSIS...TREND CHANNEL SPREADSHEET The trend-following method uses exponential smoothed moving averages (EMA) of price data. The equation for an EMA requires the previous day's EMA for the calculation of today's EMA. Consequently, the first period's closing pric

AUTHOR: Technical Analysis, Inc.DATE: MAR 1993

Download
Article

• SIDEBAR: WAMI SPREADSHEET by Technical Analysis, Inc.

  ARTICLE SYNOPSIS...WAMI SPREADSHEET by Technical Analysis, Inc. The spreadsheet (seen in sidebar Figure 5) provides a way to evaluate the WAMI power and phase spectrum as a function of the WAMI parameters L, M and N. The first column starting with A5 contains the frequenc

AUTHOR: Technical Analysis, Inc.DATE: APR 1994

Download
Article

• SIDEBAR: WRITING AND EXECUTING A SPREADSHEET MACRO

  ARTICLE SYNOPSIS...WRITING AND EXECUTING A SPREADSHEET MACRO A macro is a series of commands or keystrokes that can be stored for use for repeated operations. For all popular spreadsheets, macros can take on two different forms. One is a series of keystrokes that can be r

AUTHOR: Technical Analysis, Inc.DATE: JAN 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

WAVE WI$E Market Spreadsheet Version 6.0a by John Sweeney

AUTHOR: Technical Analysis, Inc.DATE:  1993