IBpnl requires Java 1.5. To see if you have it, double click "My Computer" icon, open folder "Program Files", then "Java". If you have sub-folders like jre1.5xxx or jdk1.5xxx, you have it already. Otherwise, you can download it from here. Make sure you use the link labeled "Download JRE 5.0 Update 6" in the middle of the page.

  1. Download IBpnl and unpack it to any folder.
  2. Edit the files setenv.bat and conf.txt. Both files contain instructions. IBpnl puts all files in an output folder you define in conf.txt.
  3. Run download.bat to download your statements. You may download the statements yourself manually. See "Tips" section for details.
  4. You may need to edit the files splits.txt and futures.txt in the folder "ibpnl\def".
  5. If you have positions at the start of the period, create a sub-folder "init" in the output folder and create a file positions.txt there. There's a sample file in the folder "ibpnl\def". You may generate this file by running IBpnl on last year's trades.
  6. Run process.bat. The report files are stored in sub-folder "report".
  7. If you want intermediate files with executions and trades, run dotrade.bat. Executions are stored in sub-folder "exec". Trades are stored in "trade".
  8. You may also want to run dointerest.bat to extract your interest data. The result files are stored in sub-folder "report".

Please verify your results. IBpnl is tested on limited number of accounts. Your account activities may result in a statement layout which IBpnl cannot work with.