Support Board
Date/Time: Wed, 14 May 2025 23:51:16 +0000
Post From: Paintbar 3 closes above/below a study
| [2016-04-01 16:20:52] |
| 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 - 331 views |