Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 06:28:46 +0000



Spreadsheet System unreliable in flattening orders

View Count: 523

[2020-11-28 19:51:54]
User351605 - Posts: 76
In my spreadsheet I've set row J88 to TRUE and J89 to a certain Time, but if I use AutoTrade System Bar Based BackTest the positions getting flattened only sometimes. It's really annoying. What could be the problem? I tried all kinds of combinations with J29 on / off and J85-87 on / off. I also tried to enable Flatten Positions at Set Time in Global Profit/Loss management. Doesn't work at all.
[2020-11-29 03:51:30]
Sawtooth - Posts: 3952
Try using J29 instead, with a formula like this:
=FRACTIME(J41)>TIMEVALUE("16:14:00")

Also, consider using a different backtesting method. The AutoTrade System Bar Based BackTest is non suited for complex configurations, IMO.
Auto Trade System Back Testing: Bar Based Back Testing
[2020-11-29 10:50:23]
User351605 - Posts: 76
Thank you Tom! It seems to work

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

Login

Login Page - Create Account