This spreadsheet study will calculate pivots based on the previous n periods, not just the previous period, and then roll them with each new single period.
Click on each of these links to download:
Dilernia nPeriod Rolling Pivots-.StdyCollct
Dilernia nPeriod Rolling Pivots.scss
and put both files in your Sierra Chart \Data folder, then click on Analysis >> Dilernia nPeriod Rolling Pivots-
-You can turn off the outer pivots by setting the Draw Styles to Hidden.
-This is a standalone study not requiring any other applied studies.
-This study uses SC’s pivot point Formula Type 7 formulas:
Sierra Chart - Pivot Point Formulas
-The nPeriod length is set in cell J2 on the spreadsheet.
-This study can be applied to any intraday or historical chart.
On an intraday chart, the nPeriod is in days.
On an historical chart, the nPeriod is in Historical Chart Bar Periods (Days, Weeks, Months, Quarters, Years).
This spreadsheet’s formulas are built on Sheet1, which corresponds to Chart #1. If you apply this study to a different chart number, you must copy the contents of cells J1&J2 on Sheet1 to cells J1&J2 of the corresponding Sheet#.