Support Board
Date/Time: Fri, 27 Dec 2024 08:52:29 +0000
Post From: time specific spreadsheet entries
| [2015-12-17 05:48:37] |
| 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, nut i can't get it to work. any help would be super!!
|