Support Board
Date/Time: Sun, 22 Dec 2024 11:03:15 +0000
[User Discussion] - Color Bar Based On Alert Condition not updating
View Count: 1151
| [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] |
| |
|
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] |
| |
|
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] |
| |
|
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] |
| |
|
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] |
| |
|
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: 4141 |
|
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] |
| |
|
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: