eTrader Zone       

This page contains the formula for Weighted Moving Average and you can download the formula in Excel spreadsheet.

Weighted Moving Average

Weighted Moving Average (WMA) indicate the everage price change for a stock and places more emphasis on the closing price.

Formula:

WMA = (( n * Pn ) + (( n - 1 ) * Pn - 1 ) + (( n - 2 ) * Pn - 2 ) + ... (( n - ( n - 1 )) * Pn - ( n - 1 )) / (n + ( n - 1 ) + ... + ( n - ( n - 1 )))

n = Running number associated with the period calculated
Pn = Previous close for the n number of day

Login or Register to download this Excel Spreadsheet