Support Board
Date/Time: Thu, 28 Nov 2024 18:47:25 +0000
[User Discussion] - Numbers Bars Calculated Values % compare thresholds to Color bar based on alert condition
View Count: 2391
| [2023-04-06 12:16:31] |
| Alv P - Posts: 37 |
|
Hi SC support; How can I create the way or the formula to highlight color bar when in study Numbers Bars Calculated Values (Range 3 up , Range 2up , Range 3 down , Range 2 down) highlights ? Thanks in advance |
| [2023-04-06 14:07:15] |
| John - SC Support - Posts: 36350 |
|
It depends on what your Input is set to for Background Coloring Method. Most likely you will need to use the alert functions specified at the following link: Study/Chart Alerts And Scanning: Special Functions For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-04-06 23:47:12] |
| Alv P - Posts: 37 |
|
Hi John, thanks ID3 as Numbers bars calculated values I tried this: AND=(ID3.In18, ID3.In19, ID3.In24, ID3.In25) but not working I just want to color bar based in Daily Data percent compare thresholds like in NBCV study, I have set it to .10, .25, .50 Any idea ? or maybe i can do like AND=(ID3.SG1 TRUEIn18) etc. |
| [2023-04-06 23:55:49] |
| Alv P - Posts: 37 |
|
__
|
Attachment Deleted. Private File |
| [2023-04-07 15:00:21] |
| John - SC Support - Posts: 36350 |
|
You can not set alerts on the Numbers Bars subgraphs themselves. They are not setup to hold any data, they are just to set the colors and sizes for some of the items. You need to look at the underlying calculation and base your alert on that data. We can point you in the right direction, but we first need to know how the following two Inputs are set for your Numbers Bars study: - Background Coloring Based On - Percent (or Actual - depending on Background Coloring Based On) Compare Thresholds For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-04-07 15:27:36] |
| Alv P - Posts: 37 |
|
Thanks John i am user from SC since years Okay The Background coloring in - Daily Data Compare Thresholds - .10, .33, .66 for example I would like to apply this full bar percent compare for various selective SG and put them together in same alert formula |
| [2023-04-07 15:30:27] |
| John - SC Support - Posts: 36350 |
|
Sorry, I was not specific enough. I need to know the "Column 1 Background Coloring Method".
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-04-07 16:14:41] |
| Alv P - Posts: 37 |
|
Oh maybe there is a misunderstanding here because I think you are talking about (Numbers bars) study and i am talking about (Numbers Bars Calculated Values) I am interested in NBCV because i need to put together different SG like ( SG1 Ask Volume Bid Volume Difference, SG4 Positive Delta Sum and more ... ) and aply to them the Volume Compare Thresholds .10, .33, .66 Daily Data for example
Date Time Of Last Edit: 2023-04-07 16:21:35
|
| [2023-04-07 20:49:22] |
| John - SC Support - Posts: 36350 |
|
Sorry. I did think you were referencing the Numbers Bars study. And looking back, you did specifically say the Numbers Bars Calculated Values. First of all, there is not a way to direct access the Inputs, so doing something like "ID1.IN18" is a Syntax error and will not do anything. Second, recreating the way the coloring is done for the background coloring of the Numbers Bars Calculated Values is not straightforward, as you would need to know the lowest value and the highest value within the data range you have set to determine the coloring from. You state that you have it set to "Day", so you would have to find the Highest and Lowest values within the past day. You should be able to do this using a Spreadsheet Study to get the high and low for the period using the Large() and Small() functions. You will also need to check the date to ensure the data is within the range you specify (i.e. today). Refer to the following for the Large() function to see how it works: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#LARGE_Function Then refer to the following for how the rest of the calculations are performed: Numbers Bars: Calculated Values Background Coloring Logic For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-04-08 01:25:49] |
| Alv P - Posts: 37 |
|
NP, Thanks John Can you make it in a.CHT? I have 0 experience with Spreadsheet and reading about it a few hours, I still having no idea about how to do it |
| [2023-04-10 13:38:45] |
| John - SC Support - Posts: 36350 |
|
We do apologize, but that is beyond the scope of our support. We simply do not have time to put together this kind of spreadsheet, as it would take some time (sometimes we do simpler ones, but this one gets a bit complicated). There are others on the board that may be able to help you. We have set this as a User Discussion for this purpose. 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: