Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 09:23:47 +0000



Alert Formula Question

View Count: 1044

[2014-04-25 14:22:13]
infpz - Posts: 826
I have a TICK-NYSE chart in Region 2 of an ES Chart (the study overlay study is ID1) and Horizontal Line Study (ID2) also in Region 2. I am using the Color Bar Based on Alert Condition study and would like the bar on the main price graph to be colored when the TICK-NYSE reaches Line 1 (from below) or Line 2(from above) of the horizontal line study.

Can you tell me what I am doing wrong? I am using the following:

=OR(CROSSFROMBELOW(ID1.SG4, ID2.SG1)),(CROSSFROMABOVE(ID1.SG4, ID2.SG2))

ID1.SG4 is the last value of the TICK-NYSE Chart and and ID2.SG1 and ID2.SG2 are line 1 and 2 of the horizontal line study, respectively.
[2014-04-25 17:14:27]
Sierra Chart Engineering - Posts: 104368
Use this:
=OR(CROSSFROMBELOW(ID1.SG4, ID2.SG1),CROSSFROMABOVE(ID1.SG4, ID2.SG2))

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-04-25 17:19:56]
infpz - Posts: 826
I seem to be missing some alerts though, see image. Can you let me know what I am missing?
image1234.png / V - Attached On 2014-04-25 17:19:29 UTC - Size: 42.46 KB - 352 views
[2014-04-25 17:39:48]
Sierra Chart Engineering - Posts: 104368
The problem is clear. You are using the closing price of the bar. So only if that crosses will the condition be true.
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-04-25 17:41:21]
infpz - Posts: 826
OK. can you tell me how to base this on the last trade price instead?
[2014-04-25 18:07:46]
Sierra Chart Engineering - Posts: 104368
This is the problem. You cannot base it on the just last trade/close price. You also need to consider the high and the low.
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-04-25 18:52:22]
infpz - Posts: 826
I changed to overlay-single line and this is working.

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

Login

Login Page - Create Account