Support Board

Date/Time: Thu, 18 Apr 2024 21:35:23 +0000

Post From: highlight entired background once EMA cross over SMA

[2014-10-03 22:11:20] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3973
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.