Login Page - Create Account

Support Board


Date/Time: Sat, 23 Nov 2024 08:09:33 +0000



Alert based on closed

View Count: 38

[2024-11-20 01:05:46]
User44790 - Posts: 21
Hello,


I would like to ask you if it is possible to set alert based on same close during five last bars. Closes do not need to be one after another but it has to be in last five bars. So for example it can be 1st bar with 3rd and 5th or 1,2,3 or 2,4,5 etc.


Thank you very much for you answere.
[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

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account