Support Board
Date/Time: Fri, 07 Nov 2025 19:22:47 +0000
average delta
View Count: 19
| [2025-11-07 12:27:28] |
| User220939 - Posts: 57 |
|
Hi, I would like to do a study which highlights an increase in delta above average over the day. But I'm having trouble finding the right formula to take into account only the day. Can you help me? |
| [2025-11-07 15:46:52] |
| John - SC Support - Posts: 42862 |
|
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 |
To post a message in this thread, you need to log in with your Sierra Chart account: