Support Board
Date/Time: Tue, 04 Feb 2025 22:03:55 +0000
[Programming Help] - BUY Limit Order ABOVE CURRENT MARKET & SELL LIMIT Order BELOW CURRENT MARKET
View Count: 2091
| [2020-02-16 04:15:33] |
| User355030 - Posts: 163 |
|
I am trying to have my automated spreedsheet trading system place limit orders above/below current price levels. For example, BUY Limit Order ABOVE CURRENT MARKET & SELL LIMIT Order BELOW CURRENT MARKET. I am having trouble achieving this..
|
| [2020-02-16 10:22:28] |
| |
|
This is going to be easier to do with ACSIL because there is a specific order type that supports this. Refer to: Automated Trading From an Advanced Custom Study Order Types: OCO Buy Limit Sell Limit Really not sure how you would accomplish something like this using the Spreadsheet System for Trading study. 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:23:26
|
| [2020-02-16 15:41:35] |
| User355030 - Posts: 163 |
|
Not having this functionality in the spreadsheet trading system is disappointing... Anyway we can add it? Maybe a “buy limit stop” & “sell limit stop” as an order entry type.
|
| [2020-02-16 15:56:40] |
| User355030 - Posts: 163 |
|
Maybe you can help me achieve my end goal with a different functionality currently available. My formula is "=AND(CROSSFROMABOVE(ID0.SG4@3:ID0.SG4@4,ID1.SG7@3:ID1.SG7@4),AND(U3<=-1,V3<=-1))" where "U" and "V" are determining the slope of "ID1.SG7" I need to somehow add logic that says when the above formula triggers I want to buy if price crosses through the high of the bar that triggered that logic (Essentially the bar that "Crossed from Above". If we had the buy limit stop functionality I was just going to set my limit order at the high of the previous bar using the "Highest High/Lowest Low" study. |
| [2020-02-17 15:10:13] |
| User355030 - Posts: 163 |
|
@tomgilb
|
| [2020-02-17 15:54:27] |
| Sawtooth - Posts: 4166 |
|
The Spreadsheet System for Trading study has the ability to place a: Buy Limit below current price, where price would retrace to enter long. Buy Stop above current price, where price would breakout to enter long. Sell Limit above current price, where price would retrace to enter short. Sell Stop below current price, where price would breakdown to enter short. Your example sounds like you want to use a Buy Stop entry. When using Stop entries in the Spreadsheet System for Trading study: - the entry signal is in K3/M3. - the Stop price is in J22/J24. You will reference J21 for an offset, if needed, like this (previous High minus 2 ticks): =C4-J21*2 - the Order Type is in J71/J73. Spreadsheet Systems, Alerts and Automated Trading: Limit or Stop Prices [J22, J23, J24, J25] Spreadsheet Systems, Alerts and Automated Trading: Buy Entry: Order Type [J71] You'll also need a way to cancel an unfilled order. Here are a couple of examples: Spreadsheet Example Formulas and Usage: Cancel Unfilled Working Order n Minutes After Entry Spreadsheet Example Formulas and Usage: Cancel an Unfilled Order After n Bars |
| [2020-02-18 01:23:44] |
| User355030 - Posts: 163 |
|
Thank you Tom!
|
To post a message in this thread, you need to log in with your Sierra Chart account: