order status for parallel database

I am trying to achieve the following:
1. Create a parallel database of orders containing certain specific fields including symbol, order id and status. In my database, status of an order is either open or close.
2. This database is for 3 separate strategies, which might or might not have the same trading symbols.
3. Now after every 30 seconds, I wish to update the status(Open/closed) in my own database.
4. Finding this status, through the order id, generated while entering the trade, is a problem.
I can't even use the symbol to find if opposite trade has been executed or not as the same symbol might have been executed for an opposite trade at some other price by the different strategy.
Kindly guide as to how can I overcome this issue.
Sign In or Register to comment.