Importing historical trades from Scotiabank

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 Scotiabank to Sharesight:

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

1 - Scotiabank tile

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

2 - Scotiabank

3 – Login to Scotiabank.

4 – Navigate to your trading account and click on the account number link, example is ‘123-45678’.

4 import Scotiabank

5 – Click on the ‘Custom Search” button on the ‘Account Details’ page.

5 import Scotiabank

6 – Enter the date range for the historical trades you wish to import into Sharesight.

Note: Scotiabank provides 7 years of transaction history.

6 import Scotiabank

7 – Select ‘Buy’ and ‘Sell’ in ‘Transaction Type’.

Note: Don’t worry about dividends and corporate actions, Sharesight will automatically generate them and you can adjust them if required.

7 import Scotiabank

8 – Select; ‘Equities’, ‘Mutual Funds’ and ‘Fixed Income’ in ‘Security Type’.

Note: Sharesight currently does not support Options. Options can be added as Custom Investments.

8 import Scotiabank

9 – Select ‘All’ in ‘Account Currency’.

9 import Scotiabank

10 – Click on the ‘Search’ button.

10 import Scotiabank

11 – When the page refreshes, click the ‘Download Data’ icon at the top of the page. 11 import Scotiabank

12 – On the popup window, click on the ‘Download transaction’ link to download your transaction history in CSV format.

13 – 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 market code the stock is held, on e.g. TSE, CNSX, NASDAQ.

Note: When saving the file make sure you save it as a CSV format.

14 – From the ‘Looking to import trades from Scotiabank’ window, click the ‘Choose file’ button.

14 - Scotiabank

15 – From the ‘Open file’ window, find and select your Scotiabank download file. The file is mostly in your download file, titled; transactionHistory.csv.

16 – Click the ‘Open’ button.

15 & 16 import Scotiabank

17 – From the ‘Looking to import trades from Scotiabank’ window, click the ‘Upload’ button.

17 import Scotiabank

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

18 import Scotiabank

19 – 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
DescriptionComments
SymbolInstrument Code
Transaction DateTrade Date
Settlement DateSkip this column
Account CurrencySkip this column
TypeTransaction Type
QuantityQuantity
Currency of PriceSkip this column
PricePrice in Dollars
SettlementSkip this column
AmountSkip this column
Market Code (this is the column you have added)Market Code

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

19 & 20 import Scotiabank

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

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

21 & 22 import Scotiabank

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

23 import Scotiabank

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 May 1, 2018 UTC