Home >> Support Board

Support Board

Date/Time: Sat, 01 Feb 2025 18:58:15 +0000

How to Post a Message for Support

[Programming Help] - ,,,set counting to column,,,

View Count: 551

[2019-07-30 10:12:24] #1 [Go To First Post]
User865284 - Posts: 4
Hi , I need help to Spreadsheet System for Trading how to set counting to column P ///start J42 / stop - reset J43 Thank you


10.png / V - Attached On 2019-07-30 10:10:38 UTC - Size: 14 KB - 239 views

[2019-07-30 11:46:08] #2 [Go To First Post]
Sawtooth - Posts: 4164
The easiest way is to use an event or signal in a Formula Column to create an incrementing variable. Here are some examples: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables

[2019-07-31 15:29:28] #3 [Go To First Post]
User865284 - Posts: 4
,,, I've already tried .... /// not count correctly //// Thanks for help


15.png / V - Attached On 2019-07-31 15:27:52 UTC - Size: 23.08 KB - 223 views

[2019-08-01 08:21:22] #4 [Go To First Post]
User865284 - Posts: 4
?? is another way / formula... ?? how to count bars / time /// ,, in J42 J43 is time value ../// thank you

[2019-08-01 12:18:55] #5 [Go To First Post]
Sawtooth - Posts: 4164
I've already tried .... /// not count correctly //// It looks like the incrementing variable is not being reset with a TRUE in L3. =IF(L3, 0,IF(OR(K3, P4 > 0), P4 + 1, P4)) This formula counts correctly if there is a TRUE somewhere in L3. You'll need to reset the variable with another event. The first IF statement resets the incrementing variable to 0. The second IF statement begins the count.

To post a message in this thread, you need to log in with your Sierra Chart account: