I know that few weeks before i promised to help Julian and Maurice to replicate the account tracker that i am using to track how my accounts are doing, but it was not possible at that time due to the amount of manual work involved. Now thanks to Nick I got to know IB Flex query reports. in short they are customised reports that you can select whatever data you want to see in them but the nice part is that these data can be pulled grammatically from IB server (a bit slow but still good)
So i developed a small tool around this it is capable of extracting the reports from IB Flex server and generating the following:
The Tool will generate two sheets for each account. One sheet will display the daily account value and if any transactions took place. The transactions can be (Fund/Withdraw) or even internal transfer between accounts.
Then for each account it will generate another sheet that has the VAMI for the account and the monthly returns in base currency of the account in addition to the charts for cumulative P/L in $ and in %
Finally it will sum all the accounts together in one sheet that will show the total activities that took place on your capital with IB and also will generate VAMI and the monthly returns in the base currency also it will generate graphs for the cumulative P/L in $ and % with the HHV for each and another graph for the DD in %.
Then it will generate the Main KPI (key performance indicators) for total accounts such as up days down days average profits average loss ..
attached is the tool and the guidelines on how to create the report and how to use the tool