Support Board

Date/Time: Sat, 04 May 2024 02:19:57 +0000

Post From: tomgilb, spreadsheet pros: swingpoints/fractals with spreadsheet study

[2014-08-14 03:10:21] Link To Thread - Link To Post [Go To First Post]
tobi - Posts: 351
Dear tomgilb and other spreadsheet pros, I am using the attached spreadsheet study to define swingpoints. In the CLR version this was working fine. But unfortunately in the non-CLR version I often times get an error. I'm pretty sure this has to do with the formulars for SH and SL using lines 1 and 2 of the spreadsheet. I define swing points like this: Swing High = at least 2 lower highs to the left and at least 2 lower highs to the right Swing Low = at least 2 higher lows to the left and at least 2 higher lows to the right If there are equal highs/lows they are treated as merged together and only the last equal high/low are marked as swing high/low (this makes the formular so long, but hopefully you have a better idea; please see the attached screenshots). Do you have a better idea, to easier and/or more efficiently calculate the swing points as defined above, that this is working in the non-CLR version too? Thanks in advance for your help, tobi


swing-points.cht - Attached On 2014-08-14 02:43:18 UTC - Size: 29.28 KB - 373 views swing-points.scwbf - Attached On 2014-08-14 02:43:23 UTC - Size: 22.24 KB - 347 views equal highs-lows.png / V - Attached On 2014-08-14 03:08:31 UTC - Size: 32.74 KB - 383 views equal lows.png / V - Attached On 2014-08-14 03:08:35 UTC - Size: 7.57 KB - 378 views