Support Board
Date/Time: Wed, 27 Nov 2024 14:34:43 +0000
Post From: active formula depend on difference between bars
| [2023-08-13 14:59:25] |
| Sawtooth - Posts: 4120 |
|
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] |