Support Board
Date/Time: Wed, 27 Nov 2024 22:32:31 +0000
Post From: function
| [2014-10-09 23:42:21] |
| Sawtooth - Posts: 4120 |
|
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
|