Trandence

Questrade

Trandence supports two ways to import your trades from Questrade: Automated Direct API Sync or Manual CSV File Export.

If you trade options, use the CSV export. Sync imports stock trades only for now; the IQ Edge Orders export brings in stocks and options.

Option 1: Automated Direct API Sync

Automated sync links your Questrade account directly to Trandence using a personal API Refresh Token. Trandence manages ongoing token rotation, supports multiple subaccounts (TFSA, RRSP, Margin), and automatically converts CAD trades to USD.

1. Generate a Refresh Token in Questrade

  1. Log in to your Questrade web portal.
  2. Go to App Hub → Partner / Personal Apps.
  3. Create a personal app (or open an existing one) and generate a Refresh Token.
  4. Copy the single-use token.

2. Connect in Trandence

  1. In Trandence, open Broker Sync from the sidebar.
  2. Click Connect Questrade.
  3. Paste your Refresh Token into the input field and click Connect Questrade.
  4. Trandence will verify the token, discover your accounts, and establish the connection.
  5. If you have multiple accounts, select which accounts (e.g., Margin, TFSA, RRSP) you want to include in trade synchronization.

Option 2: Manual CSV File Export

If you prefer exporting CSV files from Questrade IQ Edge:

Exporting from IQ Edge

  1. Open IQ Edge, click Tools at the top menu, then click Account.
  2. Open the column editor from the Orders tab’s right-click menu (Edit Columns).
  3. Select all available columns and click OK.
  4. Click Range to select your date range.
  5. Right-click on Orders again and click Export… to save the file.

Uploading to Trandence

  1. Open Trandence and go to Trades → Import Trades → Upload CSV/TXT.
  2. Select Questrade as the broker.
  3. Choose your timezone (America/New_York) and upload your file.
  4. Review the parsed trades and click Import & Review Summary.

What Trandence Reads

Trandence imports executed orders from the Orders export (Symbol, Status, Action, Fill qty, Fill price, Updated time, Total fees, Order ID). Cancelled and replaced orders are skipped.

  • Stocks and ETFs: Buy, Sell, Sell Short and Buy to Cover.
  • Stock and index options: the contract is read from Symbol, for example IWM17Jan24P192.00 (IWM, 17 Jan 2024, 192 put). The trade is filed under the underlying and priced at 100 shares per contract. BTO, STC, STO and BTC open and close long and short option positions.
  • Replaced orders: when an order was changed before it filled, Questrade lists it again with its history indented underneath, including the fill a second time. Trandence counts each executed order once and uses the time it filled (Updated time), not the time it was first placed.
  • Fees: Total fees is imported as the commission.
  • Adjusted options (a root ending in a digit, after a split or merger) are skipped, because the export does not say how many shares they deliver.
  • Canadian listings (symbols such as RY.TO) are skipped by the CSV import. Currency conversion from CAD applies to the API sync only.

The Orders export lists orders, not expirations, assignments or exercises. An option that expired or was assigned stays open after its expiry date, and Trandence lists it under Expired options to resolve on the Trades page, where you choose what happened. Choosing Assigned or Exercised also adds the shares that were delivered.

Sample file: Download a sample Questrade CSV file

Need Help?

If you have questions about linking Questrade or parsing trade files, reach out to [email protected].

Need Help?

Questions about Questrade? We answer within one business day.

Contact Support