Technical Studies Reference
- Technical Studies Reference
- Common Study Inputs (Opens a new page)
- Using Studies (Opens a new page)
Z-Score
This study calculates and displays the Z-Score of the data specified by the Input Data Input.
Let \(X\) be a random variable denoting the Input Data Input, and let \(X_t\) be the value of the Input Data at Index \(t\). Let the Inputs Mean Length and Standard Deviation Length be denoted as \(n_{\mu}\) and \(n_{\sigma}\), respectively. Then we denote the Z-Score at Index \(t\) for the given Inputs as \(Z_t(X,n_{\mu},n_{\sigma})\), and we compute it in terms of a Simple Moving Average and a Standard Deviation for \(t \geq \max\{n_{\mu},n_{\sigma}\} - 1\) as follows.
\(\displaystyle{Z_t(X,n_{\mu},n_{\sigma}) = \frac{X_t - SMA_t(X,n_{\mu})}{\sigma_t(X,n_{\sigma})}}\)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.
The formulas are in the third sheet, entitled Intermediate Calculations.
*Last modified Monday, 03rd October, 2022.