Support Board
Date/Time: Thu, 03 Jul 2025 07:10:37 +0000
poc
View Count: 129
| [2025-07-01 14:00:33] |
| User220939 - Posts: 52 |
|
Hi, I wrote a formula in the study "color bar based on alert condition" to highlight the poc when it is placed on the second tick of a candle. but it doesn't work on all candles and I don't understand why |
 Capture d’écran 2025-04-18 090958.jpg / V - Attached On 2025-07-01 13:59:53 UTC - Size: 56.59 KB - 22 views |
| [2025-07-01 14:20:24] |
| cmet - Posts: 708 |
|
How can anyone possibly help you without seeing the formula?
|
| [2025-07-01 14:36:48] |
| User220939 - Posts: 52 |
|
Ho sorry, =AND(ID3.SG1=L+TICKSIZE*1) ID3 is "volume point of control for bar" |
| [2025-07-01 16:34:58] |
| John - SC Support - Posts: 40722 |
|
You do not need the AND() in your formula, as you only have a single item being tested, so you can simplify to the following: =ID3.SG1 = L + TICKSIZE But, that will not create a problem, just informational. Your formula is fine (apart from what we mention above). We do not understand what we are looking at in the image, so we do not know what is working and what is not. You need to troubleshoot by having the "Volume Point of Control for Bar" displayed along with the Color Bar Based on Alert Condition, so you can compare the two items together. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-07-01 18:10:37] |
| User220939 - Posts: 52 |
|
in the image, the poc of the white arrows is good, the formula works, it is green. the poc on the red arrow remains blue even though it should be green since it is in the same location as the green ones. I tried the new formula I have the same problem I can't figure out why it works on some candles and not others. |
| [2025-07-01 18:57:52] |
| John - SC Support - Posts: 40722 |
|
We do not think it is your formula, but something else, although we do not know what. Please get us that chart by following these instructions for us to take a look at it: Support Board Posting Information: Providing Chartbook with Only a Single Chart For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-07-02 06:06:01] |
| User220939 - Posts: 52 |
|
File attached
|
 footprint test.Cht - Attached On 2025-07-02 06:05:43 UTC - Size: 11.84 KB - 5 views |
| [2025-07-02 15:16:15] |
| John - SC Support - Posts: 40722 |
|
Everything is fine with the chartbook when we look at it. Every instance in which the POC is at the Low or 1 or 2 ticks above are colored correctly. The only thing we can see is that you have the "Color Bar Based on Alert Condition" set to color 50000 bars. We wonder if that bar that is not showing correctly is one bar back from that (i.e. bar 50001 back from the end of the chart). Admittedly, 50000 bars is a lot, and is more than is loaded in the chart you sent us. But from the setup you have, it would be the only reason for an issue. We do want to point out that there is an easier way to do what you want with a single Color Bar Based on Alert Condition. It will not make any difference in the results, it just eliminates two other studies from your chart. To do this, do the following: - Remove two of the "Color Bar Based on Alert Condition Studies". - On the remaining study, enter the following for the alert condition: =OR(ID3.SG1 = L, ID3.SG1 = L + TICKSIZE, ID3.SG1 = L + TICKSIZE * 2) - Change the "Based On" to be the "Volume Point of Control for Bars" study. - Change the "Input Data" to "VPOC". - Set "Draw Style Percentage/Ticks Offset" to "0". For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-07-02 15:36:46] |
| User220939 - Posts: 52 |
|
Hi, I just did exactly what you told me, the problem is still there. Instead of 50000 I put 50 in "numbers bars of calculate" the blue poc on the red arrows should be green |
| Capture d’écran 2025-04-18 090958.jpg / V - Attached On 2025-07-02 15:36:36 UTC - Size: 247.18 KB - 14 views |
| [2025-07-02 16:32:54] |
| John - SC Support - Posts: 40722 |
|
With regards to the number of bars, we were suggesting you might need to increase it, not decrease it. When we looked at your chart, everything was fine. We can not reproduce the problem, so we can not say where it is coming from nor can we tell you exactly what to do, as everything works fine for us. Our recommendation for troubleshooting would be to use a different Draw Type for the Color Bar Based on Alert Condition (such as Square Offset Left) so you can see if it is actually being active for those bars. Then move forward from there. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-07-02 16:40:15] |
| User220939 - Posts: 52 |
|
even with another type of drawing, it does the same thing. once it works and once it doesn't work
|
| [2025-07-02 16:57:54] |
| User431178 - Posts: 732 |
|
in the image, the poc of the white arrows is good, the formula works, it is green. the poc on the red arrow remains blue even though it should be green since it is in the same location as the green ones. I tried the new formula I have the same problem I can't figure out why it works on some candles and not others. What tick size are you using? In your images it looks like possibly 1.0. If you are using a non-standard tick size, then you probably use MROUND on the low before making the comparison, as the true low price is not rounded to the tick size. =ID3.SG1=MROUND(L, TICKSIZE)+TICKSIZE*2 |
| [2025-07-02 17:11:52] |
| User220939 - Posts: 52 |
|
oh right I hadn't thought of that... now it works perfectly on ticksize*2, but not on L, nor on ticksize
|
| [2025-07-02 17:24:20] |
| User431178 - Posts: 732 |
|
It seems to work ok at my end. // LOW
=ID3.SG1=MROUND(L, TICKSIZE) // LOW + 1
=ID3.SG1=MROUND(L, TICKSIZE) + TICKSIZE // LOW + 2
=ID3.SG1=MROUND(L, TICKSIZE) + TICKSIZE * 2 |
| [2025-07-02 17:25:31] |
| User220939 - Posts: 52 |
|
it's good it works thank you very much
|
To post a message in this thread, you need to log in with your Sierra Chart account: