Final Order status

Shabari

Hi,

How can I get the last update on the order. I'm trying to place a SL/Target order after checking the status of previous buy order. When I use below code to check the status after 20sec delay.
time.sleep(20)
print(oid)
order_history = kite.order_history(oid)
print(order_history)
order_status = pd.DataFrame(order_history)
order_status = order_status['status'].iloc[0]
print("Order Status:", order_status)

getting below list of all the status stages start from 'order received' till 'completed. and order_status is picking initial status only.

[{'account_id': 'XXXXX', 'placed_by': 'XXXXX', 'order_id': '241216000712759', 'exchange_order_id': None, 'parent_order_id': None, 'status': 'PUT ORDER REQ RECEIVED', 'status_message': None, 'status_message_raw': None, 'order_timestamp': datetime.datetime(2024, 12, 16, 10, 39), 'exchange_update_timestamp': None, 'exchange_timestamp': None, 'variety': 'regular', 'modified': False, 'exchange': 'NFO', 'tradingsymbol': 'NIFTY24D1924750CE', 'instrument_token': 12139778, 'order_type': 'LIMIT', 'transaction_type': 'BUY', 'validity': 'IOC', 'validity_ttl': 0, 'product': 'MIS', 'quantity': 50, 'disclosed_quantity': 0, 'price': 139.55, 'trigger_price': 0, 'average_price': 0, 'filled_quantity': 0, 'pending_quantity': 50, 'cancelled_quantity': 0, 'market_protection': 0, 'meta': {}, 'tag': None, 'guid': '129062XQJwM3ZCs7rlI'}, {'account_id': 'XXXXX', 'placed_by': 'XXXXX', 'order_id': '241216000712759', 'exchange_order_id': None, 'parent_order_id': None, 'status': 'VALIDATION PENDING', 'status_message': None, 'status_message_raw': None, 'order_timestamp': datetime.datetime(2024, 12, 16, 10, 39), 'exchange_update_timestamp': None, 'exchange_timestamp': None, 'variety': 'regular', 'modified': False, 'exchange': 'NFO', 'tradingsymbol': 'NIFTY24D1924750CE', 'instrument_token': 12139778, 'order_type': 'LIMIT', 'transaction_type': 'BUY', 'validity': 'IOC', 'validity_ttl': 0, 'product': 'MIS', 'quantity': 50, 'disclosed_quantity': 0, 'price': 139.55, 'trigger_price': 0, 'average_price': 0, 'filled_quantity': 0, 'pending_quantity': 50, 'cancelled_quantity': 0, 'market_protection': 0, 'meta': {}, 'tag': None, 'guid': '129062XQJwM3ZCs7rlI'}, {'account_id': 'XXXXX', 'placed_by': 'XXXXX', 'order_id': '241216000712759', 'exchange_order_id': None, 'parent_order_id': None, 'status': 'OPEN PENDING', 'status_message': None, 'status_message_raw': None, 'order_timestamp': datetime.datetime(2024, 12, 16, 10, 39), 'exchange_update_timestamp': None, 'exchange_timestamp': None, 'variety': 'regular', 'modified': False, 'exchange': 'NFO', 'tradingsymbol': 'NIFTY24D1924750CE', 'instrument_token': 12139778, 'order_type': 'LIMIT', 'transaction_type': 'BUY', 'validity': 'IOC', 'validity_ttl': 0, 'product': 'MIS', 'quantity': 50, 'disclosed_quantity': 0, 'price': 139.55, 'trigger_price': 0, 'average_price': 0, 'filled_quantity': 0, 'pending_quantity': 50, 'cancelled_quantity': 0, 'market_protection': 0, 'meta': {}, 'tag': None, 'guid': '129062XQJwM3ZCs7rlI'}, {'account_id': 'XXXXX', 'placed_by': 'XXXXX', 'order_id': '241216000712759', 'exchange_order_id': '1300000060066380', 'parent_order_id': None, 'status': 'OPEN', 'status_message': None, 'status_message_raw': None, 'order_timestamp': datetime.datetime(2024, 12, 16, 10, 39), 'exchange_update_timestamp': '2024-12-16 10:39:00', 'exchange_timestamp': datetime.datetime(2024, 12, 16, 10, 39), 'variety': 'regular', 'modified': False, 'exchange': 'NFO', 'tradingsymbol': 'NIFTY24D1924750CE', 'instrument_token': 12139778, 'order_type': 'LIMIT', 'transaction_type': 'BUY', 'validity': 'IOC', 'validity_ttl': 0, 'product': 'MIS', 'quantity': 50, 'disclosed_quantity': 0, 'price': 139.55, 'trigger_price': 0, 'average_price': 0, 'filled_quantity': 0, 'pending_quantity': 50, 'cancelled_quantity': 0, 'market_protection': 0, 'meta': {}, 'tag': None, 'guid': '129062XQJwM3ZCs7rlI'}, {'account_id': 'XXXXX', 'placed_by': 'XXXXX', 'order_id': '241216000712759', 'exchange_order_id': '1300000060066380', 'parent_order_id': None, 'status': 'COMPLETE', 'status_message': None, 'status_message_raw': None, 'order_timestamp': datetime.datetime(2024, 12, 16, 10, 39), 'exchange_update_timestamp': '2024-12-16 10:39:00', 'exchange_timestamp': datetime.datetime(2024, 12, 16, 10, 39), 'variety': 'regular', 'modified': False, 'exchange': 'NFO', 'tradingsymbol': 'NIFTY24D1924750CE', 'instrument_token': 12139778, 'order_type': 'LIMIT', 'transaction_type': 'BUY', 'validity': 'IOC', 'validity_ttl': 0, 'product': 'MIS', 'quantity': 50, 'disclosed_quantity': 0, 'price': 139.55, 'trigger_price': 0, 'average_price': 139.25, 'filled_quantity': 50, 'pending_quantity': 0, 'cancelled_quantity': 0, 'market_protection': 0, 'meta': {}, 'tag': None, 'guid': '129062XQJwM3ZCs7rlI'}]

Order Status: PUT ORDER REQ RECEIVED

psnbaba

No need to convert to dataframe try this

orderstatus = order_history[-1]['status']

if this is COMPLETE then go ahead

sujith

You seem to be fetching the order it history, it contains all the states the order has gone through in the system. For latest order status, you need to check the last item in the list. You may go through documentation to know more.

ANL

@sujith I have not tried polling for order updates; WS is out of order, so polling is also out of order?
eg: If we use this approach, history[-1]['status'], will I get the latest order status in an exact order?

sujith

@ANL,

@sujith I have not tried polling for order updates; WS is out of order, so polling is also out of order?

I didn't get you. Can you elaborate?

eg: If we use this approach, history[-1]['status'], will I get the latest order status in an exact order?

Yes, the last item in the order history gives you the latest status of the order. You may also fetch orderbook and find by order_id and check the status.

ANL

@sujith

I didn't get you. Can you elaborate?

Out of order/async status updates in WS on_order_updates, so I wanted to know that the polling order updates are out of order like on_order_updates.

orderstatus = order_history[-1]['status']
If fetching the order book and retrieving the last dict values are considered as the latest and in the exact order and no async like Ws on_order_update. I have noticed an out of order issue while polling order status today after 3 pm.

1 . Is WS on_order_update faster than the conventional polling method? Or both are updating at the same time?
2. Is there any possibility of having a flakeout while polling for order updates?
3. Is it possible to depreciate the polling method in the future, as I am considering switching from WS order updates to conventional polling for certain use cases?