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.
Important note on useage limits – Sharesight is designed for investors. Due to the real-time nature of our performance calculations, Sharesight is not suitable for active traders with large trading volumes. Sharesight is limited to a maximum of 300 trades per holding and works best with less than 3000 trades per portfolio. Our CSV import tool allows a maximum of 500 trades per CSV file.
CSV File - Column Headers
|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|
|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|
Download the following template files to complete if required:
Other supported files
The Sharesight file import feature also directly supports export files from the following systems:
- Direct Broking Limited
- Sharesight All Trades Report Export
Please let us know if you would like support for other export files.
Last modified on April 6, 2017 UTC