Back to brokers & apps

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.

TD Direct Broker Tile

2 -- From the ‘Looking to import trades from TD Direct Investing’ window, select the TD Direct Investing link.

Select the Link for TD Direct

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. TD Direct Upload a file 8 -- From the ‘Open file’ window, find and select your TD Direct Investing download file.

  1. Once the file is uploaded you will be see a table with all the trades ready to be imported. Click 'Finish and Import All'Finish and Import All- TD Direct
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.