Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

scanning for change in Heiken Ashe candles Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
rbayliss40
Posted : Saturday, November 18, 2017 11:09:00 AM
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

Bruce_L
Posted : Monday, November 20, 2017 11:07:49 AM


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
rbayliss40
Posted : Monday, November 20, 2017 12:04:12 PM
Registered User
Joined: 8/30/2011
Posts: 161

thank you Bruce for your help

glmus
Posted : Sunday, January 28, 2018 3:32:04 PM
Gold Customer 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.

Bruce_L
Posted : Monday, January 29, 2018 10:37:21 AM


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
glmus
Posted : Monday, January 29, 2018 11:48:24 AM
Gold Customer 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

Bruce_L
Posted : Monday, January 29, 2018 11:50:52 AM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.