Support Board
Date/Time: Sun, 22 Dec 2024 05:26:53 +0000
SPREADSHEET BACKGROUND AND BAR COLOR CHANGES
View Count: 1800
| [2015-07-30 08:15:59] |
| User787778 - Posts: 142 |
|
Hi Is it possible to have two different spreadsheet alert conditions, one that will change the bar color and one that will change the background color for the same bar? Thanks |
| [2015-07-30 11:27:23] |
| Sawtooth - Posts: 4141 |
|
Yes. Use two Formula Columns, each with their own formula, then set the Draw Style of one to Color Bar and the Draw Style of the other to Background. |
| [2015-07-30 12:00:29] |
| User787778 - Posts: 142 |
|
Hi Tom Thanks for your answer. I am obviously doing something wrong. I can get a color change for either the bar or the background, but not simultaneously. The background color dominates and when both are set, only the background color is displayed. Regards John |
| [2015-07-30 12:35:31] |
| Sawtooth - Posts: 4141 |
|
Well, I thought it would work, but I didn't test it. After some testing, there are two workarounds: 1) Use two instances of the spreadsheet study, each one with a unique name in the Spreadsheet Name field. 2) In addition to one spreadsheet study, use two instances of the Color Bar Based On Alert Condition study, set the Draw Style of one to Color Bar and the Draw Style of the other to Background, and use formulas in each one's Alerts tab like this: =ID1.SG1 =ID1.SG2 where ID1 is the spreadsheet study, and SG1/SG2 are the color bar/background formula columns. Both color bar studies must be below the spreadsheet study in the Studies to Graph list. |
| [2015-07-30 12:39:49] |
| User787778 - Posts: 142 |
|
Thanks Tom. I will test it tonight. Your help and willingness to share is much appreciated. |
| [2015-07-30 16:56:50] |
| |
|
Yes you can do this. Add the Spreadsheet System/Alert study twice to the chart with each one set up as you require. Each one needs to reference different Sheets or different Spreadsheets. Also look at using the Color Bar/Background Based on Alert Condition studies: https://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s252 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: