Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Fri, 29 Nov 2024 16:39:19 +0000

[User Discussion] - Levels based on Zig Zag indicator

View Count: 464

[Page 1 of 1] First Page -- 1 -- Last Page

[2023-01-31 12:53:30] #1 [Go To First Post]
User661335 - Posts: 6
Hi I want to create an alert condition or something similar with a Zig Zag indicator So lets say I have a Z High that formed at 1 000, I just want to have a single line (not extended) above and below the candle for 1% above and 1% below. IE Line above 1 000 + 1 000x0.01 = 1 010 Line Below 1 000 - 1 000x0.01 = 990 Have been trying to do this with the alert conditions but not really successful, if you could point me in the right direction, I would appreciate it. Thanks
1x Thank you

[2023-01-31 16:19:37] #2 [Go To First Post]
John - SC Support - Posts: 36350
It would be easiest to do this with the Spreadsheet Study. Just be sure on the Zig Zag study to set the Input for Additional Output for Spreadsheets to Yes so you can get the Reversal Prices, which would be what you want to use. Refer to the following: Zig Zag: Additional Output for Spreadsheets You would then use the Spreadsheet function of MOSTRECENTNONZEROVALUE() to get the point of reversal and then use two other columns to add/subtract 1% from that value to give you your lines. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MOSTRECENTNONZEROVALUE_Function For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing
2x Thank you

[2023-01-31 20:55:15] #3 [Go To First Post]
User661335 - Posts: 6
Worked like a charm thank you John I substituted the formula for MOSTRECENTNONZEROVALUE() with "=AJ3", so I can have a bit more of a look back as well and added other increments (0.25%/0.5%)
1x Thank you
Attachment Deleted. Zig Zag.JPG / V - Attached On 2023-01-31 20:53:44 UTC - Size: 102.37 KB - 93 views

[2023-02-01 15:45:00] #4 [Go To First Post]
John - SC Support - Posts: 36350
Glad it worked for you. Just so others are aware, by using AJ3 you get the dashes just at the location of the bar where the Zig Zag occurs. Using the MOSTRECENTNONZEROVALUE would give you a line that extends between the zig zag locations. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing
2x Thank you

[Page 1 of 1] First Page -- 1 -- Last Page