Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Hi renu,
If you are NOT talking about trying to mix timeframes, just copy the (slightly modified) formula into the explorer and choose the requisite timeframe in the options, something like:
Code:{col A - MER}
pds:=8;
Speed:= C - Ref(C, -pds);
Volatility:= Sum(Abs(C - Ref(C, -1)),pds);
Efficiency:= Speed / Volatility;
Mov(Mov(Efficiency, 5,E),3,E);
{col B - BUY}
pds:=8;
Speed:= C - Ref(C, -pds);
Volatility:= Sum(Abs(C - Ref(C, -1)),pds);
Efficiency:= Speed / Volatility;
MER:=Mov(Mov(Efficiency, 5,E),3,E);
MER<-0.5;
{col C - SELL}
pds:=8;
Speed:= C - Ref(C, -pds);
Volatility:= Sum(Abs(C - Ref(C, -1)),pds);
Efficiency:= Speed / Volatility;
MER:=Mov(Mov(Efficiency, 5,E),3,E);
MER>0.5;
{filter}
ColB OR ColC
An alternative way that might make things a little more customisable would be to explore the use of Fml() and FmlVar() functions and avoid repeating the same functions. There is a speed/performance cost which should be speed tested.
There is a lot of good information in the MS Users Manual and the free Equis Formula Primer regarding these functions, and creating explorations in and for different timeframes.
Hope this helps.
wabbit [:D]
|
