Import HSBC Invest Direct trades
Content also available for tax entities or on our global site.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 HSBC Invest Direct to Sharesight:
1 – On the ‘Let’s get started by adding some trades’ page, select the HSBC Invest Direct tile from the ‘Broker & Provider Import’ tab on the right-hand side of the screen.
2 – From the ‘Looking to import trades from HSBC Invest Direct’ window, select the HSBC Invest Direct link.
3 – Login to HSBC Invest Direct.
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.
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 Invest Direct’ window, click the ‘Choose file’ button.
8 – From the ‘Open file’ window, find and select your HSBC Invest Direct download file.
9 – Click the ‘Open’ button.
10 – From the ‘Looking to import trades from HSBC Invest Direct’ window, click the ‘Upload’ button.
11 – Select the date format that is used in the downloaded file; International: DD/MM/YYYY or USA MM/DD/YYYY.
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’.
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.
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.
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.
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.
CSV File - Column Headers
Compulsory Fields
| Column Header | Description | Accepted Values | Example |
|---|---|---|---|
| Trade Date | The date of the trade | dd/mm/yyyy (must be in this order,use 4 digits for year) | 22/05/2005 |
| Instrument Code | The instrument code (stock ticker, fund name, etc) | code | TLS |
| Market Code | The market code | ASX, NZX, LSE, NYSE, NASDAQ, FUNDS NZ, FUNDS AU | ASX |
| Quantity | The quantity of shares bought or sold | Integer (should be a positive value) | 1000 |
| Price in Dollars | The price per share in the currency of the market | Decimal (up to 6dp) | 12.123456 |
| Transaction Type | Whether the trade was a buy or sell | BUY, SELL | BUY |
Optional Fields
| Column Header | Description | Accepted Values | Example | Notes |
|---|---|---|---|---|
| Combined Code | The Instrument Code and Market Code separated by a period. | InstrumentCode.MarketCode | TLS.ASX | Can be used instead of individual columns for Instrument Code and Market Code |
| Exchange Rate | The exchange rate to be applied to the share price (and brokerage if applicable) - quoted as the amount of foreign currency that equals $1 of local currency | Decimal (up to 6dp) | 1.123456 | If not specified, will default to the closing exchange rate on the trade date |
| Brokerage | The brokerage fee paid per share in the Brokerage Currency specified | Decimal (up to 2dp) | 39.95 | If not specified, will default to zero |
| Brokerage Currency | The currency code that the brokerage was paid in. It must be either your local currency or the currency of the market | ISO 4217 format | AUD | Optional, If not specified will default to the market currency |
| Comments | Comments to be stored in the comments field for the transaction | text | Recommended by Market Analysis newsletter | - |
Column Sharesight does not need
- Instrument name – Sharesight data provide this information from the instruction and market codes
- Total amount of holding bought or sold – Sharesight calculates this by the Share price and quality.
Last modified on August 19, 2021 UTC