Support Board
Date/Time: Mon, 25 Nov 2024 15:21:26 +0000
Post From: Placing simultaneous buy/sell entry order? spreadsheet system for trading
| [2018-09-04 18:03:51] |
| Sawtooth - Posts: 4120 |
|
The Spreadsheet System for Trading study will do what you want. Attached is an example chartbook/spreadsheet that places bracketed Buy Stop/Sell Stop orders, with their respective OCO orders. The entry signal is at the bar close of a simple MA crossover. 'Use Attached Orders' is checked in the Trade Window. Put both attached files in your Sierra Chart \Data folder. You may need to change the chart symbol to one your broker uses. Note the formulas in these cells: K3 is the entry formula. M3 references K3. O3 counts the bars since entry. J22 is the Buy Stop price, with a 4 tick offset from the High of the signal bar. J24 is the Sell Stop price, with a 4 tick offset from the Low of the signal bar. J26 is the order quantity. J27 cancels both orders, and their respective OCO orders, if neither the Buy Stop nor Sell Stop orders fill within 2 bars. J71 sets the Buy entry to a Stop order. J73 sets the Sell entry to a Stop order. J78 cancels the remaining working entry and its OCO orders, when one direction gets filled. Note: This is not a profitable autotrader; it is only intended to be used as an example. Date Time Of Last Edit: 2019-10-13 23:26:56
|
 Bracketed entry.scss - Attached On 2018-09-04 18:02:18 UTC - Size: 68.03 KB - 477 views Bracketed entry.Cht - Attached On 2018-09-04 18:02:28 UTC - Size: 39.26 KB - 445 views |