Support Board
Date/Time: Wed, 27 Nov 2024 10:49:37 +0000
[User Discussion] - tomgilb, spreadsheet pros: swingpoints/fractals with spreadsheet study
View Count: 2062
| [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 - 393 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 - 400 views |
| [2014-08-14 14:38:58] |
| Sawtooth - Posts: 4120 |
|
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] |
| 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: