Optuma Forums › Optuma Scripting › Finding Potential Breakouts › Reply To: Finding Potential Breakouts
July 5, 2019 at 9:15 pm
#53945
- Topics: 70
- Replies: 790
- Posts: 860
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:
1 2 3 4 5 6 |
V1=PIVOT(MIN=10, TYPE=High); V2=VALUEWHEN(HIGH(), V1); C1=CLOSE(); (c1/v2)-1 |
Time since pivot:
1 2 3 4 |
v1=PIVOT(MIN=10, TYPE=High); TIMESINCESIGNAL(v1) |
Workbook attached.