Setting Up Power Pivot Expert Advisurs

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

Notification

Error

Setting Up Power Pivot Expert Advisurs - Setting Up Power Pivot Expert Advisurs

Options

Previous Topic Next Topic

Keith Johnson		#1 Posted : Thursday, June 22, 2006 4:16:07 AM(UTC)
Rank: Newbie Groups: Registered, Registered Users, Subscribers Joined: 5/27/2006(UTC) Posts: 6		I am new to metastock and power pivots. I have done some simple explorers and functions. I was trying to copy some of the expert advisors over from the forum but I do not have the options that seem to appear on the advisor setup menu. On the setup menu it only has a place to put a bullish and a bearish trend. The formulas require a long position, short, sell etc. Also the symbol options on the formulas on the forum do not seem to be consitant with the format that is given in the Advisor setup menu. Is there a good reference that i can look at or am I missing something. All of the stock PP+ formulas are protected so I can't dig through them to see how to do it. Also, for some reason everytime I do a search on the forum I get a message that there are no posts. I don't think I have changed any settings from the default. Am I doing something wrong? :(


User Profile View All Posts by User View Thanks


	Wanna join the discussion?! Login to your Discussions forum account or Register a new forum account.

henry1224		#2 Posted : Thursday, June 22, 2006 10:37:17 PM(UTC)
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 need the PowerPivots + Add-on for the exact formula to work} click on the expert advisor click new you will now see a screen for the name name it Chaos BL MTF2 you also have a space to write a note about the system click on the trends tab in the bullish box factor:=2; offset:=0; HD:=ExtFml("PowerPivots.TDataCreate",1, factor); LD:=ExtFml("PowerPivots.TDataCreate",2, factor); A3:= {Alligator Blue Balance Line - Jaw} {13 bar smoothed average offset 8 bars} Ref(Wilders((HD+LD)/2,13),-8); A2:= {Alligator Red Balance Line - Teeth} {8 bar smoothed average offset 5 bars} Ref(Wilders((HD+LD)/2,8),-5); A1:= {Alligator Green Balance Line - Lip} {5 bar smoothed average offset 3 bars} Ref(Wilders((HD+LD)/2,5),-3); UCloud:=Max(A1,Max(A2,A3)); LCloud:=Min(A1,Min(A2,A3)); UCloud:=ExtFml("PowerPivots.TDataLocalize", UCloud, factor, offset); A3:=ExtFml("PowerPivots.TDataLocalize", A3, factor, offset); A2:=ExtFml("PowerPivots.TDataLocalize", A2, factor, offset); A1:=ExtFml("PowerPivots.TDataLocalize", A1, factor, offset); LCloud:=ExtFml("PowerPivots.TDataLocalize", LCloud, factor, offset); Z:=If(C>Ucloud,1,If(C<LCloud,-1,0)); Z=1 in the bearish box factor:=2; offset:=0; HD:=ExtFml("PowerPivots.TDataCreate",1, factor); LD:=ExtFml("PowerPivots.TDataCreate",2, factor); A3:= {Alligator Blue Balance Line - Jaw} {13 bar smoothed average offset 8 bars} Ref(Wilders((HD+LD)/2,13),-8); A2:= {Alligator Red Balance Line - Teeth} {8 bar smoothed average offset 5 bars} Ref(Wilders((HD+LD)/2,8),-5); A1:= {Alligator Green Balance Line - Lip} {5 bar smoothed average offset 3 bars} Ref(Wilders((HD+LD)/2,5),-3); UCloud:=Max(A1,Max(A2,A3)); LCloud:=Min(A1,Min(A2,A3)); UCloud:=ExtFml("PowerPivots.TDataLocalize", UCloud, factor, offset); A3:=ExtFml("PowerPivots.TDataLocalize", A3, factor, offset); A2:=ExtFml("PowerPivots.TDataLocalize", A2, factor, offset); A1:=ExtFml("PowerPivots.TDataLocalize", A1, factor, offset); LCloud:=ExtFml("PowerPivots.TDataLocalize", LCloud, factor, offset); Z:=If(C>Ucloud,1,If(C<LCloud,-1,0)); Z=-1 click ok click on the highlights tab click new name it long factor:=2; offset:=0; HD:=ExtFml("PowerPivots.TDataCreate",1, factor); LD:=ExtFml("PowerPivots.TDataCreate",2, factor); A3:= {Alligator Blue Balance Line - Jaw} {13 bar smoothed average offset 8 bars} Ref(Wilders((HD+LD)/2,13),-8); A2:= {Alligator Red Balance Line - Teeth} {8 bar smoothed average offset 5 bars} Ref(Wilders((HD+LD)/2,8),-5); A1:= {Alligator Green Balance Line - Lip} {5 bar smoothed average offset 3 bars} Ref(Wilders((HD+LD)/2,5),-3); UCloud:=Max(A1,Max(A2,A3)); LCloud:=Min(A1,Min(A2,A3)); UCloud:=ExtFml("PowerPivots.TDataLocalize", UCloud, factor, offset); A3:=ExtFml("PowerPivots.TDataLocalize", A3, factor, offset); A2:=ExtFml("PowerPivots.TDataLocalize", A2, factor, offset); A1:=ExtFml("PowerPivots.TDataLocalize", A1, factor, offset); LCloud:=ExtFml("PowerPivots.TDataLocalize", LCloud, factor, offset); Z:=If(C>Ucloud,1,If(C<LCloud,-1,0)); Z=1 color it green click ok click new name it short factor:=2; offset:=0; HD:=ExtFml("PowerPivots.TDataCreate",1, factor); LD:=ExtFml("PowerPivots.TDataCreate",2, factor); A3:= {Alligator Blue Balance Line - Jaw} {13 bar smoothed average offset 8 bars} Ref(Wilders((HD+LD)/2,13),-8); A2:= {Alligator Red Balance Line - Teeth} {8 bar smoothed average offset 5 bars} Ref(Wilders((HD+LD)/2,8),-5); A1:= {Alligator Green Balance Line - Lip} {5 bar smoothed average offset 3 bars} Ref(Wilders((HD+LD)/2,5),-3); UCloud:=Max(A1,Max(A2,A3)); LCloud:=Min(A1,Min(A2,A3)); UCloud:=ExtFml("PowerPivots.TDataLocalize", UCloud, factor, offset); A3:=ExtFml("PowerPivots.TDataLocalize", A3, factor, offset); A2:=ExtFml("PowerPivots.TDataLocalize", A2, factor, offset); A1:=ExtFml("PowerPivots.TDataLocalize", A1, factor, offset); LCloud:=ExtFml("PowerPivots.TDataLocalize", LCloud, factor, offset); Z:=If(C>Ucloud,1,If(C<LCloud,-1,0)); Z=-1 color it red click ok click new name it out factor:=2; offset:=0; HD:=ExtFml("PowerPivots.TDataCreate",1, factor); LD:=ExtFml("PowerPivots.TDataCreate",2, factor); A3:= {Alligator Blue Balance Line - Jaw} {13 bar smoothed average offset 8 bars} Ref(Wilders((HD+LD)/2,13),-8); A2:= {Alligator Red Balance Line - Teeth} {8 bar smoothed average offset 5 bars} Ref(Wilders((HD+LD)/2,8),-5); A1:= {Alligator Green Balance Line - Lip} {5 bar smoothed average offset 3 bars} Ref(Wilders((HD+LD)/2,5),-3); UCloud:=Max(A1,Max(A2,A3)); LCloud:=Min(A1,Min(A2,A3)); UCloud:=ExtFml("PowerPivots.TDataLocalize", UCloud, factor, offset); A3:=ExtFml("PowerPivots.TDataLocalize", A3, factor, offset); A2:=ExtFml("PowerPivots.TDataLocalize", A2, factor, offset); A1:=ExtFml("PowerPivots.TDataLocalize", A1, factor, offset); LCloud:=ExtFml("PowerPivots.TDataLocalize", LCloud, factor, offset); Z:=If(C>Ucloud,1,If(C<LCloud,-1,0)); Z=0 color it blue click ok click on the symbol tab click new name it long entry factor:=2; offset:=0; HD:=ExtFml("PowerPivots.TDataCreate",1, factor); LD:=ExtFml("PowerPivots.TDataCreate",2, factor); A3:= {Alligator Blue Balance Line - Jaw} {13 bar smoothed average offset 8 bars} Ref(Wilders((HD+LD)/2,13),-8); A2:= {Alligator Red Balance Line - Teeth} {8 bar smoothed average offset 5 bars} Ref(Wilders((HD+LD)/2,8),-5); A1:= {Alligator Green Balance Line - Lip} {5 bar smoothed average offset 3 bars} Ref(Wilders((HD+LD)/2,5),-3); UCloud:=Max(A1,Max(A2,A3)); LCloud:=Min(A1,Min(A2,A3)); UCloud:=ExtFml("PowerPivots.TDataLocalize", UCloud, factor, offset); A3:=ExtFml("PowerPivots.TDataLocalize", A3, factor, offset); A2:=ExtFml("PowerPivots.TDataLocalize", A2, factor, offset); A1:=ExtFml("PowerPivots.TDataLocalize", A1, factor, offset); LCloud:=ExtFml("PowerPivots.TDataLocalize", LCloud, factor, offset); Z:=If(C>Ucloud,1,If(C<LCloud,-1,0)); Z=1 and ref(Z,-1)<1 in the graphic tab select an arrow pointing up and color green click ok click new name it short entry factor:=2; offset:=0; HD:=ExtFml("PowerPivots.TDataCreate",1, factor); LD:=ExtFml("PowerPivots.TDataCreate",2, factor); A3:= {Alligator Blue Balance Line - Jaw} {13 bar smoothed average offset 8 bars} Ref(Wilders((HD+LD)/2,13),-8); A2:= {Alligator Red Balance Line - Teeth} {8 bar smoothed average offset 5 bars} Ref(Wilders((HD+LD)/2,8),-5); A1:= {Alligator Green Balance Line - Lip} {5 bar smoothed average offset 3 bars} Ref(Wilders((HD+LD)/2,5),-3); UCloud:=Max(A1,Max(A2,A3)); LCloud:=Min(A1,Min(A2,A3)); UCloud:=ExtFml("PowerPivots.TDataLocalize", UCloud, factor, offset); A3:=ExtFml("PowerPivots.TDataLocalize", A3, factor, offset); A2:=ExtFml("PowerPivots.TDataLocalize", A2, factor, offset); A1:=ExtFml("PowerPivots.TDataLocalize", A1, factor, offset); LCloud:=ExtFml("PowerPivots.TDataLocalize", LCloud, factor, offset); Z:=If(C>Ucloud,1,If(C<LCloud,-1,0)); Z=-1 and ref(Z,-1)>-1 click the graphic tab select a pointing down arrow and color it red click ok click new name it long exit factor:=2; offset:=0; HD:=ExtFml("PowerPivots.TDataCreate",1, factor); LD:=ExtFml("PowerPivots.TDataCreate",2, factor); A3:= {Alligator Blue Balance Line - Jaw} {13 bar smoothed average offset 8 bars} Ref(Wilders((HD+LD)/2,13),-8); A2:= {Alligator Red Balance Line - Teeth} {8 bar smoothed average offset 5 bars} Ref(Wilders((HD+LD)/2,8),-5); A1:= {Alligator Green Balance Line - Lip} {5 bar smoothed average offset 3 bars} Ref(Wilders((HD+LD)/2,5),-3); UCloud:=Max(A1,Max(A2,A3)); LCloud:=Min(A1,Min(A2,A3)); UCloud:=ExtFml("PowerPivots.TDataLocalize", UCloud, factor, offset); A3:=ExtFml("PowerPivots.TDataLocalize", A3, factor, offset); A2:=ExtFml("PowerPivots.TDataLocalize", A2, factor, offset); A1:=ExtFml("PowerPivots.TDataLocalize", A1, factor, offset); LCloud:=ExtFml("PowerPivots.TDataLocalize", LCloud, factor, offset); Z:=If(C>Ucloud,1,If(C<LCloud,-1,0)); Z=0 and Ref(Z,-1)=1 click the graphic tab select a stop sign and color it blue click ok click new name it short exit factor:=2; offset:=0; HD:=ExtFml("PowerPivots.TDataCreate",1, factor); LD:=ExtFml("PowerPivots.TDataCreate",2, factor); A3:= {Alligator Blue Balance Line - Jaw} {13 bar smoothed average offset 8 bars} Ref(Wilders((HD+LD)/2,13),-8); A2:= {Alligator Red Balance Line - Teeth} {8 bar smoothed average offset 5 bars} Ref(Wilders((HD+LD)/2,8),-5); A1:= {Alligator Green Balance Line - Lip} {5 bar smoothed average offset 3 bars} Ref(Wilders((HD+LD)/2,5),-3); UCloud:=Max(A1,Max(A2,A3)); LCloud:=Min(A1,Min(A2,A3)); UCloud:=ExtFml("PowerPivots.TDataLocalize", UCloud, factor, offset); A3:=ExtFml("PowerPivots.TDataLocalize", A3, factor, offset); A2:=ExtFml("PowerPivots.TDataLocalize", A2, factor, offset); A1:=ExtFml("PowerPivots.TDataLocalize", A1, factor, offset); LCloud:=ExtFml("PowerPivots.TDataLocalize", LCloud, factor, offset); Z:=If(C>Ucloud,1,If(C<LCloud,-1,0)); Z=0 and Ref(Z,-1)=-1 Click the graphic tab sselect a stop sign and color it blue click ok for those that want alerts just repeat the the instructions for the symbols but under the alert tab click ok and attach it to a chart


