Formatting downloaded trade history files
To bulk upload your investments using the ‘File importer’ feature in Sharesight, your file must contain required information and formatting.
Open your downloaded historical trades file into your favourite spreadsheet software, such as Microsoft Excel or Apple Numbers. In the screenshot below, we’re using Google Sheets which is free and works on any computer.
Check that your file contains one row per trade and has a column for each of the following:
|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|
Most files contain other additional columns, this is fine.
The naming of the columns (column headers) is also unimportant as you will be asked to specify which column contains which piece of information during the import.
If your file is missing some of the above information, add it manually using your spreadsheet software.
When saving the file, be sure to save it in CSV format.
Last modified on March 28, 2018 UTC