Login Page - Create Account

Support Board


Date/Time: Wed, 07 May 2025 14:50:46 +0000



OCO stop loss odd behavior spreadsheet trading

View Count: 209

[2024-11-25 08:04:35]
User488241 - Posts: 41
Hello,

I am using a simple oco stop loss 20 pts from entry. I am entering 1 lot at a time up to 4 lots total.
In most situations I will have different stop loss locations depending on where the trade was entered.
When the trade does not work out all the stop losses will be hit which is expected behavior.

The problem is when a single profit target is hit the other stop losses disappear.
To be clear I am not using an OCO profit target but a market exit from spread sheet trade study.

Just as an example I have 3 lots long, one at 2001, 2004, 2010 with corresponding stop losses
spreadsheetstudy will generate a buy exit signal for 1 lot and all the working orders will disappear.

I have cancel orders on, entries and reversals/reversals/entries/exits all set to No

Could you please let me know why this is happening?
Date Time Of Last Edit: 2024-11-25 08:04:57
[2024-11-25 17:59:51]
John - SC Support - Posts: 39675
You must have the Input for "Cancel All Working Orders on Exit" set to "Yes" for your Spreadsheet System for Trading. Otherwise, if this is set to "No", then if you have working Stop orders, a true value for the "Buy Exit" would not allow you to actually exit any positions. This is due to the lack of a connection between using the "Entry/Exit" options on the Spreadsheet and the working orders on the chart.

In the end, there is not a way to do what you are wanting to do, at least in the way you are wanting to do it. As noted above, you are really wanting an OCO connection between the Spreadsheet Exit column and the working orders, which does not exist.

What you need to do is expand your Buy Exit to cover the Stop scenarios as well as the Target scenarios.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-11-25 19:02:05]
User488241 - Posts: 41
Hi John,

Thanks for your input. I am only using the stop loss as an emergency situation incase my internet or computer shuts down during an open trade. I don't mind coding in the exits and entries all into the spreadsheet study but is there a way to still keep a stop loss for emergency situations in my situation?
[2024-11-25 22:58:15]
Sierra_Chart Engineering - Posts: 19468
If you are doing what is explained here:
Spreadsheet Systems, Alerts and Automated Trading: Using Both Attached Orders and Buy Exit and Sell Exit at the Same Time

However, on the Spreadsheet Exit you do not want to exit the entire position but only part of it and you want to avoid the Stop orders from being canceled, then that is not going to work when using a Spreadsheet trading study.

What you want is more advanced and you need to use ACSIL Trading instead:
Automated Trading From an Advanced Custom Study

So you certainly can do what you want, but you just need a higher degree of control. This is where you need to use ACSIL.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2024-11-25 22:58:35

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

Login

Login Page - Create Account