Home >> Support Board

Support Board

Date/Time: Sun, 08 Sep 2024 01:52:41 +0000

How to Post a Message for Support

Same-day calculations

View Count: 116

[2024-07-27 03:57:15] #1 [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?

[2024-07-29 14:34:31] #2 [Go To First Post]
John - SC Support - Posts: 34254
You can not use the Spreadsheet Formula to do what you are wanting. It is simply too complex for that study. You would have to use the Spreadsheet Study to do this, or create a custom study. Refer to the following: Overview of Spreadsheet Studies For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account: