Hi Bruce!

I was hoping you would try this scan and see if you are getting the same results as me.  I am scanning for stocks in the Russel 3K for a weekly 50EMA crossing above the 200EMA in the last 20 bars using this formula:

XAVGC50 > XAVGC200 AND (XAVGC50.1 <= XAVGC200.1 OR XAVGC50.2 <= XAVGC200.2 OR XAVGC50.3 <= XAVGC200.3 OR XAVGC50.4 <= XAVGC200.4 OR XAVGC50.5 <= XAVGC200.5 OR XAVGC50.6 <= XAVGC200.6 OR XAVGC50.7 <= XAVGC200.7 OR XAVGC50.8 <= XAVGC200.8 OR XAVGC50.9 <= XAVGC200.9 OR XAVGC50.10 <= XAVGC200.10 OR XAVGC50.11 <= XAVGC200.11 OR XAVGC50.12 <= XAVGC200.12 OR XAVGC50.13 <= XAVGC200.13 OR XAVGC50.14 <= XAVGC200.14 OR XAVGC50.15 <= XAVGC200.15 OR XAVGC50.16 <= XAVGC200.16 OR XAVGC50.17 <= XAVGC200.17 OR XAVGC50.18 <= XAVGC200.18 OR XAVGC50.19 <= XAVGC200.19 OR XAVGC50.20 <= XAVGC200.20)
 

When I run the scan, TC2000 is giving me results that either have not enough data to generate a 200 week EMA such as the ticker FRAM, or RM or the software is giving tickers such as KCAP and RUTH that has no cross in the last 20 bars.  The weekly 50 EMA is clearly has not crossed above the 200 yet.

If you have any insights into what I am doing wrong or need to change, I would greatly appreciate it!  Thanks so much!

Dave

There simply is not enough data available in TC2000 version 12.2 for this Condition Formula to exactly match the charts. That said, I do not show it currently returning true for RM, KCAP or RUTH (and don't have FRAM as a ticker).

Interesting, I ran the scan again and I am still getting cross over that are true for RM, KCAP, RUTH and ALJ but no crossovers on the charts.  Those appear to be false signals. 

FRAM should be ticker symbol FRAN. I mixed up the "N" 

I am pulling the list from the component section and choosing Russel 3000.   

Dave

FRAN doesn't show as currently returning true for me either. Are you using a Daily Time Frame for the Condition Formula and for the chart?

I have everything set to weekly.  Weekly scan and weekly chart time frame.  I ran ALJ as the test symbol in the conditions menu and it returned "True" but the weekly chart says it is "False" as the EMAs are clearly not cross and have not been for some time.

Bruce,

I ran ALJ in stockcharts.com and indeed it has crossed!  The TC2000 chart with a weekly 50 EMA and 200 EMA does not show that.  On my charts is shows the 50 EMA below the 200 with no cross.  There seems to be a display bug on the charting side as the calculations are correct.

Dave

The main issue is that there is only 500 bars of data in any given Time Frame in TC2000 version 12.2 and you are trying to calculate 200-Period Exponential Moving Averages.

A 200-Period Exponential Moving Average needs something closer to 1000 bars of data to be calculated in way that most of the possible algorithms used in its calculation would come to the same result. About the longest Exponential Moving Average that you are going to be able to use in TC2000 version 12.2 that is going to closely match all sources would be a 100-Period Exponential Moving Average.

Note that there is another technical issue in your results besides the above. You are getting results (as am I) before there should be enough data to calculate the EMAs at all. This would be a bug.

Thanks Bruce!  I will have to rethink and approach what I am trying to do.

Dave

You're welcome.