Support Board

Date/Time: Mon, 20 May 2024 09:08:44 +0000

Post From: Array formulas and auto-recalculate script

[2018-02-14 21:11:49] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4001
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.