Documentation

This page contains information on how to install and use TradeConverter

 

  • Windows 10, Windows 11
  • Click here to go directly to the application page in Microsoft Store, or:
    • Go to the Start  button on your Windows PC, and then from the apps list select Microsoft Store
    • In Microsoft Store, type “tradeconverter” in the search box at the top
    • Select the TradeConverter application
  • Click the Get button
  • Once download and installation completes, click Open button or start the TradeConverter from Start menu
  1. Export trading data from your brokerage:

Note: if you would like to add a brokerage, please use the Contact Form to send us a request

Questrade:

    • In your account, go to Reports > Account Activity
    • Select the date range of the data to export
    • Select the account to export if you have multiple accounts (normally, only taxable/non-registered accounts should be used for adjusted cost base and gain/loss calculations)
    • Optionally, use the Activity Types filter to exclude irrelevant transactions such as Deposits, Withdrawals, Dividends, Fees and Rebates. If this data is included in the report, TradeConverter will ignore it
    • Click Export to Excel button and save the report file on your local machine

TD WebBroker:

    • In your account, go to Accounts > Documents (eServices)
    • Switch to Tax Documents tab
    • Select Tax Year
    • Download the Trade summary spreadsheet (CSV) report by clicking the link in the Document (year) column
    •  
  1. Launch TradeConverter from the Windows Start menu or a Desktop/Taskbar shortcut if you created one
  2. Click the Import menu button at the top
  3. Select File Format and click the Open button next to it. Alternatively, after selecting the format, you can drag&drop the import file onto the application window
  4. Browse to the location on your computer where you saved the trading report, select the report file and click Open
  5. The Import Progress window will open and display the progress of the import routine. TradeConverter automatically processes/converts data as part of the import routine. Once the line “Successfully imported <nnn> records” appears, click OK to close the window. If there are any errors during the import, note the error message and inspect/correct the report file, or contact us for support
  6. Repeat Step 6 if you have multiple reports of the same format to import. Please note that TradeConverter re-processes the entire data set after each additional file import, resulting in the import routine taking longer as you add more files
  7. To delete all imported and converted data and to reset selected file format click the Clear All Data button on the Import screen
  8. Once all data is imported, click the Convert/Export menu button at the top. A submenu will be displayed below the main menu for different slices of your data, and the Trades screen will be selected by default.
  9. The Securities section shows all securities’ names/symbols detected in the imported files and if those names/symbols have associated substitutions. Substitutions are useful when you want to replace the name/symbol of security provided by your brokerage. For example, “BLACKBERRY LIMITED” from TD WebBroker can be replaced with “TD.TO” symbol. The new name/symbol will be used for all related transactions in the export file(s)
      •  To create new or edit existing substitution, select the row to edit, then click in the Substitution filed of that row and type the new name. When done, press Enter button on your keyboard to confirm the edit or Esc button to cancel
      • To remove a substitution, select its row and click the Clear Selected button
  1. The Trades section displays all the converted trade transactions ready to be exported. Substitution column shows if the value in the Security column will be replaced in the final export file, but the column itself will not be included in the export. Here, as well as in the Options and the Splits sections, you can view the original imported record of the selected converted record at the bottom of the window, in case you want to compare and confirm that the conversion was done correctly
    • When ready to export the data, click the Export button. The Save As dialog window will open. Browse to the location where you want to save your export file(s), type the desired file name, then click Save. If operation was successful, a message box will be displayed, listing the name(s) of exported file(s). Click OK button to close the message and to return to the application
    • If the total number of exported records exceeds the Max records per export file value, the export will be split into multiple files. At the time of writing this guide, adjustedcostbase.ca accepts up to 500 transactions per import file. The same number is set by default in TradeConverter. See the item 15 of this guide on how to change that value
  1. The Options section presents the detected options transactions, grouped and organized. The table on the left side contains the list of all detected options, and the table on the right – all individual transactions for the selected option. While adjustedcostbase.ca doesn’t currently accept options transactions in import files, this screen should make it easier to enter the options trades manually.
    • Please note that, since options transaction can be spread over multiple days/weeks/months, your import files may not include all transactions for each option from opening to closure. In order to see all transactions, please import data for all relevant date ranges
    • Questrade uses auto-generated unique identifiers in place of the underlying security symbol for some of options transactions. TradeConverter relies on the Description filed in order to find and interpret options transactions. This may lead to unpredictable results during conversion, especially if Questrade modifies the way they identify and export such transactions in the future. Please always check the Ignored section and contact us if any relevant transactions were misinterpreted or ignored
  1. The Splits section displays all detected stock split transactions with a calculated split ratio for an easier manual entry
    • As with the options transactions, some splits could be identified with an auto-generated symbol instead of the proper security symbol
    • TradeConverter uses the related pairs of split transactions to calculate the old number of shares, the number of shares after the split, and the resulting split ratio. With some odd ratios such as the 1:12.465 reverse split of Madison Metals in July 2021, TradeConverter will calculate the ratio as whole numbers, e.g. “1 for 12”. This should still be accurate for the adjusted cost base calculations, but you will need to handle the related cash-in-lieu transaction manually if there is one
  1. Finally, the Ignored section contains transactions that could not be converted or are irrelevant for adjusted cost base and gain/loss calculations. Review the records and contact us for support if any of the relevant transactions were ignored or misinterpreted
  2. Three additional menu buttons are located at the top right corner of the application window:
    • The button with “i” icon brings up the window with general information about the TradeConverter application and contact information
    • The question mark button opens this page in your default browser
    • The button with cog icon opens the application settings window:
      • The Questrade tab allows selecting whether to use Transaction Date or Settlement Date from Questrade transactions as the date of transactions in export file(s). The default setting is Settlement Date
      • The Export tab contains settings for date format and maximum records in export file(s). As per the adjustedcostbase.ca import format requirements, the default settings are “MM/dd/yyyy” for the date format and “500” for the maximum records
      • The Substitutions tab is similar to the Securities section described in item 10 of this guide. The difference is that in the Settings window you can view and modify all saved substitutions, while the Securities section only shows securities detected in currently imported data. Edit the substitution by selecting the required row, then clicking in the Substitution field and typing the desired value. Press Enter to confirm or Esc to cancel the edit. Click the Delete button to remove the substitution. When done, click OK to confirm and save all changes, or click Cancel to cancel all changes
  1. Helpful tips:
    • Column widths in all displayed tables can be modified in order to better display content that doesn’t fit in the default column width. Alternatively, hover the mouse cursor over the field that doesn’t fit all its data in order for a pop-up to display the entire content
  • When closing the Import Progress window after importing a report, the main application window may sometimes flicker briefly
  •  When Substitutions are modified through the Settings window while either the Securities or the Trades section is displayed, the changes will not be reflected in the active window. Switch to any other section, then back to refresh the table
  • On high DPI monitors with scaling set at 300% or higher, icons on some buttons may disappear. As a workaround at this time, please switch to scaling of 250% or lower

TradeConverter version 1.0.2.0 – October 10, 2022

  • Improved handling of high DPI monitors
  • Drag&drop functionality for import files

TradeConverter version v1.0.1.0 – September 23, 2022

  • Initial release