Support Board

Date/Time: Mon, 06 May 2024 16:10:25 +0000

Post From: Spreadsheet question . place limit order if not fill market order

[2018-07-19 10:27:10] Link To Thread - Link To Post [Go To First Post]
User651753 - Posts: 77
I am trying to use the spreadsheet order to place a limit order if it hasn't been filled in X Time ( 15 min or 15 x 1 min candle) cancel the order and market open example = 1 min chart P3 = Count since the first trigger buy order J71 = if(p3=15,"M","L") spreadsheet setting "Reset condition on new bar" = YES I kinda got it to work - however, I place an order $2 lower than current Bid price, every min it deletes and replaces a new order at a NEW price $2 from the candle open price after 15 x 1 min candle it will change the 16th order as a market buy if I turn off "Reset condition on new bar" = NO - it will only place the first order, leaving it there ( doesn't market buy) i have also tried adding canceling all order on the 16th candle with J78 = if(p3=15,1,0) How could i get it to do the same thing, just leave a buy order for 15 min, on the 16th min replace that order with a market order?