Support Board
Date/Time: Tue, 21 Jan 2025 04:08:44 +0000
Post From: Spreadsheet question . place limit order if not fill market order
| [2018-07-20 05:40:21] |
| Sawtooth - Posts: 4157 |
|
Assuming 'Signal Only On Bar Close' is Yes, and you are using 1 min bars, your K3 formula would look something like this: =OR(limitordercondition,AND(P3=16,$J$4>0)) Column P will start an incrementing count from 1 when the Limit order is placed. Column K will have a 1 at the Limit entry, then zeros until P3 is 16 where it will have a 1 again. The unfilled Limit order is cancelled in the 15th bar, and the Market order is placed at the open of the 16th bar. Obviously I haven't tested this, but this is the concept. Date Time Of Last Edit: 2018-07-20 05:41:24
|