Upload data from Interactive Brokers

Daily data import from Ending Equity

Generate an XML file which can be uploaded into our system. Please check http://www.interactivebrokers.com/en/software/am/am/reports/activityflexqueries.htm

1. Go to Account Management > Reports > Activity > Flex Query
2. Click on Create New, give the file a name, choose the account, time frame, etc
3. Within the Net Asset Value (NAV) in Base section , choose the file “TOTAL” and “REPORT DATE”, select date range, for example period Last 365 Calendar Days and run or set for delivery.
4. upload your file in Monthly data section, choose option Load Data From Interactive Brokers.

More information can be found at https://www.interactivebrokers.com/en/software/reportguide/reportguide/activity_flex_query_reference.htm

Trades import

1. Go to Account Management > Reports > Activity > Flex Query
2. Click on Create New, give the file a name, choose the account, time frame, etc
3. Within the Open Positions , choose the file “ACCOUNT ID”,”SYMBOL”,”QUANTITY” and “OPEN PRICE”, select date range, for example period Last 365 Calendar Days and run or set for delivery.
4. upload your file in Monthly data section, choose option Load Data From Interactive Brokers.

Your imported data will display in Exposure markets graph.
(recommended default template is Daily Analytical)