Trandence

Interactive Brokers (IBKR) fornisce comprehensive reporting tools. For il most accurate import into Trandence, we highly recommend generating a custom CSV file using their Flex Queries feature.

Creating a Flex Query

  1. Access il Client Portal at interactivebrokers.com e log in.
  2. From il main menu, navigate to Performance & Reports, then select Flex Queries.
  3. Locate il Trade Confirmation Flex Query section e click il Create (plus icon) pulsante.
  4. Name your query (e.g., “Trandence Export”).
  5. In il Sections area, select Trade Confirmations e check il box to Select All fields (or specifically ensure Account ID, Trade Date, Symbol, Buy/Sell, Quantity, Price, Commission, e Net Cash are included).
  6. Scroll down to il General Configurations e ensure il format is set to CSV.
  7. Salva il query.

Exporting Your Data

  1. Return to il Flex Queries pagina.
  2. Fai clic su il Run (Play icon) pulsante next to your newly created query.
  3. Seleziona il desired Date Period (e.g., Last 365 Calendar Days).
  4. Run il report e save il resulting .csv file to your computer.

Import in Trandence

  1. Apri Trandence e vai a il Trades pagina.
  2. Fai clic su Import Trades e select Upload CSV/TXT.
  3. Scegli Interactive Brokers as il broker.
  4. Imposta CSV Timezone to il timezone used by il broker export. For most* US equities workflows, this is America/New_York.
  5. Optionally* apply an import preset if you use saved defaults for this account.
  6. Seleziona or drop il exported CSV file.
  7. Rivedi il parsed trades prima saving. Confirm symbols, side, open/close times, quantity, prices, commissions, e il sessione date range.
  8. Usa Batch Tags to label il import, for example IBKR Main or IBKR June.
  9. Fai clic su Import & Review Summary to save il import e open il post-import riepilogo.

For il full import workflow, including presets, preview validation, multi-sessione progress, e conflict review, see Importing Trades.

Cosa legge Trandence

Trandence legge righe Flex Query con campi come DataDiscriminator, Symbol, Date/Time, Quantity, T. Price e Comm/Fee. Questi campi aiutano a identificare lato, size, prezzo, commissioni e ora di esecuzione.

Trandence conserva i simboli azionari USA supportati, inclusi formati di classe come BRK.A e BRK.B, e organizza le esecuzioni importate in trade completati per la revisione.

Gestione conflitti

Se le righe importate si sovrappongono a trade gia presenti in Trandence, usa Review Conflicts per controllarle prima del salvataggio. L azione piu sicura e Keep Existing, che conserva il trade esistente.

Se devi sostituire dati esistenti, elimina o correggi prima i trade attuali e poi importa di nuovo il file. Puoi controllare gli import completati in Import History.

Sample file: Download a sample IBKR CSV file to see il expected format.

Serve aiuto?

Se your file fails to upload, or if il broker has recently updated their export format, please reach out to us at [email protected]. We’ll help you get your dati synced smoothly!