Import your historical trading data from Questrade

To bulk import your historical trading data from Questrade to Sharesight:

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

1. Select Questrade tile

2 From the ‘Import your historical trade from your Questrade account.’ window, select the Questrade link.

Step 2 select Questrade link

3 In Questrade ‘Account activity’ banner, select the date range of the period covering trades you would like to import into Sharesight.

Note: Any trades outside the selected date range will not be imported into Sharesight.

4 Then select ‘Export to Excel’. This will download all Buys and Sell made by Questrade in the date range selected into a CSV file which can then be uploaded directly into Sharesight.

Note: If you have changed brokers and transferred the holdings to Questrade these trades will not be in the ‘Exported to Excel’ file and will not be imported into Sharesight. This can be added these trades and holdings manually.

3 & 4 select date range & select export to Excel

5 From the ‘Import your historical trade from your Questrade account’ window, click the ‘Choose file’ button.

step 5 click choose file

6 From the ‘Open file’ window, find and select your Questrade exported Excel file. It is likely the file will be in your downloads folder.

7 Then click the ‘Open’ button.

6 & 7 Select and upload Questrade exported file

8 From the ‘Import your historical trade from your Questrade account ‘ window, click the ‘Upload’ button.

step 8 click upload

9 The ‘Trades to import into Portfolio:’ page will show an itemised list of all trades imported from the Questrade exported Excel 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.

Note: Sharesight currently does not support the OTCBB and Over the Counter, OTC markets.These can be added as custom investments. If you invest in these Stock Exchange ask us to support it by ‘sharing an idea’ on the Sharesight community forum. If someone else has already suggested it, please click the ‘+1’ button to add your vote.

10 Once you have verified the trade data, select ‘Save all transactions’.

9 & 10 Verfiy & save trades

11 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.

11 successfully saved and imported Questrade

Last modified on December 4, 2017 UTC