Support Board

Date/Time: Mon, 06 May 2024 18:00:54 +0000

Post From: Color Bar based on closing price above/below sub graph

[2020-09-04 14:00:19] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
- if price below VWAP green will be muted green. above VWAP red bar will be muted red. Add two more instances of the Spreadsheet Formula study, one for the muted green and one for the muted red. These two instances need to be below the original Spreadsheet Formula study in the Studies to Graph list. On both instances: -Set the Chart Region to 1 -Set 'Draw Zero Values' to No -Set the Draw Style to Color Bar Muted green formula in the Formula field: =IF(AND(CROSSFROMABOVE(C,ID3.SG1),ID2.SG1=1),1,IF(ID2.SG1=-1,0,ID4.SG1[-1])) -where this Spreadsheet Formula study is ID4 Muted red formula in the Formula field: =IF(AND(CROSSFROMBELOW(C,ID3.SG1),ID2.SG1=-1),1,IF(ID2.SG1=1,0,ID5.SG1[-1])) -where this Spreadsheet Formula study is ID5 -where, in both formulas, the VWAP study is ID3, and the original Spreadsheet Formula study from post#2 is ID2. Date Time Of Last Edit: 2020-09-04 19:54:50