5 Day Moving Average

A common question I receive is, how do you display a 5 day moving average on a 10 (or 30) minute timeframe?  SEE CHARTS BELOW

When looking at moving averages you have to consider which timeframe you are looking at.  If you have a chart with 10 minute candles, overlaying a moving average with the period being set to “five” does not give you a five DAY moving average, it gives you the average price for the last five – 10 minute periods, or the average price the stock traded at for the last 50 minutes!

If you want to see a five DAY moving average on a chart with 10 minute candles, you have to consider how many 10 minute periods of trading there are in the trading day.  The US equities markets are open from 9:30- 4:00 each day, which is 6.5 hours per trading day.  In each hour of trading, there are 6-10 minute periods, so during the regular session for equities, the market is open for 390 minutes or 39-10 minute periods per day.  If we are to get a five day moving average, we would take the 39-10 minute periods the market is open each day and then multiply that by five days.  39 x 5 = 195.  So a 5 DAY moving average is represented by a 195 PERIOD moving average when looking at a 10 minute timeframe.

If you wanted to see the 5 day moving average on a chart with 3o minute candles, you would do the same type of calculation.  There are 13- 30 minute periods during a day of traiding and over 5 days, there would be (13×5) 65- 30 minute periods.  The 5 DAY moving average is represented on a 30 minute timeframe by a 65 PERIOD moving average.

The same type of calculation would be applied to other  timeframes.  If you wanted to see a 10 DAY moving average on these timeframes, you would double the number of periods to look at.  On a 30 mintue timefremae, a 10 DAY moving average would be reperesented by 39- 30 minute periods.

What about a 5 day moving average on a 65 or a 15 minute timeframe?  Seriously?  Don’t be so lazy, you can see how the math works, sit down and figure it out!! (-:

Below are charts of three different timeframes, each with a 5 DAY moving average.

The first chart is with daily candles and a 5 period (day) moving average.

When we change our chart to intraday timeframes like the 30 minute period below, the 5 DAY moving average is represented with 65 periods.

When we take a closer with 10 minute periods, we change the moving average to 195 periods to display the 5 DAY moving average.

Here are the timeframes and number of periods to use in your moving average to replicate a 5 day moving average.

195 minutes = 10 period

130 minutes = 15 period

78 minutes = 25 period

65 minutes = 30 periods

39 minutes = 50 period

30 minutes = 65 period

26 minutes = 75 period

15 minutes = 130 period

13 minutes = 150 period

10 minutes = 195 period

6 minutes = 325 period

5 minutes = 390 period