Support Board
Date/Time: Fri, 07 Nov 2025 03:51:38 +0000
Post From: Handling Stop and Limit orders with the Spreadsheet for trading
| [2025-11-05 15:34:40] |
| John - SC Support - Posts: 42830 |
|
For a Long position (so you initially have the "Buy Entry" be True for entry) you would use the "Buy Exit" to close out the position. You either use the "Buy Exit" or you use an OCO set of Stop/Target - you can not use both, as this would create a problem should a Target close a position and then the Buy Entry go true. So you are not using the Buy Exit properly. If you want to have a Stop/Target OCO, then the easiest way to do this is to leave the Buy Exit alone and not setup any of the cells as you have stated above. Just set the Attached Orders on the Trade Window for the chart that has the Spreadsheet Study on it the way you want them. As long as the "Trade Window" has the option for "Use Attached Orders" enabled, then when a "Buy Entry" or "Sell Entry" goes True in the Spreadsheet System for Trading, those Attached Orders will be used. If you want more specific control over the Target/Stop, then enter a formula in cells J84 and J85 that gives you the offset you want for the Target and Stop. If these cells have valid numbers in them, then this will override the Attached Orders settings in the Trade Window. Refer to the following: Spreadsheet Systems, Alerts and Automated Trading: Attached Order Target Offset (write only) [v1:J80, v2:J84] -- We are not certain of the issue in terms of the documentation for the Spreadsheet cells. The documentation lists the specific cells for both versions 1 and 2 for Columns I and J. Admittedly, it is a bit messy, but this is due to having both versions available. And if you are curious, the reason for the two versions is that Version 1 came about as things got added to the Spreadsheet System for Trading. So items were not in a good order. They were reordered and hence Version 2 came out. But we could not force people to redo their spreadsheets, therefore we kept both implementations. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |