Support Board
Date/Time: Wed, 27 Nov 2024 00:31:45 +0000
[User Discussion] - Spreadsheet help___repeating condition
View Count: 1494
| [2014-06-22 14:27:24] |
| Atlatyl - Posts: 19 |
|
Using the "Highest High/Lowest Low Over N Bars" study, I'm trying to create a condition that reads *true* in a trading spreadsheet, once a new high has been made...essentially the formula behind the study that makes the higher high line turn green and stay green until it turns red again. Can't wrap my brain around it...any help would be appreciated.
|
 XXXXXXX.bmp - Attached On 2014-06-22 14:25:31 UTC - Size: 886.41 KB - 455 views |
| [2014-06-22 19:49:14] |
| Sawtooth - Posts: 4120 |
|
Use a double IF statement, like this: =IF(AA3>AA4,TRUE,IF(AA3<AA4,FALSE,P4)) Where the above formula is in cell P3, and the Highest High is in column AA. Date Time Of Last Edit: 2014-06-22 20:43:45
|
| [2014-06-22 20:11:20] |
| Atlatyl - Posts: 19 |
|
Thanks Tom, you da man ;-)
|
To post a message in this thread, you need to log in with your Sierra Chart account: