Support Board
Date/Time: Fri, 28 Feb 2025 22:32:38 +0000
Zig Zag Reversal Price
View Count: 1022
| [2021-08-27 22:43:20] |
| User195924 - Posts: 68 |
|
Hi, I would like to understand how I could reference the most recent Zig Zag Reversal prices. The most recent reversal high and most recent reversal low into other studies, specifically the horizontal lines study or study subgraph multiply study. And I just want to be able to reference only 2 prices (recent high and recent low from zig zag reversal). Thanks
Date Time Of Last Edit: 2021-08-28 03:36:31
|
| [2021-08-28 14:38:52] |
| John - SC Support - Posts: 38292 |
|
You would need to use the Spreadsheet Study to do this and set the Input on the Zig Zag study for Additional Outputs for Spreadsheets to Yes. Refer to the following: Zig Zag Then you can access the information you want from the spreadsheet study. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2021-08-28 14:39:23
|
| [2021-08-29 18:39:50] |
| User195924 - Posts: 68 |
|
Got it but how do I filter the zeros out as shown in the attachment and be able to reference only AC row 3 and row 4 in other studies when they change as zig zag changes?
|
 ZigZagReversal.PNG / V - Attached On 2021-08-29 18:37:46 UTC - Size: 13.62 KB - 228 views |
| [2021-08-30 00:59:04] |
| Sawtooth - Posts: 4177 |
|
how do I filter the zeros out as shown in the attachment and be able to reference only AC row 3 and row 4
You'd have to use this method:Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values |
| [2021-08-30 01:47:00] |
| User195924 - Posts: 68 |
|
Thank you for that, its helpful but one more condition I'd like to add to this is that I only the most recent LH/HH and HL/LL as the most recent 2 values... how do I add the text label into this these formulas?
|
| [2021-08-30 02:42:05] |
| Sawtooth - Posts: 4177 |
|
I only want the most recent LH/HH and HL/LL as the most recent 2 values... how do I add the text label into this these formulas?
In the example at the link in post #4, the two most recent values are in O3 and P3, which are SG5 and SG6 of the spreadsheet study.-Set the spreadsheet study to Region 1. -Set the Draw Style of SG5 and SG6 to Dash. -Set the colors of SG5 and SG6 to the same color. -Checkmark the Value Label of SG5 and SG6. |
| [2021-08-30 04:25:45] |
| User195924 - Posts: 68 |
|
Thanks, but I don't believe that's what I'm looking for: I would like most recent high reversal when it's HH/HL and most recent low reversal when it's LL/LH. I just need to be able to incorporate additional condition into these formulas where text labels OR(ID1.SG2=1, ID1.SG2=2) return most recent High Reversal Price.... : Cell O3: =IF(ID1.SG3@3 > 0, ID1.SG1@3, O4) This sets cell O3 to the Price of the most recent Zig Zag reversal point. Cell P3: =IF(ID1.SG3@3 > 0, O4, P4) This sets cell P3 to the Price of the second most recent Zig Zag reversal point. Cell Q3: =IF(ID1.SG3@3 > 0, P4, Q4) Date Time Of Last Edit: 2021-08-30 04:26:02
|
| [2021-08-31 01:21:44] |
| Sawtooth - Posts: 4177 |
|
In the example formulas at the link in post #4, the LH/HH, HL/LL will each become the current alternately. O3 is always the current. Do you want to know which of the 4 text labels it is? 'Most recent' is not necessarily the current. Text labels 1 and 2 are LH and HH, respectively. HH/HL is 2/3, LL/LH is 4/1. Zig Zag: Text Labels Subgraph Description It's not clear what you want. Please explain further. Date Time Of Last Edit: 2021-08-31 01:36:01
|
| [2021-08-31 03:23:12] |
| User195924 - Posts: 68 |
|
Yes, that formula will return LH/HH, HL/LL as current as the reversal price updates, but problem with the formulas at the link in the post #4 it will return current LH/HH, HL/LL as first or second. I simply want one cell to have current LH/HH reversal price and another cell with current LL/HL reversal price. On the attached screen shot, I would like one cell to have 4534.5 as current whether it is HH or HL and another cell to have 4347.75 as current whether it is HL or LL. Does that help? Date Time Of Last Edit: 2021-08-31 13:31:46
|
| Reversal Prices.PNG / V - Attached On 2021-08-31 03:22:10 UTC - Size: 7.11 KB - 168 views |
| [2021-09-01 00:43:22] |
| Sawtooth - Posts: 4177 |
|
I simply want one cell to have current LH/HH reversal price and another cell with current LL/HL reversal price.
O3 is the current reversal price and P3 is the previous reversal price. These are the two values you want, except that they alternate columns at each reversal. To find the LH/HH in either O3 or P3, use this in Q3: =MAX(O3,P3) To find the LL/HL in either O3 or P3, use this in R3: =MIN(O3,P3) This works because the LH/HH pair is always greater than the LL/HL pair. If you paired them differently, it becomes more complicated. |
| [2021-09-01 01:11:13] |
| User195924 - Posts: 68 |
|
Ahh, that's exactly what I needed.. just a simple solution. thank you so much!
|
To post a message in this thread, you need to log in with your Sierra Chart account: