Home >> (Table of Contents) Studies and Indicators >> Technical Studies Reference >> Moving Average - Triangular
Technical Studies Reference
- Technical Studies Reference
- Common Study Inputs (Opens a new page)
- Using Studies (Opens a new page)
Moving Average - Triangular
This study calculates and displays a Triangular Moving Average of the data specified by the Input Data Input. The Triangular Moving Average is calculated in terms of the Simple Moving Average. Refer to that study to familiarize yourself with the notation used here.
Just as with the Simple Moving Average, this study relies on the Inputs Data Input \(X\) and Length \(n\). We calculate two additional Lengths based on \(n\), \(n_1(n)\) and \(n_2(n)\), as follows.
\(\displaystyle{n_1(n) =\left\{ \begin{matrix} \left\lceil{\frac{n}{2}}\right\rceil & n \space odd\\ \frac{n}{2} & n \space even \end{matrix}\right .}\)\(\displaystyle{n_2(n) =\left\{ \begin{matrix} \left\lceil{\frac{n}{2}}\right\rceil & n \space odd\\ n_1 + 1 & n \space even \end{matrix}\right .}\)
For an explanation of the ceiling function (\(\left\lceil{\space\space}\right\rceil\)), refer to our description here.
We denote the Moving Average - Triangular at Index \(t\) for the given Input Data and calculated Lengths as \(TMA_t(X,n)\), and we compute it for \(t \geq n_1(n) + n_2(n) - 1\) as follows.
\(TMA_t(X,n) = SMA_t\left(SMA\left(X,n_1(n)\right),n_2(n)\right)\)Inputs
Spreadsheet
The spreadsheet below contains the formulas for this study in Spreadsheet format. Save this Spreadsheet to the Data Files Folder.
Open it through File >> Open Spreadsheet.
*Last modified Tuesday, 27th September, 2022.