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

Notification

Icon
Error
Setting Up Power Pivot Expert Advisurs - Setting Up Power Pivot Expert Advisurs
Options
Go to last post Go to first unread
Previous Topic Next Topic
Keith Johnson  
#1 Posted : Thursday, June 22, 2006 4:16:07 AM(UTC)
Keith Johnson

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? :(
Back to top

Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
Back to top  
henry1224  
#2 Posted : Thursday, June 22, 2006 10:37:17 PM(UTC)
henry1224

Rank: Advanced Member

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

Was thanked: 3 time(s) in 3 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
Back to top
henry1224  
#3 Posted : Friday, June 23, 2006 11:38:14 PM(UTC)
henry1224

Rank: Advanced Member

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

Was thanked: 3 time(s) in 3 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
Back to top
Keith Johnson  
#4 Posted : Sunday, July 2, 2006 11:54:56 PM(UTC)
Keith Johnson

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?
Back to top
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.

Powered by YAF.NET | YAF.NET © 2003-2026, Yet Another Forum.NET