Login Page - Create Account

Support Board


Date/Time: Tue, 11 Mar 2025 16:54:40 +0000



[User Discussion] - Spreadsheet System, possible to enter more trades but NOT add to existing order?

View Count: 457

[2022-04-23 00:52:31]
j4ytr4der_ - Posts: 946
I'm working on a spreadsheet system, that sometimes gets multiple signals at different prices in the same direction. This is trading using order flow, so I would like to take all the signals. The problem is that it will ALSO add again when price gets to re-triggering an existing, working order. I'll describe a working example.

My system has a short bias and is looking for short entries. Price bounces up and triggers a signal and a short sell stop order is placed below, but not filled yet as price continues moving up. Price tops out, and begins to come down, and another signal is given, and a short order is placed and filled. Now price continues to fall, reaching the spot where the first signal was given, which causes a second order to be placed in the same place as the one that's already there. This means I get filled doubly when price passes through that order.

I hope that makes sense. I would like to be able to place as many orders as there are signals, but not place an order where one is already sitting. Can this be done in a spreadsheet?
Date Time Of Last Edit: 2022-04-23 01:56:10
[2022-04-23 12:31:55]
Sawtooth - Posts: 4182
I would like to be able to place as many orders as there are signals, but not place an order where one is already sitting. Can this be done in a spreadsheet?
There would be no easy way to do this, if there is even a way to do it.

One way would be to cancel the pending order if price moves more n ticks against you, or if some other condition occurs.
[2022-04-23 14:29:37]
j4ytr4der_ - Posts: 946
Yes I already do that if price moves beyond N ticks from an unfilled order, but I don't want to remove the existing order if another signal is fired within that range... that's the whole point, to leave it alone, because the signal that generated it won't be valid anymore when price comes back to it again, so the order needs to already be there.

Oh well, this was an improvement to what I'm working on, I will probably just have to abandon it. A shame for sure but... such is life. Thanks Tom!

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account