Login Page - Create Account

Support Board


Date/Time: Fri, 07 Nov 2025 21:05:27 +0000



Post From: average delta

[2025-11-07 15:46:52]
John - SC Support - Posts: 42869
You would have to use the Spreadsheet Study to control the averaging over the time period you want. You would need to use the TIME() function for comparison with the bar times to control the period.

For example, to give you the Volume Values for bars that start between 09:00:00 and 12:00:00, you would use the following formula in row 3 of one of the formula columns (such as K3):
=IF(AND(FRACTIME(A3) >= TIME(09, 00, 00), FRACTIME(A3) <= TIME(12, 00, 00), ID0.SG5@3, 0)

You can then calculate the average over those values. You have to be careful with going overnight if you are including the evening session.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing