Support Board

Date/Time: Sat, 18 May 2024 06:22:42 +0000

Post From: Color Bar Based on Alert on PNF Chart

[2023-07-21 12:49:06] Link To Thread - Link To Post [Go To First Post]
Oz - Posts: 48
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 - 66 views Attachment Deleted.