hi guys
Im new here
btw, I'm now trying to make an explorer formula to filter out stock that is approaching (is not breaking, but 5% below its 9 months previous high) and volume is above 5 days average...can it be done??
I couldnt figure it out
anyone??
thanks a million
Hi buzz,
Try this (I'm assuming that there are 185 trading days in the last 9months...it is approximately 185 trading days excluding saturday,sundays and other occasional holidays....even then, it isn't quite probable that the high is at the first few bars, so there won't be much of a difference),
Coloumn A:
a:= C;
b:= HHV(C,185);
d:= .97*b;
f:= .93*b;
g:= V;
i:= Mov(V,5,S);
a > f AND a < d AND g > i
Filter:
ColA
I have coded it in simple language to increase understanding. The result will give a "1" when the price is below 3% but above 7% from its 185 day high( i.e, from 93% to 97% of its 185 day high) and volume greater than 5day simple average.
Oxymoron.