Login Page - Create Account

Support Board


Date/Time: Sat, 11 May 2024 10:41:45 +0000



Post From: BUY Limit Order ABOVE CURRENT MARKET & SELL LIMIT Order BELOW CURRENT MARKET

[2020-02-17 15:54:27]
Sawtooth - Posts: 3995
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