Ask Colin

I don't know how much you know about excel, but is it possible to create a formula that calculated exponential moving averages?

I don't know how much you know about Excel, but is it possible to create a formula that calculated exponential moving averages?

If you can find a maths teacher, he or she would be able to tell you how to calculate an exponential moving average.

However, if you want to do it yourself, there is a formula and worksheet in "Trading for a Living" by Dr Alexander Elder pages 122-24. You could buy it at The Educated Investor in Collins Street. If you are interested in trading, you will not regret buying the book anyway.

Most people use charting software to calculate and plot the moving average. It is much faster and easier to buy some software than to go about reinventing the wheel for yourself.

Keyword: