Support Board
Date/Time: Wed, 05 Feb 2025 03:57:58 +0000
[Programming Help] - Calculate the difference between swings
View Count: 935
| [2020-02-28 10:26:30] |
| grantx - Posts: 244 |
|
Zig Zag study prints the size of the swings. How would I get the difference between the current swing high and the last swing high? for example: In the picture: I would like to know the difference between point 2 and point 1. I would like to know the difference between point 4 and point 3. etc.. |
1.png| [2020-02-28 13:28:33] |
| Sawtooth - Posts: 4167 |
|
Use this method: Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values |
| [2020-02-28 14:34:29] |
| grantx - Posts: 244 |
|
tomgilb that works great. But it appears to be only reporting on the up swings and not the down swings. So it skips the lower swing sizes and only reports 2 back. If you get what I mean? I posted a pic. Date Time Of Last Edit: 2020-02-28 14:36:18
|
| [2020-02-28 14:46:13] |
| Sawtooth - Posts: 4167 |
|
it appears to be only reporting on the up swings and not the down swings
The example formulas return every reversal price, alternating both highs and lows.It works for me, not sure what you're doing. Date Time Of Last Edit: 2020-02-28 14:51:43
|
| [2020-02-28 15:10:16] |
| grantx - Posts: 244 |
|
What does the @3 part mean?
|
| [2020-02-28 15:19:39] |
| Sawtooth - Posts: 4167 |
|
It refers to row 3. Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study Date Time Of Last Edit: 2020-02-28 15:44:44
|
To post a message in this thread, you need to log in with your Sierra Chart account: