[ts-gen] Unique Identifier for Orders
kfmfe04 at gmail.com
Wed Sep 9 21:10:02 EDT 2009
I'd like to open a discussion of unique identifiers for orders.
I thought I understood order_tag to be a shim-wide identifier for
orders so I tried to surmise the next order_tag by SELECT
MAX(order_tag)+1 - I was a little surprised today to see order_tag go
back to 1 when I upgraded to 090904 - I was expecting 57. It looks
like a change in client_id from 8 to 4 may have been the culprit.
Ultimately, what I am trying to grasp is the unique order identifier
at these three levels:
1. My signal generator (my responsibility)
2. Shim - looks like order_id
3. TWS/IB - probably something other than order_id
I need to tie together all three order_id's in a one-to-one-to-one
relationship, or I will get myself in trouble. In particular, I care
about binding 1. to 2. carefully as my signal generator will generate
a row in MySQL before the Shim generates an order_id so I have a
little bit of a chicken-and-egg problem here (hence my hacky SELECT
Thanks in advance.
More information about the ts-general