fbpx

Exponentially Weighted Moving Average (EWMA)

A quantitative or statistical measure used to model or describe a time series

What is the Exponentially Weighted Moving Average (EWMA)?

The Exponentially Weighted Moving Average (EWMA) is a quantitative or statistical measure used to model or describe a time series. The EWMA is widely used in finance, the main applications being technical analysis and volatility modeling.

The moving average is designed as such that older observations are given lower weights. The weights fall exponentially as the data point gets older – hence the name exponentially weighted.

The only decision a user of the EWMA must make is the parameter alpha. The parameter decides how important the current observation is in the calculation of the EWMA. The higher the value of alpha, the more closely the EWMA tracks the original time series.

 

EWMA Formula

The EWMA’s simple mathematical formulation described below:

 

Exponentially Weighted Moving Average (EWMA)

 

Where:

  • Alpha = The weight decided by the user
  • r = Value of the series in the current period

 

The EWMA is a recursive function, which means that the current observation is calculated using the previous observation. The EWMA’s recursive property leads to the exponentially decaying weights as shown below:

 

EWMA Decaying Weights

 

The above equation can be rewritten in terms of older weights, as shown below:

 

EWMA Formula - Older Weights

 

It can be further expanded by going back another period:

 

 

The process continues until we reach the base term EWMA0. The equation can be rearranged to show that the EWMAt is the weighted average of all the preceding observations, where the weight of the observation rt–k is given by:

 

Weight of Observation

 

Since alpha is between 0 and 1, the weight becomes smaller as k becomes larger. In other words, as we go back further in history, the weight becomes smaller. The fact is illustrated in the chart below, which plots the weights of observation as k increases for different choices of the parameter alpha.

 

EWMA Weights

 

N-Day EWMA

The EWMA can be calculated for a given day range like 20-day EWMA or 200-day EWMA. To compute the moving average, we first need to find the corresponding alpha, which is given by the formula below:

 

N-Day EWMA - Formula

 

Where:

  • N = number of days for which the n-day moving average is calculated

 

For example, a 15-day moving average’s alpha is given by 2/(15+1), which means alpha is 0.125. Naturally shorter the lookback period – more closely, the EWMA – tracks the original time series.

 

Applications of the EWMA

 

Technical Analysis

The EWMA is widely used in technical analysis. It may not be used directly, but it is used in conjunction with other indicators to generate trading signals. A well-known example is the Negative Volume Index (NVI), which is used in conjunction with its EWMA. A buy signal is generated when the NVI crosses above its 250-day EWMA.

The EWMA can also be used in a simple crossover strategy, where a buy signal is generated when the price crosses the EWMA from above, and a sell signal is generated when the price crosses the EWMA from below.

Another application of the EWMA in technical analysis is that it can be used as support or resistance levels. For this purpose, it is better to use longer moving averages, usually longer than a 20-day moving average.

The following chart shows the 5-day and 15-day EWMA for the series of MSFT stock price:

 

MSFT Price EWMA

 

Volatility Modelling

The exponentially weighted moving average is widely used in computing the return volatility in risk management. There are various methods of computing the return volatility of a price series, like the historical standard deviation method, the EWMA models, and the GARCH model.

The standard deviation method weighs all observations equally and often understates the volatility. The GARCH model is a complex statistical model based on the EWMA model. The EWMA model strikes the perfect balance between complexity and accuracy; hence, it is a very popular approach to estimating volatility.

Volatility can be estimated using the EWMA by following the process:

  1. Step 1: Sort the closing process in descending order of dates, i.e., from the current to the oldest price.
  2. Step 2: If today is t, then the return on the day t-1 is calculated as (St / St–1) where St is the price of day t.
  3. Step 3: Calculate squared returns by squaring the returns computed in the previous step.
  4. Step 4: Select the EWMA parameter alpha. For volatility modeling, the value of alpha is 0.8 or greater. The weights are given by a simple procedure. The first weight (1 – a); is the weights that follow are given by a * Previous Weight.
  5. Step 5: Multiply the squared returns in step 3 to the corresponding weights computed in step 4. Sum the above product to get the EWMA variance.
  6. Step 6: Finally, the volatility can be computed as the square root of the variance calculated in step 5.

The volatility number is then used to compute risk measures like the Value at Risk (VaR). It can also be used for option valuation, where volatility is an input parameter to the Black-Scholes-Merton formula.

 

More Resources

To keep learning and developing your knowledge base, please explore the additional relevant resources below:

  • Advanced Technical Analysis
  • Double Exponential Moving Average (DEMA)
  • Historical Volatility
  • Value at Risk (VaR)