Login Page - Create Account

Support Board


Date/Time: Sat, 11 Jan 2025 05:00:07 +0000



Post From: Spreadsheet Study for Automated Trading

[2016-10-30 17:19:35]
jakesans - Posts: 50
What would be a a good formula to exit all open positions prior to session close? I didn't see a default study setting to do this.

I was thinking adding the time line study and setting to 1 minute prior to market close and using the crossover function, but it seems like this isn't necessary and may not actually work because of the values the study provides on the spreadsheet. It seems like the best way is to create a formula from the time stamps already provided in the default spreadsheet, but I am not sure how exactly to do it. I have tried the TIME and TIMEVALUE functions, but I get errors, so probably not using correctly. An example would be most helpful. Please advise.

Thanks.