Support Board

Date/Time: Mon, 20 May 2024 11:02:03 +0000

Post From: Array formulas and auto-recalculate script

[2018-02-14 20:20:54] Link To Thread - Link To Post [Go To First Post]
User606491 - Posts: 164
Directly, here's what I am trying to do: In my spreadsheet, I would like to reference the second text label in the Zig Zag study. For example: find a contiguous pair of LH and HH. I can use get-corresponding-match to find the first text label greater than 0. However, because, the text label column is interspersed with zeroes, I am not able to capture the second text label greater than zero. This can be done with an array formula. Second, because the Zig Zag study may not always identify the final pivot high/low, I am looking for a way to automatically recalculate the chart based on a predetermined interval. As always, thank you for your guidance.