logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
asdsa  
#1 Posted : Friday, December 2, 2005 9:58:23 PM(UTC)
asdsa

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
Patrick  
#2 Posted : Wednesday, December 7, 2005 3:41:45 PM(UTC)
Patrick

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:
asdsa  
#3 Posted : Thursday, December 8, 2005 7:55:20 PM(UTC)
asdsa

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:
asdsa  
#4 Posted : Thursday, December 8, 2005 8:19:20 PM(UTC)
asdsa

Rank: Newbie

Groups: Registered, Registered Users
Joined: 11/8/2005(UTC)
Posts: 4

Sory See This Attachment
asdsa  
#5 Posted : Thursday, December 8, 2005 8:28:27 PM(UTC)
asdsa

Rank: Newbie

Groups: Registered, Registered Users
Joined: 11/8/2005(UTC)
Posts: 4

take this http://www.forex-training.com/moving_average.htm http://trader.snowseed.com/macd.htm i think this pages will help you to helpe me
johnl  
#6 Posted : Friday, December 9, 2005 1:54:34 AM(UTC)
johnl

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.