Support Board
Date/Time: Wed, 27 Nov 2024 16:34:04 +0000
Post From: Spreadsheet study - How to flatten all positions just on Fridays
| [2023-07-22 18:27:00] |
| Rui S - Posts: 190 |
|
Hello. I have been starting my incursions with the Spreadsheet for Trading and I have already made some research but I can't figure out how to make the Spreadsheet to flatten all open positions at the end of the day just on Fridays. To flatten on a daily basis I'm using the following formula on J29, for West European Time: =FRACTIME(J41)>TIMEVALUE("20:59:00"). I would like to have a version of that formula that would flatten just on Fridays. I think I will need to use the "WEEKDAY" Function, but I can´t figure out how. Any help will be appreciated. Thanks. |