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 : Saturday, March 26, 2005 4:04:02 PM(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 MUST HAVE THE POWERPIVOTS PLUS ADD-ON TO USE THIS EXPERT Highlight tab Long A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B>0 Short A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B<0 Out A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B=0 Symbol tab Long entry: A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B>0 AND Ref(B,-1)<=0 Short entry: A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B<0 AND Ref(B,-1)>=0 Long exit: A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B=0 AND Ref(B,-1)>0 Short Exit: A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B=0 AND Ref(B,-1)<0
Danny14  
#2 Posted : Wednesday, April 27, 2005 11:46:14 AM(UTC)
Danny14

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 3/21/2005(UTC)
Posts: 1

Hi henry1224, Is there any chance of getting copies of the codes you have written, that do not have to use the POWERPIVOTS PLUS ADD-ON. Regards Danny
henry1224  
#3 Posted : Thursday, April 28, 2005 12:12:04 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)
Danny, I do not have any affiliation with Equis, "Their Loss" but I Highly recommend this add-on. It is not for the systems that come with the add-on but for the extra functions!
minnamor  
#4 Posted : Thursday, April 28, 2005 5:44:00 PM(UTC)
minnamor

Rank: Advanced Member

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

I am relatively new to the forum but not to MS and I own PowerPivots Plus. I notice that you often use the function "ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); " in your systems. This function is not documented in Ch.7 "External Formula Functions" of the PowerPivots add-on manual. I suspect that this function calls the signal from certain PowerPivots systems (the funny symbols in quotation marks) but would like your confirmation of this if possible. Thanks. Maurizio
henry1224  
#5 Posted : Friday, April 29, 2005 12:39:05 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)
minimoor, the powerpivots external formulas have several benefits LE:=A2>A3 AND Cross(A1,A2); {long entry} LX:=Cross(A3,A2) OR Cross(A2,A1); {long exit} SE:=A2<A3 AND Cross(A2,A1); {Short entry} SX:=Cross(A2,A3) OR Cross(A1,A2);{Short exit} B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); takes the LE,SE,LX,and SX and creates it into a binary signal, without having to use the If(Cum(1) blah,blah ,else prev functions since it is an external formula it calculates faster in explorations Do not change any of the symbols
henry1224  
#6 Posted : Saturday, May 14, 2005 2:20:57 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)
To see how to write an expert without the powerPivot Plus Add-on check out the Abberation Expert
henry1224  
#7 Posted : Sunday, July 31, 2005 12:16:50 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 : A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = 1 SHORT : A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = -1 out : A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = 0 Symbols tab ENTER LONG : A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = 1 AND Ref(B,-1) <> 1 ENTER SHORT : A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = -1 AND Ref(B,-1) <> -1 EXIT LONG : A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = 0 AND Ref(B,-1) = 1 EXIT SHORT : A1:=Mov(C,12,S); A2:=Mov(C,50,S); A3:=Mov(C,200,S); LE:=A2>A3 AND Cross(A1,A2); LX:=Cross(A3,A2) OR Cross(A2,A1); SE:=A2<A3 AND Cross(A2,A1); SX:=Cross(A2,A3) OR Cross(A1,A2); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = 0 AND Ref(B,-1) = -1
Users browsing this topic
Guest (Hidden)
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.