Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 01:44:24 +0000



Post From: Multiple Exit Spreadsheet Automated Trading Attached Order Issue

[2023-10-02 11:19:55]
User12222 - Posts: 20
Hi,

I am using the Spreadsheet System for Trading, trading two contracts at a time, and I have 2 spreadsheet programed exits (Condition 1 and Condition 2). I am also using attached orders (Stop Loss for each contract = 2 attached orders) so Stop Loss orders are on the brokers server as a 'catastrophic stop loss'. Otherwise, the buy/sell engine and exits are programmed into the spreadsheet. I am having an issue with attached orders. When the first exit condition is reached, the first of two contracts is flattened. However, when this occurs, both of the attached stop loss working orders are canceled, instead of just the one that was closed by the spreadsheet exit, leaving me with a 'naked' contract with no stop loss order.

When I use the spreadsheet for multiple exists, I have J26 = 2, J82 = 1, and J83 = 1. I also use logic for the Buy Exit (Sell) and Sell Exit (Buy) to peal off contracts one at a time with this logic =OR(AND(ABS($J$8)>1,(Condition 1))),AND(ABS($J$8)>0, Condition 2))). The exits do work when Conditions 1 and 2 are present. Again, I am looking to keep the 2nd attached order (Stop) when the first condition is executed and the contract is pealed off.

Under Study Settings, the following are YES:
Reset Condition on New Bar;
Signal only once per bar;
Cancel all orders on entries and reversals;
Allow entry with working orders;
Signal only on bar close (Line 17 and 18);
Support reversals;
Cancel working orders on exit;
Strict Signal on Bar close evaluation;

When I set the 'Cancel All working orders on exit' to NO, then the Buy Exit and Sell Exit conditions programmed into the spreadsheet do not trigger an exit.

I am using version 2540 which is a newer version.

If you need more detail please let me know. Thank you in advance for your time helping me resolve this issue.