Login Page - Create Account

Support Board


Date/Time: Thu, 09 Jan 2025 20:06:40 +0000



Formula help

View Count: 818

[2016-08-04 23:51:23]
User976133 - Posts: 38
Good evening,
I have three different studies that I want to develop into an alert, changing the background color or adding an arrow.
The conditions are based on the color of the slope of a line.
I want an alert based on if all three evaluate to +1 or all three evaluate to -1. I want the alert to go off when it goes from not all match to when they do match.
I can not figure out where to go next and I need some guidance on how to move forward.
Help is appreciated.
Thank you
Date Time Of Last Edit: 2016-08-05 00:13:27
[2016-08-05 06:06:37]
Sierra Chart Engineering - Posts: 104368
This is explained in this section here:
Study/Chart Alerts And Scanning: Historical and Visual Evaluation of Alert Condition
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2016-08-05 11:10:32]
User976133 - Posts: 38
Thanks for the response, but that is not what I am asking.
3 conditions - A, B, and C
I want to change colors (your link) based on the evaluation of the three conditions.

When A, B, and C are all true on this bar, but not on the prior bar is when I want the alert to go.
The other time is when they are all false and the bare before is not, and then all three turn false.
[2016-08-05 11:13:50]
Sierra Chart Engineering - Posts: 104368
You need to create a formula to do what you want. Refer to this page:

Study/Chart Alerts And Scanning

We do not provide formula programing help. You have to study that page and start work on the formula. If you have very specific question about something which is not clear you can let us know.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2016-08-05 11:14:44
[2016-08-05 13:50:35]
Sawtooth - Posts: 4147
The formula structure will look like this:

=OR(AND(A=1,B=1,C=1,A[-1]=-1),AND(A=1,B=1,C=1,B[-1]=-1),AND(A=1,B=1,C=1,C[-1]=-1))
[2016-08-05 17:44:30]
Sierra Chart Engineering - Posts: 104368
A,B,C need to replaced with the proper identifiers:
Study/Chart Alerts And Scanning: Alert Condition Formula Format
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to 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