Support Board
Date/Time: Tue, 04 Feb 2025 22:08:39 +0000
Using OCO Orders with Spreadsheet
View Count: 1413
| [2020-02-13 21:09:21] |
| User346364 - Posts: 15 |
|
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] |
| |
|
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: 15 |
|
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] |
| |
|
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: