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 : Friday, May 13, 2005 1:48:54 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 LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); State:=If(Cum(1)=1,0,If(LE,1,If(SE,-1,If((LX AND PREV=1) OR (SX AND PREV=-1),0,PREV)))); State=1 Short LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); State:=If(Cum(1)=1,0,If(LE,1,If(SE,-1,If((LX AND PREV=1) OR (SX AND PREV=-1),0,PREV)))); State=-1 Out LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); State:=If(Cum(1)=1,0,If(LE,1,If(SE,-1,If((LX AND PREV=1) OR (SX AND PREV=-1),0,PREV)))); State=0 Symbols long Entry LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); State:=If(Cum(1)=1,0,If(LE,1,If(SE,-1,If((LX AND PREV=1) OR (SX AND PREV=-1),0,PREV)))); State=1 AND Ref(State,-1)<1 Short entry LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); State:=If(Cum(1)=1,0,If(LE,1,If(SE,-1,If((LX AND PREV=1) OR (SX AND PREV=-1),0,PREV)))); State=-1 AND Ref(State,-1)>-1 Long Exit LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); State:=If(Cum(1)=1,0,If(LE,1,If(SE,-1,If((LX AND PREV=1) OR (SX AND PREV=-1),0,PREV)))); State=0 AND Ref(State,-1)=1 Short Exit LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); State:=If(Cum(1)=1,0,If(LE,1,If(SE,-1,If((LX AND PREV=1) OR (SX AND PREV=-1),0,PREV)))); State=0 AND Ref(State,-1)=-1
henry1224  
#2 Posted : Saturday, May 14, 2005 1:47:13 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)
This version uses the PowerPivots Plus Add-on, it eliminates the Prev functions and speeds up explorations Highlights Long LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B>0 Short LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B<0 Out LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B=0 Symbols long entry LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B>0 AND Ref(B,-1)<=0 Short Entry LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B<0 AND Ref(B,-1)>=0 Long exit LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B=0 AND Ref(B,-1)>0 Short Exit LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:=ExtFml("PowerPivots.SysEval",LE,LX,SE,SX,"!@#$#@!"); B=0 AND Ref(B,-1)<0
henry1224  
#3 Posted : Sunday, July 31, 2005 12:20:13 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 : LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = 1 SHORT : LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = -1 out : LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = 0 Symbols tab ENTER LONG : LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = 1 AND Ref(B,-1) <> 1 ENTER SHORT : LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = -1 AND Ref(B,-1) <> -1 EXIT LONG : LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = 0 AND Ref(B,-1) = 1 EXIT SHORT : LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); B = 0 AND Ref(B,-1) = -1
klburris  
#4 Posted : Sunday, July 31, 2005 6:29:14 PM(UTC)
klburris

Rank: Member

Groups: Registered, Registered Users
Joined: 10/28/2004(UTC)
Posts: 16

Henry - Being a MS newby, let me ask a really dumb one-- Using the Aberration Expert, I tried (without success) to turn it into an exploration. What I did was to take the long and short entry code and plug into a column and then filter on COLA or COLB. I got some results, but when attaching the expert to the resultant chart, the signals did not line up. Am I doing something really dumb here (probably)? Help is always appreciated :) -- Keith
henry1224  
#5 Posted : Sunday, July 31, 2005 9:37:07 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)
LE:=C>BBandTop(C,35,S,2); LX:=C < Mov(C,35,S); SE:=C<BBandBot(C,35,S,2); SX:=C > Mov(C,35,S); B:= ExtFml("ForumDll.Latch",LE,LX,SE,SX); (B = 1 AND Ref(B,-1) <> 1)-(B = -1 AND Ref(B,-1) <> -1) Filter: ColA<>0
henry1224  
#6 Posted : Sunday, July 31, 2005 9:41:07 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)
I can't verify Patrick's Latch! I use the SysEval function from PowerPivots Plus. I assume that you are using Patrick's Latch.
klburris  
#7 Posted : Monday, August 1, 2005 3:22:18 AM(UTC)
klburris

Rank: Member

Groups: Registered, Registered Users
Joined: 10/28/2004(UTC)
Posts: 16

Henry: It's most likely a case of the grey hair soaking up the grey matter, but it still does essentially the same thing, IE the exploration results still don't match up with the expert. Not that big of a thing, I was just trying to understand this a little more. -- Keith
henry1224  
#8 Posted : Tuesday, August 2, 2005 12:53:43 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)
Keith, Check to see load Minimum records is unchecked in the options of your exploration
Users browsing this topic
Guest (Hidden)
Similar Topics
Abberation Expert SAR Stop & Trend Direction (Formula Assistance)
by henry1224 8/6/2005 2:28:00 PM(UTC)
Abberation Expert w SAR Stop (Formula Assistance)
by henry1224 8/6/2005 2:22:39 PM(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.