Support Board
Date/Time: Mon, 16 Jun 2025 17:41:22 +0000
Post From: Sum of Values restricted to Session/Trading Day
[2025-05-01 00:05:18] |
Sawtooth - Posts: 4227 |
what if I needed to accomplish this using just the library of studies on SC and the Spreadsheet Formula study?
Try this, using the Spreadsheet Formula study:=IF(BARDATE<>BARDATE[-1],ID237.SG1,ID237.SG1+ID1.SG1[-1]) where ID1 is this Spreadsheet Formula study. This will give you a cumulative sum since Midnight. But you need to scroll back to see each day's summed value. You also might try the Cumulative Sum of Study study, and set 'Reset at Start of Trading Day' to Yes. However, this study uses the Chart Setting's Session Start time for the trading day start, if 'Use Evening Session' is set to No, but uses the Evening Start Time if 'Use Evening Session' is set to Yes. |