Questrade trading journal
Connect Questrade read-only and your stock and option fills refresh daily. Or export your transaction history and drop the file in. Either way, read your Questrade trading back as an equity curve, a calendar and your own written notes.
Connect Questrade read-only from Connections, signing in on Questrade’s own page, and your stock and option fills refresh daily. Or export your transaction history as a CSV and drop it onto Import & Export. Either way your fills become positions with an equity curve, calendar P&L and your notes, free forever.
How do I import Questrade trades into a journal?
Export your transaction history from Questrade as a CSV, open Import & Export in sizeforzero, choose the account to import into, set Exported from to Questrade, drop the file and press Import trades. Buys and sells are paired into positions. Dividends and interest are recorded as income, and deposits and transfers are not counted as trades.
Connect Questrade
- Sign in to sizeforzero and open Connections.
- Choose Questrade. A secure window opens on Questrade’s own sign-in page.
- Authorise read-only access there. Your password is entered on their page, never ours.
- Your accounts appear as journal accounts, each named for what it is, and your executed stock and option trades are pulled in.
- From then on it refreshes daily. Every connection shows when it last synced, with a Sync now button beside it.
The connection is the one route that brings in Questrade options. Disconnecting stops the sync and leaves every trade already in your journal where it is.
Import a Questrade CSV
- Sign in to Questrade and open the Reports page from the top navigation.
- Choose “Go to transaction history” and pick the date range you want.
- Download the report as CSV. Questrade also offers PDF; the journal reads CSV.
- In sizeforzero, open Import & Export and choose the account to import into, or create one. “Questrade TFSA” is a fine name.
- Set Exported from to Questrade so the columns map themselves, then drag the CSV onto the drop zone. Set the import window if you only want recent trades.
- Press Import trades. You are told how many landed, how many were skipped as already imported, and anything that needs a second look.
Questrade reshuffles its web layout from time to time. If the wording has moved, you are looking for the transaction-history export in CSV form. The older Account Activity export downloads as an XLSX spreadsheet, which is not a CSV, so use the CSV.
Connection or CSV: which one?
Connect when you want the journal to stay current without thinking about it. The connection refreshes daily, reads stock and option fills straight from Questrade, and is the only route that brings in options. Import a CSV when you would rather not connect, or for history older than the connection reaches.
The two can run side by side. Import the older file once, keep the connection running for everything after it, and the two sit in one book. The CSV path is not a lesser one: it reads the same file you would download for your accountant and maps Questrade’s own column names.
TFSA, RRSP, FHSA and margin accounts
Make one journal account per Questrade account, name it for what it is, and import each file into its own. When you connect, each Questrade account arrives as its own journal account. Under Show more you can mark an account’s type: TFSA, RRSP, FHSA, RESP, LIRA, margin or cash. Every screen reads per account or across all of them.
A Questrade export carries an Account # and an Account Type column. If one file covers more than one account, sizeforzero asks you to name a journal account for each and suggests the registered type from the file. If the file’s account type differs from the type you set on the journal account, you are asked to confirm before it imports.
CAD, USD and other currencies
Every row in a Questrade file carries its own currency, so a US-dollar fill and a Canadian-dollar fill sit side by side in the same account, each in the currency it traded in. Positions can be held in USD, CAD, GBP, EUR, AUD, JPY or CHF, and a US-dollar position inside a Canadian-dollar account keeps its own currency instead of being flattened.
Canadian listings are understood. A symbol with an exchange suffix such as RY.TO is matched to its Toronto listing, and the same goes for .V on the TSX Venture, .CN on the CSE and .NE on Cboe Canada.
What each kind of Questrade row becomes
A Questrade file mixes trades with everything else on the account, and each Action code is handled on purpose. Buys and sells, including liquidations, become trades. Dividends and interest are recorded as income. Contributions are recorded as cash movements. Deposits, withdrawals, transfers between accounts and similar cash-only rows are recognised and left out, because they are not trades.
Dividend reinvestment and in-kind distribution rows are skipped on purpose. Questrade writes an internal placeholder ticker on them, and booking a reinvestment under a junk symbol is worse than leaving it out.
The file gives the day of each fill, not a time of day, so trades are dated by the day they happened.
What the Questrade import leaves out
Options come in through the connection, not the CSV. The Questrade file has no option format sizeforzero reads, so a row whose symbol is one of Questrade’s internal codes is refused with a plain message instead of being booked as a share at an option’s price.
Multi-leg option strategies, futures and crypto are not supported, and dividend reinvestments are skipped as above.
A sell with no matching buy, because the buy predates your export, is not guessed at. It waits in your Inbox until you add the missing side, so your win rate is never quietly wrong.
sizeforzero never places an order and never moves money. It reads what already happened.
Does sizeforzero sync with Questrade automatically?
Yes. Open Connections, choose Questrade and sign in on Questrade’s own page. The link is read-only and refreshes daily, and it brings in stocks and single-leg options. CSV import stays a fully supported path if you would rather export a file, which takes about a minute.
Is the Questrade connection read-only?
Yes. It reads positions and executions and nothing else. It cannot place, cancel or modify an order or move money, and your Questrade password is entered on Questrade’s own page, never ours. A CSV import never touches your Questrade login at all.
What does the Questrade CSV need to contain?
Questrade’s own transaction-history export is already the right shape: transaction date, action, symbol, quantity, price, commission, currency and description. Pick Questrade in the Exported from list and nothing needs reshaping. Any other CSV works with the Generic CSV preset, as long as it carries date, symbol, side, quantity and price.
Does it handle Questrade options?
Yes, through the connection: single-leg calls and puts arrive with strike, expiration and right on every contract. The Questrade CSV is not read for options, because no option format is on record for it, so a row with one of Questrade’s internal codes is refused with a plain message. Multi-leg strategies are not supported.
What happens to dividends, interest and deposits in a Questrade file?
Dividends and interest are recorded as income, not counted as trades. Contributions are recorded as cash movements, and deposits, withdrawals and transfers are recognised and left out.
What happens to Questrade dividend reinvestments?
They are skipped on purpose. Questrade puts an internal placeholder ticker on reinvestment rows, and booking one would put a phantom position under a junk symbol in your book.
Can I keep my Questrade TFSA, RRSP and margin accounts separate?
Yes. Connected Questrade accounts arrive as separate journal accounts, and for a CSV you create one journal account per Questrade account. Mark each as TFSA, RRSP, FHSA, RESP, LIRA, margin or cash under Show more. Every screen reads per account or across all of them.
Can I keep CAD and USD trades from the same Questrade account?
Yes. The Questrade file names a currency on every row, so a Canadian-dollar fill and a US-dollar fill land side by side in the same account, each in the currency it traded in. Positions can be held in USD, CAD, GBP, EUR, AUD, JPY or CHF.
What happens if I import the same Questrade file twice?
Nothing is written twice. Every upload is fingerprinted, so re-importing a Questrade file adds no trades and says so plainly. If you export an overlapping date range, set the import window to the period you want. Recent imports keep a one-click undo for 24 hours.
Is my Questrade data private?
Yes. Your notes are yours: never sold, never used to train models. Sign-in is a magic link, so there is no password to leak, and your whole book exports as CSV. A CSV import never touches your Questrade login, and the connection is read-only. PIPEDA and CCPA compliant.
What does a Questrade trading journal cost?
The Questrade connection and the CSV import are both part of the free journal. The journal is free forever: unlimited trades, every account, broker connections, CSV in and out, full analytics, the equity curve and calendar P&L, with no credit card. Pro turns the AI always on after a 30-day free trial. The pricing page has the current plans.
Once the trades are in
More on registered accounts, CAD and USD side by side, and Canadian tax record-keeping on the trading journal for Canadian traders page. Terms like expectancy, R multiple and profit factor each have a plain-English entry in the glossary. The full plan breakdown is on the pricing page.
Keep reading
Bring in your first Questrade trades and see the equity curve behind them. Free, no card.
Start freeThe fine print
sizeforzero is an independent trading journal. We are not affiliated with, endorsed by, or partnered with Questrade, Inc.. Questrade is a trademark of its owner, referenced here only to describe whose account data this journal can read, by CSV or by a read-only connection.
For informational purposes only. Not financial advice. Past performance does not guarantee future results.