Home >> Support Board

Support Board

Date/Time: Sat, 04 May 2024 05:12:12 +0000

How to Post a Message for Support

[User Discussion] - tomgilb, spreadsheet pros: swingpoints/fractals with spreadsheet study

View Count: 2007

[2014-08-14 03:10:21] #1 [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

[2014-08-14 14:38:58] #2 [Go To First Post]
Sawtooth - Posts: 3993
In the non-CLR version, you could add this to your N3 and O3 formulas: =IF(OR(ROW()=3,ROW()=4),0,ExistingFormula) This will also eliminate redrawing of the Point on High/Point on Low on the current and previous bar. Date Time Of Last Edit: 2014-08-14 15:03:11

[2014-08-15 23:13:44] #3 [Go To First Post]
tobi - Posts: 351
Thanks a lot tomgilb! That solved the problem :-)

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