Trading-shim is a database driven connector API that provides a persistent store SQL backend database.

Trading-shim is a database driven connector API that provides a persistent store SQL backend database.

The trading shim is a command-line and dbms controlled interface to the socket-based API of Interactive Brokers' Trader Workstation, abbreviated as the IB tws socket api, or simply tws api. That api has a number of advantages for our purposes, including the freely available Trader Workstation, comprehensive feeds and archives for tick and history data, a paper account ideal for software testing, and low transaction costs.

The downstream drives the shim by making changes to the database. The shim consults the database at initial startup, and from time to time thereafter when signalled by brief, simple commands. This combination of database and shim integrate persistent database storage with the tws. The command interface also serves as an alternative to the existing tws gui interfaces, to permit you to use downstream programs, whether gui or not, to drive the tws through its api.

The shim is written in C , and though developed on Linux, should run on any modern Unix-like platform. It's free software; we've released the trading shim in source form under the GNU General Public License in order to reach the widest possible community of users.

What's New in This Release:

￭ The project is almost feature complete, with nearly all functional elements implemented, on the road to moving the project out of Beta status, and into a formal production-ready stable API and database layout.
￭ Initialization defaults were modified.
￭ The Document HistoryBar database table was unloaded and restored. Bulletin exchange parsing was extended. 64-bit memory handling was partially cleaned up.
￭ A currency type checking bug was fixed.
￭ The multiple data mode ClientID connection logic was automated.