TD Direct Investing
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 TD Direct Investing to Sharesight:
1 -- On the ‘Let’s get started by adding some trades’ page, select the TD Direct Investing tile from the ‘Broker & Provider Import’ tab on the right-hand side of the screen.
2 -- From the ‘Looking to import trades from TD Direct Investing’ window, select the TD Direct Investing link.
3 -- Login to TD Direct Investing.
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 TD Direct Investing’ window, click the ‘Upload a file’ button.
8 -- From the ‘Open file’ window, find and select your TD Direct Investing download file.
- Once the file is uploaded you will be see a table with all the trades ready to be imported. Click 'Finish and Import All'
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.