Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 15:46:08 +0000



Post From: Period High and Low

[2024-02-28 20:57:34]
John - SC Support - Posts: 36245
The easiest way to do this is to use the Spreadsheet Study and use an IF() statement to check the time and if it is not in the time you want output a zero (0). For instance, to only show the values between 00:00:00 and 16:59:59 you would enter the following in cell K3:
=IF(AND(FRACTIME(A3) >= TIME(00, 00, 00), FRACTIME(A3) < TIME(16, 59, 59)), ID1.SG1@3, 0)

Where ID1 is the ID of the High/Low for time period study and SG1 is one of the Subgraphs. Refer to the following for an explanation of the notation ID1.SG1@3:
Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2024-02-28 20:59:37