Support Board
Date/Time: Sun, 02 Feb 2025 21:44:42 +0000
[Programming Help] - Color Bar Based on Alert Condition
View Count: 637
| [2019-10-13 10:09:41] |
| User752442 - Posts: 36 |
|
Hi, need a Formula similar this one "=ABS(O-C)<(H-L)*0.5", but "Open AND Close" must be below 50%. I can't find a way on my own ... please help Best Regards Ray |
| [2019-10-13 14:20:14] |
| Sawtooth - Posts: 4164 |
|
Try this: =AND(ABS(O-C)<(H-L)*0.5,O<L+((H-L)*0.5),C<L+((H-L)*0.5)) |
| [2019-10-14 06:45:11] |
| User752442 - Posts: 36 |
|
... I tried your formula and found that I do not need ABS. That's what I need =AND(O<L+((H-L)*0.5),C<L+((H-L)*0.5)) Thank you very much for help :-) |
| [2019-10-14 08:16:50] |
| User164131 - Posts: 19 |
|
According to documentation the 50% of the bar is HL for formulas. So you can use much shorter version =AND(O<HL,C<HL) |
To post a message in this thread, you need to log in with your Sierra Chart account: