Support Board

Date/Time: Thu, 11 Dec 2025 23:53:33 +0000

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

[2017-01-24 20:38:15] #1 [Go To First Post]
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] #2 [Go To First Post]
Sawtooth - Posts: 4298
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: