Quote from white17:
Electron: I keep a spreadsheet running all the time for each trade and total trades. Often times the P&L window in the "account" window wil show a loss on a position when actually the trade generated a gain. It is always a result of FIFO on partial positions.
Could this be part of the problem?
While we believe our accounting is correct, and we take substantial efforts to ensure this, errors can happen. It is completely inappropriate to assume this is a matter of intent or malfeasance on IB's part.
If anyone believes there is a genuine systematic error in the accounting as reported in the statements, please send an email to
help@interactivebrokers.com with the string 'JC111' in the subject line. Please provide the details needed to examine the problem and we will treat it as a priority matter to review, and if necessary, correct.
On related points that arose in this thread:
Please be aware that the real-time pnls on the account window and the main (order management) window can differ due to different calculation logic. The order management version is session based and expresses the pnl only since the last close. It gets its data from locally stored files which can be damaged. The Account Window is driven by IB's risk management and clearing systems and is a far better indicator given it is not session dependent. However, it does use average cost which can produce unexpected results for traders who are thinking FIFO or LIFO or other sequencing logic in their pnl estimations (the totals will be the same but the break between realized/unrealized will be different).
Lastly, IB recently upgraded the Account Window. The new version provides far greater detail about financial capacity and margin requirements. A particular feature is the 'lookahead' margin which shows the expected margin requirement at the next time it will change schema (i.e. the next time any contract in the portfolio will change from intraday to overnight margins or vice-versa). This should allow traders to anticipate upcoming requirements and avoid undesired liquidations.
However a side effect of the upgrade is that we removed the realized/unrealized pnl splits in the Account Window. We will reintroduce them in a more sophisticated form in the next release of the Account Window as part of planned enhancements that will provide better use of capital for commodity traders with combined options and futures positions.
I hope this is of assistance.
Jon
IB Management