Support Board
Date/Time: Sat, 26 Apr 2025 10:09:33 +0000
Post From: Historical Information for Column J
| [2018-12-18 22:11:19] |
| Sawtooth - Posts: 4209 |
|
User606491, thanks for the formula. I don't think it would work for scaling in/out, however. Here's a way to zero the values in bars previous to the entry bar: Put this in a formula column, e.g. P3: =IF(ROW()=3,0,OR(P2=1,AND($J$42>A2,$J$42<A1))) Put this in another formula column: =IF(P3=0,(E3-$J$9)*$J$56/$J$21*$J$5,0) |