Support Board
Date/Time: Wed, 14 May 2025 23:41:40 +0000
Post From: Paintbar 3 closes above/below a study
| [2016-04-01 18:12:04] |
| Sawtooth - Posts: 4215 |
|
To create a persistent TRUE, use a double IF statement, where the first IF turns it on and repeats until the second IF turns it off, in cell K3: =IF(AND(E3>B3,E3>ID1.SG3@4,E4>ID1.SG3@5,E5>ID1.SG3@6),1,IF(AND(E3<B3,E3<ID1.SG3@4,E4<ID1.SG3@5,E5<ID1.SG3@6),0,K4)) This requires that only the most recent bar be an up bar. Use the same formula in L3, except reverse all of the comparison operators, finishing with L4 instead of K4. With both formulas, every bar will be colored, leaving no black bars. |