|
Moving
Averages - Triangular
Description
A
triangular moving average is similar to
exponential and weighted moving averages except a
different weighting scheme is used.
Exponential and weighted moving averages
assign the majority of the weight to the most
recent data. Simple
moving averages assign the weight equally across
all the data. With
a triangular moving average, the majority of the
weight is assigned to the middle portion of the
data.
A
triangular moving average is simply a
double-smoothed simple moving average.
To calculate a 9-period (similar for all
odd periods) triangular moving average:
-
Divide
9 by 2 to get 4.5
-
Round
4.5 up to 5
-
Triangular
moving average (odd periods) =
(mov(mov(c,5,s)5,s)
A
12-period (similar for all even periods) is
calculated as follows:
-
Divide
12 by 2 to get 6.
-
Add
1 to 6 to get 7*.
-
Triangular
moving average (even periods) =
(mov(mov(c,6,s),7,s)
The
rule is to take the length divided by 2 as one
average, and that number plus 1 as the second.
Back to Moving Averages |
