exponential moving average?

[cheveley]

Is there an excel formula or add in to calculate an exponential moving average.

Thanks

 

[Andrew Poulsom]

Have a look here:

http://www.willowsolutions.com/tips/tips_2002_11.shtml

 

[cheveley]

thats excellant and is exactly what I was after

much obliged

 

[cheveley]

do some browsing on willowsolutions. great website. are you aware of any similiar websites i.e. providing excel solutions for finance?

Cheers

 

[Andrew Poulsom]

Search Google for "exponential moving average Excel" (no quotes). I got 10 pages.

 

[cheveley]

google further revealed that http://www.ksu.edu/stats/tch/malone/computers/excel/analyses/bilder/excel_es.html indicates that exponential smoothing is available in data analysis for anyone who is interested.

 

[ANANDSOLANKE]

Sir, which are the best method to generate buy and sell signal