Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 12:40:23 +0000



Number bars, color delta text when same value as volume

View Count: 413

[2023-08-20 21:46:32]
jrob - Posts: 22
Hello,

I am using Number Bars with the following 3 columns.
Column 1 Bars Text = Ask - Bid Diff
Column 2 Bars Text = Volume
Column 3 Bars Text= No Text

I want to highlight the text in column 1 (Delta), when it is equal to the text in column 2 (Volume).

I changed the Column 1 Text Coloring Method to "Based on Volume - Actual", then I set the Column 1 % Compare Threshold to 1, enabled 'Use Sep. Colors for Text' and then set Range 0 Up\Down to my color preference. This is sort of working, but it is highlighting some text that is should not. Any suggestions? Am I going about this in the correct way?
imagefp.jpg / V - Attached On 2023-08-20 21:25:42 UTC - Size: 28.54 KB - 112 views
[2023-08-21 16:07:10]
John - SC Support - Posts: 36309
There is not a way to do this within the Numbers Bars study itself.

What you can do is use 2 copies of the "Volume at Price Threshold Alert V2" and set the following Inputs:
- Comparison Method: Ask Volume Bid Volume Ratio
- Percentage Threshold: 1000 / -1000 (one copy set this to 1000, and -1000 in the other copy)
- Enable Zero Bid/Ask Compares: Yes
- Zero Value Compare Action: Set Percentage to +/- 1000

Since you are wanting a situation where the Difference is equal to the Total Volume, then this means that either the Bid or Ask is zero. The Volume at Price Threshold Alert V2 has the special setting to force a zero value comparison to 1000%, which is typically large enough that other comparisons would not get to this range.

The +1000 setting gives you the situation where the Bid is 0, and the -1000 gives you when the Ask is 0.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-08-21 18:47:43]
jrob - Posts: 22
Thanks for the reply John. That is pretty close, but it is still highlighting a few rows that are not zero's. Any other suggestions?
imagefp.jpg / V - Attached On 2023-08-21 18:47:19 UTC - Size: 32.88 KB - 102 views
[2023-08-22 14:38:41]
John - SC Support - Posts: 36309
If it is highlighting other rows that are non-zero, then look at the percentage values of the Ask to Bid volume ratio. If it is 1000% or more, then that is the reason for this, and there is not another option to get what you want using the built-in tools.

You would have to create a custom study to get exactly what you want. Refer to the following:
Advanced Custom Study Interface and Language (ACSIL)
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:

Login

Login Page - Create Account