Support Board
Date/Time: Sat, 28 Dec 2024 08:47:05 +0000
Color Bar
View Count: 729
[2016-04-14 10:26:42] |
User38606 - Posts: 108 |
Hi, I am using Spreadsheet Study / Alert. I have developed a study whereby I want certain bars to be coloured into 2 different colours. The study populates two columns with either TRUE or space. This is formula driven result. I have chosen columns P and O to be populated with either TRUE or space. When Column P has TRUE, then colour the bar Blue. when Column O has True then colour the bar Red. Have followed all steps of choosing Colour Bar/ in Draw Style in Subgraph and choosing right colours. but bars do not get coloured. I noticed that if I type in TRUE & it is text...then bars get coloured. but if True is not typed in manually, but is formula driven...no colouring. I also wrote up a formula to convert formula driven TRUE into =text(CELL A,""), CELL A is formula driven TRUE, otherwise converting into text ....still no recognition. Can you advise where I am wrong? |
[2016-04-14 10:41:54] |
Sierra Chart Engineering - Posts: 104368 |
Use the values 1 and 0 only. Or just write the formula so that it returns a Boolean result. For example: =AA>10 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: