can anyone help me?

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

Buzz2002,
First collect "Roy's" monthly code & "Jose's" calender day counter from google search,otherwise if you use hhv function (for 9months approx 9*25)for 225days then the back reference date is fixed,which may not give you the desired result.
Asish

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.

what if I need to check approaching 1 year high?
I just change the HHV in the formula is it?

million thanks