Login Page - Create Account

Support Board


Date/Time: Wed, 29 Jun 2022 15:48:37 +0000



[Programming Help] - Spreadsheet Trading Set Multiple Targets?

View Count: 107

[2022-05-03 19:35:23]
tuanluu20902 - Posts: 18
Hi there, I've been tinkering with the spreadsheet system and it seems to have an all-in and all-out approach to trading unless I use multiple targets offset through the Trade Window.

I want to bypass the Trade Window and just set targets through the spreadsheet system instead, is that possible? For example, exit half at 2xATR away from entry and exit another half 4xATR away from target. Since the ATR is always changing due to volatility regime, I don't want to have a pre-set Target 1 as I don't know if I am under or over-exaggerating volatility.
[2022-05-03 21:32:29]
tomgilb - Posts: 3327
I want to bypass the Trade Window and just set targets through the spreadsheet system instead, is that possible?
Yes, uncheck 'Use Attached Orders' on the Trade Window.
Then use the Trade Management by Study study, referencing a column/subgraph of the spreadsheet study whose formula outputs the correct price.
You can use multiple instances of the TMS study.

You will probably also need to use cells J82/J83 for a separate exit quantity.

BTW, you can use spreadsheet exits and Trade Window exits concurrently, allowing you to use a Trade Window stoploss and a spreadsheet target exit.
In this case, the Trade Window config would only have a stoploss, and no targets.
If you do this, set 'Cancel All Working Orders On Exit' to Yes.
[2022-05-12 14:55:46]
tuanluu20902 - Posts: 18
Thanks @tomgilb, is it possible to write into the Buy/Sell exit column to exit half the quantity of position? Or is it still all or nothing.
[2022-05-13 00:28:03]
tomgilb - Posts: 3327
is it possible to write into the Buy/Sell exit column to exit half the quantity of position?
Use cells J82/J83 for a separate exit quantity.

J82 set to 1 enables the separate exit quantity.
J83 is the separate exit quantity.

L3/N3 are the triggers for the exit, and will use the quantity in J83.

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

Login

Login Page - Create Account