Support Board
Date/Time: Sun, 24 Nov 2024 05:54:53 +0000
Post From: sreadsheet auto trading: different time to flatten position depending on day of the week
| [2013-09-23 18:42:09] |
| User51517 - Posts: 58 |
|
Hello SC support: I have cell J29 set as follow: =AND(J5<>0, J41-INT(J41)>TIMEVALUE("11:50:00")). This is to flatten position at 11:50, 10 minutes before noon. I wanted to add one more nuance to this rule for Thursday, when natural gas inventory number comes out at 10:30. How do I keep J29 as is for the other 4 days, and flatten position at 10:20 for Thursday? Thank you! Date Time Of Last Edit: 2013-09-23 18:42:46
|