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

Re: formula/exploration help



PureBytes Links

Trading Reference Links

Steve/

The formulas in A.J.Maas post "Re: DeMark Indicators" were in MS 5.0
code, with many commas.  Translated into v.6.5 the following should do
it.

DeMark Indicator

Sum(If(H>Ref(H,-1),H-Ref(H,-1),0),13)/
(Sum(If(H>Ref(H,-1),H-Ref(H,-1),0),13)+
Sum(If(L>=Ref(L,-1),0,Ref(L,-1)-L),13))


REI Indicator

Var1:=If(Ref(H,-2)<Ref(C,-7),
If(Ref(H,-2)<Ref(C,-8),
If(H<Ref(L,-5),
If(H<Ref(L,-6),
0,1),1),1),1);
Var2:=If(Ref(L,-2)>Ref(C,-7),
If(Ref(L,-2)>Ref(C,-8),
If(L>Ref(H,-5),
If(L>Ref(H,-6),
0,1),1),1),1);
SubValues:=Var1*Var2*(H-Ref(H,-2))+Var1*Var2*(L-Ref(L,-2));
AbsDailyVal:=Abs(H-Ref(H,-2))+Abs(L-Ref(L,-2));
REI2:=Sum(SubValues,8)/Sum(AbsDailyVal,8);
REI2

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


Steve Karnish wrote:
> 
> Ton,
> When I put in DeMark's REI formula...MS rejects the "VAR1" with:
> {This character is invalid when used in this manner at this
> location}.  What gives?  I know I'm an idiot when it comes to
> simple programming, but I copied the formula and I'm really good
> at typing things in exactly.
> 
> Thanks in advance,
> Steve Karnish
> CCT
>