Login Page - Create Account

Support Board


Date/Time: Wed, 16 Jul 2025 03:01:21 +0000



Post From: Spreadsheet trading - buy / sell if condition remains true for X duration?

[2022-07-28 17:10:09]
John - SC Support - Posts: 40916
There is not a way within the Spreadsheets to count time on its own. If you wanted to wait 5 seconds, then you would have to have a chart with 5 second (or less) bars. That way, you could then check the current bar and and the last two bars to see if your condition is true for all three, which will indicate that it has been true for at least 5 seconds (at the close of the bar 2 prior, at the close of the bar one prior and at the open of the current bar, which gives 5 seconds between them.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing