Account review
Your IBKR history from every angle: returns, positions, P&L by underlying, and every trade in plain words.
Activity Statement
RequiredTrades, positions, cash, income and costs. One file per year is fine.
Log in to IBKR on the web and open the statements page.
Performance & ReportsStatements
Find Activity and click its run arrow.
ActivityRun
Choose the period and CSV.
- Period
- Annual or Custom Date Range
- Format
- CSV
- Language
- Any
Run, download, and drop the file here. Don’t open and re-save it in Excel first.
For several years, run it once per year and drop all the files together.
Flex Query: daily NAV
OptionalAdds the daily value curve, returns for any range, monthly returns and drawdown.
Open Flex Queries and create an Activity Flex Query.
Performance & ReportsFlex QueriesActivity Flex Query+
Name it, tick the section Net Asset Value (NAV) in Base, and select all its fields.
Net Asset Value (NAV) in BaseSet the delivery options, then save the query.
- Format
- CSV
- Include Column Headers
- Yes
- Date Format
- yyyyMMdd
Run it with a custom range starting one trading day before your statement, then download the CSV and drop it here.
RunCustom Date Range
Next time, just run the saved query again. Each run covers up to 365 days: for longer history, run it once per year and drop all the files. XML works too.
Files are read in this browser and never uploaded. Close the tab and they are gone, unless you choose to keep them on this device.