Login Page - Create Account

Support Board


Date/Time: Sun, 05 May 2024 18:48:21 +0000



Post From: How to Refer to Zigzag Previous Leg Mid line?

[2017-02-28 01:32:39]
Sawtooth - Posts: 3993
It would take various formulas in several columns, depending on what you want. Attached is an example.

-Put both attached files in your Sierra Chart \Data folder.
-Move your existing Zig Zag study to the top of the Studies to Graph list.
-In your Zig Zag study's settings, set 'Additional Output for Spreadsheets' to Yes.
-Go to Analysis >> ZZ mid line alert+ and choose 'No' when asked 'Clear Existing Studies on Chart?'

The attached will alert when price approaches the previous ZZ mid line and is n ticks from it.
Use cell H2 on the spreadsheet to choose the offset.
Alerts are set on the Settings and Inputs tab, not on the Alerts tab
Alerts for approach from below mid line are in Column K
Alerts for approach from above mid line are in Column M

Edit: uploaded corrected spreadsheet file

Date Time Of Last Edit: 2017-02-28 23:03:58
attachmentZZ mid line alert+.StdyCollct - Attached On 2017-02-28 01:30:51 UTC - Size: 9.4 KB - 304 views
attachmentZZ mid line alert.scss - Attached On 2017-02-28 23:02:33 UTC - Size: 130.36 KB - 292 views