easy formula help

M

market_looser

Member
#1
#1
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

ML
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
N Algo trading made easy :Flash Trader Algo & Automated Trading 6
I EA for easy risk calculation and placing orders Software 1
W Easy for you , but hard for me :( PLEASE help :) AmiBroker 3
E write a easy formula Max today - Max yesterday MetaStock 0
S Converting Metastock formula into EASY language for Tradestation TradeStation 0

Similar threads