User Profile View All Posts by User View Thanks

henry1224		#3 Posted : Friday, June 23, 2006 11:38:14 PM(UTC)
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)		here are the two signals for the above expert Long exit factor:=2; offset:=0; HD:=ExtFml("PowerPivots.TDataCreate",1, factor); LD:=ExtFml("PowerPivots.TDataCreate",2, factor); A3:= {Alligator Blue Balance Line - Jaw} {13 bar smoothed average offset 8 bars} Ref(Wilders((HD+LD)/2,13),-8); A2:= {Alligator Red Balance Line - Teeth} {8 bar smoothed average offset 5 bars} Ref(Wilders((HD+LD)/2,8),-5); A1:= {Alligator Green Balance Line - Lip} {5 bar smoothed average offset 3 bars} Ref(Wilders((HD+LD)/2,5),-3); UCloud:=Max(A1,Max(A2,A3)); LCloud:=Min(A1,Min(A2,A3)); UCloud:=ExtFml("PowerPivots.TDataLocalize", UCloud, factor, offset); A3:=ExtFml("PowerPivots.TDataLocalize", A3, factor, offset); A2:=ExtFml("PowerPivots.TDataLocalize", A2, factor, offset); A1:=ExtFml("PowerPivots.TDataLocalize", A1, factor, offset); LCloud:=ExtFml("PowerPivots.TDataLocalize", LCloud, factor, offset); Z:=If(C>Ucloud,1,If(C<LCloud,-1,0)); Z=0 and ref(Z,-1)=1 short exit factor:=2; offset:=0; HD:=ExtFml("PowerPivots.TDataCreate",1, factor); LD:=ExtFml("PowerPivots.TDataCreate",2, factor); A3:= {Alligator Blue Balance Line - Jaw} {13 bar smoothed average offset 8 bars} Ref(Wilders((HD+LD)/2,13),-8); A2:= {Alligator Red Balance Line - Teeth} {8 bar smoothed average offset 5 bars} Ref(Wilders((HD+LD)/2,8),-5); A1:= {Alligator Green Balance Line - Lip} {5 bar smoothed average offset 3 bars} Ref(Wilders((HD+LD)/2,5),-3); UCloud:=Max(A1,Max(A2,A3)); LCloud:=Min(A1,Min(A2,A3)); UCloud:=ExtFml("PowerPivots.TDataLocalize", UCloud, factor, offset); A3:=ExtFml("PowerPivots.TDataLocalize", A3, factor, offset); A2:=ExtFml("PowerPivots.TDataLocalize", A2, factor, offset); A1:=ExtFml("PowerPivots.TDataLocalize", A1, factor, offset); LCloud:=ExtFml("PowerPivots.TDataLocalize", LCloud, factor, offset); Z:=If(C>Ucloud,1,If(C<LCloud,-1,0)); Z=0 and ref(Z,-1)=-1


User Profile View All Posts by User View Thanks

Keith Johnson		#4 Posted : Sunday, July 2, 2006 11:54:56 PM(UTC)
Rank: Newbie Groups: Registered, Registered Users, Subscribers Joined: 5/27/2006(UTC) Posts: 6		Thank you very much. I am trying to desifer all the components but its going to take a little effort. How would I then turn this into an explore/system tester?


User Profile View All Posts by User View Thanks

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.