24-04-2023 13:45:05====================================== Checked order for cancell ---230424000362300 cancel order with 230424000362300 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230424000362300' make buy order of 230424000357782 ---{"tradingsymbol":"NIFTY23APR17650CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order 230424002488796 --- Checked order for cancell ---230424000362884 cancel order with 230424000362884 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230424000362884' make buy order of 230424000357782 ---{"tradingsymbol":"NIFTY23APR17650CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order 230424002489148 --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 25-04-2023 12:12:03====================================== Checked order for cancell ---230425000367325 cancel order with 230425000367325 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230425000367325' Checked order for cancell ---230425000367491 cancel order with 230425000367491 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230425000367491' make buy order of 230425000365420 ---{"tradingsymbol":"NIFTY23APR17750CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230425001957767', 0, 25, 'COMPLETE', '2023-04-25 12:12:01') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 25-04-2023 15:04:04====================================== Checked order for cancell ---230425003287002 cancel order with 230425003287002 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230425003287002' Checked order for cancell ---230425003287062 cancel order with 230425003287062 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230425003287062' make buy order of 230425003286215 ---{"tradingsymbol":"NIFTY23APR17800CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230425003624003', 0, 25, 'COMPLETE', '2023-04-25 15:04:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 25-04-2023 15:08:04====================================== Checked order for cancell ---230425003655554 cancel order with 230425003655554 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230425003655554' Checked order for cancell ---230425003655633 cancel order with 230425003655633 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230425003655633' make buy order of 230425003654727 ---{"tradingsymbol":"NIFTY23APR17800CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230425003665295', 0, 25, 'COMPLETE', '2023-04-25 15:08:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 25-04-2023 15:10:03====================================== ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 26-04-2023 10:07:03====================================== Checked order for cancell ---230426000368813 cancel order with 230426000368813 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230426000368813' Checked order for cancell ---230426000369042 cancel order with 230426000369042 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230426000369042' make buy order of 230426000366218 ---{"tradingsymbol":"NIFTY23APR17750CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230426000892323', 0, 25, 'COMPLETE', '2023-04-26 10:07:01') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 26-04-2023 11:43:04====================================== ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 26-04-2023 11:44:03====================================== ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 27-04-2023 13:08:04====================================== Checked order for cancell ---230427000421834 cancel order with 230427000421834 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230427000421834' Checked order for cancell ---230427000422022 cancel order with 230427000422022 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230427000422022' make buy order of 230427000418668 ---{"tradingsymbol":"NIFTY2350417850CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230427002590093', 0, 25, 'COMPLETE', '2023-04-27 13:08:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 27-04-2023 14:39:04====================================== Checked order for cancell ---230427002949131 cancel order with 230427002949131 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230427002949131' Checked order for cancell ---230427002949299 cancel order with 230427002949299 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230427002949299' make buy order of 230427002948253 ---{"tradingsymbol":"NIFTY2350417900CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230427003774014', 0, 25, 'COMPLETE', '2023-04-27 14:39:01') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 28-04-2023 10:11:03====================================== Checked order for cancell ---230428000377876 cancel order with 230428000377876 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230428000377876' Checked order for cancell ---230428000378082 cancel order with 230428000378082 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230428000378082' make buy order of 230428000374551 ---{"tradingsymbol":"NIFTY2350417900CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230428000836607', 0, 25, 'COMPLETE', '2023-04-28 10:11:01') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 28-04-2023 12:46:04====================================== Checked order for cancell ---230428001509467 cancel order with 230428001509467 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230428001509467' Checked order for cancell ---230428001509525 cancel order with 230428001509525 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230428001509525' make buy order of 230428001508957 ---{"tradingsymbol":"NIFTY2350417950CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230428001916592', 0, 25, 'COMPLETE', '2023-04-28 12:46:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 28-04-2023 14:13:03====================================== Checked order for cancell ---230428002073126 cancel order with 230428002073126 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230428002073126' Checked order for cancell ---230428002073160 cancel order with 230428002073160 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230428002073160' make buy order of 230428002072793 ---{"tradingsymbol":"NIFTY2350418000CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230428002398582', 0, 25, 'COMPLETE', '2023-04-28 14:13:01') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 28-04-2023 15:08:04====================================== Checked order for cancell ---230428002593445 cancel order with 230428002593445 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230428002593445' Checked order for cancell ---230428002593499 cancel order with 230428002593499 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230428002593499' make buy order of 230428002592839 ---{"tradingsymbol":"NIFTY2350418000CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230428002891483', 0, 25, 'COMPLETE', '2023-04-28 15:08:01') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 02-05-2023 09:32:04====================================== Checked order for cancell ---230502000440607 cancel order with 230502000440607 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230502000440607' Checked order for cancell ---230502000441067 cancel order with 230502000441067 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230502000441067' make buy order of 230502000436636 ---{"tradingsymbol":"NIFTY2350418150CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230502000490419', 0, 25, 'COMPLETE', '2023-05-02 09:32:01') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 02-05-2023 14:04:04====================================== Checked order for cancell ---230502001542121 cancel order with 230502001542121 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230502001542121' Checked order for cancell ---230502001542174 cancel order with 230502001542174 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230502001542174' make buy order of 230502001541495 ---{"tradingsymbol":"NIFTY2350418150CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230502002807715', 0, 25, 'COMPLETE', '2023-05-02 14:04:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 03-05-2023 10:47:04====================================== Called cancel all order fun 03-05-2023 10:48:05====================================== Called cancel all order fun 03-05-2023 10:49:04====================================== Called cancel all order fun 03-05-2023 10:50:05====================================== Called cancel all order fun 03-05-2023 10:51:04====================================== Called cancel all order fun 03-05-2023 10:53:04====================================== Called cancel all order fun 03-05-2023 10:55:05====================================== Called cancel all order fun 03-05-2023 10:56:04====================================== Called cancel all order fun 03-05-2023 10:57:04====================================== Called cancel all order fun 03-05-2023 10:58:05====================================== Called cancel all order fun 03-05-2023 10:59:04====================================== Called cancel all order fun 03-05-2023 11:00:05====================================== Called cancel all order fun 03-05-2023 11:01:05====================================== Called cancel all order fun 03-05-2023 11:02:05====================================== Called cancel all order fun 03-05-2023 12:23:05====================================== Called cancel all order fun 03-05-2023 12:24:04====================================== Called cancel all order fun 03-05-2023 12:25:05====================================== Checked order for cancell ---230503000421300 cancel order with 230503000421300 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230503000421300' Checked order for cancell ---230503000421571 cancel order with 230503000421571 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230503000421571' make buy order of 230503000417530 ---{"tradingsymbol":"NIFTY2350418050CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230503002045738', 0, 25, 'COMPLETE', '2023-05-03 12:25:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 03-05-2023 13:06:04====================================== Checked order for cancell ---230503002072735 cancel order with 230503002072735 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230503002072735' Checked order for cancell ---230503002072774 cancel order with 230503002072774 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230503002072774' make buy order of 230503002072271 ---{"tradingsymbol":"NIFTY2350418100CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230503002340168', 0, 25, 'COMPLETE', '2023-05-03 13:06:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 03-05-2023 13:54:04====================================== Checked order for cancell ---230503002370813 cancel order with 230503002370813 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230503002370813' Checked order for cancell ---230503002370881 cancel order with 230503002370881 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230503002370881' make buy order of 230503002370160 ---{"tradingsymbol":"NIFTY2350418100CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230503002702201', 0, 25, 'COMPLETE', '2023-05-03 13:54:01') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 04-05-2023 11:15:05====================================== Checked order for cancell ---230504000424382 cancel order with 230504000424382 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230504000424382' Checked order for cancell ---230504000424562 cancel order with 230504000424562 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230504000424562' make buy order of 230504000421779 ---{"tradingsymbol":"NIFTY2351118100CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230504001579052', 0, 25, 'COMPLETE', '2023-05-04 11:15:03') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 04-05-2023 13:07:04====================================== Checked order for cancell ---230504001607276 cancel order with 230504001607276 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230504001607276' Checked order for cancell ---230504001607386 cancel order with 230504001607386 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230504001607386' make buy order of 230504001606280 ---{"tradingsymbol":"NIFTY2351118150CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230504002587272', 0, 25, 'COMPLETE', '2023-05-04 13:07:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 04-05-2023 14:49:04====================================== Checked order for cancell ---230504002635551 cancel order with 230504002635551 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230504002635551' Checked order for cancell ---230504002635631 cancel order with 230504002635631 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230504002635631' make buy order of 230504002634614 ---{"tradingsymbol":"NIFTY2351118150CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230504003730688', 0, 25, 'COMPLETE', '2023-05-04 14:49:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 05-05-2023 11:52:04====================================== Checked order for cancell ---230505000360445 cancel order with 230505000360445 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230505000360445' Checked order for cancell ---230505000360599 cancel order with 230505000360599 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230505000360599' make buy order of 230505000355726 ---{"tradingsymbol":"NIFTY2351118150CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230505001895431', 0, 25, 'COMPLETE', '2023-05-05 11:52:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 08-05-2023 12:13:04====================================== Called cancel all order fun 08-05-2023 12:32:04====================================== Called cancel all order fun 08-05-2023 12:33:04====================================== Called cancel all order fun 08-05-2023 12:35:04====================================== Called cancel all order fun 08-05-2023 12:36:04====================================== Called cancel all order fun 08-05-2023 12:37:04====================================== Called cancel all order fun 08-05-2023 12:39:05====================================== Called cancel all order fun 08-05-2023 12:40:04====================================== Called cancel all order fun 08-05-2023 12:42:05====================================== Called cancel all order fun 08-05-2023 12:43:04====================================== Called cancel all order fun 08-05-2023 12:44:03====================================== Called cancel all order fun 08-05-2023 12:45:05====================================== Called cancel all order fun 08-05-2023 12:46:04====================================== Called cancel all order fun 08-05-2023 12:47:04====================================== Called cancel all order fun 08-05-2023 12:48:04====================================== Called cancel all order fun 08-05-2023 12:49:05====================================== Called cancel all order fun 08-05-2023 12:50:04====================================== Called cancel all order fun 08-05-2023 12:51:04====================================== Called cancel all order fun 08-05-2023 12:52:05====================================== Checked order for cancell ---230508000724788 cancel order with 230508000724788 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230508000724788' Checked order for cancell ---230508000724913 cancel order with 230508000724913 ---UPDATE rk_nifty_ce_orders_atm SET status = 'CANCELLED' WHERE order_id = '230508000724913' make buy order of 230508000723264 ---{"tradingsymbol":"NIFTY2351118200CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230508002476393', 0, 25, 'COMPLETE', '2023-05-08 12:52:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 09-05-2023 14:32:04====================================== Called cancel all order fun 09-05-2023 14:33:04====================================== Called cancel all order fun 09-05-2023 14:34:03====================================== Checked order for cancell ---230509000466507 cancel order with 230509000466507 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230509000466507' Checked order for cancell ---230509000467253 cancel order with 230509000467253 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230509000467253' make buy order of 230509000464242 ---{"tradingsymbol":"NIFTY2351118300CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, created) VALUES ('230509003773355', 0, 25, 'COMPLETE', '2023-05-09 14:34:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 09:37:04====================================== Called cancel all order fun 10-05-2023 09:38:04====================================== Called cancel all order fun 10-05-2023 09:41:04====================================== Called cancel all order fun 10-05-2023 09:42:03====================================== Called cancel all order fun 10-05-2023 09:43:03====================================== Called cancel all order fun 10-05-2023 09:44:04====================================== Called cancel all order fun 10-05-2023 09:45:03====================================== Called cancel all order fun 10-05-2023 09:46:03====================================== Called cancel all order fun 10-05-2023 09:47:04====================================== Called cancel all order fun 10-05-2023 09:48:04====================================== Called cancel all order fun 10-05-2023 09:49:04====================================== Called cancel all order fun 10-05-2023 09:50:04====================================== Called cancel all order fun 10-05-2023 09:51:04====================================== Called cancel all order fun 10-05-2023 09:52:04====================================== Called cancel all order fun 10-05-2023 09:53:04====================================== Called cancel all order fun 10-05-2023 09:54:03====================================== Called cancel all order fun 10-05-2023 09:55:03====================================== Called cancel all order fun 10-05-2023 09:56:03====================================== Called cancel all order fun 10-05-2023 09:57:04====================================== Called cancel all order fun 10-05-2023 09:58:03====================================== Called cancel all order fun 10-05-2023 09:59:03====================================== Called cancel all order fun 10-05-2023 10:06:05====================================== ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 10:07:05====================================== ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 10:08:04====================================== ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 10:09:04====================================== ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 10:14:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 10:15:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:37:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:38:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:39:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:40:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:41:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:42:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:43:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:44:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:45:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:46:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:47:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:48:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:49:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:50:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:51:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:52:06====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:53:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:54:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:55:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:56:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:57:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:58:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 11:59:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:00:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:01:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:02:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:03:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:04:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:05:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:06:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:07:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:08:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:09:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:10:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:11:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:12:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:13:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:14:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:15:06====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:16:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:17:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:18:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:19:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:20:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:21:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:22:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:23:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:24:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:25:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:26:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:27:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:28:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:29:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:30:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:31:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:32:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:33:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:34:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:35:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:36:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:37:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:38:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:39:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:40:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:41:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:42:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:43:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:44:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:45:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:46:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:47:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:48:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:49:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:50:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:51:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:52:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:53:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:54:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:55:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:56:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:57:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:58:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 12:59:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:00:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:01:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:02:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:03:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:04:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:05:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:06:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:07:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:08:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:09:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:10:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:11:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:12:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:13:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:14:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:15:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:16:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:17:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:18:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:19:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:20:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:21:06====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:22:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:23:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:24:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:25:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:26:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:27:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:28:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 13:29:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 14:30:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 14:31:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 10-05-2023 14:32:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-10' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 11-05-2023 13:34:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-11' AND order_status = 0 Checked order for cancell ---230511000470734 cancel order with 230511000470734 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230511000470734' Checked order for cancell ---230511000470929 cancel order with 230511000470929 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230511000470929' make buy order of 230511000468376 ---{"tradingsymbol":"NIFTY2351818300CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, order_status, created) VALUES ('230511003295888', 0, 25, 'COMPLETE', 1, '2023-05-11 13:34:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 11-05-2023 14:27:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-11' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 11-05-2023 14:28:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-11' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 11-05-2023 14:29:02====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-11' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 11-05-2023 14:30:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-11' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 11-05-2023 14:31:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-11' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 11-05-2023 14:32:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-11' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 11-05-2023 14:36:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-11' AND order_status = 0 Checked order for cancell ---230511004026893 cancel order with 230511004026893 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230511004026893' Checked order for cancell ---230511004027005 cancel order with 230511004027005 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230511004027005' make buy order of 230511004025616 ---{"tradingsymbol":"NIFTY2351818300CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, order_status, created) VALUES ('230511004060974', 0, 25, 'COMPLETE', 1, '2023-05-11 14:36:01') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 12-05-2023 12:32:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-12' AND order_status = 0 Checked order for cancell ---230512000713431 cancel order with 230512000713431 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230512000713431' Checked order for cancell ---230512000713547 cancel order with 230512000713547 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230512000713547' make buy order of 230512000712326 ---{"tradingsymbol":"NIFTY2351818200CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, order_status, created) VALUES ('230512001922437', 0, 25, 'COMPLETE', 1, '2023-05-12 12:32:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 12-05-2023 12:35:03====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-12' AND order_status = 0 ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 12-05-2023 12:37:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-12' AND order_status = 0 Checked order for cancell ---230512001949371 cancel order with 230512001949371 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230512001949371' Checked order for cancell ---230512001949420 cancel order with 230512001949420 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230512001949420' make buy order of 230512001948726 ---{"tradingsymbol":"NIFTY2351818300CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, order_status, created) VALUES ('230512001954470', 0, 25, 'COMPLETE', 1, '2023-05-12 12:37:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 15-05-2023 12:42:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-15' AND order_status = 0 Checked order for cancell ---230515000741891 cancel order with 230515000741891 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230515000741891' Checked order for cancell ---230515000741966 cancel order with 230515000741966 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230515000741966' make buy order of 230515000741003 ---{"tradingsymbol":"NIFTY2351818350CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, order_status, created) VALUES ('230515001904007', 0, 25, 'COMPLETE', 1, '2023-05-15 12:42:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 16-05-2023 12:45:04====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-16' AND order_status = 0 Checked order for cancell ---230516000435674 cancel order with 230516000435674 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230516000435674' Checked order for cancell ---230516000435889 cancel order with 230516000435889 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230516000435889' make buy order of 230516000433227 ---{"tradingsymbol":"NIFTY2351818400CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, order_status, created) VALUES ('230516002301406', 0, 25, 'COMPLETE', 1, '2023-05-16 12:45:01') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 16-05-2023 14:48:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-16' AND order_status = 0 Checked order for cancell ---230516002433428 cancel order with 230516002433428 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230516002433428' Checked order for cancell ---230516002433551 cancel order with 230516002433551 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230516002433551' make buy order of 230516002431999 ---{"tradingsymbol":"NIFTY2351818350CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, order_status, created) VALUES ('230516003329955', 0, 25, 'COMPLETE', 1, '2023-05-16 14:48:02') --- ============= close order done !!!!!!!!!1 ============== Called cancel all order fun 17-05-2023 13:00:05====================================== ====================================== select query >>> SELECT * FROM rk_nifty_ce_orders_atm WHERE (status != 'COMPLETE' AND status != 'CANCELLED') AND DATE(created) = '2023-05-17' AND order_status = 0 Checked order for cancell ---230517002233601 cancel order with 230517002233601 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230517002233601' Checked order for cancell ---230517002233673 cancel order with 230517002233673 ---UPDATE rk_nifty_ce_orders_atm SET order_status = 1, status = 'CANCELLED' WHERE order_id = '230517002233673' make buy order of 230517002232939 ---{"tradingsymbol":"NIFTY2351818150CE","exchange":"NFO","quantity":50,"transaction_type":"BUY","order_type":"MARKET","product":"MIS"} insert buy order ========== INSERT INTO rk_nifty_ce_orders_atm (order_id, parent_order_id, quantity, status, order_status, created) VALUES ('230517002514477', 0, 25, 'COMPLETE', 1, '2023-05-17 13:00:03') --- ============= close order done !!!!!!!!!1 ==============