Support Board
Date/Time: Wed, 27 Nov 2024 18:43:37 +0000
Post From: Color Bar Based on Alert on PNF Chart
| [2023-07-21 12:49:06] |
| Oz - Posts: 50 |
|
Hi John, Thank you for your help. I got it to work using: =AND(H<H[-1], AV-BV>0) and =AND(L>L[-1], AV-BV<0) however there is a slight issue. After a big move in one direction we often get a lower high and a higher low bar or an inside bar (please see pic). So we need to add an exception or give preference to one side. What do you suggest? Is there a syntax for an inside bar? and then give preference to the other side when the prior bar is a down bar. This will assume the next is an up bar, hence correcting the issue. Any suggestions appreciated, PS with syntax explained as I feel I'm getting way out of my league here :>) Many thanks |
 PNF Inside Bar Example1.png / V - Attached On 2023-07-21 12:48:27 UTC - Size: 258.81 KB - 91 views Attachment Deleted. |