Bulk importing historical trades via CSV

To import a CSV spreadsheet file containing historical buy and sell trades into your Sharesight portfolio, simply select ‘Import a CSV file’ from the ‘Add Holding’ drop-down button and follow the prompts.

Bulk importing historical trades via CSV: Column Headers

Compulsory Fields

Column Header Description Accepted Values Example Notes
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
(supported currency formats)
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

Template file

Download the following template files to complete if required:

CSV template_bulk-upload_historical-trades

Other Supported Files

The Sharesight file import feature also directly supports export files from the following systems:

  • Direct Broking Limited
  • Sharesight ‘All Trades’ Export

Please let us know if you would like support for other export files.

Last modified on May 18, 2016