Rank: Newbie
Groups: Registered, Registered Users Joined: 11/8/2005(UTC) Posts: 4
|
hi
I Maked Formulae same macd from [ Mov( Close, 12, E) - Mov(Close, 26,e) ]
but resultes differen.
see Attachment
where wronge??!!!!!!!!!!!!!!!!!!!!!
Why Macd <> Mov( Close, 12, E) - Mov(Close, 26,e)
*******************************
this text from meatastock help
*******************************
Most analysts (including Equis International's) say that the MACD indicator is "the difference between 12-day and 26-day exponential moving averages." However, the indicator is really the difference between 0.15 and 0.075 exponential moving averages (whereas, when expressed in decimal form, the 12- and 26-day exponential moving averages are actually 0.153846 and 0.076923 exponential moving averages). See Moving Average Calculation Methods for more information on exponential moving average calculation methods.
Due to these minor differences in the exponential values, the following formula is slightly different than the predefined MACD indicator. Remember that you can plot the true MACD indicator using the macd() function (see MACD).
mov( close, 12, E) - mov( close, 26, E)
The MACD's trigger (which is a 9-day exponential moving average of the MACD indicator) can be calculated as shown below:
mov( macd(), 9, E)
*********************************
where wrong??!!!!!!!!!!!!!!!!!!!
thanks
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 9/8/2004(UTC) Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Here is the answer by Chris.
Please post in the right forum next time ;)
Quote:
{MACD Custom}
a:=0.15;
b:=0.075;
MovAvg:=9;
ShortMA:= If(Cum(1)=1,C,PREV*(1-a)+C*a);
LongMA:= If(Cum(1)=1,C,PREV*(1-b)+C*b);
cMACD:=ShortMA-LongMA;
cTrigger:=Mov(ShortMA - LongMA,MovAvg,E);
cMACD;Mov(cMACD,MovAvg,E)
Chris
Patrick :mrgreen:
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users Joined: 11/8/2005(UTC) Posts: 4
|
:thumbup:
THANKSSSSSSSSSSSSSSSSSSSSSS :) Patrick
Now
i need macd on excel
see Attachment
then reply file
thanks :wub:
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users Joined: 11/8/2005(UTC) Posts: 4
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users Joined: 11/8/2005(UTC) Posts: 4
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 11/7/2005(UTC) Posts: 602
|
I have been looking around for some MACD code. Thanks.
I modified the code so you can play around with different inputs
====================
{MACD Custom}
a:= Input("Short MA",.005,3.00,0.15);
b:= Input("Long MA",.005,5.00,0.075);
MovAvg := Input("Trigger MA",3,21,9);
ShortMA:= If(Cum(1)=1,C,PREV*(1-a)+C*a);
LongMA:= If(Cum(1)=1,C,PREV*(1-b)+C*b);
cMACD:=ShortMA-LongMA;
cTrigger:=Mov(ShortMA - LongMA,MovAvg,E);
cMACD;Mov(cMACD,MovAvg,E)
===================
you can play around with the input parameters to see which one fits the best for
the stock you are trying to trade.
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.