Login Page - Create Account

Support Board


Date/Time: Sun, 28 Apr 2024 01:10:38 +0000



[Programming Help] - BUY Limit Order ABOVE CURRENT MARKET & SELL LIMIT Order BELOW CURRENT MARKET

View Count: 1715

[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]
Sierra Chart Engineering - Posts: 104368
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: 3980
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:

Login

Login Page - Create Account