Learn

LONG TERM INVESTING

How can I add pre-Pearler trades to Sharesight?

Profile Piture
By Kurt Walkom

2022-04-218 min read

Are you looking to add shares to Sharesight that you purchased before signing up to Pearler? It might feel daunting, but we're here to take you through the entire process.

blog cover photo

You’ve recently transferred your portfolio across to Pearler and set up your Sharesight integration. Now you’ve noticed that while all your trades made on Pearler have automatically synced with Sharesight, your pre-Pearler trades have not.

Since the only way to push data to Sharesight is by pushing trade information, Pearler cannot automatically sync trades that were made on other brokerage platforms.

There are two ways you can add buy and sell trades or adjustments manually:

  1. Update a single holding (best for a handful)
  2. Bulk import historical buy and sell trades (best for many)

Update a single holding

You can add additional buy and sell trades or adjustments manually for any holding in a Sharesight portfolio. This is the best option if you just need to add a handful of trades.

1 – On the Portfolio Overview Page, click on the holding. 2 – On the Individual Holding Page, click the ‘Enter a new Trade or Adjustment’ button.

Sharesight 1.png

3 – From the type dropdown menu, select the transaction or adjustment type. Depending on the transaction or adjustment type, the ‘Enter a new Trade’ form fields will change.

Sharesight 2.png

4 – Fill in all the fields for the trade or adjustment. For a buy or sell trade, Sharesight will suggest a share price underneath the ‘Shares Price’ field. Click on the price for it to be entered in the share price field.

5 – Click the ‘Save this trade’ button.

Sharesight Integration

Note: If you receive a ‘Saving this trade would result in a negative number of shares being held (-46)’ error message, it means you are trying to save a trade that would result in a negative number. Sharesight will not allow you to save a trade that would result in a negative quantity position. For this reason, it is best to record additional trades in the date order that they occurred.

Bulk import historical buy and sell trades

Importing a spreadsheet containing your historical buy and sell trades is the quickest way to populate a large number of trades into your Sharesight portfolio (when they haven’t been synced already). Most brokers will enable you to download your historical trade history in a spreadsheet.

For your spreadsheet to successfully import:

Tracking your shares

Download the template spreadsheet to create your historical trade spreadsheet if required:

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.

Sharesight 5.png

5 – Select ‘Choose file’.

Tracking your shares

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’.

Sharesight 7.png

8 – Select ‘Individual trades’.

Sharesight 8.png

9 – Click ‘Next’.

Monitoring your trades

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

Sharesight 10.png

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.

Sharesight 11.png

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’.

Sharesight 12.png

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

Sharesight 13.png

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

Sharesight 14.png

There are 3 tabs at the top of the page:

Imported Trades

  • This tab contains the number of trades that have been imported in this process.

Ready to Import

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

Sharesight Tab 3.png

  • 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 point need to successfully import.

The solutions to common errors can be found here.

To edit the trade data, click on the pen icon.

Sharesight 15.png

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

Sharesight 16.png

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

Sharesight 17.png

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.

Sharesight 18.png

Your holdings will be calculated by Sharesight’s performance calculatrion 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, Sharesight recommends 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.

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

b) Set up the Trade Confirmation Emails to automatically import future trades.

c) Share access to your portfolio with your accountant.

d) Add your other investments to Sharesight.

WRITTEN BY
Author Profile Piture
Kurt Walkom

Kurt is one of Pearler's co-founders. After reading the Barefoot Investor at the age of 14, Kurt got started on his Financial Independence journey early. He invested his $15,000 in "life savings" in 3 stocks based on a stockbroker's recommendation – right before the Global Financial Crisis. Seeing his share portfolio plummet in value (and never bounce back), Kurt resolved to learn all he could about investing, and why retail investment advice gets it so wrong, so often. In 2018, Kurt co-founded Pearler with his two friends, Hayden and Nick, to make it easier for everyday Aussies to invest in shares the right way - incremental amounts in diversified portfolios, for the long-term.

first trade free
first trade free

Your first trade is free after
signing up to Pearler!

Home