Import Qtrade Investor trades

Content also available for tax entities or on our global site.

To bulk import your historical trading data from Qtrade Investor to Sharesight:

1 – On the ‘Let’s get started by adding some trades’ page, select the Qtrade Investor tile from the ‘Broker & Provider Import’ tab on the right-hand side of the screen.

1 - Qtrade tile

2 – From the ‘Looking to import trades from Qtrade Investor’ window, select the Qtrade Investor link.

2 - Qtrade

3 – Login to Qtrade Investor.

4 – Navigate to your trading account. Find the link to download your trades. This is typically labelled ‘trades’ or ‘confirmations’. The correct downloaded file is titled: [Number]Account_History[YYYY-MM-DD]

5 – Open the downloaded file and add a column titled ‘Market Code’. This is required content for the file to successfully upload.

Against each trade add the Stock market code the stock is held, on e.g. TSE, CNSX, NASDAQ, NYSE. For other Stock Exchange codes, please refer to the Supported Stock Exchanges help page.

6 – The ‘Transaction Type’ column contains more than ‘Buy’ and ‘Sell’ transactions, all the other content needs to be filtered out, use the filter feature in your spreadsheet program.

7 – From the ‘Looking to import trades from Qtrade Investor’ window, click the ‘Choose file’ button.

3 - Qtrade

8 – From the ‘Open file’ window, find and select your Qtrade Investor download file.

9 – Click the ‘Open’ button.

step 8 & 9 broker file import

10 – From the ‘Looking to import trades from Qtrade Investor’ window, click the ‘Upload’ button.

4 - Qtrade

11 – Select the date format that is used in the downloaded file; International: DD/MM/YYYY or USA MM/DD/YYYY.

step 11 broker file import

12 – On the ‘Bulk Trade Importer - Column Selection’ page; the left side column titles in blue are your spreadsheet file uploading titles. On the right is the Sharesight fields.

Sharesight will automatically suggest Sharesight fields. To change the selections, select from the dropdown menu to match the Sharesight field to your spreadsheet column content.

Map the Column as below:

Your downloaded fileSharesight
Entry DateTrade Date
Settlement DateSkip this column
ActionTransaction Type
SymbolInstrument Code
PricePrice in Dollars
Net AmountSkip this column
Market Code (this is the column you have added)Market Code

13 – Once all columns have been matched with the correct Sharesight field or ‘Skip this column’. Click ‘Start import now’.

step 12 & 13 broker file import

14 – The ‘Trades to import into Portfolio:’ page will show an itemised list of all trades imported from the spreadsheet file. Verify and edit the trade data as required. If trades appear in red, this means that Sharesight can’t upload the trade or the trade will cause errors in your portfolio. The solutions to common errors can be found here.

step 14 broker file import

15 – Once you have verified the trade data, click ‘Save all transactions’.

16 – Once the trades are saved, your Sharesight portfolio will be populated and the Portfolio Overview Page will load.

Your holdings will be calculated by Sharesight’s performance calculation methodology which is a money-weighted return methodology, meaning the investment performance takes account of the size and timing of cash flows.

Sharesight will automatically create dividends and corporate actions for the holdings you have imported.

Now that you have populated your portfolio we recommend you verify and confirm automatically generated data and set up the broker email import feature to automatically import future trades.

step 16 broker file import

Last modified on August 19, 2021 UTC

Try Sharesight today
Track 10 holdings for free.
Sign up for Free