Login Page - Create Account

Support Board


Date/Time: Sun, 12 Jan 2025 00:37:22 +0000



[User Discussion] - Closing position end of week spreadsheet auto trading

View Count: 1292

[2017-01-24 20:38:15]
JamesP - Posts: 89
I'm aware of closing positions end of day using "Disable auto trading" but I'm wondering if/how I can close out positions end of day Friday(just fridays) using spreadsheet auto trading? Thanks.
[2017-01-24 21:04:08]
Sawtooth - Posts: 4149
Use the WEEKDAY function in cell J29, like this:
=AND(J41-INT(J41)>=TIMEVALUE("16:00:00"),WEEKDAY(J41)=6)
http://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#WEEKDAY_Function
Date Time Of Last Edit: 2017-01-24 21:08:10

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account