Skip to content
Sign inGet Started
CA

Import National Bank Direct Brokerage Transactions

National Bank Direct Brokerage (NBDB) is the self-directed trading platform of National Bank of Canada. HCC StockWatcher can import the CSV transaction history from NBDB.

Export from National Bank Direct Brokerage

  1. 1Log into your NBDB account.
  2. 2Navigate to Account > Transaction History.
  3. 3Select the account and date range for the export.
  4. 4Click the Download button and choose CSV format.
  5. 5Save the file to your computer.

Import into HCC StockWatcher

  1. 1Go to the Transactions page and click Import.
  2. 2Select your National Bank Direct Brokerage CSV file. The parser is auto-detected.
  3. 3Review the preview — each transaction is shown with date, symbol, quantity, price, and type.
  4. 4Confirm the import. Your holdings and estimated cost basis update immediately.

Parser Details

The National Bank Direct Brokerage parser reads buy, sell, dividend, deposit, and withdrawal rows from the Type column, in French or in English. The market and the currency come from the ticker's exchange suffix when it has one, from a Currency column when your export includes one, and otherwise fall back to Canadian dollars on the Canadian market — the import preview flags every row that fell back.

Supported CSV Fields

DateTypeSymbolQuantityPriceCommissionTotalCurrency

What transfers from your National Bank Direct Brokerage CSV

Exactly what the National Bank Direct Brokerage parser reads out of the file, and what you will still need to enter yourself afterwards.

Read from the file

  • Buy and sell rows: Date, Symbol, Quantity, and Price.
  • French and English transaction types alike — achat as well as buy, vente as well as sell.
  • The Commission column, applied as the fee on each trade.
  • Dividend (dividende), deposit (dépôt), and withdrawal (retrait) rows from the Type column.
  • A Currency column when your export includes one, and an exchange suffix such as ENB.TO on the ticker — either one sets the Canadian or the US market.

Entered by hand afterwards

  • Currency when the export states none and the ticker carries no exchange suffix. Those rows fall back to Canadian dollars on the Canadian market, and the import preview flags them as assumed — correct any US-dollar trades before confirming.
  • Cost basis for positions transferred in from another institution.
  • Option contracts, and bond and GIC terms such as face value, coupon rate, and maturity date.
  • Corporate actions such as splits, mergers, spinoffs, and return of capital are skipped.

Estimated capital gains, adjusted cost base, and the year-end United States and Canadian reference reports are all derived from these transactions, so anything missing here is missing from those figures too. See how estimated tax reporting works

Ready to import your National Bank Direct Brokerage transactions?

Free to get started. No credit card required.

Create Your Free Account

Related Resources

Other Supported Brokerages

HCC StockWatcher is an informational tool for portfolio tracking. All cost basis and P&L figures are estimates. Consult your brokerage statements and a qualified tax professional for official records.