hi been trying to set up new scan with no luck could you please help here is what i'm trying to do

 i'm looking for an uptrend:

1- the lowest close of the last 5 days greater then 50 day moving average at the lowest close of the day

2- the highest high of the last 16 day equal to highest high of the last 30 days

3- STOC K  8,3  under  25

4- OBV greater then .30

==============================================================================

looking for a down trend

1-  200 day moving average of the SPY lower then the 200 day moving average 1 day ago

2- 50 day expotenial moving average of the SPY lower then the 50 day simple moving average 1 day ago

==============================================================================

i'm looking for a down trend  here 

1-  the close 1 day ago is greater then the lowest low of the last 10 days as of 2 days ago

2- the close is lower then the lowest low10 days ago as of 1 days ago

3- the 50 day moving average close is  lower then the 50 day moving average as of the last 5 days*0.997

4- the close lower then the 50 moving average close

5- the highest high of the last 10 days minus the close divided by the close lower then 0.10

6- the low is greater then the lowest low  70 days ago as of 1 day ago

i hope i  typed what i'm trying to do correctly  any help is greatly appreciated   rich

We can do everything besides On Balance Volume (because checking for OBV being greater than .3 is completely meaningless).

MINC5 > AVGC50 AND MAXH16 = MAXH30 AND STOC8.3 < 25

Dealing with OBV & MS in PCF's - how to interp their "values"

Any Condition Formula would not be specific to the SPY, it would work with any symbol.

AVGC200 < AVGC200.1 AND XAVGC50 < XAVGC50.1

Which could also be written as:

C < C200 AND C < XAVGC50.1

C1 > MINL10.2 AND C < MINL10.1 AND AVGC50 < .997 * AVGC50.5 AND C < AVGC50 AND MAXH10 < 1.1 * C AND L > MINL70.1

 wow  thank you so much bruce  i really appreciate your time and knowledge

Bruce  i got a error message on first line.  MIN5>        argument missing near >  ( if i remove ( > )  it calculate true.  would that code still make  what i'm looking  for valid 

Same message on  the second line avg200c ( argument missing near < ) 

       on the last line  ( argument missing near *)    i have no idea what it means could you look it over for an error     ty bruce 

It should be MINC5 instead of MIN5 and AVGC200 not AVG200C.

Hi bruce   just copied and pasted the pcf's you did for me worked  on version 12 copy and paste  doesn't work on 16  stil got error messages    i don't know if it the progran

I have copied and pasted all of the formulas into TC2000 v16 and don't get any error messages. Please contact technical support.

hi bruce trying to figure  new scan i'm just doing something wrong would you mind helping me please

heres what im' trying to do

1.    200 sma of today>200 sma of yesturday and the high of today > then the 200sma of toay and the low of the today < 200 sma  and stoch  8,3,3 %K  < = 40

2.   20 sma of today > 20 sma of yesturday and 50 sma of today > 50 sma of yesturday and the low of today > 50 sma of today and the high of today < 20 sma of today  and slow stoch 8,3,3,%K < =40

thanks bruce  really appreciated  forgot to tell you looking for uptrend if  that matters if this works  i'll send you my down trend formular if you don't mind

H > AVGC200 AND AVGC200 > L AND C > C200 AND AVG(STOC8.3,3) <= 40

AVGC20 > H AND L > AVGC50 AND C > C20 AND C > C50 AND AVG(STOC8.3,3) <= 40 

If you need these both in the same formula.

AVGC20 > H AND H > AVGC200 AND AVGC200 > L AND L > AVGC50 AND C > C20 AND C > C50 AND C > C200 AND AVG(STOC8.3,3) <= 40

Bruce,

   Could you please explain your formula from the above post, I seem to be missing something:

"20 sma of today > 20 sma of yesturday and 50 sma of today > 50 sma of yesturday"

"C > C20 AND C > C50"

instead of   AVGC20 > AVGC20.1  and AVGC50 > AVGC50.1

Is this just an oversight or some sort of math trick?

Thank you,

Don

It is a math trick.

C > C20 when AVGC20 > AVGC20.1

And C > C50 when AVGC50 > AVGC50.1

This is because the other 19 or 49 points are common to both moving averages.

Bruce,

   Thank you for explaining this.

Don

You're welcome.