Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 14:46:09 +0000



Color Bar Based On Alert Condition Question

View Count: 1479

[2014-05-09 15:50:22]
infpz - Posts: 826
Looking to Color Bar when the 3 Moving Averages in the Moving Averages Study cross in the same bar.

I am getting an alert when I use this formula: =CROSSOVER(ID1.SG1,ID1.SG2,ID1.SG3)

Any help would be appreciated.
[2014-05-09 16:31:04]
Sierra Chart Engineering - Posts: 104368
There is not enough detail here for us to help with. What are the exact cross rules?

Also using more than two Study Subgraph references for the CROSSOVER function will not work.
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
[2014-05-09 16:43:43]
infpz - Posts: 826
OK. We would like to color the bar if at anytime inside of a 1 candle, all 3 MAs have the same value.
[2014-05-09 17:10:24]
Sierra Chart Engineering - Posts: 104368
This would seem to be a very unlikely scenario but the formula would be:
= AND (ID1.SG1==ID1.SG2,ID1.SG2 ==ID1.SG3)

It would be doubtful that this would work properly. You would need to add some kind of range check to the formula to see when the values are close.
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
[2014-05-09 17:12:28]
infpz - Posts: 826
OK. Something so it does not have to be so precise - can you provide some guidance on how to do that?
[2014-05-11 02:25:36]
Sierra Chart Engineering - Posts: 104368
This the general formula to use:

Alert Formula For When Difference Between All 3 Study Subgraph Lines Is Less Than Chart Tick Size: =AND(ABS(SG1-SG2) < TICKSIZE, ABS(SG2-SG3) < TICKSIZE)

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