Support Board
Date/Time: Sun, 24 Nov 2024 14:22:20 +0000
Post From: REQUEST -- Including Slope Data from Indicators
[2024-06-05 18:55:50] |
Sawtooth - Posts: 4118 |
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. |