Support Board
Date/Time: Fri, 24 Jan 2025 21:07:23 +0000
Post From: Color background study
| [2019-01-28 21:10:04] |
| Sawtooth - Posts: 4162 |
|
is it possible to have the ""entire chart"" background colored when condition is met?
You can do this with a spreadsheet study. To also be able to get alerts, add the Spreadsheet System/Alert study. -Give it a name in the Spreadsheet Name field. -Assign alert numbers to Column K Alert and Column M Alert. -On the Subgraphs tab, set the Draw Style of SG1 and SG3 to Background, and set SG1 and SG3 to the up and down colors, respectively. -Press OK and OK On the spreadsheet: -Put this formula in cell K3: =ID2.SG1@$3>ID3.SG1@$3 -Put this formula in cell M3: =ID2.SG1@$3<ID3.SG1@$3 where ID2.SG1 and ID3.SG1 are two MAs, or any two studies or subgraphs whose lines would cross; edit the ID#s and/or SG#s as needed. |