Support Board
Date/Time: Sun, 22 Dec 2024 04:06:45 +0000
Pivot Points Variable period Settings
View Count: 929
[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: 4141 |
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: 4141 |
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: