Support Board

Date/Time: Mon, 16 Jun 2025 17:30:11 +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: 4227
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