Back to brokers & apps

HSBC Canada

Sharesight allows you to bulk import your historical buy and sell trades directly from HSBC InvestDirect Canada. You can also have your ongoing trades automatically synced to your Sharesight portfolio. Keep reading to learn how.

How to import your historical trades

Note: This only imports your trade history. Once you have imported your history, set up the Trade Confirmation Emails feature to automatically import future trades.

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

1 - HSBC tile

2 - From the ‘Looking to import trades from HSBC InvestDirect’ window, select the HSBC InvestDirect link.

2 - HSBC

3 - Login to HSBC InvestDirect.

4 - Navigate to your trading account.

5 - Find the link to download your trades. This is typically labelled ‘trades’ or ‘confirmations’. If you have the choice, choose ‘CSV’ as the file type. Otherwise, choose ‘XLS’ or ‘XLSX’ format.

3 - HSBC

6 - Check that your downloaded file contains the required information. If necessary, convert your XLS or XLSX file to CSV format. If you require assistance please contact support and we will help you.

7 - From the ‘Looking to import trades from HSBC InvestDirect’ window, click the ‘Choose file’ button.

8 - From the ‘Open file’ window, find and select your HSBC InvestDirect download file.

9 - Click the ‘Open’ button.

step 8 & 9 broker file import

10 - From the ‘Looking to import trades from HSBC InvestDirect' window, click the ‘Upload’ button.

4 - HSBC

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 CSV 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 CSV column content. Make sure the Compulsory Fields are selected. If a field isn’t required select ‘skip this column’.

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

step 16 broker file import

Your holdings will be calculated by Sharesight’s performance calculation methodology, which is a money-weighted return methodology, meaning the performance figures take 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 any automatically generated data.

How to automatically import future trades

You can automatically import your ongoing ANZ Share Investing trades using Sharesight's trade confirmation emails feature. Read more about how to forward your contract notes in this guide.