Support Board
Date/Time: Tue, 04 Nov 2025 13:40:00 +0000
[Programming Help] - Need help on how to target last HIGH LOW volume of the last swing in a MGANN study i have.
View Count: 1069
|   [2022-02-03 05:29:56]     |  
| GravisHTG - Posts: 316 | 
| 
                See picture and the main things are [ID2.SG9] Wave Direction --- from 1 to 0 to -1 confirmation are 1 and -1 [ID2.SG15] Wave Total Volume [ID2.SG18] Wave Delta Volume So when this wave is Final ( becaues you need to wait for a certain amount of HH or LL ) I want to compare volume and delta to the last time it happen , how to do this ? I understand How to target the current Swing, but how to target the last one ? that is where i am clueless. Thanks in advance for the help Date Time Of Last Edit: 2022-02-03 05:56:02  
             | 
        
|          |  
|   [2022-02-03 17:25:54]     |  
| Sawtooth - Posts: 4285 | 
| 
                 I want to compare volume and delta to the last time it happen , how to do this ? 
You would need to use a spreadsheet study employing the concept in this example:Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values  | 
        
|   [2022-02-08 15:33:19]     |  
| User337568 - Posts: 64 | 
| 
                @Tomgilb 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? Thank you for any help, Tom  | 
        
|          |  
|   [2022-02-08 16:06:22]     |  
| Sawtooth - Posts: 4285 | 
| 
                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:10:54  
             | 
        
|   [2022-02-08 22:17:58]     |  
| GravisHTG - Posts: 316 | 
| 
                The second option is more accurate. The other problem I encounter now it the fact that it give fake signal ... And I still have to understand how to fix that.  | 
        
|   [2022-02-09 00:41:22]     |  
| User337568 - Posts: 64 | 
| 
                Gravis: Not a mind reader... what specifically do you mean by this statement: "The second option is more accurate." What is a "correct" signal as compared to the "fake signal?"  | 
        
To post a message in this thread, you need to log in with your Sierra Chart account:
