Support Board
Date/Time: Sun, 11 May 2025 11:02:02 +0000
Formula Question
View Count: 941
| [2016-08-04 15:32:26] |
| User101736 - Posts: 6 |
|
I was wondering if there is a way to automate this? I want to have a green rectangle appear in every candle that is at least 110 contracts and has a consolidation point (i.e. two consecutive candles that share the same midpoint). I think this would be a simple if/ then statement; if volume > 110 and if two or more candles share the same midpoint then draw a rectangle, but I’m not sure how to input this into studies. Please advise—thanks!
|
| [2016-08-04 22:21:54] |
| |
|
You need to use the Color Bar Based on Alert Condition study for this: https://www.sierrachart.com/index.php?page=doc/TechnicalStudiesReference.html#s245 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-08-05 18:44:20] |
| User101736 - Posts: 6 |
|
Thanks! I have played around with that, but I'm not sure 1) How to get it to form a rectangle, and 2) what the formula should be if I want to include only candles that have 110 contracts or more. I am using the DOW charts by the way...
|
| [2016-08-05 18:48:32] |
| |
|
1. You could a Square at the top or bottom of the bar. Did you want to do that? 2. The formula for Volume is: V >= 110 This can be combined with other formulas by using the AND function: Study/Chart Alerts And Scanning: OR and AND Functions Sierra Chart Support |
| [2016-08-05 19:01:43] |
| User101736 - Posts: 6 |
|
I wanted to draw a full rectangle on those candles, but I'm not sure if that's an option. Also I'm not sure how to input the formula-- basically I want it to draw a rectangle (or whatever shape) on two consecutive candles where at least one of them is more than 110 contracts and they share the same midpoint. I have it currently setup so that if a candle shares the same midpoint as the one next to it, it shows a dashed line, and the formula I have for that one is =(HL=HL[-1]). I'm not sure how to combine the formulas...
|
| [2016-08-05 19:02:21] |
| User101736 - Posts: 6 |
|
I tried the AND function and it didn't work...
|
| [2016-08-05 19:05:27] |
| User101736 - Posts: 6 |
|
By the way, this is the formula I'm using and nothing happens =AND V> 110, (HL=HL[-1]) |
| [2016-08-05 21:41:19] |
| User101736 - Posts: 6 |
|
Okay I figured out how to at least get a blue square where I wanted. I'm not sure if a rectangle is possible given the drawing options, but this should work for now. Thanks for all your help!
|
| [2016-08-07 01:02:44] |
| |
|
The formula needs to be formatted like this: =AND( V> 110, HL=HL[-1] ) 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: