Calculating Moving Average from Close and the Other Methods

Calculating Moving Average from Close

Most people calculate moving averages (or let their software calculate it) from the closing price of each bar. This has a valid reason on daily or weekly charts, because the price at which the market closes on a particular trading day or week has a big meaning.

Of course, like many things in trading, this meaning is partly self-fulfilling. Because everybody else watches it, I should watch it too, as it has a potential to influence future market development.

For Intraday Charts Closing Prices Are Less Significant

On the contrary, when you are using intraday charts and short time frames (for example 3 minute bars), the closing price of a particular bar is not that important. Who cares where the market was exactly at 10:24:00 (as opposed to 10:23:56), or where it “closed” at 10:27:00?

Furthermore, with the improvements in technology and speeding up the internet some people started using so called alternative time frames like tick charts (each bar represents a particular number of trades) or volume charts (each bar represents a particular number of shares or contracts traded). If you use these, the closing price of a particular bar has probably no meaning at all.

Calculating Moving Average from Other Prices

For intraday charts, the high and low of each bar may give you a much more useful information than close. A common approach is calculating a kind of average from high and low (and sometimes also close or even open). This average is then used for calculating the moving average.

In sum, most common methods for calculating moving averages are calculating them from:

Which Method to Choose?

Which one is the best? It depends, like everything, on your own taste, your strategy, and your needs. However, in most markets the selection of one of these methods will most likely not be the most critical factor in your strategy. In most cases the length of moving average period influences the behaviour of the moving average much more than which price is used for its calculation.

Related pages

cut your losses definitionhow to calculate in excel formulaweighted average method of inventory valuationrules of multiplying square rootsadvantages and disadvantages of median in statisticshedge fund sec filingsrsi wilderiron butterfly strategystandard deviation formula in financecall option payoff graphblack scholes options calculatormini vix futuresblack scholes historyscholes option pricing modelspot vixstock option price calculatorblack scholes templateexcel exponential functionrelative deviation calculatorwhen do vix options expirelogarithm calculator step by stepvolatility index formulastock momentum formulacost of ending inventory calculatoruvxy shortrsi valuescomputing standard deviation in excelblack scholes formulaseasy calculation mean median modeexcel logarithmharmonic mean of 3 numbersetf listsema in exceld2 calchow to calculate var in excelvix 3x etfvix and morefonts for notepadcall option payoffhow to read the macdyahoo historical datameaning of option contractarithmetic median formulapayoff of put optionbutterfly spread calculatorstraddle strategycalculate square root in excelshort put option payofftrading divergencesrsi formula excelhow to calculate delta of an optioncboevixvolatility wikispx s&p 500derivation of standard deviation formulavolatility calculation excelsample mean formula excelbuy the vixcustomize notepadbear call spread payoffrsi calculation formulaexcel formula to calculate average percentageinterpret skewness and kurtosishistorical vixcalculating standard deviation on calculatorexcel volatilitythinkback thinkorswimadvantages and disadvantages of mean mode and medianmacro hedge fund strategycoefficient of skewness examplexiv vixhow to write pi in excelvariance calcvix futures symbolwhat is stdevmeasuring skewnessskewness and kurtosis examples