Import formats

What you can import

yourfinance reads a CSV file, recognizes its format from its columns, and shows which one it found:

• IBKR Activity / Flex: an Interactive Brokers activity statement or Flex query, as CSV.
• DEGIRO Transactions: DEGIRO’s transactions export.
• Trading 212 history export
• Trade Republic transaction export
• The yourfinance template: your current positions, filled in from any spreadsheet. In Import, Download template gives you the file with its columns.
• The yourfinance history template: your full history, one row per event. Download history template gives you that one.

Importing works during the trial and with a Beginner or Pro key.

A template saved again from a spreadsheet keeps working. Excel in Czech, German, Dutch or French writes semicolons between cells and decimal commas (185,50), and Excel’s “Unicode Text” writes tabs; both are read as they are. A number that could be read two ways, such as 1.234, is shown on its row for you to write out, never guessed. Save as “CSV UTF-8” when you can: a file in another encoding is read in your computer’s Windows code page, and the preview says so.

A broker file brings in where you stand today

A broker’s file brings in your positions as they stand now: the shares at their cost, as the raw basis, and an open option’s credit as open premium. Nothing is described as past realized P&L. For your history, use the history template.

A fraction of a share, such as 100.6 shares after a reinvested dividend, is never rounded: the preview asks for the whole shares to track, since only whole shares can back a covered call.

The history template

One row per event, in these columns: event_id, account_id, broker, ticker, event_type, event_date, quantity, price, fees, option_type, strike, expiry, multiplier, option_ref, leg_group_id.

• event_type is what happened: buy_shares, sell_call, sell_put, buy_to_close, expired, assigned or called_away.
• broker is required on every row.
• An account_id of default is the unnamed account, which does not count toward Beginner’s one account.

The spreadsheet guide’s sheet is this template filled in with the demo roll; it imports as it is.

The preview checks every row

In Import, press Choose CSV. Before anything is written, the preview marks each row as valid, duplicate, invalid or needing input, and asks for anything the file cannot say exactly, such as the ticker on a DEGIRO or Trade Republic row. A suggestion is marked as a guess and is never used until you type the value.

yourfinance converts nothing between currencies. When a file quotes a price or a fee in another currency than your display currency (a US share bought from a euro account, or a London price in pence), the preview shows the amount with its currency and asks you to enter it in your display currency. A connector’s fetch follows the same rule: a trade in another currency, or one whose currency the broker does not name, waits in the preview until you record it by hand and set it aside.

Confirm atomic import then writes every valid row at once, or none. A history file is recorded whole: if any row needs attention, nothing is written until it is sorted out.