Login Page - Create Account

Support Board


Date/Time: Fri, 30 May 2025 03:28:05 +0000



Post From: Auto placing a limit order away from price based on alert condition

[2020-11-30 20:03:33]
Sawtooth - Posts: 4221
Any idea how i place the order x ticks away from price using that?
- The entry signals are in cells K3/M3. Use a formula like this: =CROSSFROMBELOW(E3:E4,ID1.SG1@3:ID1.SG1@4)
where the MA is ID1. Note: spreadsheet syntax is different than Simple Alert syntax.
This will go TRUE when the current price crosses the MA from below, compared to the previous bar.
Spreadsheet Systems, Alerts and Automated Trading: BuyEntry (K), BuyExit (L), SellEntry (M), SellExit (N) Spreadsheet Order Action Columns

- The Limit prices are in cells J22/J24. Use a formula like this: =E3+J21*2
where E3 is the current/close price, and J21 is the ticksize.
Spreadsheet Systems, Alerts and Automated Trading: Limit or Stop Prices [J22, J23, J24, J25]
Spreadsheet Systems, Alerts and Automated Trading: Tick Size (Read-only) [J21]

- The order types are in cells J71/J73. Set both to L.
Spreadsheet Systems, Alerts and Automated Trading: Buy Entry: Order Type [J71]