Exporting Your Data

Your trades are yours, and there are three ways to take them out of OptionsPro as a CSV. They differ in where you start them, what ends up in the file, and which plan they need.

Every file is UTF-8 with a byte-order mark, so Excel, Numbers and Google Sheets open it correctly without an import step.

Download my data (the whole journal)

In Settings → Your Data, Download CSV builds a full copy of your trading journal.

• Every option trade and every stock trade in your organization, with no filters applied. The date range, portfolio filter or search you have set elsewhere in the app make no difference to it.
• The file is named optionspro-trades-YYYY-MM-DD.csv.
• Large histories can take a minute.

Each row carries what the app shows for that trade - your edits and fee overrides applied - alongside what the broker originally reported in a set of original_* and broker_reported_fee columns, so a correction never costs you the underlying record. Option and stock rows share one column set and are told apart by record_type; a column that doesn't apply to a row (strike on a stock trade, FX rate on an option trade) is left empty. Flags for unverified, user_edited, closed_by_expiration, expired_worthless and physically_assigned come along too.

The export is all-or-nothing by design: if it would pass the file-size ceiling (19 MB) or take longer than five minutes, it stops and tells you rather than handing back a file that looks complete but is missing its oldest years. Nothing is downloaded in that case - contact Support if you hit it.

Export the trades you're looking at

The Trades page header carries an Export button beside the portfolio filter. It downloads the option trades the table is showing, with the filters you have set applied, as optionspro-filtered-trades-YYYY-MM-DD.csv.

• Your filters come along: portfolio, brokerage, account, status, manual source, the date range, and the search box. Unlike the table itself, the filtering happens on the server, so the file covers every matching trade in your history rather than the rows a page could read - see Large Trade Histories.
• The columns are the full export's columns, so a filtered file and the whole-journal file line up in the same spreadsheet.
• Option trades only. Stock trades are in the whole-journal export.

Two cases can't be exported, and the button's tooltip says which:

• Group by Position or Group by Strategy with a status filter set. In those views Open and Closed describe a whole position, which a file of individual fills cannot reproduce. Clear the status filter, or switch to Ungrouped or Group by Order.
• Group by Trade, where enabled for your org, since a row there is a whole trade lifecycle rather than a fill. Switch to Ungrouped or Group by Order.

Export the positions you're looking at

The Positions page header carries the same Export button, and it downloads optionspro-positions-YYYY-MM-DD.csv: one row per position the table holds under your current filters, not just the page on screen.

The columns are the position's own figures rather than the fills behind them: contract key, underlying, type, strike, expiration, status, quantity and max contracts, average open and close price, cost basis, current price, market value, unrealized and realized P&L, underlying price, notional delta, daily theta, days to expiry, days in trade, the strategy and leg role where the position belongs to one, brokerage, account and portfolio.

Because it is built from the rows on the page, it matches what you are reading exactly - including the strategy grouping and the collateral netting - rather than being re-derived server-side into a slightly different answer. The market-data columns in it are as fresh as the page: see Market Data.

What an export is not

• Not a backup of your account. Exports cover trades and positions. They do not carry your portfolios, your manual strategy groups, your notes, your fee overrides as objects, or your settings.
• Not a tax document. Realized P&L in the file is OptionsPro's own FIFO-matched figure, not a 1099-B.
• Not re-importable as-is. To bring trades back in, use Trade Import, which reads a broker export or any reasonable CSV through its own wizard.

Related

• Settings - where the whole-journal export lives.
• Trades and Positions - the two pages with a view export.
• Subscription - what else Pro unlocks.