Bulk importing historical buy and sell trades via CSV file

Content also available for tax entities or on our global site.

Import a CSV spreadsheet file containing your historical buy and sell trades is a quick way to populate your trades into your Sharesight portfolio.

Note that if you have changed broker and have had your historical trades transfer to your new broker, these historical trades will not be on your CSV file download from your new broker. You will need to download the CSV from the original broker or adding the holdings and trades in manually.

The first row of your file must contain a header for each column. The file must contain the compulsory fields and it is important that the column headers and data values match the format supplied in the CSV File - Column Headers section to ensure that your data is imported correctly.

Bulk Importing Historical Trades via CSV - Sharesight Portfolio Management

Most online stock brokers will enable you to download your historical trade history in a csv format

Download the following template files to complete if required:

icon csv   CSV Template - Bulk Importing Historical Trades

Step by step guide to bulk importing your buy and sell trades via a CSV file:

1 – Login to your broker or portfolio tracking provider and download you historical trades as a CSV file.

2 – Open the downloaded CSV file and check it has the Compulsory Fields, headings and format required for the Manual importer feature.

3 – Login to Sharesight.

4 – On the ‘Let’s get started by adding some trades’ page, select the ‘Manual Import’ tab, on the right-hand side of the screen.

Bulk CSV import step 5

5 – Select ‘Choose file’.

Bulk CSV import step 4

6 – From the ‘Open file’ window, find and select your download historical trade CSV file. The file will likely be in your downloads folder. Make sure it is a Comma Separated Values file. If necessary, convert your XLS or XLSX file to CSV format.

7 – Click ‘Open’.

Bulk CSV import step 6 & 7

8 – Select you are importing ‘trades’ from the dropdown menu.

Bulk CSV import step 8 opening balance

9 – Click ‘Upload’.

Bulk CSV import step 9 trade

10 – Select the date format preference. International: DD/MM/YYYY or USA MM/DD/YYYY.

Bulk CSV import step 10

11 – On the ‘Bulk Trade Importer - Column Selection’ page; the left side column titles in blue are your CSV file uploading titles. On the right is the Sharesight fields. Sharesight will automatically suggest Sharesight fields. To change the selections, select from the dropdown menu to match the Sharesight Field to your CSV column content. Make sure the Compulsory Fields are selected. If a field isn’t required select ‘skip this column’.

12 – Once all columns have been matched with the correct Sharesight field or ‘Skip this column’. Click ‘Start import now’.

Bulk CSV import step 11 & 12

13 – The ‘Trades to import into Portfolio:’ page will show an itemised list of all trades imported from the CSV file. Verify and edit the trade data as required. If trades appear in red, this means that Sharesight can’t upload the trade or the trade will cause errors in your portfolio. The solutions to common errors can be found here.

14 – Once you have verified the trade data, click ‘Save all transactions’.

Bulk CSV import step 13 & 14

15 – Once the trades are saved, your Sharesight portfolio will be populated and the portfolio overview page will load.

Your holdings will be calculated by Sharesight’s performance calculation methodology which is a money-weighted return methodology, meaning the investment performance takes account of the size and timing of cash flows. Sharesight will automatically create dividends and corporate actions for the holdings you have imported.

Now that you have populated your portfolio we recommend you verify and confirm automatically generated data and set up the broker email import feature to automatically import future trades.

Bulk CSV import step 15

CSV File - Column Headers

Compulsory Fields

Column HeaderDescriptionAccepted ValuesExample
Trade DateThe date of the tradedd/mm/yyyy (must be in this order,use 4 digits for year)22/05/2005
Instrument CodeThe instrument code (stock ticker, fund name, etc)codeTLS
Market CodeThe market codeASX, NZX, LSE, NYSE, NASDAQ, FUNDS NZ, FUNDS AU ASX
QuantityThe quantity of shares bought or soldInteger (should be a positive value)1000
Price in DollarsThe price per share in the currency of the marketDecimal (up to 6dp)12.123456
Transaction TypeWhether the trade was a buy or sellBUY, SELLBUY

Optional Fields

Column HeaderDescriptionAccepted ValuesExampleNotes
Combined CodeThe Instrument Code and Market Code separated by a period.InstrumentCode.MarketCodeTLS.ASXCan be used instead of individual columns for Instrument Code and Market Code
Exchange RateThe 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 currencyDecimal (up to 6dp)1.123456If not specified, will default to the closing exchange rate on the trade date
BrokerageThe brokerage fee paid per share in the Brokerage Currency specifiedDecimal (up to 2dp)39.95If not specified, will default to zero
Brokerage CurrencyThe currency code that the brokerage was paid in. It must be either your local currency or the currency of the marketISO 4217 formatAUDOptional, If not specified will default to the market currency
CommentsComments to be stored in the comments field for the transactiontextRecommended by Market Analysis newsletter-

Column Sharesight does not need

  • Instrument name – Sharesight data provide this information from the instruction and market codes
  • Total amount of holding bought or sold – Sharesight calculates this by the Share price and quality.

Other supported files

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

Would you like us to support other export files?

If you would like support for other export files, please let us know by ‘sharing an idea’ on the community forum. If someone else has already suggested that we add your broker, please click the ‘+1’ button to add your vote. This will allow us to prioritise support for additional brokers.

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.

Last modified on April 16, 2018 UTC