Support Board
Date/Time: Fri, 07 Nov 2025 03:48:50 +0000
Post From: Handling Stop and Limit orders with the Spreadsheet for trading
| [2025-11-06 09:23:01] |
| Fabio - Posts: 129 |
|
Hey John, Thanks for coming back to me. I found a part of the documentation that goes against what you said at the beginning: 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.
You can find it here: Automated Trading Management: SupportAttachedOrdersForTrading But I also copy and paste the part I am referring to here for easy reference for you to check: It is possible to use both Attached Orders and BuyExit or SellExit to exit the Position. This is explained in this section.
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.
I found part of the documentation that this was not case (although most of them have both V1 and V2). I got lost in the rabbit hole of the links so I don't know where to find the missing ones anymore, but if I find it again I will let you know.I think I solved the problem with the use of cells J84/ 85 and it looks working just fine so I think I will simplify a little using those. With that said, it would be curious to know how to handle the exits using column L (for the long) and N for the shorts. For those columns to handle both stop and target, it means that cell J74/76 must be left to "M" (market order), right? Only by doing so a market order will be fired off when either/or conditions are met, is that correct? Doing so, won't allow me to visually see the stop and target on the chart, nor to have them in case of a sudden interruption of the platform (i.e. sudden shut down of the platform, the power goes down etc). Look forward to hearing back from you. Thanks, F. |