Importing historical trades from RBC Direct

Please help us improve these instructions: We know these instructions could be better. We’d be really grateful if you can help us improve them! Please contact us if you can help and we’ll give you a little thank you gift for your trouble.

To bulk import your historical trading data from RBC Direct to Sharesight:

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

1 - RBC tile

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

2 - RBC

3 – Login to RBC Direct.

4 – Navigate to your trading account.

5 – Find the link to download your trades. This is typically labelled ‘trades’ or ‘confirmations’.

The correct downloaded file is titled: [number]Activity[number][month][DD]_[YYYY].csv.

6 – From the ‘Looking to import trades from RBC Direct’ window, click the ‘Choose file’ button.

6 RBC

7 – From the ‘Open file’ window, find and select your RBC Direct download file.

8– Click the ‘Open’ button.

7 & 8 CA Broker

9 – From the ‘Looking to import trades from RBC Direct’ window, click the ‘Upload’ button.

9 RBC

10 – The ‘Trades to import into Portfolio:’ page will show an itemised list of all the buy and sell 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.

Note: Only buy and sell trades are imported using the Broker & Provider Import. This error message will be displayed when the file you are importing contains other transactions; ‘This file contains some transaction types that cannot be imported into Sharesight. Only buy and sell transactions are supported, all other transactions are not shown here.’

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

10 & 11 CA Broker

12 – 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.

12 CA Broker

Please help us improve these instructions: We know these instructions could be better. We’d be really grateful if you can help us improve them! Please contact us if you can help and we’ll give you a little thank you gift for your trouble.

Last modified on October 23, 2018 UTC