Excel & VBA

A list of Excel & VBA projects that Gavin has completed.

• Year 2009
  • Trade Reconciliation - Reconcile trades from two settlement systems.
  • Ledger Position Transfer - Transfer the initial position from the old system to the new one.
  • Ledger Translation - Translate manual journal to a new format based on account mapping rules.
  • Trade Feeder - Feed trades into settlement system in bulk.
• Year 2010
  • Thailand conversion tagging - Find the foreign/local conversion (a knapsack problem), tag the client trades with conversion types and quantities.
  • Korea regulatory reconciliation - Daily reconciliation to make sure client trades in our system is consistent with regulatory system.