| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 8/30/2011
Posts: 161
|
Is there a way to set up a scan so it detects wether the candle has changed from red to green and vice versa compared to the previous one.
c>c1 still shows red candles just that the actual close is higher, id like a scan/wording to show to color change in a candle please
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If Color Based On is set to Open vs Close, then going from red to green could be written as follows.
TrueInRow(O + H + L + C >= XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1, 2) = 1
And going from green to red could be written as follows.
TrueInRow(O + H + L + C < XAVGO3.1 + XAVGH3.1 + XAVGL3.1 + XAVGC3.1, 2) = 1
If Color Based On is set to Net Change, then going from red to green could be written as follows.
TrueInRow(O + H + L + C >= O1 + H1 + L1 + C1, 2) = 1
And going from green to red could be written as follows.
TrueInRow(O + H + L + C < O1 + H1 + L2 + C1, 2) = 1
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/30/2011
Posts: 161
|
thank you Bruce for your help
|
|
 Gold Customer
Joined: 10/7/2004
Posts: 50
|
Bruce, I want to scan for HA bars with a flat bottom (or top). The formula requires
min(l,o1,c1) but I can't seem to find that. Please help.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I will start with your formula using regular prices.
LEAST(L, O1, C1)
And using HA prices.
LEAST(L, XAVG(O2 + H2 + L2 + C2, 3) / 4, (O1 + H1 + L1 + C1) / 4)
A formula for an HA candle without a lower wick (an HA candle with a flat bottom) can be written as follows.
XAVG(O1 + H1 + L1 + C1, 3) <= 4 * L
A formula for an HA candle without an upper wick (an HA candle with a flat top) can be written as follows.
XAVG(O1 + H1 + L1 + C1, 3) >= 4 * H
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 10/7/2004
Posts: 50
|
Bruce, the two formulas above are FABULOUS. I could not have gotten these without you. This should keep me in trends longer, both up and down. MANY THANKS.
P.S. Your response BEFORE I EXPANDED IT didn't seem to be the same. Perhaps you made a change.
glmus
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I am pretty sure I didn't change anything in my response after posting it (I do sometimes change something after posting, I added this parenthetical for example, but I don't recall doing so for my Monday, January 29, 2018 10:37:21 AM ET post... then again... I am getting older).
I am not really sure what you mean by "expanded it" either.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |