levamit 101 posts msg #51824  Ignore levamit 
5/26/2007 7:56:10 PM
i try to build filter with this kind parameters :a day in which the range (highlow) is two or more times the average range of the last 20 days,the last day volume is larger then the previous day's volume ,and the last day close is in the top 1/3 of the day's range.
if someone can help !!:) .
thanks

nikoschopen 2,824 posts msg #51826  Ignore nikoschopen 
5/27/2007 12:51:05 AM
1) a day in which the range (highlow) is two or more times the average range of the last 20 days
First, we'll need to find the range for each of the past 20 days and then take the average of its sum by dividing it by 20. (We'll also take this number against the ATR and see the difference).
set{ADR, sum(day point range,20) / 20}
set{2xADR, day point range / ADR}
2xADR above 2
2) the last day volume is larger then the previous day's volume
volume above volume 1 day ago
3) the last day close is in the top 1/3 of the day's range
Close is above Day Position(0.66,1)
Add column ADR
Add column 2xADR
Here's a complete filter:
Here's the same filter but with ATR as the replacement for ADR:
On a side note, you can see from columns 5 and 6 that ADR and ATR has slightly different values. That is because, unlike ADR that takes the difference between only the high and low into calculation, ATR is comprised of the high, low and the previous close.

levamit 101 posts msg #51891  Ignore levamit 
5/31/2007 8:10:28 AM
first I want to thanks for your quick answer about my question and this is exactly what i looking for .
now i looking for a day in which the range (highlow) is two or more times the average range of the last 20 days,the last day volume is larger then the previous day's volume ,and the last day close is in the low 1/3 of the day's range.
i try to change parameters between "above" and "below" but the chart not look like what i searching for.
thanks for your help.

nikoschopen 2,824 posts msg #51896  Ignore nikoschopen 
5/31/2007 5:11:07 PM
Since everything remains essentially the same as before, we merely need to tweak the parameter for the last condition from "above 0.66" to "below 0.33" (line 4):
Here's the same filter but with ATR as the replacement for ADR:
Add price and volume criteria to narrow down the matches.
