Login Page - Create Account

Support Board


Date/Time: Sun, 05 May 2024 23:38:15 +0000



Post From: trouble Setting up Alerts

[2018-06-20 22:17:54]
Xfanman1 - Posts: 320
Your formula is saying you want to color the bar only when C(Closing Price) is equal to VWAP. You want to capture if the bar crosses over VWAP so try this:

=OR(CROSSFROMABOVE(ID1.SG1,C),CROSSFROMBELOW(ID1.SG1,C))

This should color your bar if the bar crosses and Closes from below OR crosses and Closes from above VWAP. It will not capture wicks that touch your VWAP but don't cross between the Open and Close body of the candle.

--
Scott
Date Time Of Last Edit: 2018-06-20 22:23:09
imageCrossover.PNG / V - Attached On 2018-06-20 22:20:23 UTC - Size: 142.11 KB - 274 views