Support Board
Date/Time: Fri, 07 Nov 2025 13:11:12 +0000
Post From: color bars over for x number of days
| [2020-11-21 00:14:36] |
| Sawtooth - Posts: 4286 |
|
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
|