Support Board
Date/Time: Tue, 26 Nov 2024 08:41:24 +0000
color background in study
View Count: 383
| [2023-12-12 10:33:25] |
| Benz - Posts: 46 |
|
Hi Guys, I am using study: Numbers Bars Calculated Values. I am then using Subgraphs: Bid Volume Per Second (SG53) Ask Volume Per Second (SG54). I would like to be able to colour the background / set background colour alert when one subgraph is an increased percentage of the other subgraph. For example, if there is > 100% more bid vol than ask vol then i would like the the SG53 bid value to to provide a coloured background alerting me to that percentage increase. Thanks very much for your help. |
| [2023-12-12 12:51:01] |
| Benz - Posts: 46 |
|
I have been trying to work around an alert formula that would look something like this: =IF(ID1.SG53 > 1.0 * ID1.SG54 OR ID1.SG54 > 1.0 * ID1.SG53) or this: =IF(OR(ID1.SG53 > 1.0 * ID1.SG54, ID1.SG54 > 1.0 * ID1.SG53)) or at a more basic level: =AND (ID1.SG53 > 1.0 * ID1.SG54) I have been trying many different formula and study setting combinations using THESE STUDIES: Color Background Based on Alert Condition Color Bar Based on Alert Condition I am having zero success. Thanks |
| [2023-12-12 16:21:20] |
| John - SC Support - Posts: 36286 |
|
The first thing is that you can not color the background of the Numbers Bars Calculated Values based on an Alert Condition. The only background coloring is the built-in option for "Color Background Based on Value Percentage". Refer to the following: Numbers Bars: Numbers Bars Calculated Values Input Descriptions But, you can do many other things by using the "Color Bar Based on Alert Condition study. To start with, your alert condition would be the following: =ID1.SG53 > 2 * ID1.SG54 You state that you want 100% more bid volume, so this would be twice the ask volume. In terms of options for the Color Bar Based on Alert Condition, refer to the following section within the documentation for this study: Color Bar Based on Alert Condition: Drawing Arrows/Text or Other Styles at the High or Low of Bars And be sure to look through the rest of the documentation for that study. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-12-12 17:22:28] |
| Benz - Posts: 46 |
|
Ok thanks very much John. I’ll give this a go.
|
To post a message in this thread, you need to log in with your Sierra Chart account: