Have any of you come up with a method of reconciling an Interactive Brokers brokerage statement? Specifically, I want to look at the change in net asset value on the first page of this statement, and I want to understand what other parts of the statement need to be used to derive that change in net asset value. This would tell you the actual sources of gains or losses in the account, over the statement period.
For those not familiar with Interactive Brokers, their statements are designed for hedge funds. They are unbelievably detailed and include all kinds of different views of the same basic data. There are many hidden sources of expenses as well.
It looks to me like the vast majority of the account value change can be derived from the following categories:
1) Mark-to-market securities gain or loss (this appears to include realized gains and losses and appears to include many of the fees) 2) Transfers in and out of the accountBut these two are not enough to complete the reconciliation. One area of potential complexity is currency gains or losses that are implied by current cash holdings. If you have a cash position in Australian, Swiss, Canadian, etc currency, those have mark to market gains or losses that would affect the net asset value. None of this appears to be broken out separately from the forex gains/losses within stock positions. But it might be calculated already in the ending date cash value on the statement of net asset value.
And I'm sure you are wondering why we don't just ask Interactive Brokers these questions? My grade to Interactive Brokers' customer service would be a "D". No one there has a clue how to answer this question. Or, rather, the person at Interactive Brokers who can answer this question is not allowed to talk to customers.