Support Board
Date/Time: Sun, 02 Nov 2025 16:03:17 +0000
Post From: Swing High and Low using spreadsheets for automated trading
| [2024-02-27 01:05:51] |
| Sawtooth - Posts: 4285 |
|
That example creates a persistent value of the most recent event, and the second most recent event, and brings both values to row 3, in columns O and P respectively, where you can compare them. Use a formula like this in O3: =IF(ID3.SG1@3 > 0, ID3.SG1@3, O4) Use a formula like this in P3: =IF(ID3.SG1@3 > 0, O4, P4) -where the Swing High and Low study is ID3. This is for the Swing High. Replicate in two other Formula Columns for the Swing Low. |