Login Page - Create Account

Support Board


Date/Time: Sat, 18 May 2024 18:46:27 +0000



Post From: [Urgent] Spreadsheet System for Trading - Cell J29 Can't Flatten During Backtest

[2018-06-06 17:26:22]
MichaelPPTF - Posts: 68
Hello,

As I am developing a new spreadsheet system for trading, and specified a formula in cell J29 to flatten and cancel, but strangely, when this cell turns "1", nothing occured in the back testing - Position is still on, resting orders, too.

I am using an attached order for target and no stop is used (cell J29 is basically my stop). Nothing exists in L and N column for exits.

Wonder what could contribute to this problem? I read the technical document, seems that J29 take precedence of all other forms of order management, so it should trigger when it turns non-zero or true, regardless what everything else is doing or trying to do.

I am on version 1738, 32bit version of Sierra.

Please shed me some light, thanks in advance.