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

Notification

Icon
Error
Power Pivots Plus - Power Pivots Plus
Options
Go to last post Go to first unread
Previous Topic Next Topic
EPHESUS1  
#1 Posted : Thursday, December 8, 2011 3:01:27 PM(UTC)
EPHESUS1

Rank: Newbie

Groups: Registered, Registered Users
Joined: 12/8/2011(UTC)
Posts: 2
Hi, Not new to Metastock, but not a programmer. Have no skills in this area. Have PowerPivot Plus add-on Page 65-67 of accompanying manual provide a list of external formulas. Would like to write an Exploration that would highlight when the following pivots occur: Primary Hi, Primart Lo, Major Hi, Major Lo. Are there any kind Samaritans who could provide me with the answer. Thanking you in anticipation for your time & effort EPHESUS1
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, December 8, 2011 5:50:49 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)
Pivots

a:=ExtFml("PowerPivots.Pivots");
D:=If(A=4,4,If(A=3,3,If(A=2,2,If(A=1,1,If(A=-4,-4,If(A=-3,-3,If(A=-2,-2,If(A=-1,-1,0))))))));
D

This will Plot the pivots when they happen.
Pivots are dynamic and subject to change
Back to top
henry1224  
#3 Posted : Thursday, December 8, 2011 5:55:47 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)
here is an indicator Cycle 4,8,16,32,64 Comb w TDC

TF:=Input("Time frame 1",1,100,1);
Off:=Input("Offset",0,100,0);
HD:= ExtFml("PowerPivots.TDataCreate",1,TF);
LD:= ExtFml("PowerPivots.TDataCreate",2,TF) ;
CD:= ExtFml("PowerPivots.TDataCreate",3,TF) ;
P0:=Mov(((CD-LLV(LD,4))/(HHV(HD,4)-LLV(LD,4)))*100,3,E);
P1:=Mov(((CD-LLV(LD,8))/(HHV(HD,8)-LLV(LD,8)))*100,3,E);
P2:=Mov(((CD-LLV(LD,16))/(HHV(HD,16)-LLV(LD,16)))*100,3,E);
P3:=Mov(((CD-LLV(LD,32))/(HHV(HD,32)-LLV(LD,32)))*100,3,E);
P4:=Mov(((CD-LLV(LD,64))/(HHV(HD,64)-LLV(LD,64)))*100,3,E);
A0:=Mov(((P0-LLV(P0,4))/(HHV(P0,4)-LLV(P0,4)))*100,3,E);
A1:=Mov(((P1-LLV(P1,8))/(HHV(P1,8)-LLV(P1,8)))*100,3,E);
A2:=Mov(((P2-LLV(P2,16))/(HHV(P2,16)-LLV(P2,16)))*100,3,E);
A3:=Mov(((P3-LLV(P3,32))/(HHV(P3,32)-LLV(P3,32)))*100,3,E);
A4:=Mov(((P4-LLV(P4,64))/(HHV(P4,64)-LLV(P4,64)))*100,3,E);
AC:=Mov(Mov((A0+A1*2+A2*3+A3*4+A4*5)/15,2,S),2,S);
UZ:=Mov(AC,34,S)+(1.3185*Stdev(AC,34));
LZ:=Mov(AC,34,S)-(1.3185*Stdev(AC,34));
AC2:=Mov(AC,4,S);
AC2:=ExtFml( "PowerPivots.TDataLocalize", AC2, TF, Off);
UZ:=ExtFml( "PowerPivots.TDataLocalize", UZ, TF, Off);
LZ:=ExtFml( "PowerPivots.TDataLocalize", LZ, TF, Off);
AC:=ExtFml( "PowerPivots.TDataLocalize", AC, TF, Off);
95;50;5;
AC;AC2;UZ;LZ;


This allows you to change the time frame of the indicator to plot a weekly indicator onto a daily chart
Back to top
henry1224  
#4 Posted : Thursday, December 8, 2011 5:58:59 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)
an indicator for trend identification
PP+ Trend 5C>105ma w TDC

