Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 07:22:33 +0000



Spreadsheet OCO entry orders

View Count: 123

[2024-10-17 11:11:01]
User745789 - Posts: 313
Is it possible to use the spreadsheet auto trading to place an entry OCO buy stop sell stop?
[2024-10-17 14:57:48]
John - SC Support - Posts: 36238
We are not sure what you are wanting in terms of an "OCO buy stop sell stop". But you can enter a Limit order (or Stop Limit) with a Stop order, as well as an OCO Stop and Target.

With the Spreadsheet System for Trading, if you do not define a specific Target and Stop, then the attached order setup in your Trade Window is used.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-10-29 23:58:19]
User745789 - Posts: 313
I mean this type of order
Order Types: OCO Buy Stop Sell Stop
[2024-10-30 00:06:14]
John - SC Support - Posts: 36238
The "Spreadsheet System for Trading" does not support entering an "OCO Buy Stop Sell Stop" order type.

One of the points being that the reason to enter the Buy Stop Sell Step is that you are not sure which direction the market is going to move, so you are setting up this order to enter into a position when the market moves one way or the other.

The Spreadsheet System for Trading, and any automated system, should be setup to enter either a Long or a Short based on the particular conditions. So you would know at the time, whether you are wanting a Long or a Short.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-10-30 00:15:41]
Sawtooth - Posts: 4118
See this for an example of how to do a bracketed entry with Buy Stop and Sell Stop entries, using the Spreadsheet System for Trading study:
https://www.sawtoothtrade.com/free-stuff-20.html
[2024-10-30 00:53:47]
User745789 - Posts: 313
That is quite helpful, thank you. J78 does a lot of the work.

But my main hurdle now is regarding attached take profit and stop loss. The order price of the attached stop loss exit and take profit orders are determined by the Trade Window settings, and they are fixed. Where as my bracket attached order prices are determined by the spreadsheet.
[2024-10-30 00:58:57]
Sawtooth - Posts: 4118
...my bracket attached order prices are determined by the spreadsheet.
You can use the Trade Management by Study study to move an attached target and stop.
It would reference the subgraph of one of the Formula Columns.
You would need an instance for the target and one for the stop.
Attached Orders: Study Controlled Targets and Stops

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

Login

Login Page - Create Account