How to import your historical trading data from Stake CSV to Sharesight

Stake has created an historical trades report (CSV file) to enable Stake’s customers to seamlessly bulk import their Stake trades into Sharesight. Once uploaded, you will be able to make use of Sharesight’s reporting tools to generate tax reports for the 2019 financial year.

Note: If you have already populated your portfolio by forwarding the confirmation emails using the Broker Email Import feature. Importing the CSV will duplicate the trades in the portfolio.

Step by step guide:

1 - Open the email from Stake titled ‘Stake Trades - Sharesight’ that you received in July and download the attached file ‘stake_trades_sharesight.csv’.

2 - Login to or Sign up for Sharesight.

3 - On the ‘Let’s get you started with Sharesight’ page, select the ‘Import from your Broker’ tile.

3 - stake

4 - Click on the Stake Tile.

4 - stake

5 - On the ‘Import your historical trades from Stake’ page, click ‘Choose file’.

5 - stake

6 – From the ‘Open file’ window, find and select your downloaded Stake historical trade CSV file, titled ‘stake_trades_sharesight.csv’.

The file will likely be in your downloads folder.

7 – Click ‘Open’.

6 & 7 - stake

8 – Click ‘Upload’.

8 - stake

9 – The ‘Trades to import into Portfolio:’ page will show an itemised list of all trades imported from the Stake CSV file. Verify and edit the trade data as required.

If trades appear in red, this means that Sharesight either can’t upload the trade or the trade will cause errors in your portfolio.

A common error issue when importing from a Broker is:

‘Saving this trade would result in a negative number of Shares being held’

This means you are importing more sell shares of a stock than bought shares. It happens if you have transfers stock from another broker or have any off-market trades.

Click ‘Import anyway’ for each of these stocks. Then handle them later in Sharesight.

The solutions to other common errors can be found here.

10 – Once you have verified the trade data, click ‘Save all transactions’.

10 - stake

11 – Once the trades are saved, your Sharesight portfolio will be populated and the Portfolio Overview Page will load.

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 (occurs when transferred stocks from another broker).

b - Check fractional share trades for rounding differences.

c - Exchange rates are generated by Sharesight using the end of day exchange rate, these can be edited within the trade.

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

Note: When importing your Stake CSV, sell trades may contain regulatory fees (SEC/TAF fees) within the brokerage field.

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

3 - Set up the broker email import feature to automatically import future trades.

Note: You will need to manually forward on the confirmation emails you receive from Stake to Broker Email Import (portfolio) email address.

4 - Share access of your portfolio with your accountant.

5 - Add your other investments to Sharesight.

6 - Use Sharesight to help you complete your tax return.

Last modified on July 23, 2019 UTC