Support Board

Date/Time: Mon, 25 Nov 2024 08:49:41 +0000

Post From: Count Number of times of New Alert Condition Since Previous Color Bar Alert Triggered

[2024-03-29 15:49:04] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4120
Here's a spreadsheet syntax solution: =IF(AND(K4=0,K3=1),0,IF(D3<D4,O4+1,O4)) where this formula is in cell O3. This assumes the TRUE in K3 is persistent until there is a short signal. To convert this to the Spreadsheet Formula study, which uses Alert syntax: =IF(AND(ID1.SG2=0,ID1.SG1=1),0,IF(L<L[-1],ID2.SG1[-1]+1,ID2.SG1[-1])) where ID2 is this Spreadsheet Formula study.