Support Board
Date/Time: Tue, 24 Mar 2026 11:14:51 +0000
Post From: active formula depend on difference between bars
| [2023-07-26 16:25:14] |
| Sawtooth - Posts: 4321 |
|
You can also do it with another instance of the Spreadsheet Formula study using a formula that counts bars since the crossover: =IF(CROSSOVER(ID1.SG1,ID2.SG1),1,ID4.SG1[-1]+1) where ID4 is this Spreadsheet Formula study. Then reference this study's output for a value >40. |
