Account Reconciliation

The program should reconcile record entries in two files originating from two different sources. The entries in each file are the current positions in a futures brokerage account @ Interactive Brokers. The files are; 1. An account status file downloaded by connecting to the Interactive Brokers TWS trading platform, via the supplied proprietary Java Application Programming Interface (API). The program should ideally be developed using the Net-beans IDE. 2. A check file stored in a specified directory locally. The file name of this file has today’s date appended to it e.g [login to view URL] The program should perform the following simple steps via a GUI. 1. Connect to the TWS platform through the Java API (Connect Button - report on GUI). 2. Download account status file from TWS and store it locally (Download Button - report on GUI) 3. Disconnect from TWS. 4. Load the check file from the specified folder on local drive(...can use default directory) 5. Reconcile and show discrepancies between records: display output to the GUI and send to a local file For each record in the check file, determine that the equivalent record exists in the TWS status file. Also ensure that the TWS status fule does not contain any entries that do not exist in the check file For example if the the check file has the following entries; maturity is year and month of expiry Symbol, Maturity, Quantity LE, 201109, 32 ZM, 201206, 7 ZN, 201109, 15 ZQ, 201112, 66 etc... The output reconciliation report will have the following 4 categories. 1. All entries where the records match e.g. LE, 201109, 32 2. Entries where maturity or quantity is wrong e.g ZN, 201109, 2(15) ...quantity wrong ZQ, 201109(201112), (66) … maturity wrong 3. Entries in check file but missing in TWS file 4. Entries in TWS file but missing in check file The program should be a stand-alone exe, and properly commented. And it should have error checks, for missing files, unable to connect etc... Links; Interactive Brokers API guide [login to view URL] TWS application [login to view URL],