Pivot Price from PowerPivots Plus Add-on
Here are a few indicators that will tell you where the pivots will change 

These should be used on Daily Charts 

Pivot Price Intermediate Last Value 

In:=Input("Instance",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; 

Pivot price Minor Last Value 

In:=Input("Instance",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; 

Pivot Price Major Last Value 

In:=Input("Instance",0,10,0); 
A1:=Cum(1); 
NP:=ROC(ExtFml("PowerPivots.BarsSinceNthPivot",3,In),1,$)<0; 
A2:=LastValue(A1-BarsSince(NP>0)); 
PP3:=If(A1<A2,BarsSince(A1>=A2),LastValue(ExtFml("PowerPivots.NthPivotPrice",3,In,1))); 
NP:=ROC(ExtFml("PowerPivots.BarsSinceNthPivot",-3,In),1,$)<0; 
A2:=LastValue(A1-BarsSince(NP>0)); 
PT3:=If(A1<A2,BarsSince(A1>=A2),LastValue(ExtFml("PowerPivots.NthPivotPrice",-3,In,1))); 
PP3;PT3;