Thanks. It worked ---In [email protected], <[email protected]> wrote:
My take on the question uses the Sum() function which provides a simple way of testing a contiguous logical state back over as many bars as might be required. M:=Mov(C,50,S); Sum(M>Ref(M,-1),20)=20 AND C/M>.97 AND C/M<1.03; Roy ---In [email protected], <[email protected]> wrote: When(Mov(C,50,S),>,Ref(Mov(C,50,S),-1)) AND When(LLV(Mov(C,50,S),19),>,Ref(Mov(C,50,S),-19)) AND When(LLV(Mov(C,50,S),14),>,Ref(Mov(C,50,S),-14)) AND When(LLV(Mov(C,50,S),9),>,Ref(Mov(C,50,S),-9)) AND When(C*100/Mov(C,50,S),>=,97) AND When(C*100/Mov(C,50,S),<=,103) This formula does not guarantee the sma to be higher for 20 consecutive days, however it is the equivilant of the sma being higher than each consecutive weekly sma. The scan would bring up shares that fulfil the 20 day consecutive sma rise criteria as well as shares that do not. You could no doubt arrive at the 20 day consecutive sma rise criteria by increasing the lines of the formula which would probably take up approx five times more space. ---In [email protected], <[email protected]> wrote: I am seeking help with exploartion which look for rising 50 days simple moving average of close to be higher than previous day for 20 consecutive days and close price of today is within 3% of moving average. Thanks
