What's new

HOW DO YOU CALCULATE MOVING AVERAGE?

2.00 star(s) 1 Vote

jinz13

New Member
As explained above, the most common moving averages are the simple moving average (SMA) and the exponential moving average (EMA). Almost all charting packages will have a moving average as a technical indicator.

The simple moving average is simply the average of all the data points in the series divided by the number of points.

The challenge of the SMA is that all the data points will have equal weighting which may distort the true reflection of the current market’s trend.

The EMA was developed to correct this problem as it will give more weighting to the most recent prices. This makes the EMA more sensitive to the current trends in the market and is useful when determining trend direction.

The mathematic formula for each can be found below:

Simple Moving Average:

SMA =


Where:

A= Is each of the data points

n = Number of time periods

For example, looking at a 5-day SMA on a daily chart of EUR/USD and the closing prices over the 5 days are as follows:

Day 1: 1.321

Day 2: 1.301

Day 3: 1.325

Day 4: 1.327

Day 5: 1.326

SMA = (1.321 + 1.301 + 1.325 + 1.327 + 1.326)/5

SMA = 6.6/5

SMA = 1.32

Exponential Moving Average:

EMA =


Where:

EMAt= EMA today

Vt= Value today

EMAt = EMA today

s =smoothing

d = number of days

Steps for calculating EMA:

1. Calculate the SMA for the particular time period

2. Calculate the multiplier for weighting the EMA using the formula:

[2 ÷ (selected time period + 1)]. So, for a 10-day moving average, the multiplier would be [2/(10+1)]= 0.01818.

3. Use the smoothing factor combined with the previous EMA to arrive at the current value.

For example, looking at a 10-day EMA for a share, the table below displays how the EMA would be calculated:

DATEPRICE10-DAY SMASMOOTHING CONSTANT 2/(10 + 1)10-DAY EMA
124-Apr-1823.24
225-Apr-1822.99
326-Apr-1822.85
427-Apr-1823.00
528-Apr-1822.96
629-Apr-1822.21
730-Apr-1821.99
81-May-1822.43
92-May-1822.24
103-May-1822.5522.6522.65
114-May-1822.1522.540.181822.56
125-May-1822.3922.480.181822.53
136-May-1822.3822.430.181822.50
147-May-1822.6122.390.181822.52
158-May-1823.3622.430.181822.67
169-May-1824.0522.620.181822.92
1710-May-1823.7522.790.181823.07
1811-May-1823.8322.930.181823.21
1912-May-1823.9523.100.181823.35
2013-May-1823.6323.210.181823.40
 

Create an account or login to comment

You must be a member in order to leave a comment

Create account

Create an account on our community. It's easy!

Log in

Already have an account? Log in here.

Similar threads

Users Who Are Viewing This Thread (Total: 1, Members: 0, Guests: 1)

Top
AdBlock Detected

We get it, advertisements are annoying!

Sure, ad-blocking software does a great job at blocking ads, but it also blocks useful features of our website. For the best site experience please disable your AdBlocker.

I've Disabled AdBlock    No Thanks