Login Page - Create Account

Technical Studies Reference


Moving Average - Volume Weighted

This study calculates and displays a Volume Weighted Moving Average of the data specified by the Input Data Input.

Let \(X\) be a random variable denoting the Input Data, let \(X_i\) be the value of the Input Data at Index \(i\), and let \(V_i\) be the Volume at Index \(i\). Let the Input Length be denoted as \(n\). The Moving Average - Volume Weighted at Index \(t\) for the given Inputs is denoted as \(VWMA_t(X,n)\), and we compute it for \(t \geq n\) as follows.

\(\displaystyle{VWMA_t(X,n) = \left. \left(\sum_{i=t-n+1}^tX_iV_i\right) \middle/ \sum_{i=t-n+1}^tV_i\right.}\)

For an explanation of the Sigma (\(\Sigma\)) notation for summation, refer to our description here.

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.

Moving_Average_-_Volume_Weighted.105.scss


*Last modified Wednesday, 03rd January, 2018.