Login Page - Create Account

Support Board


Date/Time: Thu, 06 Mar 2025 18:56:20 +0000



[User Discussion] - Swing High Low - Accessing Subgraph values

View Count: 946

[2022-02-08 15:55:32]
User337568 - Posts: 61
Goal - tracking pivot polarity changes using a pivot script.

The Swing High/Low script does not allow me to access the subgraph values.
Everything is 0

I want to be alerted about the relative Swing high/low to the previous high/low.

Is this Swing High higher or lower than 1 ago?
Is this Swing Low higher or lower than 1 ago?

Search results:
I did find this post regarding holding a value in an array:
How to find all values of an sc.Subgraph[] array that are above a given value?
imageSwing High Low vs 1 ago SC.jpg / V - Attached On 2022-02-08 15:54:16 UTC - Size: 184.31 KB - 163 views
Attachment Deleted.
[2022-02-08 16:11:45]
Sawtooth - Posts: 4181
The Swing High and Low study outputs a price at every marker, but not at every bar.

Add the Spreadsheet System/Alert study, and look in column AA or higher to see the study's output.

Use this spreadsheet study to compare the volume at each Swing H.
Use formulas like these:
Cell O3:
=IF(ID1.SG1@3 > 0, F3, O4)
Cell P3:
=IF(ID1.SG1@3 > 0, O4, P4)
where ID1 is the Swing High And Low study.

The volume at the most recent Swing H is in O3, and the volume at the previous Swing H is in P3.
Use K3 to N3 for your comparison alert formulas.

The above is a variation of the example here:
Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values
Date Time Of Last Edit: 2022-02-08 16:12:12
[2022-02-08 16:27:46]
User337568 - Posts: 61
Tom:

Thank you and, I want the subgraph value and not the volume.

Hopefully, this makes sense.
[2022-02-08 17:26:44]
Sawtooth - Posts: 4181
I want the subgraph value and not the volume.
Then use formulas like these:
Cell O3:
=IF(ID1.SG1@3 > 0, ID1.SG1@3, O4)
Cell P3:
=IF(ID1.SG1@3 > 0, O4, P4)
where ID1 is the Swing High And Low study.

You can use this example to return any value.

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

Login

Login Page - Create Account