Login Page - Create Account

Support Board


Date/Time: Sat, 27 Apr 2024 23:11:29 +0000



Using OCO Orders with Spreadsheet

View Count: 1180

[2020-02-13 21:09:21]
User346364 - Posts: 14
Hello SC,

I am currently trying to build out a spreadsheet trader. I have read through your documentation online, and have managed to create the required ENTRY formulas for both buy and sell. However, I do not want it to buy straight into the market when the condition is met. I would like to place a BUY LIMIT order at a SPECIFIC price for a buy entry and a SELL LIMIT order at a SPECIFIC price for a sell entry. I would like these order to be OCO and have the "STOP" (STOP order) and the "TARGET" (LIMIT order) placed using specific prices (or ticks, if not possible with prices).

For example, using Gold (GCE). Let's say at any given moment my buy condition is met, I would like to place an OCO Bracket order. The BUY LIMIT entry at the close of the previous rotation (candle), and the STOP at the low of the previous rotation (number of ticks, or price).

Is this possible? And how can I go about achieving this?

Many thanks,
Dean
[2020-02-16 10:43:04]
Sierra Chart Engineering - Posts: 104368
Refer to:
Spreadsheet Systems, Alerts and Automated Trading: Limit or Stop Prices [J22, J23, J24, J25]

And refer to:
Spreadsheet Systems, Alerts and Automated Trading: Initiating Trades with Auto-Trading and Using Manual or Attached Orders Exits
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, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2020-02-16 10:43:45
[2020-02-16 14:41:10]
User346364 - Posts: 14
Thank you for your response, it has been most informative.

However, I am still struggling on one aspect. I know now, based on the information you provided above, that I can change the market order type in cells J71:J74, and I can also change the order entry type to Limit and adjust the price for the entry order. Now, I also know that I can change the order type to a bracket by setting the order type using the Trade Window on the chart. And I am also aware that I can set the Target and the Stop to Ticks or Price in that window, but those are static. I would like to change them using the Spreadsheet and make them dynamic, so for example if I place a buy limit (entry) with 10 tick stop and 30 tick target, how do I set the stop and target values when sending the bracket order?

Many thanks,
Dean
[2020-02-17 20:48:02]
Sierra Chart Engineering - Posts: 104368
Refer to these Sheet Inputs for controlling the Target and Stop offsets:
Spreadsheet Systems, Alerts and Automated Trading: Attached Order Target Offset (write only) [J80]

And also the documentation we previously linked to explains this.
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, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

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

Login

Login Page - Create Account