Bulk importing opening balances via CSV

Sharesight lets you import a CSV file to ensure you can quickly upload your trades to a portfolio. 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.

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

Compulsory Fields

Column HeaderDescriptionAccepted ValuesExampleNotes
Opening Balance DateThe opening balance datedd/mm/yyyy (must be in this order)30/06/2012 Usually this would be the end of the previous financial year
Instrument CodeThe instrument code (stock ticker, fund name, etc)codeTLS 
Market CodeThe market codeASX, NZX, LSE, NYSE, NASDAQ, FUNDS NZ, FUNDS AUASX 
QuantityThe quantity of shares held on the opening balance dateInteger (should be a positive value)1000 
Cost BaseThe 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 HeaderDescriptionAccepted ValuesExampleNotes
Combined CodeThe Instrument Code and Market Code separated by a periodInstrumentCode.MarketCodeTLS.ASXCan be used instead of the individual columns Instrument Code and Market Code
Market PriceThe market price of the share on the opening balance dateDecimal (2dp)12.34Will default to Sharesight’s closing market price if not specified
Market Price Exchange RateThe exchange rate on the opening balance dateDecimal (4dp).8123Used only for shares listed on a foreign market - will default to Sharesight’s closing exchange rate if not specified
CommentsComments to be stored in the comments field for the transactiontextRecommended by Market Analysis newsletter 

Embedded content: Bulk importing opening balances via CSV - Sharesight Portfolio Management

Template File

Download the following template file to complete if required:

icon csv   CSV Template - Bulk Importing Opening Balance

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

Last modified on April 6, 2017 UTC