McGinley Dynamic

The McGinley Dynamic looks like a moving average line but is a smoothing mechanism for prices that adjusts to shifts in market speed. This minimizes lag and avoids whipsaws, tracking the market far better than standard moving averages.

MCGINLEY

=MCGINLEY(data, period)

Example Usage

=MCGINLEY(A2:F500, 14)

Parameters

Parameter Type Description Status
data
Range
The input range of columns containing the Date, Open, High, Low, Close, and Volume data.
 Required
period
Number
The lookback period. Default is 14.
 Optional

Returns

A two-column array of dates and their corresponding McGinley Dynamic values.

McGinley Dynamic Formula Result in Google Sheets