|  DEC 1992

A Spreadsheet For Time Ratio Analysis by Robert Miner

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 dates, along with an example of a trade. As W. D. Gann described more than 70 years ago, markets make swing highs or lows in proportion (relation) to past market cycles. My March 1991 STOCKS & COMMODITIES article, ""Time as a trading tool,"" described the theory and methodology of projecting proportions of past cycles forward in time to deter nine future dates with the greatest probability of change in trend. Past cycles are proportioned by the most important geometric ratios, and these proportions of past cycles are in turn projected forward. Future changes in trend should coincide with clusters of target dates from proportions of past cycles. Any spreadsheet program, as I will demonstrate, can project the future dates. Proportioning and projecting forward dates with a spreadsheet program is as easy as dividing a price cycle for retracements or projections. A time projection spreadsheet will simply treat the values as dates instead of prices. A time projection spreadsheet proportions various past cycles and projects the future dates of the proportioned past cycles.

by Robert Miner