Login Page - Create Account

Support Board


Date/Time: Sat, 04 May 2024 02:53:19 +0000



[User Discussion] - Color Bar Based On Alert Condition not updating

View Count: 1019

[2015-06-24 12:37:05]
User15952 - Posts: 132
I have a very simple condition; "=AND(V<V[-1],V<V[1])"

It updates initially but as the day progresses it stops working. I have to press F5 to get it to restart. This keeps on happening throughout the day.

I have "enabled" and "evaluate on bar close checked"
[2015-06-24 17:12:41]
Sierra Chart Engineering - Posts: 104368
Although you have enabled the option Evaluate On Bar Close, the following new bar is still in the process of forming and will have a very low volume.

This formula is only evaluated once when a new bar begins to form.
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: 2015-06-24 17:16:51
[2015-06-24 17:15:32]
User15952 - Posts: 132
Thanks for the reply, it is not lagging by one bar but by multiple bars.
[2015-06-24 17:17:40]
Sierra Chart Engineering - Posts: 104368
We do not fully understand what you are saying, however one thing is for sure is that formula is not going to work properly in real-time.
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
[2015-06-24 17:18:59]
User15952 - Posts: 132
How should the formula be to work in real time?
[2015-06-24 17:38:49]
Sierra Chart Engineering - Posts: 104368
This is equivalent:
=AND(V[-1]<V[-2],V[-1]<V)

You also need to uncheck Evaluate on Bar 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
Date Time Of Last Edit: 2015-06-24 17:39:04
[2015-06-24 17:55:02]
User15952 - Posts: 132
They are not equivalent.

=AND(V<V[-1],V<V[1]) is a very different condition to =AND(V[-1]<V[-2],V[-1]<V)
[2015-06-24 18:24:03]
Sierra Chart Engineering - Posts: 104368
When you have enabled Evaluate on Bar Close for the Color Bar Based on Alert Condition study, what it effectively does is evaluate the Alert Condition Formula across all bars in the chart other than the last one. So when it is disabled, the evaluation also occurs on the last bar in the chart.

The formula we gave is equivalent but it will show the result on the next bar compared to the formula you are using. So the last bar the chart will be evaluated as well.

Not sure how we can make this more clear. But in any case, the formula you are original using will not work. It is simply impossible.
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
[2015-06-25 09:28:47]
User15952 - Posts: 132
I am not sure why you are not seeing they are CLEARLY DIFFERENT mathematical formula. Please study them closely. I have attache an image with my condition and your condition activated. The grey background are the conditions.

http://screencast.com/t/DhRJxYhmrh7e
[2015-06-25 09:43:45]
Sierra Chart Engineering - Posts: 104368
It makes sense to us. We did indicate that the formula we provided will display the indication on the following/next bar. This is exactly what we see.

If this will not work for you, we have no other advice. It is not within the scope of our support to provide formula programming help.

We have identified the problem, and said that the formula that you want to use will not work in real-time. And we spent a significant time analyzing why that is the case.
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: 2015-06-25 09:44:25
[2015-06-25 12:21:27]
User15952 - Posts: 132
It is a good thing you dont provide forumula programming, you are struggling with simple mathematics. Even on an end of day chart they produce different results. If I was a paying customer I would be pissed. LOL

Thanks for trying.
[2015-06-25 15:21:13]
Sawtooth - Posts: 3993
It looks like the results are the same, except that it is displaced one bar.

The issue is that your formula is referencing a future bar.

Try using SC's formula, and set the Displacement to -1 in the Color Bar study.
Also, leave Evaluate On Bar Close unchecked.
[2015-06-25 15:45:48]
User15952 - Posts: 132
Thank you so much, finally someone can see there is a difference. I appreciate it.
[2015-06-25 16:48:34]
Sierra Chart Engineering - Posts: 104368
This is not the case:
, you are struggling with simple mathematics.

We have given you mathematically the correct formula but it is drawn on the next bar as it would have to be.

This is what Tom said:
It looks like the results are the same, except that it is displaced one bar.

Tom suggested to use a Subgraph Displacement setting of -1 with the Color Bar Based on Alert Condition study. We had not thought of that. Doing that should put the result on the bar that you expect.
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