Support Board
Date/Time: Sat, 13 Sep 2025 13:52:27 +0000
Post From: REQUEST -- Including Slope Data from Indicators
| [2024-06-05 18:55:50] |
| Sawtooth - Posts: 4263 |
|
This formula creates a persistent value of either 1 or -1 A '1' is an upsloped line, and a '-1' is a downsloped line. The first IF statement returns a 1, and the second IF statement returns a -1. It is made persistent by referencing its previous value, until the slope changes direction: - if a spreadsheet syntax formula, by referencing the previous row (row 4) of its Formula Column. - if an alert syntax, by referencing the previous value ([-1]) of the Spreadsheet Formula study. |