Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 11:47:08 +0000



How can I highlight or make an alert or whatever would work to note the C[-50]

View Count: 428

[2020-05-27 01:36:00]
User411917 - Posts: 2
I want to have a vertical alert or some alert on the 50th before the current close So the marked bar would change every new bar always only one bar would be marked as the 50th bar before the current bar. Could you help me accomplish this in a formula

Thanks
Date Time Of Last Edit: 2020-05-27 01:43:59
[2020-05-27 03:05:35]
Sawtooth - Posts: 3992
Using the Color Bar Based On Alert Condition study, you can color the 50th previous bar with this formula:
=OR(C[49]=0,C[50])=0
This includes the current bar in the count of 50 bars.

To exclude the current bar and only count the 50 previous bars, use this instead:
=OR(C[50]=0,C[51])=0

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account