Bulk importing opening balances via CSV

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

CSV File – Column Headers

Compulsory Fields

Column Header Description Accepted Values Example Notes
Opening Balance Date The opening balance date dd/mm/yyyy
(must be in this order)
30/06/2012  Usually this would be the end of the previous financial year
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 held on the opening balance date Integer
(should be a positive value)
1000
Cost Base The cost base of the shares on the opening balance date (in your local currency) Decimal
(2dp)
1234.56  This is the total cost of the shares owned on the opening balance date, from a tax perspective

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 the individual columns Instrument Code and Market Code
Market Price The market price of the share on the opening balance date Decimal
(2dp)
12.34 Will default to Sharesight’s closing market price if not specified
Market Price Exchange Rate The exchange rate on the opening balance date Decimal
(4dp)
.8123 Used only for shares listed on a foreign market – will default to Sharesight’s closing exchange rate if not specified
Comments Comments to be stored in the comments field for the transaction text Recommended by Market Analysis newsletter

Template File

Download the following template file to complete if required:

CSV Template – Bulk Importing Opening Balances

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

Last modified on October 29, 2015