Importing your trading history directly from your broker

Using the Broker Import function is an easy way to setup a new portfolio in Sharesight. The Broker Import function will import the trading history directly from your online broker’s website. For supported brokers, this process essentially automates our CSV file import tool.

Instructional video

Embedded content: Using Broker Import - Sharesight Portfolio Management

Where to start

It’s best to utilise this feature with a new or empty portfolio as this removes the possibility of importing duplicate transactions. To begin, click the tab ‘Import from your Broker’.

BrokerImportNewSS1.1

Select your broker

The following screen will prompt you to select one of our 8 brokers.SelectBrokerNewSS2

Fill out your login details safely

Next, enter your login details just as you would on your online broker’s website. Note: Sharesight will never remember or store this information. You are simply using your private login to download your trading data, which is then uploaded on your behalf.

How much data will be imported?

You may also optionally specify a custom date range on this page. For example, if you are running the import into an existing portfolio, you may already have some trading history recorded and therefore only want to import newer trades into your portfolio.

Keep in mind that when you introduce trading history, Sharesight will automatically create dividends and corporate actions in your portfolio. The farther back in time you go, the more data will be created. It’s always a good idea to double check your data. FillOutLoginDetailsDateRangeSS3

Verify your data and edit your transactions

Once you’ve entered your login details and specified a date range click the Import button. Sharesight will now retrieve your transaction history from your online broker. The next page displays the data that’s been brought across and allows you to verify that the trade data is accurate. You can edit the transactions that have been automatically populated, ignore transactions by ticking the box, and add transactions by clicking Add Row. You can save transactions for each holding individually, or click the Save all transactions button at the bottom of the page to import all transactions at once. BrokerImportConfimTRadesSSNew4

Error warnings

The next page will dynamically show you the trades that have been recorded successfully (the green rows that build up in the Saved Trades section) and point out any errors as well. Here, again, you’ll be given a chance to edit the transactions that have been automatically populated, ignore transactions by ticking the box, or add transactions by clicking Add Row. ErrorWarningsSSNew5

If all trades were recorded successfully this page will automatically take you into your new portfolio. If you rectified (or ignored) and errors, click Save all transactions again and then you’ll be taken into your new portfolio. Once in your new portfolio, you’ll notice that your trades will be backdated to when they were executed on your broker and that all dividends and corporate actions have been automatically populated.

The Broker Import only allows you to import historical trades. This is not an on-going or active connection. In order to have future trades automatically populated in Sharesight, we recommend that you use our contract note email import service.

Handling negative balances and negative number of shares errors

If you’ve ever transferred holdings from one broker to another, you may encounter a negative balance error message. Since the original broker doesn’t give your current broker any transactional details, Sharesight won’t receive them either. This results in a situation where you’re telling Sharesight to, for example, sell units in a holding we don’t know that you own.

This is easily fixed in one of three ways:

  1. On the error page, record the missing transaction(s). Click the ‘Add row’ link to record any missing transactions.
  2. On the error page, edit the transaction(s) causing the error.
  3. Exclude the holding from the import and deal with it later. If you don’t have the missing data at hand, you can use the delete checkbox to exclude certain transactions from the import. You can set up these holding later using an opening balance transaction or by manually entering your original buy transaction

Last modified on March 7, 2017 UTC