Login Page - Create Account

Support Board


Date/Time: Thu, 06 Mar 2025 18:50:52 +0000



Post From: Swing High Low - Accessing Subgraph values

[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