Bulk import historical buy and sell trades

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

Import a spreadsheet containing your historical buy and sell trades is a quick way to populate your trades into your Sharesight portfolio. Most brokers will enable you to download your historical trade history in a spreadsheet.

For your spreadsheet to successfully import:

Download the template spreadsheet to create your historical trade spreadsheet if required: icon csv   Bulk Import Historical Trades Template Spreadsheet

Step by step guide:

1 – Log into your broker or portfolio tracking provider and download your historical trades as a spreadsheet file.

2 – Open the downloaded spreadsheet file and check it has the 6 compulsory fields, column headings on the first row and data format required for the file importer feature.

3 – Login to Sharesight.

4 – On the ‘Let’s get started with Sharesight’ page, select the ‘Import from a file’ tile.

4 - Bulk file import

5 – Select ‘Choose file’.

5 - Bulk file import

6 – From the ‘Open file’ window, find and select your downloaded historical trade spreadsheet. The file will likely be in your downloads folder.

7 – Click ‘Open’.

6 & 7 - Bulk file import

8 – Select ‘Individual trades’.

8 - Bulk file import

9 – Click ‘Next’.

9 - Bulk file import

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

10 - Bulk file import

11 – On the ‘Bulk Trade Importer - Column Selection’ page; the left side column titles in blue are your spreadsheet column headings. On the right is the Sharesight fields.

Bulk Trade Import page

Sharesight will automatically suggest Sharesight fields. To change the selections, select from the dropdown menu to match the Sharesight field to your spreadsheet column content. Make sure the 6 compulsory fields are selected. If a field isn’t required select ‘skip this column’.

11 - Bulk file import

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

12 - Bulk file import

13 – The next page will show an itemised list of all trades importing from the spreadsheet.

13 - Bulk file import

There are 3 tabs at the top of the page:

Imported Trades tab - This tab contains the number of trades that have been imported in this process.

Ready to Import tab - This tab contains the number of trades that are available to import, they can be edit and deselected from this tab.

Rejected Trades tab - This tab contains the number of trades that are currently not available to import this is due to them either not being supported but Sharesight i.e. CFDs or the trade does not contain the minimum 6 data points need to successfully import.

The solutions to common errors can be found here.

To edit the trade data click on the pen icon.

Pen icon

Edit the trade data and then click the save icon to save.

edit, select & save bulk import

14 – Once you have verified the trade data, click ‘Finish and Import All’.

14 - Bulk file import

15 – Once the trades are imported, the trades move to the ‘Imported Trades’ tab. Click on ‘Back to Portfolio’ to load the Portfolio Overview Page .

15 - Bulk file import

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:

1 - Review the trades imported:

a – Handle any negative holdings - Holdings with less buy trades than sell trades (can occur when transferred stocks from another broker, dividend reinvestment plan or off market purchases).

b - Handle any non automated corporate actions, such as mergers etc.

c - Check fractional share trades for rounding differences.

d - For international stocks, the exchange rates are generated by Sharesight using the end of day exchange rate, these can be edited within the trade.

2 - Set up any dividend reinvestment plan.

3 - Verify and confirm automatically generated data (dividends and corporate actions).

4 - Set up the Trade Confirmation Emails feature to automatically import future trades.

5 - Share access to your portfolio with your accountant.

6 - Add your other investments to Sharesight.

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.
  • The total amount of holding bought or sold – Sharesight calculates this by the share price and quality.

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 usage 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 File import tool allows a maximum of 500 trades per spreadsheet file.
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 spreadsheet file download from your new broker. You will need to download the spreadsheet from the original broker or adding the holdings and trades in manually.

Other supported files

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

Last modified on August 3, 2020 UTC

Try Sharesight today
Track 10 holdings for free.
Sign up for Free