Common errors when bulk importing trades

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

If trades appear in red, this means that Sharesight can’t upload the trade or the trade will cause an error in your portfolio. The solutions to common errors can be found below:

Error:

‘Saving this trade would result in a negative number of shares being held.’ Or ‘The first trade must be a ‘Buy’’

Saving this trade would result in a negative number of shares being held.

Example The holding you are importing only has a Sell and not a Buy. Sharesight requires holding to have a Buy to have a Sell.

Why might this happen? You are importing only part of your history or you have changed brokers and are only importing the history from the broker who performed the Sell. The Buy is not included in the import.

How to fix this This trade can be imported but will not be shown or calculated in your portfolio until the holding is not negative. You will need to manually add the Buy trade. If you don’t know the date of the trade, this could be added using an open balance. We recommend using the date of the beginning of the financial year.

Errors:

‘Trade type must be specified as Buy or Sell.’ Or ‘Trade must have a description’

Example The type of trade is not specified.

Trade type must be specified as Buy or Sell error message

Why might this happen? The file import does not specify if the trade is a Buy or Sell transaction.

How to fix this Select Buy or Sell from the ‘Type’ dropdown menu.

Error

‘We don’t have a record for [holding code] on [market code]. Please ensure the instrument code is current or consider recording it as an unquoted instrument. Learn more’

Example

‘We don't have a record for [holding code] on [market code]. Please ensure the instrument code is current or consider recording it as an unquoted instrument. Learn more’ error message

Why might this happen? Either: 1. The holding or stock exchange market is incorrect; or 2. Sharesight does not currently support the stock exchange market or investment that you are importing.

How to fix this Check the holding or stock exchange market code. Check the list of supported stock exchange markets. If the stock exchange market is not are currently supported, add them as custom investments.

Error

Traded On can’t be in the future. (Current market day is [todays date])

Example Date on the holding is today.

Why might this happen? If there is no trade date on the imported file, Sharesight will default to the date of importing.

How to fix this Add the trade date by editing the ‘Traded on’ cell in the ‘Trades to import into Portfolio:’ screen. If you don’t know the date of the trade, this could be added using an open balance. We recommend using the date of the beginning of the financial year.

Errors

Quantity must be greater than zero Or Quantity can’t be blank Or Quantity must be a number between 0 and 9,999,999,999.

Example Quantity of shares is not specified.

Quantity must be greater than zero

Why might this happen? The file import does not specify the number of shares in the transaction.

How to fix this Add the trade quantity by editing the ‘Quantity’ cell in the ‘Trades to import into Portfolio:’ screen.

Error

A trade with this identifier already exists in your portfolio

Example This is a duplicate holding in your Sharesight portfolio.

A trade with this identifier already exists in your portfolio error message

Why might this happen? You are trying to import a trade that you have already imported or added to your Sharesight portfolio.

How to fix this Tick the ‘Do not import’ box on the trade. Make a note of the trade and check you Sharesight portfolio once you have finished the import. If you purchase an identical trade for a holding you can add the trade manually after the import is finished. This is done from the individual holding page.

Last modified on October 22, 2018 UTC