TF:=Input("Time frame",1,100,1);
Off:=Input("Offset",0,100,0);
Type:=Input("1=MP,2=Typ,3=(O+H+L+C)/4,4=(O+H+L+(2*C))/5,5=C",1,5,5);
OD:= ExtFml("PowerPivots.TDataCreate",0,TF);
HD:= ExtFml("PowerPivots.TDataCreate",1,TF);
LD:= ExtFml("PowerPivots.TDataCreate",2,TF) ;
CD:= ExtFml("PowerPivots.TDataCreate",3,TF) ;
Type2:=If(Type=1,(HD+LD)/2,If(Type=2,(HD+LD+CD)/3,If(Type=3,(OD+HD+LD+CD)/4,If(Type=4,(OD+HD+LD+(2*CD))/5,CD))));
A:=If(Sum(Type2>Mov(Type2,105,S),5)>4,1,If(Sum(Type2<Mov(Type2,105,S),5)>4,-1,0));
UPTrend:=If(A=1,1,0);
DnTrend:=If(A=-1,-1,0);
UPTrend:=ExtFml( "PowerPivots.TDataLocalize", UPTrend, TF, Off);
DnTrend:=ExtFml( "PowerPivots.TDataLocalize", DnTrend, TF, Off);

UpTrend;DnTrend;
Back to top
henry1224  
#5 Posted : Thursday, December 8, 2011 6:08:12 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)
PP+ Trend Direction 1,2

A2:= ExtFml("PowerPivots.TrendDirection",1,2);
TR:=If(Sum(A2>0,2)>1,1,If(Sum(A2<0,2)>1,-1,0));
Green:=If(Tr=1,1,0);
Red:=If(TR=-1,-1,0);
Green;Red;
Back to top
henry1224  
#6 Posted : Thursday, December 8, 2011 6:20:59 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)
PP+ Time Capsules

TF:=Input("TFactor",1, 1000, 3);
OF:=Input("Offset", -100, 100, 0);
Plot:=Input("Plot 1=odd 2= even 3= both",1,3,3);
TCH:=ExtFml("PowerPivots.TimeCapsules",H,TF,OF);
TCL:=ExtFml("PowerPivots.TimeCapsules",L,TF,OF);
RNG:=TCH-TCL;
78R:=If(plot<>2,Rng*.875+TCL,TCH);
68R:=If(plot<>1,Rng*.75+TCL,TCH);
58R:=If(plot<>2,Rng*.625+TCL,TCH);
48R:=If(plot<>1,Rng*.5+TCL,TCH);
38R:=If(plot<>2,Rng*.375+TCL,TCH);
28R:=If(plot<>1,Rng*.25+TCL,TCH);
18R:=If(plot<>2,Rng*.125+TCL,TCH);
TCH;78R;68R;58R;48R;38R;28R;18R;TCL;
Back to top
henry1224  
#7 Posted : Thursday, December 8, 2011 6:31:24 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)
Pivot Price Intermediate Last Value

In:=Input("Instance back",0,10,0);
A1:=Cum(1);
NP:=ROC(ExtFml("PowerPivots.BarsSinceNthPivot",2,In),1,$)<0;
A2:=LastValue(A1-BarsSince(NP>0));
PP2:=If(A1<A2,BarsSince(A1>=A2),LastValue(ExtFml("PowerPivots.NthPivotPrice",2,In,1)));
NP:=ROC(ExtFml("PowerPivots.BarsSinceNthPivot",-2,In),1,$)<0;
A2:=LastValue(A1-BarsSince(NP>0));
PT2:=If(A1<A2,BarsSince(A1>=A2),LastValue(ExtFml("PowerPivots.NthPivotPrice",-2,In,1)));
PP2;PT2;
Back to top
henry1224  
#8 Posted : Thursday, December 8, 2011 6:33:48 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)
Pivot Price Minor Last value

In:=Input("Instance back",0,10,0);
NP:=ROC(ExtFml("PowerPivots.BarsSinceNthPivot",1,In),1,$)<0;
A1:=Cum(1);
A2:=LastValue(A1-BarsSince(NP>0));
PP1:=If(A1<A2,BarsSince(A1>=A2),LastValue(ExtFml("PowerPivots.NthPivotPrice",1,In,1)));
NP:=ROC(ExtFml("PowerPivots.BarsSinceNthPivot",-1,In),1,$)<0;
A1:=Cum(1);
A2:=LastValue(A1-BarsSince(NP>0));
PT1:=If(A1<A2,BarsSince(A1>=A2),LastValue(ExtFml("PowerPivots.NthPivotPrice",-1,In,1)));
PP1;PT1;
Back to top
henry1224  
#9 Posted : Thursday, December 8, 2011 6:37:48 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)
Pivot Trading Range in 1/8's

