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

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

thank you Bruce for your help

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.

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, 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

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.