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

difference between variance and volatilityvix futures term structurekurtosis interpretation spssstandard deviation subtractiondivergence macddelta hedging put optionvix averagenotepad colorarithmetic mean diameteroption delta calculatorwhat is the macd indicatorblack scholes formula calculatorcontinuously compounded returnshort sp500 etfs&p 500 spreadsheetstdev sshort strangle strategyipath etfsexcel stock spreadsheetaverage inventory cost formulasvxystandard deviation derivationblack scholes definitionadvantages and disadvantages of mean mode and medianblack scholes formulasgreeks financetrading option greeksmsft historical pricesblack scholes put option formulahow to calculate a formula in excelvar function in excelshort straddlescalculate standard deviation using excelannualized daily returnvxx inverseubs etracsvix term structures&p futures tickerarithmetic mean for grouped data examplethe black-scholes formulacboe options quotesvariance and standard deviation for grouped datahow do you calculate standard deviation on exceloption pricing black scholespro shares ultra shortcontango explaineddeviate deflong term vix chartema msftcentral tendency excelhow to calculate implied volatility of a stockshort put payoffexcel stdev formuladelta formulasrealized volatility calculationshort straddle optioncost of common equity capital calculatordownload yahoo finance data into exceldjia weighting2x vixcboe rulesinterpret skewness and kurtosiscalculating rsiinverse etncalculation of skewnesshow to find the sample variance in statisticss&p official websitehow to calculate the standard deviation in excelstrike price exercise pricecalculating stock volatilityhow to trade with macdreal time vix