Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 01:21:11 +0000



[Programming Help] - Scaling Out With Spreadsheet Trading Systems

View Count: 1689

[2018-07-04 01:20:13]
User41727 - Posts: 124
I have a simple spreadsheet trading system with one chart. When an entry signal has been given, I would like to generate a stop loss order and a limit target order for a fraction of the size of the initial position, so that the quantity of the stop loss is reduced to the remaining size once the limit order has been filled.

I can generate the two as attached orders, but then there seems to be no way of setting the size of the target order to anything but the full position size. The alternative is only to create an attached stop order while using Buy/Sell Exit to create the limit order with the correct quantity. But now I have to enable "Cancel all working orders on exit" for this to work at all, and this means the entire stop order is cancelled as soon as the limit order is hit.

So, my question is whether I am missing something or whether this kind of thing should be done with ACSIL.
[2018-07-04 04:23:40]
Sawtooth - Posts: 3952
This is entirely possible with the Spreadsheet System for Trading study.

- Use cells J82/J83 for the exit quantity. L3/N3 uses J83 for the exit quantity if J82 is 1.
- 'Support Scale Out' needs to be checked.
- A spreadsheet formula returns the scale out price level, and is compared to E3 for a T/F.
- The stop loss quantity will decrement.
- 'Cancel All Working Orders On Exit' will need to be set to No.
[2018-07-04 20:28:00]
User41727 - Posts: 124
Thank you, that actually works.

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

Login

Login Page - Create Account