Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 07:28:05 +0000



Post From: Alert formula for color Background

[2023-09-17 23:57:45]
Sawtooth - Posts: 4120
I need assistance with an alert formula to color blue the background when the close is above the upper band and have the background remain the blue color until there is a close under the lower band.
You need to create a persistent TRUE when the Close is > than the upper band, then release it when the Close is < the lower band.
Reverse the operators for the opposite color.
The TRUE, and the FALSE, are made persistent by referencing the color background's previous bar in the final 'else'.

Blue:
=IF(C>ID6.SG1,1,IF(C<ID7.SG1,0,ID8.SG1[-1]))
where this color background study is ID8.

Pink:
=IF(C<ID7.SG1,1,IF(C>ID6.SG1,0,ID9.SG1[-1]))
where this color background study is ID9.
Date Time Of Last Edit: 2023-09-18 00:04:56