I need a scan to find stocks that:

Have demonstrated good support for the past 2 years. Maybe bounced off the support at least 4 times over the 2 years. Have at least a 10% spread between support and resistance. not too thinly traded. Maybe greater than 500,000 shares/day average. Thank you.

Hi mjbarton, don't we all? :)

I think you're going to have to come up with a more specific, objective, and unambiguous defintion. Daily average volume of half-a-milllion shares is a start, but how do you define support? Resistance? "Bounced"?

Inquiring computers need to know. 

I want the resistance to be obvious over the last 2 years and yes bouncing off of the support/resistance would happen

Looks like Bruce just walked in, so he'll be able to help you soon, but I'm just trying to help you clarify what you really want to ask for.

For example, what's "obvious" to you isn't obvious to a computer scanning stocks. That's why I suggested a more specific and objective operational definition. Computers aren't that smart. Yet. :)

like I posted earlier. It bounces off the support at least 4 time over the last years. so whatever the price is that it supports the price.

Okie-doke. Grab a number and wait in the lobby. Bruce will be with you momentarily. :)

I cannot think of a way to create a Condition Formula for good support using the definition of bouncing off support at least 4 times over the last 2 years.

anything at all that would show a stock with good support over the last 2 years?

Maybe something like the following?

MINL63 <= 1.03 * MINL252 AND 1.1 * MINL252 <= MAXH63 AND MINL63.63 <= 1.03 * MINL252 AND 1.1 * MINL252 <= MAXH63.63 AND MINL63.126 <= 1.03 * MINL252 AND 1.1 * MINL252 <= MAXH63.126 AND MINL63.189 <= 1.03 * MINL252 AND 1.1 * MINL252 <= MAXH63.189 AND AVGV252 > 500000

It divides the year into four equal segments. Then it checks for the lowest low in each of those segments to be within 3% of the lowest low over the year, with the high in each of those segments being at least 10% above the low over the year.

The four bounces would have to be fairly evenly spread and the support would need to be the low over the year, but it is about is close as I can come to the definition.

thanks. Could you also tell me how to find a stock where the difference between the MACD 12 26 and the exp moving average 9 is less than it was yesterday. i.e. the macd is getting closer to the exp moving average.

Please try the following Condition Formula.

ABS(XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9)) < ABS(XAVGC12.1 - XAVGC26.1 - XAVG(XAVGC12.1,9) + XAVG(XAVGC26.1,9))

I get error in formula sytanx error?

The syntax of the formula should be fine. If you are using Edge or Internet Explorer, try using Chrome. You could also try copying and pasting into a text editor like Notepad and then copying and pasting from the text editor into TC2000.

Works for me. Perhaps you missed a parenthesis when copying & pasting?

Or what Bruce said. LOL. His fingers are faster than mine. :)

Yes, I was using IE.  I double checked it and tried many times before saying there was a syntax error.  BUT, I went to Chrome to cut and paste and it worked!!!  thanks.  

You're welcome.