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

Notification

Icon
Error

Options
Go to last post Go to first unread
mymetaforum  
#1 Posted : Thursday, February 4, 2016 2:44:07 PM(UTC)
mymetaforum

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

mymetaforum  
#2 Posted : Friday, February 5, 2016 8:55:20 AM(UTC)
mymetaforum

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 ?
MS Support  
#3 Posted : Monday, February 8, 2016 10:37:01 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,943

Thanks: 86 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)
thanks 2 users thanked MS Support for this useful post.
mymetaforum on 2/9/2016(UTC), Pescasub on 2/9/2016(UTC)
mymetaforum  
#4 Posted : Tuesday, February 9, 2016 4:07:49 AM(UTC)
mymetaforum

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/27/2013(UTC)
Posts: 15

Thanks: 1 times
Originally Posted by: MS Support Go to Quoted Post
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.