Support Board
Date/Time: Tue, 16 Sep 2025 08:59:44 +0000
Post From: Programming a Limit Order Entry with Tick Offset
| [2020-02-09 18:27:39] |
| Sawtooth - Posts: 4263 |
|
When using Limit entries in the Spreadsheet System for Trading study: - the entry signal is in K3/M3. - the Limit price is in J22/J24. You will reference J21 for the offset, 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 (read/write) [[v1:J22,v2:J78], [v1:J23,v2:J79], [v1:J24,v2:J80], [v1:J25,v2:J81] Spreadsheet Systems, Alerts and Automated Trading: Buy Entry: Order Type (read/write) [v1:J71, v2:J73] 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 Date Time Of Last Edit: 2020-02-09 18:47:20
|