Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/27/2013(UTC)
Posts: 15
Thanks: 1 times
|
I need a formula to come up with a Indicator Builder, a Explorer, a Create Expert Edvisor and a Enhanced
System Tester for the below simple formula in metastock software.
1. I have a simple calculation for which I need metastock formula assistance.
2. I have three 1 minute bar chart at the moment as F2, F3, F4 in a sequence.
3. I need a column with my output as formula, below are the details
4. The simple calculation is =IF(F3>F2,F4-F3,F3-F4) , where f4 = current bar and F3 = previous one minute bar and f2 = previous second one minute bar(first bar)
Below is two examples for understanding:
Example one :
F2 = 730.3 AND F3 = 731.5 F4 = 731.2, by using the formula IF(F3>F2,F4-F3,F3-F4) , the output should be -.03 in minus(negative)
Example two :
F2 = 734.45 AND F3 734.9 AND F4 = 738 by using the formula IF(F3>F2,F4-F3,F3-F4) , the output should be 3.1 in plus(positive)
I hope you have understood my simple requirement.
Thanks
Sam
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/27/2013(UTC)
Posts: 15
Thanks: 1 times
|
Request someone in the forum to help at least that small formula pls ?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,943
Thanks: 87 times
Was thanked: 155 time(s) in 150 post(s)
|
Not sure if I fully understood, but you can try the following to see if it meets your criteria:
F4:=C;
F3:=Ref(C,-1);
F2:=Ref(C,-2);
F1:=Ref(C,-3);
If(F3>F2,F4-F3,F3-F4)
|
 2 users thanked MS Support for this useful post.
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/27/2013(UTC)
Posts: 15
Thanks: 1 times
|
Originally Posted by: MS Support  Not sure if I fully understood, but you can try the following to see if it meets your criteria:
F4:=C;
F3:=Ref(C,-1);
F2:=Ref(C,-2);
F1:=Ref(C,-3);
If(F3>F2,F4-F3,F3-F4)
Thankyou, it worked. Great job.
sam
|
|
|
|
|
|
| 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.
