Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 20 Apr 2024 03:17:39 +0000

How to Post a Message for Support

Post From: function

[2014-10-09 23:42:21]
[Go To First Post]
Sawtooth - Posts: 3976
Use a double IF statement, the first IF to turn on the latched value, the second to turn it off:

Formula in P3:
=IF(AND(Q3>=0,4;Q4<0,4);R3;IF(Q3<0,4;0;P4))

This will capture the first bar's value of Q that was >0,4 at the close of the bar (not the value it was intrabar), and it will repeat until the value of Q < 0,4

Date Time Of Last Edit: 2014-10-09 23:43:28