Support Board
Date/Time: Mon, 25 Nov 2024 01:27:36 +0000
[User Discussion] - spreadsheet problem
View Count: 2305
| [2013-12-23 22:47:41] |
| toews&kane - Posts: 209 |
|
Hi there, Trying to work on this problem for a bit now. I am trying to restrict one condition for this time frame $H$8 =AND(J41-INT(J41)>=TIMEVALUE("13:00:00"),J41-INT(J41)<TIMEVALUE("14:00:00")) with column x refering to it IF($H$8, SOME CONDITION, PREVIOUS CELL VALUE) so that once the condition is met say B3<=-10 it will be flagged true for the rest of the day how do i do this? |
| [2013-12-24 00:33:06] |
| Sawtooth - Posts: 4120 |
|
If your formula goes TRUE between the TIMEVALUEs, it won't necessarily stay TRUE. Take a look at this solution: http://www.sawtoothtrade.com/example-9.html Let me know if you need more help. Date Time Of Last Edit: 2015-08-14 01:48:44
|
| [2013-12-24 01:03:11] |
| Bedhog - Posts: 179 |
|
How many Rows in Column H are available for setting state like this? |
| [2013-12-24 02:43:53] |
| toews&kane - Posts: 209 |
|
@tom works like a gem thanks @bedhog I think H,I, J are the only column that doesn't scroll so as many rows as you have I guess, or you can do a test I've never tried the max rows it will take |
| [2013-12-24 23:17:43] |
| toews&kane - Posts: 209 |
|
I am finding a problem H8 holds =AND(J41-INT(J41)>=TIMEVALUE("13:00:00"),J41-INT(J41)<TIMEVALUE("14:00:00")) H9 holds =AND(OR(AND(H8=TRUE, CT3<=-4000),H10>1),H11=FALSE) H10 holds a counter to hold the condition true =IF($H$8=TRUE, H10+1,IF(INT(A3)>INT(A4), 1, H10)) H11 is the release on the lock =INT(A3)>INT(A4) The issue is H9 goes to true automatically without evaluation ct3<=-4000. how can that happen? |
| [2013-12-25 01:30:29] |
| Sawtooth - Posts: 4120 |
|
I think the locking formula should be this: =AND(OR(H9=TRUE,AND(CT3<=-4000,H10>1)),H11=FALSE) The locking TRUE formula should reference its own cell (H9), and the second part of the OR statement is the condition that initiates the TRUE. |
| [2013-12-26 01:59:59] |
| toews&kane - Posts: 209 |
|
my bad, I know what happened I wasn't referencing to the locking true formula, thanks
|
To post a message in this thread, you need to log in with your Sierra Chart account: