The Lab

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Reflector tracks positions in two (2) separate places:

In the first instance, Reflector tracks the position using the actual runtime and in the second instance in an execution database. The runtime version tracks open orders in addition to executed fills, but is heavily optimized for latency. This means every possible effort to reduce memory usage is employed. At the end of the trading day, the process does not know how much to roll over.

...


Reflector begins by identifying the user account, before connecting to the fill database. Reflector will then identify the relevant schema for the user before running a query for the entire set of fills (belonging to the credentials of the user that are valid and have not expired) an example of what such results may look like is displayed in the table (1)below.
 

Table (1) 

exec_idcredential_idseq_numinternalvaliditybuy_ccysell_ccybuy_amtsell_amttrade_datesettle_datevenue_namecomp_idtakerclient_idexpires_at_settlement
1232174119ftNZDEUR60114.96360002017012420170130FIX_Venue76000/109331True6792True
12342174172ftNZDEUR83491.5500002017012420170130FIX_Venue76000/109331True6792True
123452174284ftNZDEUR417382.52500002017012420170130FIX_Venue76000/109331True6792True
1234562174293ftNZDEUR83476.5500002017012420170130FIX_Venue76000/109331True6792True
12345672174294ftNZDEUR2504281500002017012420170130FIX_Venue76000/109331True6792True
123456782174737ftNZDEUR1017186.56050002017012420170130FIX_Venue76000/109331True6792True

...