i1:=Input("Pivot (1=Minor 2=Interm 3=Major 4=Primary)",1,4,2);
i2:=Input("Trend Direction",1,4,1);
aPivots:= ExtFml("PowerPivots.Pivots");
aTrend:= ExtFml("PowerPivots.TrendDirection",i1,i2);
ExtFml("PowerPivots.RetInd",0,aPivots,aTrend,i1,0);
ExtFml("PowerPivots.RetInd",0,aPivots,aTrend,i1,.125);
ExtFml("PowerPivots.RetInd",0,aPivots,aTrend,i1,.25);
ExtFml("PowerPivots.RetInd",0,aPivots,aTrend,i1,.375);
ExtFml("PowerPivots.RetInd",0,aPivots,aTrend,i1,.5); ExtFml("PowerPivots.RetInd",0,aPivots,aTrend,i1,.625);
ExtFml("PowerPivots.RetInd",0,aPivots,aTrend,i1,.75);
ExtFml("PowerPivots.RetInd",0,aPivots,aTrend,i1,.875);
ExtFml("PowerPivots.RetInd",1,aPivots,aTrend,i1,.875);
ExtFml("PowerPivots.RetInd",2,aPivots,aTrend,i1,.875);
ExtFml("PowerPivots.RetInd",0,aPivots,aTrend,i1,1);
Back to top
henry1224  
#10 Posted : Thursday, December 8, 2011 6:43:48 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)
Pitch Last Value

Piv:=Input("1=Minor 2=Intermediate 3=Major 4=Primary",1,4,2);
A:=If(BarsSince(ExtFml("PowerPivots.Pivots")=Piv)< BarsSince(ExtFml("PowerPivots.Pivots")=-Piv),1,0);
BSC:=If(A=1,ExtFml("PowerPivots.BarsSinceNthPivot",Piv,0),
ExtFml("PowerPivots.BarsSinceNthPivot",-Piv,0));
BSB:= If(A=1,ExtFml("PowerPivots.BarsSinceNthPivot",-Piv,0),
ExtFml("PowerPivots.BarsSinceNthPivot",Piv,0));
BSA:= If(A=1,ExtFml("PowerPivots.BarsSinceNthPivot",Piv,1),
ExtFml("PowerPivots.BarsSinceNthPivot",-Piv,1));
CP:=If(A=1,ValueWhen(1,ExtFml("PowerPivots.Pivots")= Piv,H), ValueWhen(1,ExtFml("PowerPivots.Pivots")=-Piv,L));
BP:=If(A=1,ValueWhen(1,ExtFml("PowerPivots.Pivots")= -Piv,L), ValueWhen(1,ExtFml("PowerPivots.Pivots")=Piv,H));
AP:= If(A=1,ValueWhen(2,ExtFml("PowerPivots.Pivots")= Piv,H), ValueWhen(2,ExtFml("PowerPivots.Pivots")=-Piv,L));
B:=LastValue(Cum(1)-BSC);
ML:= If(Cum(1)<B,BarsSince(Cum(1)>=B),If(((((.5*CP)+(.5*BP))-AP)/((.5*(BSA-BSC))+(.5*(BSA-BSB))-0)*BSA)+AP>0,((((.5*CP)+(.5*BP))-AP)/((.5*(BSA-BSC))+(.5*(BSA-BSB))-0)*BSA)+AP,AP));
BL:= If(Cum(1)<B,BarsSince(Cum(1)>=B),If(A=1, ML-Abs((BP-CP)/2), ML+Abs((BP-CP)/2)));
CL:= If(Cum(1)<B,BarsSince(Cum(1)>=B),If(A=1,ML+Abs((BP-CP)/2), ML-Abs((BP-CP)/2)));
382P:= If(Cum(1)<B,BarsSince(Cum(1)>=B),If(A=1, ML-Abs((BP-CP)/2)*.382, ML+Abs((BP-CP)/2)*.382));
618P:= If(Cum(1)<B,BarsSince(Cum(1)>=B),If(A=1, ML-Abs((BP-CP)/2)*.618, ML+Abs((BP-CP)/2)*.618));
1618P:= If(Cum(1)<B,BarsSince(Cum(1)>=B),If(A=1, ML-Abs((BP-CP)/2)*1.618, ML+Abs((BP-CP)/2)*1.618));
382M:= If(Cum(1)<B,BarsSince(Cum(1)>=B),If(A=1, ML-Abs((BP-CP)/2)*-.382, ML+Abs((BP-CP)/2)*-.382));
618M:= If(Cum(1)<B,BarsSince(Cum(1)>=B),If(A=1, ML-Abs((BP-CP)/2)*-.618, ML+Abs((BP-CP)/2)*-.618));
1618M:= If(Cum(1)<B,BarsSince(Cum(1)>=B),If(A=1, ML-Abs((BP-CP)/2)*-1.618, ML+Abs((BP-CP)/2)*-1.618));

382P;618P;1618P;BL;ML;CL;382M;618M;1618M;
Back to top
henry1224  
#11 Posted : Thursday, December 8, 2011 6:55:43 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)
Major Trendlines F 3 Pivots

