Support Board
Date/Time: Wed, 27 Nov 2024 16:57:19 +0000
Post From: Spreadsheet study - How to flatten all positions just on Fridays
| [2023-07-22 21:34:32] |
| Rui S - Posts: 190 |
|
Hi again. I'm sorry to bother you again, there is one more step I can't figure how out to do it. I'm using this formula bellow and it's working well - it's the trading time frame (14:00:00 to 19:28:00) with a "recess" (15:20:00 to 17:00:00): =OR(OR(FRACTIME(J41<TIMEVALUE("14:00:00"),FRACTIME(J41)>TIMEVALUE("19:28:00")),AND(FRACTIME(J41)>TIMEVALUE("15:20:00"),FRACTIME(J41)<TIMEVALUE("17:00:00"))) Now I need to add a second "recess", e.g. from 17:30:00 to 18:00:00. After several attempts, it comes always with an error (#sintax). Here is one of those attempts: =OR(OR(FRACTIME(J41<TIMEVALUE("15:00:00"),FRACTIME(J41)>TIMEVALUE("19:28:00")),AND(FRACTIME(J41)>TIMEVALUE("15:20:00"),FRACTIME(J41)<TIMEVALUE("17:00:00"),AND(FRACTIME(J41)>TIMEVALUE("17:30:00"),FRACTIME(J41)<TIMEVALUE("18:00:00"))) Could you please take a look and correct it for me? Thank you. Date Time Of Last Edit: 2023-07-22 21:35:14
|