Support Board
Date/Time: Sun, 07 Dec 2025 13:56:25 +0000
[User Discussion] - zigzag study referencing turning points
View Count: 1720
| [2018-06-06 23:45:07] |
| User439550 - Posts: 12 |
|
I would like to compare current price with past Highs and Lows, and past highs with highs before and lows with lows before. How do I reference these turning points? I appreciate if someone point me to the right direction. Thanks... |
| [2018-06-07 00:38:05] |
| Sawtooth - Posts: 4295 |
|
You can do it with a spreadsheet study. Here are some example formulas: Spreadsheet Example Formulas and Usage: Other Examples |
| [2018-06-07 01:08:59] |
| User439550 - Posts: 12 |
|
Thank you Tomgilb, I am aware of the example formulas, as a newbie to spreadsheet formulas ( I mostly do my work with "color bar based on alert condition" study) how ever I could not figure out how to reference previous Higher high to a higher high before that, for example, any leads on that direction?
|
| [2018-06-07 02:11:53] |
| Sawtooth - Posts: 4295 |
|
It's not possible to reference previous Zigzag swing highs and lows with Simple Alert formulas. To do it with a spreadsheet study, you'd need a formula for each previous high and low, so the number of previous legs you could reference would be limited. |
| [2018-06-07 02:43:08] |
| Acro - Posts: 454 |
|
If you don't want to see the exact values you can also use the swing high and low study. That study can draw you a line at each swing point along with some arrows etc |
To post a message in this thread, you need to log in with your Sierra Chart account: