Support Board
Date/Time: Sat, 28 Dec 2024 07:45:14 +0000
Post From: spreadsheet study and time
| [2015-12-22 01:07:16] |
| User175327 - Posts: 36 |
|
hi- i am trying to write buy/sell entries based upon certain criteria being met at the open....specifically within 5 minutes of the open. i have been through several threads on the support board but cant get this to work. not sure what i am doing wrong....=AND($J$41>=TIMEVALUE("08:00:00"),($J$41<=TIMEVALUE("08:10:00"),(id0.sg4@3>id3.sg1@3)).... this is where i am. i only want the spreadsheet to look at the first 5 minutes after the open and include at least one other qualifier like the example, but i can't get it to work. any help would be super!!
|