Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 23:21:20 +0000



Post From: Opening Swing High

[2024-01-31 15:29:05]
John - SC Support - Posts: 36286
First you need to isolate the data between 07:30 and 07:40. To get all the Lows in this time use the following formula in Cell 3 of the a formula column:
=IF(AND(FRACTIME(A3) >= TIME(07, 30, 00), FRACTIME(A3) <= TIME(07, 40, 00)), ID0.SG3@3, 0)

Then you can use the MIN() to get the lowest value in that column.

Hopefully this gives you enough to get the rest worked out.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing