Support Board
Date/Time: Fri, 09 May 2025 15:09:48 +0000
Post From: Spreadsheet formula study to count occurences since session open bar
| [2023-05-26 20:36:30] |
| User562383 - Posts: 10 |
|
How to calculate how many times events have occurred since the session open bar using the spreadsheet formula study? The simplest example would be bar count since the open. Eg If it's the opening session bar, set it to 0, otherwise add 1 to the previous cell IF(ABS(BARTIME - TIME(9, 30, 0)) < TIME(0, 0, 1),0,ID22.SG1@4+1) Results in every entry = 0. IF(ABS(BARTIME - TIME(9, 30, 0)) < TIME(0, 0, 1),0,1) and IF(ABS(BARTIME - TIME(9, 30, 0)) < TIME(0, 0, 1),0,CU4+1) Results in opening bar = 0 and every other entry = 1 except opening bar, but I need a running count. Eg 0,1,2,3,4,5... |