Support Board
Date/Time: Sun, 24 Nov 2024 05:59:58 +0000
[User Discussion] - sreadsheet auto trading: different time to flatten position depending on day of the week
View Count: 1774
| [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
|
| [2013-09-24 00:43:48] |
| Sawtooth - Posts: 4118 |
|
Use the WEEKDAY function. http://office.microsoft.com/en-us/excel-help/weekday-HP005209336.aspx?CTT=5&origin=HP005204211 |
To post a message in this thread, you need to log in with your Sierra Chart account: