A Scan Based Upon the MACD and the ADX Returns Bad Results

[craigjjmorrison]

I ran a query several times with the following code for Month, Week, and Day:
MACD()."Value" is greater than MACD()."Avg" and
MACD()."Avg" is greater than 0 and
ADX() is greater than 25

Several of the results violated the criteria. The screen print below shows an example:


While the MACD value is > the average, the average is < 0. Also, the ADX is < 25;
Here is the scan:
http://tos.mx/!796eG1vc

Most of the results are good. I don't understand the inclusion of results that don't seem to meet the criteria. Where did I go wrong?
Craig

 

[useThinkScript]

@craigjjmorrison

You are running your scan on the current month, week, and day candle.
Current candles update on every tick.

Therefore, at the moment of the scan: conditions were true for the scan results.
At the moment you looked at the chart, they no longer were.

To have static unchanging results you would need to look at closed candles: last month, last week, yesterday
To do this, change to: look one bar back

 

[Joshua]

The chart in the image is also scrolled back to July 16th.