Login Page - Create Account

Support Board


Date/Time: Sat, 05 Jul 2025 07:14:29 +0000



Post From: color bars over for x number of days

[2020-11-21 00:14:36]
Sawtooth - Posts: 4232
You can do this with 4 instances of the Color Bar Based On Alert Condition study:

Use this formula in the 1st instance, and Hide this instance:
=C[10]
This finds all bars < [-10]
Use this formula in the 2nd instance, and choose your color bar color:
=ID1.SG1=0
where the 1st instance is ID1; edit as needed.

Use this formula in the 3rd instance, and Hide this instance:
=C[5]
This finds all bars < [-5]
Use this formula in the 4th instance, and choose a different color bar color:
=ID3.SG1=0
where the 3rd instance is ID3; edit as needed.

Note: all 4 instances must be in order in the Studies to Graph list so that the 5 previous color bars overpaint the 10 previous color bars.

You can also do this with two formulas in one instance of the Spreadsheet Study study.
Date Time Of Last Edit: 2020-11-21 00:27:12