Login Page - Create Account

Support Board


Date/Time: Wed, 05 Feb 2025 12:01:37 +0000



[Programming Help] - Zig Zag trend in spreadsheet

View Count: 824

[2020-03-11 10:46:57]
User354816 - Posts: 21
Hello,
I want to define a trend via spreadsheet text labels.
If the last is HH and the one before is HL = long.

Is there any formula i can use for ?

Thanks !
imageScreenshot_148.png / V - Attached On 2020-03-11 10:46:29 UTC - Size: 24.54 KB - 261 views
[2020-03-11 12:52:25]
Sawtooth - Posts: 4167
Here are the text label value conversions:
Zig Zag: Text Labels Subgraph Description

Next you would need to make the previous ZZ leg's text label value persistent so you could compare it to the current text label value.
See this example:
Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values

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

Login

Login Page - Create Account