Support Board
Date/Time: Tue, 26 Nov 2024 08:31:31 +0000
Background color sharing in Numbers Bars Calculated Value
View Count: 1074
| [2019-04-02 04:18:35] |
| User873570 - Posts: 27 |
|
If I understand this correctly: Numbers Bars: Calculated Values Background Coloring Logic Then when I set "Reset Day Calculation at Both Session Starts" to true, the shade coloring should reset at my Evening Session time (as well as my Day session start). That means that if my evening session time is defined in Chart Settings to being at 18:00, that I should expect to see a range of colors showing up in my "Total volume" value for the bars following 18:00 -- even though all of those values are massively lower than the values generated during the much more active day session. Correct? But that is not what I see. I see a steady line of the color representing Range 0 and none of the other colors. Am I misunderstanding how it should work? |
| [2019-04-02 15:55:36] |
| John - SC Support - Posts: 36286 |
|
Yes, you are misunderstanding. The coloring is not affected by the setting for Reset Day Calculation at Both Session Starts nor does it depend on the daily calculations at all. It simply looks at the entire row of data and determines the highs and lows and percentages based on the entire row of values. We will update the documentation to make sure this is clear. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2019-04-02 16:11:12] |
| User873570 - Posts: 27 |
|
Thank you for clarifying. I am having an issue that my highest band of total volume of 75%+ never gets hit except at 09:30 and 16:00 which effectively renders the coloring useless for the rest of the session. I was hoping to narrow that band or exclude those periods in the determination of colors for the rest of the session. Is it possible to achieve an outcome like this with Numbers Bars Calculated Values today? I realize I could filter out the large volumes that occur at 09:30 and 16:00 but I don't really want the filter the volume amounts, rather I want to filter out those times from impacting the rest of the coloring. Thank you. |
| [2019-04-02 16:51:01] |
| John - SC Support - Posts: 36286 |
|
Really, the only other thing available is changing the Percent Compare Thresholds. Setting the highest percentage to something like .95. But, in doing this you effectively lose one color option. Otherwise, you would be looking to do the Volume Filtering, which the Numbers Bars Calculated Values is capable of doing by referencing another chart, specifically for this kind of reason. You will find the information on how to do this here: Numbers Bars: Overlaying a Numbers Bars Calculated Values Study from Another Chart For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2019-04-02 19:11:00] |
| User873570 - Posts: 27 |
|
I have been unsuccessful at applying volume filter parameters or using any of the proposed approaches above to overcome my challenge. There are huge volume bars on the 1-min ESM19 contract at 15:59pm every day. (This is the chart I was going to try to use as my reference for my numbers bar calculated values study.) I've been focusing on the occurrence on 4/1. I have to go down to an exclusion setting of trade sizes of <50 in the "Exclude >=" just to get the volume to start to move. Most of it still remains even at a setting of 20. Therefore, I cannot use the volume filtering setting to overcome the issue, because the issue is a massive number of transactions at 15:59 every day, it's not large trade sizes, per se. Per https://www.sierrachart.com/index.php?page=doc/NumbersBars.php#CalculatedValuesBackgroundColoringLogic, I cannot simply adjust the threshold values as you suggested, because when my 1m chart bar high value is 65k volume, and almost every other bar is in the hundreds or small thousands, most bars come in between 0-2%. Even the largest normal intraday 1m bars max out around 10%, and there are a very small number of them in a normal day. Next I tried changing the 1-min chart setting session times to exclude 15:58-16:01. That should be sufficient in theory, and that worked on the standalone chart, but then when I tell my numbers bar study on my main chart to reference that chart, it forces it back to using the full session definition. I am out of ideas. Settings on the numbers bar calculated values to help with this would be great. For example: -A lookback number of bars period (this would probably be the simplest - I would provide options at least for 'all bars in view on screen' and 'user-defined number of bars') -Rules/Ranges around bar times or volumes to be excluded -Alternative options as to what math is used to drive the colors of the statistics bars I have been focused entirely on the 'Total volume' value for the moment. I am also using the Bid-Ask and Bid-Ask Change values but I have not dug into those yet, so not sure yet if I have specific requests around those, because I'm stuck on this core issue with respect to Volume. Thank you for your ongoing support. |
| [2019-04-02 20:36:34] |
| John - SC Support - Posts: 36286 |
|
Really, the only thing to do at this point would be to set the Percent Compare Thresholds along the lines of .05, .10, .15. This would give you a range of 0-5%, 5-10%, 10-15%, then 15-100%. As I stated previously, this will basically make the Range 3 color useless, as there is a large range of values in there, but at least you will be able to see a separation between the other colors. Otherwise, the things that you are looking for would be development items. There have been requests like yours, so at least there is some desire from the community, but we just can't give any timeline on when we might be able to get around to these things. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-12-13 02:12:09] |
| User951086 - Posts: 23 |
|
I would like to follow up to inquire whether SierraChart has implemented any fixes for the issue highlighted by the user in 2019. Many of us encounter similar limitations regarding the color codings of the "number bars calculated values" study. This becomes especially problematic due to the extremely high volume of trades, particularly at 9:30 EST and 16:00 EST, rendering the color coding nearly useless. As the user who initially raised this concern suggested, the implementation of settings such as a lookback number of bars period and rules/ranges around bar times or volumes to be excluded would be greatly beneficial. The wait has been considerable, and many users would greatly appreciate it if the team could devise some solutions to address the aforementioned issues. |
| [2023-12-13 15:56:42] |
| John - SC Support - Posts: 36286 |
|
There has not been any work in this area and we can not say when we would get to it.
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: