Support Board

Date/Time: Fri, 03 May 2024 23:34:26 +0000

Post From: Paintbar 3 closes above/below a study

[2016-04-01 16:20:52] Link To Thread - Link To Post [Go To First Post]
User95787 - Posts: 18
sorry but not to knowledgable in the spreadsheet study and learning a few things now but unable to correctly match to what i need to do yet. I used the following on K3 cell (basically saying the Last Price 3 bars ago >= Open Price 3 bars ago and Last Price 3 bars ago >= my indicator) =AND(ID0.SG4@5>=ID0.SG1@5,ID0.SG4@5>=ID1.SG3@3)- this paints bar green =AND(ID0.SG4@5<=ID0.SG1@5,ID0.SG4@5<=ID1.SG3@3)- this paints bar red Problem is that it does not continue to paint continuously (the black OHLC is the normal color bar) and also in between it will paint the wrong color (I made some notes on the attached chart)..hope you can help tomgilb even if to create a new spreadsheet Even tried =ID0.SG4@5<=ID1.SG3@3 which is LAST <= my indicator 3 BARS AGO which colors all of the bars correctly green up/red down but doesnt fit the criteria of HH/HC or LH/LC


Above Below Example.jpg / V - Attached On 2016-04-01 16:13:55 UTC - Size: 211.09 KB - 288 views