Login Page - Create Account

Support Board


Date/Time: Thu, 01 May 2025 23:09:59 +0000



Post From: Alert on past condition

[2025-02-20 16:19:51]
John - SC Support - Posts: 39605
This can be done, but it requires that you create a "Persistent Variable" to capture when the line has crossed the opposing line first. And you would need to add a condition to control that it is just looking at today's incident. For example, here is how the persistent variable would be written for the Low of a bar to have crossed the Initial Balance Low line using the "Spreadsheet Formula" study:
=IF(AND(BARDATE = TODAY(), CROSSOVER(L, ID1.SG9)), 1, ID2.SG1[-1])

Where ID1 is the ID of the Initial Balance study and SG9 is the IB Low subgraph of the Initial Balance study; ID2 is the ID of the Spreadsheet Formula study and SG1 is the Result subgraph of the Spreadsheet Formula study.

You would then use this with a test for a crossing through the IB High to get what you want.

Refer to the following:
Study/Chart Alerts And Scanning: Alert Condition Formula Format

Spreadsheet Formula
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing