Support Board
Date/Time: Sun, 24 Nov 2024 03:24:57 +0000
Numbers Bars Calculated Values Text on Chart
View Count: 312
| [2024-06-22 09:15:50] |
| mandano89 - Posts: 24 |
|
I have a footprint chart with additional calculated values (Low Bid Volume Percent & High Ask Volume Percent). I am using the Number Bars Calculated Values in combination with Color Bar Based Alerts + Study Subgraph Above/Below Bar as Text. This is already working as you can see in the attachment. - bearish candle --> show High Ask Volume Percent, above bar, red color - bullish candle --> show Low Bid Volume Percent, below bar, green color Now I am trying to add additional conditions. I only want to see: - values equal 30 and above - values equal 0.7 and below All other values should be removed. Is it possible to do this and how can I do this? |
 footprint_Ratios.PNG / V - Attached On 2024-06-22 09:15:27 UTC - Size: 49.77 KB - 63 views |
| [2024-06-24 06:52:26] |
| mandano89 - Posts: 24 |
|
Can anyone help?
|
| [2024-06-24 17:35:30] |
| John - SC Support - Posts: 36238 |
|
From what you describe, you need to adjust your "Color Bar Based on Alert Condition" study to add the conditions that you want.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-06-24 19:41:05] |
| mandano89 - Posts: 24 |
|
Yes, but I dont know how the code looks like. Do you know the answer?
|
| [2024-06-24 20:23:50] |
| John - SC Support - Posts: 36238 |
|
What exactly does the "Color Bar Based on Alert Condition" do in this situation? What is it coloring?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-06-25 06:44:05] |
| mandano89 - Posts: 24 |
|
The Color Bar Based on Alert Condition colors the text like this: - bearish candle --> show High Ask Volume Percent, above bar, red color - bullish candle --> show Low Bid Volume Percent, below bar, green color For the red color I use the following condition: =C < C[-1] For the green color I use the following condition: =C >= C[-1] |
| [2024-06-25 14:17:09] |
| John - SC Support - Posts: 36238 |
|
To start with, you do not need the "Study Subgraph Above/Below Bar as Text" study. The "Color Bar Based on Alert Condition" can do this for you. Rather than basing the Color Bar Based on Alert condition on the "Study Subgraph Above/Below Bar as Text" set it to be based on the study that the Study Subgraph Above/Below Bar as Text is set to reference. Then change the "Input Data" to be the subgraph of that reference. Then to show only values above 30 and less than .7, you would change your formulas to be the following: =AND(C < C[-1], ID1.SG1 > 30, ID1.SG1 < 0.7) and =AND(C >= C[-1], ID1.SG1 > 30, ID1.SG1 < 0.7) Where ID1 is the ID of the study that has the data and SG1 is the subgraph of that study that has the data. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-06-26 18:29:14] |
| mandano89 - Posts: 24 |
|
Thank you for your help! It works with the following corrected formulas: To show values above 30 and less than 0.7: =AND(C >= C[-1], OR(ID2.SG45 < 0.70, ID2.SG45 > 30)) and =AND(C < C[-1], OR(ID1.SG46 < 0.70, ID1.SG46 > 30)) It was important to add the OR function. Otherwise the number has to be smaller than 0.7 AND bigger than 30. This is impossible. Another important aspect is that you have to checkmark "Use Full Precision" on the Alert. |
| [2024-06-26 19:35:50] |
| John - SC Support - Posts: 36238 |
|
Thank you for catching the OR, you are correct we were not thinking properly. We are surprised that you would have to enable "Use Full Precision". Refer to the following that may be related to this: Numbers Bars: Referencing Numbers Bars Calculated Values Subgraphs in Alert Formulas For the most reliable, advanced, and zero cost futures order routing, use 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: