Posted by Doug Morris on July 23, 2014
This is a huge new feature announcement. Now on Sharesight you can instantly import your trading history directly from your broker – meaning no data to enter or spreadsheets to upload. This is by far, the easiest way to get started with Sharesight or to bring in your additional portfolios.
Broker Import allows you to login to your online brokerage account – from within Sharesight. After you securely connect, we’ll automatically import your buy and sell transactions within a date range of your choice. Importing takes a few seconds. When finished, your portfolio will now be setup on Sharesight – complete with your entire trading history.
Give it a try
To try it out, we’d recommend creating a new portfolio, or using a “spare” portfolio you might keep for watchlist purposes. From the new dropdown menu next to Add Holding, select Import from your broker and choose your broker (Westpac is coming soon!):
On the next screen, enter the same details you use to login to your broker’s website and click Import. For security reasons, Sharesight will never store or remember your broker login details. You’re essentially downloading your trading history through a secure connection, and uploading it into Sharesight’s existing setup process.
After a few seconds, Sharesight will display the trading history collected from your broker. This is a really handy step, which allows you to confirm the trades you’re about to use to create the portfolio’s history. For those of you who’ve used our bulk importer before, you might notice that we’ve married Broker Import with our existing spreadsheet upload process.
This page will also allow you to make adjustments (if necessary) without having to leave Sharesight. If you do get stuck on a particular holding, you can always come back and add it manually later.
Once ready click Save all transactions and Sharesight will begin building your portfolio. You’ll see a number of green rows of data layering on top of one another. Any errors that do appear can be dealt with on this page, ignored, or handled once inside your new portfolio. In other words, should any of your holdings not flow through to Sharesight automatically, we’ll flag those, but still set up your portfolio based on the trades that did come through successfully.
And that’s it! The page will refresh and you’ll be taken into your new portfolio. And just like Sharesight does for any holding, we’ll auto-populate all subsequent dividends and corporate actions.
We’re thrilled about this new feature and we can’t wait to get your feedback. We think this will help investors of all kinds and the professionals who look after their portfolios. The faster and easier you can get your data to work in Sharesight, the quicker you can make better investment and tax decisions. We’ve always made it our mission to cut down on the admin time spent on portfolios. We think Broker Import represents an exponential leap forward.
Keep in mind when using a feature that’s THIS automatic & powerful:
1. It’s still beta. There is only so much testing we can do. This feature will be only be optimised after you give it a go and send us your feedback.
2. Broker Import will only bring in your historical trades. You will still need to use our contract note feature for auto-recording future buys and sells.
3. Be mindful of how much history to bring across. If you bring in 20 years worth of trade data, you’d be wise to go through and double check your dividends and corporate actions since we populate everything automatically. And for 20 years – that’s a lot of data. Any edits that you missed will compound over time. Starting since your last tax return or for the past 12 months is a more manageable approach.
4. Negative balances. 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 right on the error page:
- Record the missing transaction(s). Click the ‘Add row’ link to record any missing transactions.
- 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.