Support Board
Date/Time: Tue, 26 Nov 2024 06:23:50 +0000
Color Shading on Numbers Bars Background (and text)
View Count: 4222
| [2016-12-14 17:51:46] |
| BenjaminR - Posts: 170 |
|
Hi: I've explored the manual on the available options on coloring both the background and text, but have not found one that fits what I'm trying to do. I am trying to color the background (full type) based on 3 net volume levels: high, medium, and light - similar to the diagonal percentage method; however I need to specify the difference between the net buyers and net sellers for the level. For example 1-300 net buyers/net sellers between the bid/ask would be lighter color green on the bid, and above 301 a darker shade, etc. It would be great to have this option in coloring the text as well, and not the backgound, so as to be able to efficiently use the background for a profile type in the same column, for example. Please advise, and thank you! |
| [2016-12-14 17:57:58] |
| BenjaminR - Posts: 170 |
|
I may have found the way to do this through 'compare threshholds', as long as it is actually comparing net difference, versus a ratio or percentage. Am I on the right track? I always try a search of the board first before submitting a request or help topic. |
| [2016-12-14 18:22:47] |
| BenjaminR - Posts: 170 |
|
Okay.. I haven't read every post on the support board that mentions Numbers Bars, but none seem to fit what I'm doing. I read 'compare thresholds', and set values, etc... but it is not functioning like I'm looking for. I've tried all the selections under Background Coloring methods... no joy. So I'll wait for your instructions.
|
| [2016-12-14 18:26:25] |
| |
|
This is supported. You need to use this particular Background Coloring Method described at 5 here: http://www.sierrachart.com/index.php?page=doc/NumbersBars.php#BackgroundColoringMethods The comparison thresholds need to be greater than 1. For complete details, refer to: http://www.sierrachart.com/index.php?page=doc/NumbersBars.php#AskVolBidVolDiffPercentage 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 |
| [2016-12-14 18:58:30] |
| BenjaminR - Posts: 170 |
|
I will send a screenshot when I can... this doesn't work, and I've tried reversing the colors, reversing the values, making them negative, etc. I'm installing an OS on the machine currently, so when that's finished it will be easier to post a screenshot with notations. Thank you, |
| [2016-12-14 19:16:09] |
| |
|
It definitely does work. It is not going to help us to see a screenshot. Instead provide a Chartbook with a single chart containing the Numbers Bar study: Support Board Posting Information: Providing Chartbook with Only a Single Chart 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 |
| [2016-12-14 19:39:41] |
| BenjaminR - Posts: 170 |
|
I am sure it works the way it's coded. Never questioned that. I am also sure the solution offered works for what you perceived I was trying to do. However following your instructions, did not yield the result. No problem. Seemed to me perhaps I didn't communicate clearly enough what I was looking for, therefore illustrating it is a way to at least be sure we are on the same page. I have seen other users attach a screenshot. Maybe I've done it wrong per your instructions. Okay, unlikely, but no problem. Per your request I am attaching a chartbook containing the Numbers Bar Study. |
Private File |
| [2016-12-14 20:42:48] |
| |
|
The settings are not correct for the Numbers Bars study in this Chartbook. You need to set Column 1 Background Coloring Method to: Based on AskVol BidVol Difference Percentage You need to set Column 1 Compare Thresholds to something like: 300, 600, 900 After that just adjust the color inputs as required to what you want. How the colors are used is documented here: http://www.sierrachart.com/index.php?page=doc/NumbersBars.php#AskVolBidVolDiffPercentage 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: 2016-12-14 20:43:57
|
| [2016-12-24 15:04:08] |
| BenjaminR - Posts: 170 |
|
This is a bit downstream now, but wanted to explain why I simply submitted a chartbook with a single numbers chart per your request, instead of the one I was working with. I just read this at face value- "Instead provide a Chartbook with a single chart containing the Numbers Bar study:". I did, however, have the study set up correctly on my working chart, per your first instructions. The reason I did not believe it was working properly, is that I was comparing background coloring based on bid/ask ratios by reading the values as I scrolled back to see if it was working. It seemed to sometimes work and other times not. I realize now that this is because I was not watching how the bars were colored in real-time. As explained in the manual, "Due to the diagonal comparison, the Bid Volume and Ask Volume at a single level could both be considered dominant." I think this is why I thought perhaps I was misunderstood after following the initial directions. Thank you for your help. Cheers. |
| [2018-03-29 20:30:04] |
| whats1thingnow - Posts: 407 |
|
You need to set Column 1 Background Coloring Method to: Based on AskVol BidVol Difference Percentage
You need to set Column 1 Compare Thresholds to something like: 300, 600, 900 After that just adjust the color inputs as required to what you want. How the colors are used is documented here: http://www.sierrachart.com/index.php?page=doc/NumbersBars.php#AskVolBidVolDiffPercentage i'm want to use Based on AskVol BidVol Difference - Percentage but cannot find it anywhere? i want to color my numbers bars similar to this method (Numbers Bars: NumbersBars Calculated Values Background Coloring Example ), but the values used i want it to be the AskVol BidVol Difference can you help? |
| [2018-03-29 20:50:52] |
| BenjaminR - Posts: 170 |
|
Be sure you are using the scroll bar in the dropdown menu to see all of the options available. Perhaps this is what you are looking for: Numbers Bars: Background Coloring Based on Dominant AskVol BidVol To Volume At Price Percentage Hopefully that helps. Be sure to carefully read the descriptions of the options in the documentation. |
| [2018-03-29 21:34:46] |
| whats1thingnow - Posts: 407 |
|
Thanks @BenjaminR for the reminder ... I looked at the documentation again thoroughly and indeed did not see what i'm looking for This is a description of what I hope the Background Coloring is Based on: AskVol BidVol Difference - Value Percentage Just like https://www.sierrachart.com/index.php?page=doc/NumbersBars.php#BackgroundColoringBasedOnAskVolBidVolDifferenceActual: The Value is: Value = Absolute Value(Ask Volume - Bid Volume) Then, it's just like in https://www.sierrachart.com/index.php?page=doc/NumbersBars.php#CalculatedValuesBackgroundColoringLogic, we Color Background of the numbers bars Based on Value Percentage: First, the Highest value and the Lowest value are determined for the row and an Up Range and Down Range are calculated.
- If the Highest value is positive and the Lowest value is negative, then the Up Range is defined from the Highest Value to 0 and the Down Range is defined from the Lowest value to 0 (Up Range = Highest and Down Range = Lowest). - If both values are positive, then the Up Range is determined to be the difference between the Highest value and the Lowest value (Up Range = Highest - Lowest). - If both values are negative, the the Lower Range is determined to be the difference between the Lowest value and the Highest value (Down Range = Lowest - Highest). the Up Range and Down Range are then divided into four percentage groups as defined by the Percent Compare Thresholds. For example, if the Percent Compare Thresholds are set to .25, .50, and .75 then each range is divided into the following groups with each group mapping to a Color Range: - 0.0% - 24.9% Up/Down Range 0 Color - 25.0% - 49.9% Up/Down Range 1 Color - 50.0% - 74.9% Up/Down Range 2 Color - 75.0% - 100.0% Up/Down Range 3 Color The percentage value of each value in the row is determined and the appropriate coloring selected. Positive values are assigned into the Up Range # Colors and Negative values are assigned into the Down Range # Colors. - If the Highest value is positive and the Lowest value is negative, then a cell with a Positive value has its percent value calculated as Percentage = Cell Value / Highest Value; and a cell with a Negative value has its percent value calculated as Percentage = Cell Value / Lowest Value. - If the Highest and Lowest values are both Positive, then each cell's percent value is calculated as Percentage = (Cell Value - Lowest Value) / (Highest Value - Lowest Value). - If the Highest and Lowest values are both Negative, then each cell's percent value is calculated as Percentage = (Cell Value - Highest Value) / (Lowest Value - Highest Value). Zero values are handled special, depending on the range of values in the row. If the row is all Positive values, then a 0 value is mapped into the Up Range 0 Color. If the row is all Negative values, then a 0 value is mapped into the Down Range 0 Color. If the row values span across zero (both positive and negative values) then a 0 value is mapped into the Up Range 0 Color. If a row has all the same values (including all zero values) then the background coloring for all cells in that row uses the Up Range 0 Color. is this what " http://www.sierrachart.com/index.php?page=doc/NumbersBars.php#AskVolBidVolDiffPercentage " was but for some reason got taken away? thank you SC support! Date Time Of Last Edit: 2018-03-29 21:36:45
|
| [2018-03-29 22:43:19] |
| BenjaminR - Posts: 170 |
|
If you don't see a response from SC Engineering here by Monday, April 2nd, 2018, it might be best to start a new ticket. I'm not exactly sure I understand what formula for background coloring you need & cannot find among the options, except to say - you might explore the diagonal bid-ask vol options using percentages. Date Time Of Last Edit: 2018-03-29 22:43:52
|
| [2018-03-29 22:47:44] |
| whats1thingnow - Posts: 407 |
|
tried it, but diagonal bid-ask vol isn't what i'm looking... thanks anyway! will hopefully get a response from SC regarding reply #12 ( Color Shading on Numbers Bars Background (and text) | Post: 144176 ) Date Time Of Last Edit: 2018-03-29 22:48:04
|
| [2018-04-02 18:27:43] |
| |
|
Can you please give us some additional information on what you are looking for, as we just do not fully understand. In particular, what do you want the difference to be a percentage of? It also sounds like you do NOT want this to be diagonal comparison, is that correct? Are you looking for something similar to http://www.sierrachart.com/index.php?page=doc/NumbersBars.php#BackgroundColoringBasedOnAskVolBidVolDiagonalDifferencePercentageOfBarRange but not diagonal? 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 |
| [2018-04-05 06:06:57] |
| whats1thingnow - Posts: 407 |
|
thanks for the reply. sorry for the delay, leaving for vacation soon and on vacation mode :) It also sounds like you do NOT want this to be diagonal comparison, is that correct?
Correct, I do NOT want this to be diagonal comparisonAre you looking for something similar to http://www.sierrachart.com/index.php?page=doc/NumbersBars.php#BackgroundColoringBasedOnAskVolBidVolDiagonalDifferencePercentageOfBarRange but not diagonal?
No, it's much more simple than this.This is what market delta does with their default background coloring, with a slight improvement: They use the Ask Vol Bid Vol Difference (AskVolume BidVolume Difference) (the difference between AskVolume and BidVolume for each price within the Numbers Bar) and color background based on the Value Percentage relative to Today's Chart Bars (not All Loaded Chart Bars, nor Visible Bars Only). Example: (very similar coloring logic to Numbers Bars: Calculated Values Background Coloring Logic ) - The Highest value and the Lowest value are determined for the day and an Up Range and Down Range are calculated. - If the Highest value is positive and the Lowest value is negative, then the Up Range is defined from the Highest Value to 0 and the Down Range is defined from the Lowest value to 0 (Up Range = Highest and Down Range = Lowest).
- If both values are positive, then the Up Range is determined to be the difference between the Highest value and the Lowest value (Up Range = Highest - Lowest). - If both values are negative, the the Lower Range is determined to be the difference between the Lowest value and the Highest value (Down Range = Lowest - Highest). - The percentage value of each value in the bar is determined and the appropriate coloring selected. Positive values are assigned into the Up Range # Colors and Negative values are assigned into the Down Range # Colors. - If the Highest value is positive and the Lowest value is negative, then a cell with a Positive value has its percent value calculated as Percentage = Cell Value / Highest Value; and a cell with a Negative value has its percent value calculated as Percentage = Cell Value / Lowest Value.
- If the Highest and Lowest values are both Positive, then each cell's percent value is calculated as Percentage = (Cell Value - Lowest Value) / (Highest Value - Lowest Value). - If the Highest and Lowest values are both Negative, then each cell's percent value is calculated as Percentage = (Cell Value - Highest Value) / (Lowest Value - Highest Value). - Zero values are handled special, depending on the range of values in the row. If the row is all Positive values, then a 0 value is mapped into the Up Range 0 Color. If the row is all Negative values, then a 0 value is mapped into the Down Range 0 Color. If the row values span across zero (both positive and negative values) then a 0 value is mapped into the Up Range 0 Color. - If a row has all the same values (including all zero values) then the background coloring for all cells in that row uses the Up Range 0 Color. Assume we use Percent Compare Thresholds: .25, .50, .75 If the AskVolume BidVolume Difference values within a 5 minute footprint bar is: -4697
5845 470 687 -3225 -3458 Percent Values for 5 minute footprint bar -4697 → 1.00 (-4697 / -4697 = 1.00)
5845 → 1.00 (5845 / 5845 = 1.00) 470 → 0.08 (470 / 5845 = 0.08) 687 → 0.11 (687 / 5845 = 0.11) -3225 → 0.69 (-3225 / -4697 = 0.69) -3458 → 0.74 (-3458 / -4697 = 0.74) Background Color Mapping -4697 (1.00) → Down Range 3 Color (1.00 > 0.75 and Negative Value)
5845 (1.00) → Up Range 3 Color (1.00 > 0.75 and Positive Value) 470 (0.08) → Up Range 0 Color (0.08 < 0.25 and Positive Value) 687 (0.11) → Up Range 0 Color (0.11 < 0.25 and Positive Value) -3225 (0.69) → Down Range 2 Color (0.50 < 0.69 < 0.75 and Negative Value) -3458 (0.74) → Down Range 2 Color (0.50 < 0.74 < 0.75 and Negative Value) The option that Market Delta doesn't have to my knowledge, but would improve this dramatically is the setting for a Maximum Quantity (just like https://www.sierrachart.com//index.php?page=doc/StudiesReference.php&ID=375&Name=Market_Depth_Historical_Graph#StudyInputs_MaximumQuantityForColoring ): If any AskVolume BidVolume Difference values are greater than this value, they will be colored as if they are equal to the Input value. This effects the overall range of quantity values used for the Block Coloring Logic.
The purpose of this Input is to prevent very large values from desaturating the rest of the graph. For example, if you were viewing a graph where most quantity values are in the range of 100~500, but there are one or two quantities that are over 5000, that would cause the large quantity values to stand out significantly while all of the other quantity values would be barely visible. With this Input, if it is set to a value of 500 or 600 for the example, the large quantity values would not stand out as much, and the details of the rest of the graph would be more visible. Setting this to 0 means there is no maximum quantity limit. Hope this helps and thank you very much in advance for adding this option! |
| [2018-06-03 04:51:53] |
| whats1thingnow - Posts: 407 |
|
back from vacation :) was wondering if there are any updates on this? |
| [2018-12-31 20:49:12] |
| |
|
In regards to post #16, we have another request for this and we are in the process of adding it.
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 |
| [2019-01-04 15:04:44] |
| whats1thingnow - Posts: 407 |
|
amazing! can we make sure to add this part too? The option that Market Delta doesn't have to my knowledge, but would improve this dramatically is the setting for a Maximum Quantity (just like https://www.sierrachart.com//index.php?page=doc/StudiesReference.php&ID=375&Name=Market_Depth_Historical_Graph#StudyInputs_MaximumQuantityForColoring ): If any AskVolume BidVolume Difference values are greater than this value, they will be colored as if they are equal to the Input value. This effects the overall range of quantity values used for the Block Coloring Logic.
The purpose of this Input is to prevent very large values from desaturating the rest of the graph. For example, if you were viewing a graph where most quantity values are in the range of 100~500, but there are one or two quantities that are over 5000, that would cause the large quantity values to stand out significantly while all of the other quantity values would be barely visible. With this Input, if it is set to a value of 500 or 600 for the example, the large quantity values would not stand out as much, and the details of the rest of the graph would be more visible. Setting this to 0 means there is no maximum quantity limit. |
| [2019-03-28 03:53:07] |
| whats1thingnow - Posts: 407 |
|
In regards to post #16, we have another request for this and we are in the process of adding it.
did we complete the implementation of this? if so, please point me to the docs for this option! thanks!! |
To post a message in this thread, you need to log in with your Sierra Chart account: