Login Page - Create Account

Support Board


Date/Time: Fri, 09 May 2025 19:38:37 +0000



[User Discussion] - ZigZAG time duration in spreadsheet

View Count: 1359

[2014-11-02 09:53:53]
Thib - Posts: 54
Hello SC,

Is there a way to have ZigZag time duration in spreadsheet (I don't have it in Additional Output for sreadsheets)?
[2014-11-02 19:14:12]
Sawtooth - Posts: 4214
You can calculate it with these formulas:
O3:
=IF(AC3>0,A3,O4)
P3:
=IF(O3>O4,O3-O4,"")
where 'Additional Output for Spreadsheets' is Yes, and column AC is the Reversal Price.

However, you cannot display the value in Time format.
[2014-11-02 19:58:39]
Thib - Posts: 54
It'sperfect tomgib. Thank you very much

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account