Support Board
Date/Time: Wed, 27 Nov 2024 10:36:52 +0000
Post From: tomgilb, spreadsheet pros: swingpoints/fractals with spreadsheet study
| [2014-08-14 03:10:21] |
| 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 - 392 views swing-points.scwbf - Attached On 2014-08-14 02:43:23 UTC - Size: 22.24 KB - 446 views  equal highs-lows.png / V - Attached On 2014-08-14 03:08:31 UTC - Size: 32.74 KB - 409 views equal lows.png / V - Attached On 2014-08-14 03:08:35 UTC - Size: 7.57 KB - 399 views |