[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: formula help



PureBytes Links

Trading Reference Links

Paul/

If the moving average is shifted 5 bars to the right then today's value
is the moving average from five days ago.  There is no formula to read
the shifted MA directly.

Try:  C>Ref(Mov(C,10,S),-5)

Harvey Pearce, Victoria, B.C., Canada
=====================================


Paul wrote:
> 
> hello,
> 
> I know I can shift a moving average horizontally and vertically using
> moving average properties dialog box. Now, what's the formula for that? Say,
> I wanna create an exploration filter to check out all the securities that
> are above their 10 day simple moving average that is HORIZONTALLY SHIFTED 5
> bars to the right.
> 
> thank you
> 
> paul