Calculating numerous EMAs

I am trying to calculate the various EMAs of a stock.

I have the formula and I know how it works. I am attacing a spreadsheet for the same...

At times I have to calculate numerous EMAs for the same stock for which I have to retype the formula and copy it...

Is there a way by which if I change a single value (the period for which the EMA has to be calculated) and the formula can be changed automatically and pasted accordingly....

Any help will be apprciated...

hi Navin, formula solution, formula is in E4:E128, try to change D1 value (it has validation check for integer numbers)

Thanks watersev....

problem solved in this sheet... but i will bother u once again with another sheet where i need help..... is that ok?

Thanks a lot..... Appreciate it... I am having a lot of problems in loading files here.... Is it possible to share your email ID pls?

Mine is mentioned in the signature ([email protected])... Request you to drop me a test mail and I can send it....

Cheers