Support Board

Date/Time: Mon, 16 Sep 2024 19:51:51 +0000

Post From: Same-day calculations

[2024-07-27 03:57:15] Link To Thread - Link To Post [Go To First Post]
pjk0225 - Posts: 27
I need help getting a spreadsheet formula to limit its calculations to only bars that occurred on the same day. I want to get a daily total to compare with other days. I'm using a spreadsheet formula study with the "sum" function, but currently I am simply limiting the range of the bars to count and manually checking the value at the end of the day by moving the chart to display the last bar of the day at the very right edge of the screen. I'm using the formula: sum(ID175.sg1[0:-2591]) for a 10 sec chart. How can I update this to calculate a day's worth of bars based on my set market hours or a "time range highlight" study?