Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 14:39:10 +0000



Post From: active formula depend on difference between bars

[2023-07-26 16:25:14]
Sawtooth - Posts: 4120
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.