Support Board
Date/Time: Fri, 07 Feb 2025 18:19:22 +0000
Post From: Zig Zag: Retrieval of Delta accumulated volume
| [2019-04-12 17:06:41] |
| Sawtooth - Posts: 4173 |
|
Add the Spreadsheet System/Alert study, give it a name in the Spreadsheet Name field. On the spreadsheet, enter these formulas: Cell O3: =IF(ID1.SG3@3>0,ID1.SG5@3,O4) Cell P3: =IF(ID1.SG3@3>0,O4,P4) Cell Q3: =IF(ID1.SG3@3>0,P4,Q4) -where ID1 is the Zigzag study; edit as needed. Row 3 is the current bar, so cell O3 will contain the most recent ZZ accumulate volume. Cell P3 will contain the second most recent ZZ accumulate volume. Cell Q3 will contain the third most recent ZZ accumulate volume. You can use additional Formula Columns to continue this daisy chain reference for additional previous values. Now, use formulas in K3 to N3 for your alert conditions, referencing cells O3, P3, Q3. If you only want the Lows, you could use every other column's value. Or you could use a more detailed formula referencing SG2 for only the LL and/or HL: LH = 1 HH = 2 HL = 3 LL = 4 |