FT := LastValue( ExtFml("Powerpivots.NthPivotPrice",-3,0,1));
ST := LastValue( ExtFml("Powerpivots.NthPivotPrice",-3,1,1));
TT := LastValue( ExtFml("Powerpivots.NthPivotPrice",-3,2,1));
FPK := LastValue( ExtFml("Powerpivots.NthPivotPrice",3,0,1));
SPK := LastValue( ExtFml("Powerpivots.NthPivotPrice",3,1,1));
TPK := LastValue( ExtFml("Powerpivots.NthPivotPrice",3,2,1));
DV := FT - TT;
DH := LastValue(ExtFml("Powerpivots.BarsSinceNthPivot",-3,2)) -
LastValue(ExtFml("Powerpivots.BarsSinceNthPivot",-3,0));
DeltaPerBar := DV / DH;
BNST := LastValue(
Cum(1) - ExtFml("Powerpivots.BarsSinceNthPivot",-3,2));
Trend := If(Cum(1) < BNST,BarsSince(Cum(1) >= BNST),
TT + (DeltaPerBar * (Cum(1) - BNST)));
UpT:=If(FT >= TT, Trend, BarsSince(FT >= TT));
DV := FPK - TPK;
DH := LastValue(ExtFml("Powerpivots.BarsSinceNthPivot",3,2)) -
LastValue(ExtFml("Powerpivots.BarsSinceNthPivot",3,0));
DeltaPerBar := DV / DH;
BNST := LastValue(
Cum(1) - ExtFml("Powerpivots.BarsSinceNthPivot",3,2));
Trend := If(Cum(1) < BNST,BarsSince(Cum(1) >= BNST),
TPK + (DeltaPerBar * (Cum(1) - BNST)));
UpP:=If(FPK >= TPK, Trend, BarsSince(FPK >= TPK));
DV := FPK - TPK;
DH := LastValue(ExtFml("Powerpivots.BarsSinceNthPivot",3,2)) -
LastValue(ExtFml("Powerpivots.BarsSinceNthPivot",3,0));
DeltaPerBar := DV / DH;
BNST := LastValue(
Cum(1) - ExtFml("Powerpivots.BarsSinceNthPivot",3,2));
Trend := If(Cum(1) < BNST,BarsSince(Cum(1) >= BNST),
TPK +(DeltaPerBar * (Cum(1) - BNST)));
DnP:=If(FPK <= TPK, Trend,BarsSince(FPK <= TPK));
DV := FT - TT;
DH := LastValue(ExtFml("Powerpivots.BarsSinceNthPivot",-3,2)) -
LastValue(ExtFml("Powerpivots.BarsSinceNthPivot",-3,0));
DeltaPerBar := DV / DH;
BNST := LastValue(
Cum(1) - ExtFml("Powerpivots.BarsSinceNthPivot",-3,2));
Trend := If(Cum(1) < BNST,BarsSince(Cum(1) >= BNST),
TT +(DeltaPerBar * (Cum(1) - BNST)));
DnT:=If(FT <= TT, Trend,BarsSince(FT <= TT));

UPT;UPP;DnP;DnT;
Back to top
henry1224  
#12 Posted : Thursday, December 8, 2011 6:59:50 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)
Jackson Zones Last Value

Pt:=Input("P 1=minor 2=intermediate 3=major 4=primary",1,4,2);
NW:=If(ExtFml("Powerpivots.BarsSinceNthPivot",PT,0)< ExtFml("Powerpivots.BarsSinceNthPivot",-PT,0),
ROC(ExtFml("Powerpivots.BarsSinceNthPivot",PT,0),1,$)<0, ROC(ExtFml("Powerpivots.BarsSinceNthPivot",-PT,0),1,$)<0);
A1:=Cum(1);
A2:=LastValue(A1-BarsSince(NW>0));
WH:=ValueWhen(1,Nw, ExtFml("Powerpivots.NthPivotPrice",Pt,0,1));
WL:=ValueWhen(1,Nw, ExtFml("Powerpivots.NthPivotPrice",-Pt,0,1));
WCL:=ValueWhen(1,Nw,Ref(C,-1));
BP:=LastValue((WH+WL+WCL)/3);
RB2:=If(A1<A2,BarsSince(A1>=A2),LastValue(((WH-WL)*1.382)+BP));
D1:=If(A1<A2,BarsSince(A1>=A2),LastValue((WH-WL)+BP));
RB1:=If(A1<A2,BarsSince(A1>=A2),LastValue(((WH-WL)*.618)+BP));
D:=If(A1<A2,BarsSince(A1>=A2),LastValue(((WH-WL)/2)+BP));
MBP:=If(A1<A2,BarsSince(A1>=A2),LastValue((WH+WL+WCL)/3));
B:=If(A1<A2,BarsSince(A1>=A2),LastValue(BP-((WH-WL)/2)));
SB1:=If(A1<A2,BarsSince(A1>=A2),LastValue(BP-((WH-WL)*.618)));
B1:=If(A1<A2,BarsSince(A1>=A2),LastValue(BP-(WH-WL)));
SB2:=If(A1<A2,BarsSince(A1>=A2), LastValue(BP-((WH-WL)*1.382)));
RB2;D1;RB1;D;MBP;B;SB1;B1;SB2;
Back to top
jjstein  
#13 Posted : Thursday, December 8, 2011 6:59:58 PM(UTC)
jjstein

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA

