Excel formula for "adaptive moving average"

[acipojesa]

I have been reading up on the "Adaptive Moving Average" (references to Perry Kaufman on the net).

I would like to replicate the formula for this in Excel.

[adavisvenu]

Does anyone have experience of the "AMA"? Is anyone able to assist me in replicating the formula in Excel?

[aexeniciey]

I've now replicated the formula in Excel.

[adolume]

if it's not too rude, can you send me the code?

[admin]

Hi nansen ... can i request you to kindly share the excel sheet with the KAMA calculation method, please?