Support Board
Date/Time: Fri, 27 Dec 2024 16:06:25 +0000
Color Bar open price crossover with BB
View Count: 899
| [2016-04-16 03:40:54] |
| User398047 - Posts: 5 |
|
Hi there, I have 2 studies attached. One is Bollienger Bands and another Color bar on conditions. Can you please advise what is the formula if I want the bar to change color whenever the open price crosses with external BB's and where to put this formula. Thanks |
| [2016-04-17 21:58:48] |
| |
|
Use the Color Bar Based on Alert Condition study: https://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s245 The formula is: =OR( CROSSOVER (ID1.SG1, O) , CROSSOVER (ID1.SG3, O) ) This assumes ID1 is the identifier for the Bollinger Bands. The formula needs to be entered on the Color Bar Based on Alert Condition study. Here is the documentation: https://www.sierrachart.com/index.php?page=doc/doc_StudyChartAlertsAndScanning.php#EnterAlertOnStudy 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 |
| [2016-04-18 01:00:04] |
| User398047 - Posts: 5 |
|
Thanks, Can you please advise on what would be the best way to attach the sound alarm based on the same conditions as well? |
| [2016-04-18 03:17:13] |
| User398047 - Posts: 5 |
|
Please ignore the audio sound. I've found it. The formula doesn't seems to be working properly though. Bollinger Bands identifier is ID:2 so I've changed the formula to =OR( CROSSOVER (ID2.SG1, O) , CROSSOVER (ID2.SG3, O) ) I've restarted the program but the candles are not being colored at all. When applied the original one sent by you earlier with ID1 the candles are colored but not correctly. A lot of them where price is far away from BB's are colored too. |
| [2016-04-18 03:44:30] |
| User398047 - Posts: 5 |
|
I've changed the formula slightly to =OR( CROSSOVER (ID1.SG1,H) , CROSSOVER (ID1.SG3,L) ) It seems it's more accurate than before however there are still a lot of candles which are not being colored or there are a lot of which are being colored but theoretically shouldn't as they don't cross the BB's. Any ideas how to tune it in and why there are so many discrepancies. |
| [2016-04-18 17:25:29] |
| |
|
It is hard for us to tell you what formula to use because we do not know exactly what you want to do. It is best that you work out the proper formula. Here is the relevant documentation: https://www.sierrachart.com/index.php?page=doc/doc_StudyChartAlertsAndScanning.php 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 |
| [2016-04-19 04:22:17] |
| User398047 - Posts: 5 |
|
Well, All I want to do is to color the candle once crosses with the external Bollienger Band. The results are not very consistent on Sierra Chart in this respect, from what I was able to observe. |
| [2016-04-19 04:25:04] |
| |
|
The consistency is strictly due to the formula you are using. The evaluation of a formula is 100 percent perfect and that is not where the problem is. You still need to define exactly what you want to do. Your description is still vague and nonspecific. What specifically is meant by this: candle once crosses with the external Bollienger Band.
A candlestick consists of 4 values. 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 Date Time Of Last Edit: 2016-04-19 04:25:22
|
| [2016-04-19 04:36:14] |
| |
|
Here is the result from the formula given in post #2: http://www.sierrachart.com/image.php?Image=1461040541946.png 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 |
| [2016-04-19 05:24:34] |
| |
|
If the Alert Formulas do not appear to be evaluating correctly, it could have to do with the Value Format which explained here: https://www.sierrachart.com/index.php?page=doc/doc_StudyChartAlertsAndScanning.php#ValueFormat 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: