Support Board
Date/Time: Wed, 27 Nov 2024 16:30:55 +0000
Post From: Spreadsheet study - How to flatten all positions just on Fridays
| [2023-08-01 00:27:54] |
| Rui S - Posts: 190 |
|
Hi Tom, Thank you for your reply. Your explanation is simply great. I very much prefer a good explanation (when possible) than just the work "done". This way I can understand and learn! For your J29 to go TRUE, there must be a chart bar that includes the FRACTIME(J41) of 23:20:00
This is the problem for sure!! The Market (CME-NQ) closes at 22:00 Western Europe Time and here I am going around and around and then taking your time with such a silly thing!! My sincere apologies for that. Once again the obvious answer was right in front of my eyes but I kept looking to the formulas...Most Futures contracts have no bars after 17:00:00 ET on Fridays. I'm having a busy day out tomorrow for health tests, but as soon as I get back home I will rearrange that time of close issue and will also add the AND(J8=0 to the formula. Thank you so much for taking the time to check my issue and for the thorough explanation. Date Time Of Last Edit: 2023-08-01 00:31:22
|