Support Board
Date/Time: Sun, 22 Dec 2024 03:25:45 +0000
[User Discussion] - price action study for the time passed meaning that happened before ?
View Count: 1145
| [2015-07-31 06:22:08] |
| mario mario - Posts: 22 |
|
Say at 11 am, if I want the price study between 11 :30 and 12 noon, I can use IF STATEMENTS in the spreadsheet and if the conditions meet, to signal the alerts at that time. 1) how do I make the alert signals to stay all day beyond 12 noon 2)How can I do the same signals alert from the passed time say between 10 and 10:30 and if the conditions have met, the alert signals to stay all day. for the passed time, i cannot use IF statements because current time condition does not meet since row 3 is for current bar time and it rolls downward, top down. Is there any WHEN STATEMENT in the spreadsheet rather than IF STATEMENT, to extract the data when and what happened with price in the passed time. thanks |
| [2015-07-31 12:49:31] |
| Sawtooth - Posts: 4141 |
|
There are various ways create a persistent value that stays in row 3. Here's one example that you might be able to use or modify: http://www.sawtoothtrade.com/free-stuff-5.html A way to create a single persistent value is to use double IF statements, where the first IF begins the persistence and the second IF ends it: =IF(ConditionsForTrue,TRUE,IF(ConditionsForFalse,FALSE,S4)) where the above formula is in cell S3. You can also lock a TRUE condition with a self-referencing formula. Here's an example: http://www.sawtoothtrade.com/example-9.html |
To post a message in this thread, you need to log in with your Sierra Chart account: