As a newbie, please tell me if this is inappropriate for this forum.
Interactive Brokers has a very nice download mechanism called "FlexStatements".
See these links for background:
http://www.interactivebrokers.com/en/accounts/flextool.php?ib_entity=llc
http://www.interactivebrokers.com/en/accounts/flexStatementsWebService.php?ib_entity=llc
The help information on it states that it is still in beta and has been that way for a long time.
Perhaps we can give some impetus to get them to complete it and make it useful. I will edit this lead post to summarize the discussion and accumulate the priorities.
Another thread includes some software that will let you use this service to do some reporting calculations at the end of the day:
http://www.elitetrader.com/vb/showthread.php?s=&threadid=83759
FlexStatements Fixes/Improvement Priorities:
* Include all fields in the XML download that occur in a statement. One very important field that is missing is the accrued interest field. Without it, you can't calculate net liquidation value to compare with a statement.
* Include the "customer order reference" string for the trades. This is critical to be able to tie trades back to strategies.
* When a requested statement, isn't ready yet (such today's when today isn't complete or last month when last month hasn't been computed), it appears that the server just responds: "Statement not ready. Please try again after in [sic] a few minutes.". It ought to give a code that indicates you will never get that statement rather than making you wait
* Add support for FlexStatement to download paper trading statements.
* Permit some simple parameters to the query at query time such as "date range".
Interactive Brokers has a very nice download mechanism called "FlexStatements".
See these links for background:
http://www.interactivebrokers.com/en/accounts/flextool.php?ib_entity=llc
http://www.interactivebrokers.com/en/accounts/flexStatementsWebService.php?ib_entity=llc
The help information on it states that it is still in beta and has been that way for a long time.
Perhaps we can give some impetus to get them to complete it and make it useful. I will edit this lead post to summarize the discussion and accumulate the priorities.
Another thread includes some software that will let you use this service to do some reporting calculations at the end of the day:
http://www.elitetrader.com/vb/showthread.php?s=&threadid=83759
FlexStatements Fixes/Improvement Priorities:
* Include all fields in the XML download that occur in a statement. One very important field that is missing is the accrued interest field. Without it, you can't calculate net liquidation value to compare with a statement.
* Include the "customer order reference" string for the trades. This is critical to be able to tie trades back to strategies.
* When a requested statement, isn't ready yet (such today's when today isn't complete or last month when last month hasn't been computed), it appears that the server just responds: "Statement not ready. Please try again after in [sic] a few minutes.". It ought to give a code that indicates you will never get that statement rather than making you wait
* Add support for FlexStatement to download paper trading statements.
* Permit some simple parameters to the query at query time such as "date range".