Rank: Newbie
Groups: Registered Users, Subscribers
Joined: 9/1/2015(UTC)
Posts: 2
Thanks: 1 times
|
I would like to create the formula to find out the difference between two MACDs (eg. 10&20 and 50&100) and also find out their average as well. Can anyone pl help me to figure out the formulas for the same.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
The built-in MACD() function is hard-coded to 12,26 periods. To control these values manually, you can subtract 2 exponential moving averages to calculate MACD:
A:=10;
B:=20;
X:=50;
Y:=100;
MCD1:=Mov(C,A,E) - Mov(C,B,E);
MCD2:=Mov(C,X,E) - Mov(C,Y,E);
MCD1-MCD2;
Use of variables is optional, but can make it easier to adjust the MACD values down the road. To figure out their average, you would just wrap a moving average around both:
Mov(MCD1,9,E);
Mov(MCD2,9,E);
|
 1 user thanked MS Support for this useful post.
|
|
|
|
| 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.
