Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Mon, 06 May 2024 13:39:00 +0000

[User Discussion] - simple counting spreadsheet cell

View Count: 879

[Page 1 of 1] First Page -- 1 -- Last Page

[2015-05-24 19:57:04] #1 [Go To First Post]
SSGill - Posts: 35
Hello; I am using SC spreadsheet for trading. I'm using version 1258. In the old spreadsheets. This is on a one minute chart. In cell p3, this formula =IF(P4=20,1,P3+1), I would have expected to count on each new row of data, instead, it updates it seems every time the data changes on the chart. 10-20 times per minute. Another issue is that in the following columns, I don't see a counting on each row, but a repeat of the same number that changes in cell p3, again 10-20 times per minute.
0x Thank you
temp.PNG / V - Attached On 2015-05-24 19:55:29 UTC - Size: 68.57 KB - 321 views

[2015-05-25 15:37:29] #2 [Go To First Post]
SSGill - Posts: 35
I used Sierra Charts about 2 years ago, and this simple formula would have only updated once per row, and would have given me back a count down each row uptil 20,then reset, like it's written. I don't understand why it is doing this. Any help would be greatly appreciated, on the above question.
0x Thank you

[2015-05-25 18:41:32] #3 [Go To First Post]
Sawtooth - Posts: 3993
This counts from 1 to 20 at each new row, then starts at 1 again, in cell P3: =IF(OR(MROUND(A3-INT(A3),1/86400)=0,P4=20),1,P4+1) It starts at midnight, but you could start it at any time, or at any one-time event.
0x Thank you

[Page 1 of 1] First Page -- 1 -- Last Page