logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
henry1224  
#1 Posted : Thursday, April 28, 2005 1:35:33 AM(UTC)
henry1224

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT

Was thanked: 2 time(s) in 2 post(s)
You will also need the PowerPivots Plus Add-on Highlights long A30:=ExtFml("MSX_KSR.CER",30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",5); Val1.5:=If(Pk>0,HHV(H-1.5*A,10),LLV(L+1.5*A,10)); LE:=C>Val1.5; SE:=C<Val1.5; LX:=0; SX:=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B>0 Short A30:=ExtFml("MSX_KSR.CER",30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",5); Val1.5:=If(Pk>0,HHV(H-1.5*A,10),LLV(L+1.5*A,10)); LE:=C>Val1.5; SE:=C<Val1.5; LX:=0; SX:=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B<0 Symbols long Entry A30:=ExtFml("MSX_KSR.CER",30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",5); Val1.5:=If(Pk>0,HHV(H-1.5*A,10),LLV(L+1.5*A,10)); LE:=C>Val1.5; SE:=C<Val1.5; LX:=0; SX:=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B>0 AND Ref(B,-1)<=0 Short Entry A30:=ExtFml("MSX_KSR.CER",30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",5); Val1.5:=If(Pk>0,HHV(H-1.5*A,10),LLV(L+1.5*A,10)); LE:=C>Val1.5; SE:=C<Val1.5; LX:=0; SX:=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B<0 AND Ref(B,-1)>=0
henry1224  
#2 Posted : Thursday, April 28, 2005 1:43:33 AM(UTC)
henry1224

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT

Was thanked: 2 time(s) in 2 post(s)
You will also need the PowerPivots Plus Add-on Highlights long A30:=ExtFml("MSX_KSR.CER",30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B>0 Short A30:=ExtFml("MSX_KSR.CER",30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B<0 Out A30:=ExtFml("MSX_KSR.CER",30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B=0 Symbols Long entry A30:=ExtFml("MSX_KSR.CER",30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B>0 AND Ref(B,-1)<=0 Short Entry A30:=ExtFml("MSX_KSR.CER",30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B<0 AND Ref(B,-1)>=0 Long Exit A30:=ExtFml("MSX_KSR.CER",30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B=0 AND Ref(B,-1)>0 Short Exit A30:=ExtFml("MSX_KSR.CER",30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B=0 AND Ref(B,-1)<0
minnamor  
#3 Posted : Thursday, April 28, 2005 6:32:48 PM(UTC)
minnamor

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 4/27/2005(UTC)
Posts: 126
Location: Italy

Apparently you should have specified the Data Array before the length as documented in http://www.ksr.sp.ru/msx/msxen.htm. Regards.
ksr  
#4 Posted : Thursday, April 28, 2005 7:43:23 PM(UTC)
ksr

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 4/27/2005(UTC)
Posts: 1

minnamor wrote:
Apparently you should have specified the Data Array before the length as documented in http://www.ksr.sp.ru/msx/msxen.htm.
The new calling convention which requires that the Data Array should be explicitly defined right before the length was implemented since the version 1.7.0.5 Oct. 11, 2004 of the dll. greetings.
henry1224  
#5 Posted : Friday, April 29, 2005 1:08:39 AM(UTC)
henry1224

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT

Was thanked: 2 time(s) in 2 post(s)
since they updated the DLL here is the corrected expert Highlights long A30:=ExtFml("MSX_KSR.CER",C,30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",C,5); Val1.5:=If(Pk>0,HHV(H-1.5*A,10),LLV(L+1.5*A,10)); LE:=C>Val1.5; SE:=C<Val1.5; LX:=0; SX:=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B>0 Short A30:=ExtFml("MSX_KSR.CER",C,30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",C,5); Val1.5:=If(Pk>0,HHV(H-1.5*A,10),LLV(L+1.5*A,10)); LE:=C>Val1.5; SE:=C<Val1.5; LX:=0; SX:=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B<0 Symbols long entry A30:=ExtFml("MSX_KSR.CER",C,30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",C,5); Val1.5:=If(Pk>0,HHV(H-1.5*A,10),LLV(L+1.5*A,10)); LE:=C>Val1.5; SE:=C<Val1.5; LX:=0; SX:=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B>0 AND Ref(B,-1)<=0 Short entry A30:=ExtFml("MSX_KSR.CER",C,30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",C,5); Val1.5:=If(Pk>0,HHV(H-1.5*A,10),LLV(L+1.5*A,10)); LE:=C>Val1.5; SE:=C<Val1.5; LX:=0; SX:=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B<0 AND Ref(B,-1)>=0
henry1224  
#6 Posted : Friday, April 29, 2005 1:12:53 AM(UTC)
henry1224

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT

Was thanked: 2 time(s) in 2 post(s)
Highlights long A30:=ExtFml("MSX_KSR.CER",C,30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",C,5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B>0 Short A30:=ExtFml("MSX_KSR.CER",C,30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",C,5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B<0 Out A30:=ExtFml("MSX_KSR.CER",C,30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",C,5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B=0 Symbols Long entry A30:=ExtFml("MSX_KSR.CER",C,30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",C,5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B>0 AND Ref(B,-1)<=0 Short Entry A30:=ExtFml("MSX_KSR.CER",C,30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",C,5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B<0 AND Ref(B,-1)>=0 Long exit A30:=ExtFml("MSX_KSR.CER",C,30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",C,5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B=0 AND Ref(B,-1)>0 Short exit A30:=ExtFml("MSX_KSR.CER",C,30); RWH:=(H-Ref(L,-30))/(A30*Sqrt(30)); RWL:=(Ref(H,-30)-L)/(A30*Sqrt(30)); Pk:=Mov((RWH-RWL),3,W); A:=ExtFml("MSX_KSR.CER",C,5); Val1.5:=If(Pk>0,Max(HHV(H-1.5*A,10),Ref(HHV(H-1.5*A,10),-1)),Min(LLV(L+1.5*A,10),Ref(LLV(L+1.5*A,10),-1))); TD:=ExtFml("PowerPivots.TrendDirection",1,2); LE:=C>Val1.5 AND TD=1; SE:=C<Val1.5 AND TD=-1; SX:=C>Val1.5 AND TD<=0; LX:=C<Val1.5 AND TD>=0; B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B=0 AND Ref(B,-1)<0
Users browsing this topic
Guest (Hidden)
Similar Topics
CER Trailing Stop Expert w ATS Win Loss Trend & SAR (Formula Assistance)
by henry1224 9/17/2005 1:43:10 AM(UTC)
CER Trailing Stop Expert w ATS Win Loss Trend (Formula Assistance)
by henry1224 9/17/2005 1:08:41 AM(UTC)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.