Support Board
Date/Time: Fri, 14 Mar 2025 22:25:06 +0000
Spreadsheet System for Trading: Flatten Positions and Cancel not working.
View Count: 490
| [2022-07-06 21:42:17] |
| Alex Q - Posts: 112 |
|
I'm running a backtest using the spreadsheet system for trading study. I have a bracket on with a 10 point stop, but with NO target. I am trying to get data from the max open profit column. In order to close any open position before close so that auto-trading/ back testing can resume the following session I have done as follows: J88 is set to TRUE, and J89 is set to 12:58:00 PST J85 is set to TRUE, J86 to market open @6:30:00 PST, and J87 12:49:00 Positions are not being closed by the time specified in J88. |
| [2022-07-07 00:57:25] |
| Sawtooth - Posts: 4182 |
|
Positions are not being closed by the time specified in J89.
This is because autotrading is disabled at 12:49 in J87.To get around this, use J28/J29 instead of J85-J89, like this: J28: =AND(J8=0,OR(FRACTIME(J41)<TIMEVALUE("06:30:00"),FRACTIME(J41)>TIMEVALUE("12:49:00"))) -With J8=0 in above formula, entries are only allowed between the times, but exits can occur between the times and after the latest time. J29: =FRACTIME(J41)>TIMEVALUE("12:58:00") - The time in J29 needs to be later than the latest time in J28. Spreadsheet Example Formulas and Usage: Disable Trading From Spreadsheet Study for Trading Date Time Of Last Edit: 2022-07-07 02:19:43
|
To post a message in this thread, you need to log in with your Sierra Chart account: