Home >> Support Board

Support Board

Date/Time: Thu, 09 May 2024 11:24:58 +0000

How to Post a Message for Support

[Programming Help] - Array formulas and auto-recalculate script

View Count: 2217

[2018-02-14 19:42:15] #1 [Go To First Post]
User606491 - Posts: 164
two questions: 1) is there a way to generate an array formula in the SC spreadsheet? 2) is there an auto-recalculate study available? This would be useful updating my charts on a pre-determined interval. I remember seeing one a while back, but can no longer find it. thanks,

[2018-02-14 20:20:54] #2 [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.

[2018-02-14 21:11:49] #3 [Go To First Post]
Sawtooth - Posts: 3993
1) is there a way to generate an array formula in the SC spreadsheet? This is not supported. 2) is there an auto-recalculate study available? Kiwi has created a recalc study in kiwi15.dll See post#2 here: request for a very simple ACSIL study To return the price at previous ZZ legs, use the INDEX/NMATCH function combination, like this where the Zigzag study is ID1: Cell O3: =ID1.SG2@3>0 this returns a 1 at each leg. Cell P3: =INDEX(ID1.SG1@3:ID1.SG1@1002,NMATCH(1,1,O3:O1002,0),1) this returns the price at the nearest ZZ leg Cell Q3: =INDEX(ID1.SG1@3:ID1.SG1@1002,NMATCH(3,1,O3:O1002,0),1) this returns the price at the 3rd previous ZZ leg Since contiguous pairs of highs occur every other leg, the NMATCH is looking for the 1st and 3rd previous occurrences. You could INDEX the Text Labels column looking for these numeric identifiers: LH=1 HH=2 HL=3 LL=4 The INDEX/NMATCH formulas do not need to be in Formula Columns.

[2018-02-14 21:21:06] #4 [Go To First Post]
User606491 - Posts: 164
As always thanks, Tom. I may have some work for you. Where's the best place to reach you, https://www.sawtoothtrade.com/?

[2018-02-14 22:11:05] #5 [Go To First Post]
Sawtooth - Posts: 3993
Yes

[2018-02-27 22:06:42] #6 [Go To First Post]
samual sprat - Posts: 343
Hey Guys. Not sure if you've noticed this too but since the 64bit update which allows access to more memory, I've noticed kiwi may have a memory leak. Just thought i'd make you aware in case you're using it. Maybe you can help to fix it. See this post: Kiwi Resync Study - Memory leak? Thanks S

[2018-02-27 22:25:57] #7 [Go To First Post]
Sawtooth - Posts: 3993
Yes, I noticed that Kiwi's Recalc study caused some serious lag when I upgraded to from 1689 to 1697, before the 64bit version. I had to remove it my charts.

[2018-03-03 11:45:54] #8 [Go To First Post]
samual sprat - Posts: 343
Guys, the fix for kiwi 15 resynce memory leak is here Kiwi Resync Study - Memory leak? Worked perfectly so far in my testing. Date Time Of Last Edit: 2018-03-03 11:46:25

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