Support Board

Date/Time: Fri, 06 Feb 2026 16:17:16 +0000

Post From: Sum of Values restricted to Session/Trading Day

[2025-04-30 15:32:43] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4313
Try this, using the Spreadsheet Study study: K3: =IF(INT(A3)<>INT(A4),0,K4+1) L3: =SUM(ID237.SG1@3:OFFSET(ID237.SG1@3,K3,0)) This brings the sum of the most recent day's values to row 3. Assuming the Number of Rows setting is large enough to see previous days, use another Formula Column for each previous day: M3: =IF(INT(A3)<>INT(A4),L4,M4) O3: =IF(INT(A3)<>INT(A4),M4,O4) ...etc. This is based on this example: Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values