Import SelfWealth trades

Content also available for tax entities or on our global site.

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

1 – On the ‘Let’s get you started with Sharesight’ page, select the ‘Import from a File’ tile.

Import file

2 – Login to SelfWealth.

4 - Select ‘Trading Account’

4

5 - Select ‘Reports’

5

6 - Report Filters: ‘Include Trades’ only

6

7 - Report Time Period: ‘Custom’

7

8 - Enter the date range of the trades to include in the spreadsheet. From: ‘01/01/2000’ (before your first trade). To: Enter today’s date.

8

Note: If you have already populated your portfolio by forwarding the confirmation emails using the Trade Confirmation Emails feature. Importing the spreadsheet will duplicate the trades in the portfolio.

9 - Select ‘Export Rows’: As CSV

9

10 - Open the spreadsheet in Google Sheets or Microsoft Spreadsheet

11 - Highlight Column A ‘Transaction date’

12 - Format the content of the column to DD/MM/YYYY. Right click > select ‘Format cell..’ > select ‘Date’ > select DD/MM/YYYY.

13 - Highlight Column B ‘Comment’.

14 - This column contains data that Sharesight needs to be separated into different columns to successfully import.

In Excel: Select: ‘Data’ tab > ‘Text to columns’ >Next> Delimiter: Space>Next>Finish

Excel - text to columns

In Google sheets: Select: ‘Data’ tab > ‘Split text to columns’ > Separator: Space

Google sheets - split text to columns

15 - Keep the columns:

Transaction type - Whether the trade was a buy or sell

Quantity - The number of shares bought or sold

Price - The price per share in the currency of the market

Instrument code (ticker) - The investment code (stock ticker, fund name, etc)

16 - Title the columns as above on the first row of the spreadsheet, remove all other content.

17 - Add a new column and title it ‘Market code’. Add the market code to all investments, for example: ASX, NZX, LSE, NYSE, NASDAQ, FUNDS NZ, FUNDS AU

18 - Save the spreadsheet as CSV format.

19 - Upload file to Sharesight using the File importer and click ‘Next’.

20 - 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 Fields to your CSV column content.

Make sure the Compulsory Fields are selected. If a field isn’t required select ‘skip this column’.

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

Bulk CSV import step 11 & 12

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

23 - Once you have verified the trade data, click ‘Save all transactions’.

Bulk CSV import step 13 & 14

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

Bulk CSV import step 15

Now that you have populated your portfolio we recommend you:

1 - Review the trades imported:

a – Handle any negative holdings - Holdings with less buy trades than sell trades (occurs when transferred stocks from another broker).

b - Handle any non automated corporate actions, such as mergers etc.

2 - Verify and confirm automatically generated data (dividends and corporate actions).

3 - Set up the Trade Confirmation Emails feature to automatically import future trades.

4 - Share access of your portfolio with your accountant.

5 - Add your other investments to Sharesight.

6 - Use Sharesight to help you complete your tax return.

Last modified on July 22, 2020 UTC