Was thanked: 1 time(s) in 1 post(s)
Henry -- Um, I get the impression you're hot on PowerPivots, yes?
Back to top
henry1224  
#14 Posted : Thursday, December 8, 2011 7:06:51 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)
Fibonacci Ladder

i:=Input("Lookback Period", 10, 1000, 300);

ExtFml("PowerPivots.FibLadder",-2,i);
ExtFml("PowerPivots.FibLadder",-1,i);
ExtFml("PowerPivots.FibLadder",0,i);
ExtFml("PowerPivots.FibLadder",1,i);
ExtFml("PowerPivots.FibLadder",2,i);
ExtFml("PowerPivots.FibLadder",3,i);
ExtFml("PowerPivots.FibLadder",4,i);
ExtFml("PowerPivots.FibLadder",5,i);
ExtFml("PowerPivots.FibLadder",6,i);
ExtFml("PowerPivots.FibLadder",7,i);
ExtFml("PowerPivots.FibLadder",8,i);
ExtFml("PowerPivots.FibLadder",9,i);
ExtFml("PowerPivots.FibLadder",10,i);
Back to top
henry1224  
#15 Posted : Thursday, December 8, 2011 7:10:05 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)
Johnathan,

I have been playing around with them since they were first released.

The problem with this add-on is that there is very little documentation on how to use the external formulas
Back to top
henry1224  
#16 Posted : Thursday, December 8, 2011 7:12:13 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)
here's a link to more formulas

http://forum.equis.com/files/3015/metastock_files/entry19667.aspx
Back to top
EPHESUS1  
#17 Posted : Tuesday, December 13, 2011 7:46:57 AM(UTC)
EPHESUS1

Rank: Newbie

Groups: Registered, Registered Users
Joined: 12/8/2011(UTC)
Posts: 2
Hi Henry1224, Thanks for your response & thanks also to all others who responded. Overwhelmed by responses Thanks to all EPHESUS1
Back to top
henry1224  
#18 Posted : Thursday, December 29, 2011 5:17:31 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)
Pivot Trading Range in Fib

Piv:=Input("Pivot (1=Minor 2=Interm 3=Major 4=Primary)",1,4,2);
TF:=Input("TFactor",1,4,1);
PPs:= ExtFml("PowerPivots.Pivots");
TD:= ExtFml("PowerPivots.TrendDirection",Piv,TF);
TD:=If(Sum(TD=1,2)>1,1,If(Sum(TD=-1,2)>1,-1,0));
ExtFml("PowerPivots.RetInd",0,PPs,TD,Piv,0);
ExtFml("PowerPivots.RetInd",0,PPs,TD,Piv,.25);
ExtFml("PowerPivots.RetInd",0,PPs,TD,Piv,.382);
ExtFml("PowerPivots.RetInd",0,PPs,TD,Piv,.5);
ExtFml("PowerPivots.RetInd",0,PPs,TD,Piv,.618);
ExtFml("PowerPivots.RetInd",0,PPs,TD,Piv,1);
ExtFml("PowerPivots.RetInd",0,PPs,TD,Piv,1.382);
ExtFml("PowerPivots.RetInd",0,PPs,TD,Piv,1.618);
ExtFml("PowerPivots.RetInd",1,PPs,TD,Piv,1);
ExtFml("PowerPivots.RetInd",2,PPs,TD,Piv,1);
Back to top
henry1224  
#19 Posted : Tuesday, February 19, 2013 6:10:10 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)
All of the indicators in My PowerPivot+ toolkit require the PowerPivot Plus Add-on from Equis
Back to top
Users browsing this topic
Guest (Hidden)
Similar Topics
Price Expansions (EXP) Using Power Pivots Plus (Formula Assistance)
by Derek Worswick 6/29/2011 3:02:12 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.

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