Hi, If I can capture the HIGH (i.e. actual value) then may be I can write a formula.
The Logic would be as below. IF CLOSE > IF(PDI > MDI, THEN HIGH, ELSE CLOSE+1 (Just to ensure that the condition fails in else part)). The problem here is, I am not able to fetch the HIGH value in 'THEN' part of the IF STATEMENT. So with respect to above example, the 100 should appear in place of THEN part. If I can do it, then formula is successful and I can filter stocks in exploration. Any help?
