# Support Board

Date/Time: Sun, 26 May 2024 15:46:25 +0000

## Pivot Points Variable period Settings

### View Count: 868

 [2015-07-28 11:04:32] #1 JRA - Posts: 97 I am currently using the above study on a 1 min tf and set the period of the pivot on 30 min. Is there any setting that I can only plot the last 30 minutes pivot instead of the whole chart? I found a setting for how many days but not lower.
 [2015-07-28 11:20:29] #2 Sierra Chart Engineering - Posts: 104368 No, 1 Day is the minimum. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing
 [2015-07-28 11:33:49] #3 Sawtooth - Posts: 4010 You could accomplish this using the Spreadsheet Study study, where formulas would limit the display to the most current 30 min.
 [2015-07-28 12:52:26] #4 JRA - Posts: 97 Is there any tutorial how to use spreadsheet studies?
 [2015-07-28 13:24:30] #5 Sawtooth - Posts: 4010 Add the Spreadsheet Study study, give it a name in the Spreadsheet Name field. Use a formula in cell K3 like this: =IF(ROW()<33,AA3,0) where one of the pivot lines is in column AA, and where the Bar Period is 0-1-0 Repeat the formula in other Formula Columns L and above, referencing the columns of the lines you want to display. Study outputs are in columns AA and above, when the Number of Formula Columns in the spreadsheet study settings is set to the default 16. Each chart bar is a spreadsheet row, with the current bar in row 3. Earlier bars are in rows below. If you want all lines in the PP study, set the Number of Formula Columns to 30. Do this before you enter any formulas. Set all of the Draw Styles to Dash, and choose the colors. Check Hide Study on the PP study. Date Time Of Last Edit: 2015-07-28 14:17:11
 [2015-07-28 18:21:42] #6 Sierra Chart Engineering - Posts: 104368 Here is information about the Spreadsheet Study: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudy.html Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing