Triangular Moving Average (Trima) Template

Triangular Moving Average

The Trima is another variation on the moving average theme. It derives its name from the weighting given to the prices used in its construction. For example, a 7 period trima has weighting factors of 1,2,3,4,3,2,1 applied to the most recent 7 prices.


Clearly the emphasis of the trima is on the middle of the range used. There is plenty of material on this on the web.

It is implemented as a double smoothed version of a simple ma as follows.

That’s all there is to it. If you want to change the ma period, change the value in line A. If you want to use something other than close, change the selection in line E (you can point it at a study value, or HLC/3 or virtually any other price combo).

Hope this helps.