How do I calculate a Henderson moving average (in Excel)?

Question

How do I calculate a Henderson moving average (in Excel)?

I am trying to calculate a 13 term Henderson average. Is there an add in or easy formula?

Answer 1

this would be a quite complicated formula (check to see where it lies in the list and multiply those around it by differnet table values to get an average.) I think just typing them in after you table the henderson values is best. due to excels auto adjust cell refernce if you put the table in twice low to high to low you should only have to type it twice. if you use the money sign it will paste correctly for different columns.

=A13*$N29+A14*$M29+A15*$L29+A16*$K29...

Answer 2

For positional Trading use 200 day SMA. If the stock moves above that go for a BUY and SELL it when it crosses below that

Answer 3

I have not been able to find anything about calculating this in Excel but the following URL might be of use to you.



http://www.uow.edu.au/~craigmc/henderson.html