Support Board
Date/Time: Sat, 24 May 2025 07:48:20 +0000
Post From: active formula depend on difference between bars
| [2023-08-13 14:59:25] |
| Sawtooth - Posts: 4220 |
|
You'll need to make the value persistent each time it changes, then subtract the current bar's value from the persistent value's previous value. You make the value persistent with a formula like this: Spreadsheet Formula study: =IF(event,ID6.SG1,ID7.SG1[-1]) where ID6 is the value you want to make persistent, and ID7 is this Spreadsheet Formula study. Then subtract: =ID6.SG1-ID7.SG1[-1] |