Support Board

Date/Time: Mon, 11 May 2026 09:40:54 +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: 4329
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