Login Page - Create Account

Support Board


Date/Time: Tue, 25 Feb 2025 00:55:50 +0000



Post From: "Cancel an Unfilled Order After n Bars" prevents from placing the limit order

[2021-03-23 17:11:39]
Trade-Mekoome - Posts: 7
Hello!
I'm teaching and testing spreadsheet trading system and have some issue:

I created a rule for Sale entry in M3 cell
Changed "Sell entry order type" to L J73 cell
Added rule to "Limit or Stop Price - Sell Entry (M)" in J24 (E3+0.4) or last price + 0.4

Everything works fine on test - after sale entry alert appering Limit order is being placed by last price + 0.4 - GOOD.

But I need those orders to automatically cancel after 10 bars and I did like it was written in your manual here:
Spreadsheet Example Formulas and Usage: Cancel an Unfilled Order After n Bars

added to Q3 : =IF (M3, 1, Q4 + 1)
and to J27: =OR(AND(P4 >= H4 + 1, J4 > 0), AND(Q4 >= H4 + 1, J4 < 0))
and to H4 added 10

And nothing works. Sale entry rule working and shows arrows on chart, but no any order is being placed, just like there is no any rule to place an order. I even can not place any order manually from Chart DOM - nothing happens when I press the button.
When I delete the rule from Q3 OR change "Sell entry order type" to M in J73 cell everithing returns to work - orders are being placed at Market price.

I use Volume per bar chart

Please tell me what is wrong, because I can not test the system at all.