Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 09:35:55 +0000



Pivot Points Variable period Settings

View Count: 848

[2015-07-28 11:04:32]
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]
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]
Sawtooth - Posts: 3952
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]
JRA - Posts: 97
Is there any tutorial how to use spreadsheet studies?
[2015-07-28 13:24:30]
Sawtooth - Posts: 3952
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]
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

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account