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.