Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 19:39:09 +0000



Post From: Spreadsheet Trading : Order Canceled on next tick

[2024-02-14 00:49:09]
User656492 - Posts: 143
Hi Team SC:

I have a spreadsheet which seems to be behaving as expected MOST of the time but there is one trade which is most strange.

While back testing using "Calculate at every tick", there is one buy order which gets placed correctly, but then immediately gets canceled on the next chart update. This happens every time I run this back test.

Some additional info:

There is no competing sell order.

Cells J3 and J4 both go from 0 to 1 for a moment when K3 initially = 1, then they both go to zero when the order disappears, but K3 is still = 1.

Since this is mostly working correctly, I'm at a loss to identify why this particular order is being placed on the chart and then immediately canceled.

Any thoughts?