Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 12:02:48 +0000



[User Discussion] - Spreadsheet System - Reverse Position with single order

View Count: 624

[2019-12-09 17:17:49]
User819680 - Posts: 7
Is it possible to setup a spreadsheet system to submit a single order to reverse position. For example, if my order size is 100 and I am long 100 and a Sell Entry is hit, I would like the Sell Entry order to be for 200 units, rather than a closing sell order of 100 and an opening sell order of 100.
Thanks,
[2023-02-17 20:04:13]
User658125 - Posts: 19
I've been looking for an answer to this for a long while as well. It seems like it should be relatively simple.
[2023-02-18 00:44:23]
User61168 - Posts: 318
yes.. it is as simple as a single click to enable "support reversals" in the spreadsheet system study settings. Same is the case for simple alert trading system study as well.
EDIT: And if you want to add positions, "allow multiple entries in same direction" will magically do it for you as well.
Date Time Of Last Edit: 2023-02-18 00:46:27
[2023-02-18 13:51:33]
Sawtooth - Posts: 3952
To increase the order quantity on a reversal, or when scaling in, you need to use a formula in J26 that returns the new quantity, like this:
=IF(J8<>0,2,1)
This will start with 1 and return 2 when in a position.

Or
=IF(J8<>0,ABS(J8)*2,1)
This will start with 1, and double the quantity when in a position.

If you want to increase the order quantity to a daily max, see this example:
https://www.sawtoothtrade.com/example-2.html

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

Login

Login Page - Create Account