Reply To: Finding Potential Breakouts

[Darren]

You can also count how long it’s been since the last pivot and how far it is away, eg WOR is 0.39% from it’s last 10 week pivot high that occurred 19 weeks ago:

% from Pivot formula:

V1=PIVOT(MIN=10, TYPE=High); V2=VALUEWHEN(HIGH(), V1); C1=CLOSE(); (c1/v2)-1

1 2 3 4 5 6

V1=PIVOT(MIN=10, TYPE=High); V2=VALUEWHEN(HIGH(), V1); C1=CLOSE(); (c1/v2)-1

Time since pivot:

v1=PIVOT(MIN=10, TYPE=High); TIMESINCESIGNAL(v1)

1 2 3 4

v1=PIVOT(MIN=10, TYPE=High); TIMESINCESIGNAL(v1)

 

Workbook attached.