I am Looking for Price XUP Moving avg 8, 20 and 40. thanks

I am looking PCF for decling price each bar with increasing volume. Current price bar & volume highest compare to previous 4 bars. thanks

Are you asking for a single formula or multiple formulas?

A condition formula for price crossing up its own 8, 20, and 40 period simple moving averages at the same time can be written as follows.

XUP(C, AVGC8) AND XUP(C, AVGC20) AND XUP(C, AVGC40)

A condition formula for declining price with increasing volume can be written as follows.

C < C1 AND V > V1

If you wanted that to happen say four bars in a row, you could write this as follows.

TrueInRow(C < C1 AND V > V1, 4) = 4

A condition formula for price and volume both being higher than the previous four bars can be written as follows.

C > MAXC4.1 AND V > MAXV4.1

Thank You

I am also looking for PCF for following conditiion:

Wide range bar ( Where wide range bar is minimum 3 times the averege true range)follow by narrow range bar (NRB should be on top or bottom 30% range of WRB).

Thank you so much

Please try the following Condition Formula for being in the top 30%.

H1 >= H AND 10 * L >= 7 * H1 + 3 * L1 AND H1 - L1 >= 3 * ATR14.2 AND H1 > L1

The following for the bottom 30%.

3 * H1 + 7 * L1 >= 10 * H AND L >= L1 AND H1 - L1 >= 3 * ATR14.2 AND H1 > L1

Or the following for either.

H1 >= H AND (10 * L >= 7 * H1 + 3 * L1 OR 3 * H1 + 7 * L1 >= 10 * H) AND L >= L AND H1 - L1 >= 3 * ATR14.2 AND H1 > L1

Hi Bruce

                  I am Looking for PCF for: Price change 10% followed by Narrrow Body (With wick on Top And Bottom)  two Or three Bar in row. Thanks

I am really not sure what you are requesting, but here is one possibility.

TrueInRow(ABS(O - C) < .3 * (H - L) AND H > O AND H > C AND O > L AND L > C, 2) = 2 AND (C2 >= 1.1 * C3 OR (ABS(O2 - C2) < .3 * (H2 - L2) AND H2 > O2 AND H2 > C2 AND O2 > L2 AND L2 > C2 AND C3 >= 1.1 * C4))

I am Looking for :  Price change 10% or more in last 20 days, Current bar or previous with narrow body or doji with wide range bar ( Narrrow body 2 or 3 bars in row. Thanks

Please try the following.

C >= 1.2 * C20 AND CountTrue(H - L >= 3 * ATR14, 2) > 0 AND TrueInRow(ABS(O - C) < .3 * (H - L) AND H > O AND H > C AND O > L AND C > L, 2) = 2

Note that just the 20% increase and wide range bar (using your defintiion of 3 * ATR) is pretty rare however, even without adding the narrow range bar requirement (using less than a 30% of body with wicks on both ends as the definition).

C >= 1.2 * C20 AND CountTrue(H - L >= 3 * ATR14, 2) > 0

I am looking for stocks that has: Red to green move OR Green to red move for the Day. Thanks

Is Color Based On set to Open vs Close or Net Change when you edit price?

Do you mean a change in color from the previous day to the current day or within the current day?

Based on Open Price, If open green and then turns red Or Open red but now it is green

Using Open vs Close, the candle will always be green exactly at the open (because it is green when the open equals the close or current price of the candle).

So from a completely literal standpoint, any red candle changed from the open and any green candle did not. So a candle that changed would be:

O > C

But, I suspect you mean something like the candle was green after the first change in price and is now red, the candle red after the first change in price and is now green, the candle was green x minutes after the open and is now red, the candle was red x minutes after the open and is now red, or something else similar.

There really isn't a way to do that.

If you mean the candle was red at any point during the day previously and is now green, that would be:

C >= O AND O > L

If you mean the candle was green at any point during the day previously and is now red, that would be what we already gave above (because it will open green).

O > C

But if you require that price was actually above the open at some point to be considered green, the formula would be the following.

H > O AND O > C