Import IBKR Open Positions CSV into Optioneer

1. Download from Interactive Brokers (IBKR)

1. Open Flex Queries.

   Sign in to IBKR Client Portal on the website. Go to Performance & Reports → Flex Queries. If the Account Selector appears, choose the account you want to track.

2. Create an Activity Flex Query.

   Click the + icon in Activity Flex Query and give the query a name.

3. Add Open Positions.

   Under Sections, open Open Positions. Under Options, choose Summary and leave Lot unselected. Include every field by clicking each field, then click Save.

4. Configure the CSV.

   Use these settings for a recent report with one account and a single header row.

   Required report settings

   Setting	Select this
   Open Positions → Options	Summary; leave Lot unselected.
   Delivery Configuration → Accounts	Use Add/Edit Accounts (Add/Edit Account(s) in some views) to select only the account you want to import.
   Format	CSV
   Period	Last Business Day
   Include Column Headers	Yes
   Include Head and Trailer Records	No
   Include Section Code and Line Descriptor	No
   General Configuration → Date Format	yyyyMMdd
   Display Account Alias in Place of Account ID?	No
   Breakout by Day?	No

5. Save the query.

   Click Continue, review the settings, then click Create.

6. Run and download it.

   Click the blue Run arrow beside your saved query. Check the account, Period and Format, then click Run. Save the CSV. If you receive a ZIP, extract the CSV first.

2. Select your portfolio and upload

1. Open Portfolio. Use the portfolio selector at the top to select the portfolio for this broker account. Check its name.
2. Check the file contains only this account, with USD holdings and whole quantities. Do not upload fractional holdings; their quantities are not preserved.
3. On Positions, choose Import CSV.
4. Choose Browse Files, select the CSV, then choose Upload & Parse.

Upload & Parse does not save positions. It opens a preview for you to review first.

Already reading this guide from the import window? Return to that tab to continue. Opening the instructions keeps your selected file, portfolio and progress in the original tab.

3. Review the preview before saving

Check the detected broker, stock and option counts, warnings and possible duplicates. Then compare the preview with your CSV.

Holdings

Compare every stock symbol and option’s underlying, put/call, strike, expiry, quantity and long/short side with the report.

Costs

Option premiums use the cost basis price. Stocks use the cost basis per share, or the opening price when that basis is missing or zero. The market price is not the entry cost. Stock entry prices are rounded to cents when saved.

Dates

Stock Entry Date should match the report date. Options will also use the report date when saved, even if the file contains an original opening date; check their entry dates after saving.

Data left out

This report does not import cash movements, completed trades or separate commissions. CSV line counts include headers and other rows, so compare actual holdings rather than line counts.

4. Confirm the import

When the preview matches the report, choose Confirm Import. The positions are saved to the selected portfolio, and the Portfolio refreshes after a successful import.

5. Check your saved positions

• In Portfolio → Positions, check the saved stocks and options against the report: symbol or contract, quantity, side and entry cost.
• Check the saved entry dates. They should use the report date, not the original opening date. Stock prices are rounded to cents.
• Open Trade History (History on mobile) and look for options saved as closed. A stale report can produce an incorrect zero-price expiry; it does not prove the broker’s actual outcome.

Compare holdings and entry costs. This positions CSV alone will not make your cash balance or historical performance match a broker statement.

Accounts and later imports

Use one CSV per broker account and select its matching portfolio each time. Account numbers in a CSV do not send rows to different portfolios automatically.

A later snapshot does not synchronize your portfolio. Changed holdings may be added alongside older ones; holdings absent from the new file are not removed. Check existing holdings before every import, including data from manual entry or Broker Sync.

Need help?

Email support@optioneer.io.

Include the broker, report name, exact error, device/browser and whether you chose Confirm Import. Send an anonymized file only if support requests it. Do not include brokerage credentials or personal financial data.