Login Page - Create Account

Support Board


Date/Time: Sat, 23 Nov 2024 11:47:43 +0000



Post From: Alert based on closed

[2024-11-20 14:23:20]
John - SC Support - Posts: 36238
Yes, this can be done, but the formula is going to get a bit long, as you will need to check every combination you want. For example, to test the two you list the formula would be the following:
=OR(AND(C = C[-1], C = C[-2]), AND(C[-1] = C[-3], C[-1] = C[-4]))

You would need to expand the formula to cover all your situations.

Refer to the following:
Study/Chart Alerts And Scanning: Available Main Price Graph Identifiers/Variables

Study/Chart Alerts And Scanning: Referencing Data Other Than on the Last Bar/Column In the Chart

Study/Chart Alerts And Scanning: OR and AND Functions
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing