Documentation / Broker Sync

Broker Sync

Keep your trade log in sync with your broker, and import or export trade data

Broker Sync Overview

Broker Sync keeps your Stratsigma trade log in lockstep with your broker. Once a broker is connected, your order activity is pulled automatically — fills appear within seconds, with no manual import.

Orders placed through Stratsigma are already tied to a trade, so when their fills arrive they are recorded automatically and go straight to Filled & Sync'ed — no review needed. Orders placed directly at your broker are matched automatically when they clearly correspond to an open trade; anything ambiguous waits in Filled & Need Sync with a best-guess match pre-selected.

The Broker and Account selectors at the top filter every tab. Orders are organized across six status tabs, plus a File Import / Export tab:

  • Filled & Need Sync: fills awaiting your confirmation
  • Filled & Sync'ed: fills already recorded to a trade
  • Pending: orders submitted but not yet filled (shown as "Submitted")
  • Cancelled: rejected or expired orders
  • All: every order, regardless of status
  • Ignored: orders excluded from your log
  • File Import / Export: import from CSV or OptionNet Explorer, and back up or export your trades

Each order row shows its Status, Date & Time Filled, Symbol, Account, Legs, OCC Symbol, the Trade it is linked to, and Broker ID. The number beside each tab is its order count.

The Preferred Broker setting in Settings controls which broker's orders are shown by default when you open the page.

How Orders Are Grouped

Related fills are combined into a single collapsible row so you can act on a whole trade at once instead of reviewing each fill. Grouping runs in three passes:

  • Parent order: legs that share the same broker parent order — a combo placed as one strategy — collapse into one row
  • 60-second window: separate fills on the same underlying that arrive within 60 seconds are grouped, combining quantities for identical contracts
  • Open/close pairing: opening and closing fills on the same contract are matched and shown as one row spanning the whole trade; the strategy type (e.g., Vertical Spread, Iron Condor) is inferred from the opening legs

The grouped row shows the net quantity across all fills — zero once the position is fully closed. You can link an entire group to a trade in one action, or split it back into individual rows if it was grouped incorrectly.

Reviewing & Linking Orders

Orders in Filled & Need Sync wait for you to confirm where they belong. For each one, Stratsigma pre-selects the most likely open trade (matching underlying); if there is no match, it defaults to New Trade. Rows you have not confirmed carry a Review badge.

  • Link to an existing trade: pick a trade from the row's dropdown (open trades with matching symbols are prioritized) and click Link
  • Create a new trade: choosing New Trade opens the Link & Sync dialog, where you can pre-fill strategy name, campaign, setup, timeframe, tags, up to 10 custom fields, notes, and delta / P&L monitoring thresholds
  • Bulk actions: select rows with the checkboxes, then Link All to accept all suggestions at once, or Bulk Ignore to exclude them
  • Hotkey: press S to sync the selected row(s) — linking immediately when a trade is pre-selected, or opening the Link & Sync dialog for a New Trade

Import Filters (Blocklist / Allowlist)

Import filters keep certain orders out of your review queue automatically:

  • Blocklist: orders for listed symbols are ignored
  • Allowlist: only orders for listed symbols reach the queue; everything else is ignored

Use Run Now to apply your current rules retroactively, sweeping matching orders already in the queue into the Ignored tab.

Importing a Broker CSV (Interactive Brokers Flex Query)

On the File Import / Export tab, Import Trades from CSV File loads trades from a CSV containing these columns: Date/Time, Buy/Sell, Asset Class, Symbol, Quantity, Trade Price, Commission, Underlying Symbol, Net Cash, and Account ID. Column order does not matter — Stratsigma reads them by header — so any broker that can export these columns will work. The most common source is an Interactive Brokers Flex Query.

Set up the Flex Query once, in the IBKR Client Portal:

  1. Go to Performance & Reports → Flex Queries and create a new Activity Flex Query; give it any name.
  2. In the Trades section, choose Execution and select these fields: Date/Time, Buy/Sell, Asset Class, Symbol, Quantity, TradePrice, IB Commission, Underlying Symbol, Net Cash, Account ID. (Field order is optional for Stratsigma; if you also feed this query to OptionNET Explorer, use ONE's required order.)
  3. Delivery Configuration: Format CSV; Include column headers Yes; Include header and trailer records No; Display single column header row No; Include section code and line descriptor No. Set the period to suit you (e.g., Last N Calendar Days = 45).
  4. General Configuration: Date Format yyyyMMdd; Time Format HHmmss; Date/Time Separator comma. Leave the rest at their defaults.
  5. Save the query.

To import: run the saved Flex Query in IBKR and download the CSV, then in Stratsigma go to File Import / Export → Import Trades from CSV File → Import and upload it. Stratsigma reads each execution — time, side, symbol, underlying, quantity, fill price, commission, net cash, and account — and handles option-symbol parsing, multi-leg trades, and partial fills.

Importing from OptionNet Explorer (ONE)

On the File Import / Export tab, Import Trades from OptionNet Explorer reads a ONEDetailReport export. Click Import and upload the file. ONE exports preserve complete trade history — every adjustment and leg, plus commissions and fees, and strategy / setup where available.

  • ONE Trade ID: each imported trade keeps a ONE Trade ID (visible and editable in Trade Detail) that links it back to its ONE record and prevents duplicates when you re-import the same file
  • Account linking: the originating ONE account is used during matching, so trades from different accounts are not merged
  • Matching: Stratsigma first tries an exact-timestamp match against existing executions, then falls back to symbol + quantity, so re-imports do not create duplicates

Backup & Restore

Export Trades to Backup File downloads your entire trade log as a Stratsigma backup file. Restore from Backup File re-imports one: upload a backup exported from this app and Stratsigma restores the trades, automatically skipping duplicate executions. Your import filters still apply during a restore.

Exporting Trades to CSV

Export Trades to CSV File downloads all your trades as a CSV. You choose the level of detail:

  • Core Data: trade summary fields only
  • Full Data: includes all leg details