Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 13:03:07 +0000



Post From: Pivot Points Variable period Settings

[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