Importing historical trades from CIBC Investors Edge

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 CIBC Investors Edge to Sharesight:

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

1 - CIBC tile

2 – From the ‘Looking to import trades from CIBC Investors Edge’ window, select the CIBC Investors Edge link.

2 - CIBC

3 – Login to CIBC Investors Edge.

4 – Navigate to your trading account.

5 – Find the link to download your historical trade history, the file is named: ‘Transaction History’.

6 – The downloaded file requires some editing; in the ‘Market’ column change the country code to stock market code the stock is held on, e.g. TSE, CNSX, NASDAQ. This is required content for the file to successfully upload. For other Stock Exchange codes, please refer to the Supported Stock Exchanges help page.

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

8 – Converted your downloaded file into a CSV format. If you require assistance please contact support and we will help you.

9 – From the ‘Looking to import trades from CIBC Investors Edge’ window, click the ‘Choose file’ button.

9 - CIBC import

10 – From the ‘Open file’ window, find and select your CIBC Investors Edge download file.

11 – Click the ‘Open’ button.

10 & 11 - CIBC import

12 – From the ‘Looking to import trades from CIBC Investors Edge’ window, click the ‘Upload’ button.

12 - CIBC import

13 – Select the date format that is used in the downloaded file as USA MM/DD/YYYY.

13 - CIBC import

14 – 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. Map the Column as below:

Your downloaded fileSharesight
Transaction DateTrade Date
Settlement DateSkip this column
Currency of Sub-account Held InSkip this column
Transaction TypeTransaction Type
SymbolInstrument Code
MarketMarket Code
DescriptionComments
QuantityQuantity
Currency of PriceSkip this column
PricePrice in Dollars
CommissionBrokerage
Exchange RateExchange Rate
Currency of AmountSkip this column
AmountSkip this column
Settlement InstructionsSkip this column
Exchange Rate (Canadian Equivalent)Skip this column
Canadian EquivalentSkip this column

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

14 & 15 - CIBC import

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

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

17 import Scotiabank

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

18 - CIBC import

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 July 18, 2018 UTC