Hi All,

I am transitioning from using scans on Stockcharts to TC2000 scans and so far have been unsucessful with converting the stockchart scans to TC2000 scans. What am I doing wrong?

Stockcharts Scan:

The link didn't work but here is what I did in short:

For lists to scan in the TC2000, I chose "US Common Stocks",

For the Exchange, it allows me to choose only NYSE, AMEX and NASDAQ.

I didn't see excluding OTCBB as an option in TC2000

For the 20 day simple moving average greter than 40000 shares, I chose the indicator as "volume" and specified that the condition as value is "greater than" "40000", "x bars in a row", with x being "20" and the timeframe begin "Daily"

For the real gap up, I used this TC2000 formula: "(L > (H1*1.026))" with the formula value being set to "Is true", True being set to "Now" and Timeframe being set to "Daily"

For the improving rsi, (for today's rsi(14) > 3 as an example)  I chose "Wilder's RSI14" as the indicator with the condition being that the value is greater than "30" with True being "Now" and Timeframe being "Daily". I added similar conditions for the other RSI taking into consideration that for example 2 days ago rsi condition should have True set to be "x bars ago" and Bars ago set to be "2".

I do not get the same results as the stockcharts scan does. What part is wrong? Is there a better way of doing this? Could the whole scan be implemented as a formula?

For Daily Average Volume, I suggest you use

AvgV20>40000

Your formula requires EVERY day to be over the average volume

I believe your formula for the gap will work as you described

Wilder RSI is a different formula than RSI,and so will return different results.

Try:

RSI14>30 and RSI14.1<29 and RSI14.2<28 and RSI14.3<27

If you do want to use Wilder RSI, put a W in front of each RSI is the formula above eg WRSI14

Apologies

RSI formula in above should be RSI14, RSI14.1.1, RSI14.1.2 and RSI14.1.3 respectively

14 is period of RSI Formula, second digit allows a moving averageto be applied (which we don't want in this case, so is one) and third digit is bars ago

If you aren't hung up on the numerical values this should also work

TrueInRow(RSI14>RSI14.1.1,3) = 3 and RSI14>30

Please try the following daily Condition Formula to duplicate the original.

AVGV20 > 40000 AND L > 1.026 * H1 AND WRSI14 > 30 AND WRSI14.1 < 29 AND WRSI14.2 < 28 AND WRSI14.3 < 27

That said, bcochrane's suggestion about improving RSI makes sense and you may be better off with the following instead.

AVGV20 > 40000 AND L > 1.026 * H1 AND WRSI14 > 30 AND TrueInRow(WRSI14 > WRSI14.1, 4) = 4 AND WRSI14.3 < 27

Using the condition in an EasyScan and setting the List to Scan of the EasyScan as desired is how you would set what stocks you want to scan in TC2000. It is not part of the Personal Cirteria Formula Language itself.