Updates to model removed Trade and replace with TradePosition. So new model is:
Contract oneToMany TradePosition oneToMany TradeOrder
Tradestrategy oneToMany TradeOrder.
Note
1/ There can only ever be one TradePosition open at a time for a Contract.
2/ A TradePosition is created when at least one TradeOrder becomes filled/partially filled. The TradeOrder that caused the TradePosition to be created is marked as the opening TradeOrder.
3/ A TradePosition is closed when the totaly open quantity i.e. buy quantity - sell quantity equals zero. At this point the net value represents the P/L for the position.

2.11_06 version out tomorrow new data model see below. Removed Trade table replaced with TradePosition so Tradestrategy creates oneToManat TradeOrder a TradeOrder may have One TradePosition that is for One Contract

2.11 build now avaialbe this build handle FA account holders. It also allows submission of FA orders.

1/ Altered database, Tradestrategy ManyToOne Portfolio ManyToMany Account. The Portfolio table now represents a group of accounts. This allows Profiles/Groups from IB TWS to be loaded at login into the Portfolio table. Portfolio AllocationMethod details the distribution of a position across Accounts.
2/ Configuration Tab allows configuration of Portfolio/Account relationship. Note for individual accounts this is OneToOne for FA accounts this should be managed in IB TWS.

Thanks
Simon

TradeManager 2.10 released

This release now has support for FA Accounts. On login accounts are download to the Trademanager and stored in the DB. If the accountType is CORPORATION then the Alias/Profile and Group details are requested and stored. This allows for manual order (see Contract Tab orders panel) & strategies to submit orders for a Profile or Group. If Profile or Group is not specified then the account assigned on the Trading Tab is used.

Changes to the DB are :
TradeAccount table and new tables FinancialAccount oneTomany AllocationAccount (note these are IB TWS specific)

In a future release I will probably replace the TradeAccount with a Portfolio (acts as a group/profile holder) and so the model would read
Tradestrategy manyToone Portfolio manyTomany TradeAccount

Thanks
Simon

2.9_01 release now finished. New layout for buttons. Main button bar used across tabs. Simplifies UI.

Updates to test cases lots of re-factoring of Main controller.

Added installations instructions for download from Git see Wiki/Eclipse setup.

New video to come for new UI.

Thanks
Simon

Hi all
Version 2.8_08 now complete and new videos posted!

Enjoy
Simon

TradeManager 2.8_05 now ready + updated Demo DB. Look for new video early next week. I'll try and keep this to just 15mins!
The changes are as follows:

1/ All indexes/fk names changed to be unique MySQL 5.5 requirement.
2/ Contract.localSymbol length changed to 10 from 6 to match sysmbol column.
3/ Tradingday Tab now allows you to trade the same contract with different strategies or barSize on the same day. Tradestrategy key changed to include barSize
4/ Changed the TradingCalendar to add a day when the trade.market.close property in config.properties is less or equal to the trade.market.open.
5/ On Live login main controller (managedAccountsUpdated()) now parses all accounts from TWS API reqManagedAccounts(). The first account is considered the master and will be set to the default (popup to request this) if this is not so.
6/ Added field priceMultiplier to table Contract this is needed for Futures trade
7/ Tradingday Tab open/close times on a tradingday now over-ride values set in config.properties for the trading day defaults.
8/ Change the key for Contract to Symbol/SECType/Currency/Exchange/Expiry (app uses MMYYYY)  app will use MMYYYY in searches as the ContractDetails api request sets the date to the actual date.
9/ Tradingday Tab Tradingday date-times can now be changed as long as the Tradestrategies do not have trades.
10/ When loading contracts from a csv file the app will assign these to the most recent Tradingday (usually today) regardless of open/close date-time.  If this is not found then one is created using the config.properties values.
11/ Added none trading days to config.properties
# Tradingdays Sunday=1 Saturnday=7
# Trading days for week Stock Monday-Friday.
# E-mini Sunday-Saturday
trade.market.nontradingdays=1,7
12/ On connection to TWS if connection fails app now reverts to backtesting mode.
13/ Fixed defect added refresh() to WindowActivated() on Strategy Tab
14/ Fixed defect Updated order table now enable when connected to TWS added validation on Limit/Aux field based on OrderType.
15/ Added validation to Tradingday Tab close date
16/ Added event to BrokerInterface to fire events when the orderStatus changes, these now update the Contract Tab Orders panel as changes occur.
17/ Added validation to the BarSize/ChartDays fields on Tradingday Tab.
18/ Added sample csv files to the /db dir
19/ Updated column tooltips