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

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

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

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

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

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.

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

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

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: 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

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

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

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

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