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
|