Watchlists results are not matching criteria

Watchlists results are not matching criteria

Ronen Poltek
2010-09-07 06:08:36

Dear Sirs
I am running the following filter on a static list and the results are in mismatch to the criteria, to my understanding.
var2 = close > 0.5;
var3 = open < Ma(4,_MaEma);
var4 = open < Ma(8,_MaEma);
var5 = open < Ma(21,_MaEma);
var6 = close > Ma(4,_MaEma);
var7 = close > Ma(8,_MaEma);
var8 = close > Ma(21,_MaEma);

filter = (var2) && (var3) && (var4) && (var5) && (var6) && (var7) && (var8);

Today Sep. 7 2010 I have run the filter and one of the stocks that passed the filter is GS with the following values:
Open 141.62
Close 147.29
While the values of the Moving Averages is:
EMA 4 - 142.5693
EMA 8 - 141.2124
EMA 21 - 144.3681
As can be seen the EMA 8 value is lower then the open value.
Thank you for a great product
Ronen Poltek

QuantShare
2010-09-07 10:13:08

Best Answer

Hi,

Please make sure that the screener date is the same as the date you used to check values.
If you use Bar n-0 then make sure the bar you are checking is the last bar.

I have created the same screen and GS passed filters.
However, when I checked the values of EMAs I found different results.

EMA 4 - 142.54 (Small difference)
EMA 8 - 142.1 (Big difference) -> Make sure your EMA 8 value is correct
EMA 21 - 144.14 (Small difference)

Note that the calculation of EMA depends on the number of bars and this is why there is a small difference. With more than 500-1000 bars (depends on the EMA period), EMA values should be the same.

So in order to have stable results you should have more than 500 bars (Again it depends on the EMA period)

Get more messages

No more messages

Back


Trading Items How far are the close prices from the support line Watchlists on Your Chart Number of Symbols in Watchlists Percentage of Stocks that are trading between their 50 and 200-da... Set the First Trading Bar Values to Not a Number	How-to Lessons How to detect whether price movements are predictable or not Difference between the watchlist and the screener tools How to plot a time-series that do not update the chart scale How to dynamically change the number of positions in a portfolio? How to import trades into a portfolio
Related Forum Threads Portfolio - Symbols are not up to date error Google links in scripts are not working//// Entry Signal Rejection Criteria Interpret Prediction results and making it useful? Rules manager - comparing results - back testing vs rules analysi...	Blog Posts Programming skills are not that important Create a HTML or PDF Report of your Trading System Backtesting Re... Data snooping bias Diversify your portfolio by investing in stocks from various indu... Trading System: Buy stocks with the highest Sharpe ratio