Discussions
»
Product and Service Development
»
Formula Assistance
»
MACD Help - How to calculate when black line is within -.01 of the zero line
Rank: Newbie
Groups: Registered, Registered Users
Joined: 4/29/2007(UTC)
Posts: 2
|
Hello Everyone!
Just wanted to say thanks to everyone here sharing their formulas and all.
It’s been a big help.
At the moment Im currently stumped at trying to figure a formula.
Im trying to figure out a formula that will be used in The Explorer to
calculate when the black MACD line is within -.01 of the 0 line (horizontal line).
Im currently using the formula:
If(Cross(MACD(),Mov(MACD(),9,E)),1,If(Cross(Mov(MACD(),9,E),MACD()),-1,0))
to find the crossover, and would like to apply another formula
that can tell me when the black line is within -.01 of the 0 line.
Ive attached a pic to show the MACD black line crossing over the zero line.
Any help would be greatly appreciated.
[img]http://img2.freeimagehosting.net/image.php?36594660df.jpg[/img]
If the above link doesnt work, copy the one below into a browser.
http://img2.freeimagehosting.net/image.php?36594660df.jpg
Thanks, and have a great day.
Jim.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Jim,
If you want the MACD to be within some limit of the zero line, try something like this:
limit:=0.01;
trigger:=Abs(MACD())<limit;
{plot/return}
trigger;
You can extend this idea to almost any indicator, like the MACD Histogram:
limit:=0.01;
hist:=MACD()-Mov(MACD(),9,e);
trigger:=Abs(hist)<limit;
{plot/return}
trigger;
etcetera
Hope this helps.
wabbit [:D]
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 4/29/2007(UTC)
Posts: 2
|
Hi Wabbit!
Thanks a lot for taking the time to respond.
Much appreciated, and Ill give it a try.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
MACD Help - How to calculate when black line is within -.01 of the zero line
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.
