Analyzing Interactive Brokers XML Flex Statements with pandas

** Mon 02 November 2015

http://github.com/wesm/ib-flex-analyzer

I published a small set of tools to parse, clean, and pandas-ify XML flex statements from Interactive Brokers. I love IB but they aren’t the best at giving you detailed portfolio analysis to understand how you are succeeding or failing at personal trading. Luckily we have nice things in Python!

The project will help you:

Roll up options P by underlying security and compare stock vs option P by underlying (very helpful if you write a lot of covered calls and puts).

  • Total up all your dividends and fees (e.g. broker interest for margin).

  • Look at deposits and withdrawals over time.

It’s up to you how you use this information. My experience is that it’s usually better to let someone else worry about your money. The curse of having worked in finance is the desire to run a more sophisticated book than average investors. So it goes.