Support Board
Date/Time: Wed, 27 Nov 2024 21:45:57 +0000
Post From: highlight entired background once EMA cross over SMA
| [2014-10-03 22:11:20] |
| Sawtooth - Posts: 4120 |
|
How can I highlight an entire background as long as EMA15 below SMA50? Thanks!
You can do it with the Spreadsheet Study study, using very simple formulas: -Add the Spreadsheet Study study, give it a name in the Spreadsheet Name field, and set the Chart Region to 1. -Set the Draw Style of K(SG1) and L(SG2) to Background, and set each subgraph to it's own color -Put these formulas in these cells: Cell K3: =$AA$3>$AC$3 Cell L3: =$AA$3<$AC$3 This assumes the MAs are at the top of the Studies to Graph list, so that their output is in columns AA and AC. You can also edit the formulas to reference different columns. |