Login Page - Create Account

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:

Login

Login Page - Create Account