Adaptive Moving Average

This is a discussion on Adaptive Moving Average within the Technical Analysis forums, part of the Methods category; Hello All, I have been doing some research into the Adaptive Moving Average (AMA, or KAMA) as developed by Perry ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Nov 19, 2009, 10:33am   #1
 
4 Posts
Joined Jun 2008
Adaptive Moving Average

Hello All,

I have been doing some research into the Adaptive Moving Average (AMA, or KAMA) as developed by Perry Kaufman and as described in his book “Smarter Trading” (page 140, for those who have the book).

I have replicated the formula in Excel and, if possible, I would like someone to check my workings – essentially, the results that I am getting don’t seem “quite right” when compared to, say, an exponential average....I must have missed something.

I have trawled through various Google searches for the formula and calculations : ideally, I would like to compare my workings with someone who has also replicated the formula in Excel.

Any takers?

Best wishes,

nansen.
nansen is offline   Reply With Quote
Old Dec 7, 2009, 1:49pm   #2
Joined Dec 2008
Re: Adaptive Moving Average

What is the Formula ?
xebectrader is offline   Reply With Quote
Old Dec 23, 2009, 7:19pm   #3
Joined Dec 2008
Re: Adaptive Moving Average

Isn't using moving averages kinda "laggy"?








Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.
t2wfx is offline   Reply With Quote
Old Dec 24, 2009, 12:05am   #4
Joined Aug 2003
Re: Adaptive Moving Average

Here is a suggestion for you. I often develop studies in Excel and to prove that my calculations are correct, I compare the results to the output from SierraChart.

This is how to do it: Download SierraChart, I believe you can use it for free if you do not want the real-time updating. Open a chart and add the AMA study. Now add a worksheet study and in the parameters, specify that you want to use Excel (if you don't do this, it will create a spreadsheet using an internal format, which is no use to you.

For the worksheet name, specify the name of your workbook that contains your own AMA. What happens is that SC outputs the data (OHLC and date/time) in to columns A to E and then it outputs its AMA values in column AA. If you put your AMA values in a column further to the right, you can then do a direct comparison of their values to yours (for example, you could put a formula like aa3=bb3 in a column, and you would then look for non-zero values in the column to find any mismatches).

Alternatively, you could make SC draw your AMA on the chart by putting the values in column K onwards. You could then eyeball the difference between theirs and yours on the chart.

As I say, I do this a lot. I built the Hull MA in Excel and compared it to SC and it was spot on.

Hope this helps.
swandro is offline   Reply With Quote
Old Jun 8, 2010, 9:20pm   #5
 
lbranjord's Avatar
Joined May 2008
Re: Adaptive Moving Average

Quote:
Originally Posted by t2wfx View Post
Isn't using moving averages kinda "laggy"?








Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.Click the image to open in full size.
Yes, trading the crossover of moving averages is worthless.

It's when the trend is respecting the sloping moving average that you can use it. They help you find good dips in the trend. Also, if you see a moving average pierced by a pin bar, you know the contrarians were able to draw blood and may soon be back for more. It's a warning about the strength of the current trend.

Thats how I use MA's, they are vital to my analysis. actually, they represent about 99.9% of my analysis.
lbranjord is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula for "adaptive moving average" nansen Trading Systems 3 May 12, 2013 1:51pm
Moving Average miskec Forex 8 Apr 25, 2009 7:10am
Moving Average victor Technical Analysis 55 Oct 13, 2004 7:31pm
Just Moving average osho67 First Steps 1 Nov 4, 2003 8:39pm

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)