Export your buy and sell transactions

Export buy and sell transactions from your online broker to create your portfolio in ShareAnalysis.

Before you can import your portfolio transactions into ShareAnalysis, you need to export them out of your online broking account. Below you’ll find a list of brokers supported by ShareAnalysis. For assistance exporting your transactions, please contact your broker’s help desk.

Stockbroker

Help desk number

CommSec

13 15 19

Westpac Broking

13 13 31

Sharesight

N/A

CMC Markets and e.broking

1300 557 561

E*TRADE

1300 658 355

Macquarie Prime

1800 187 434

Stex Portfolio Manager

03 9646 0109

RBS Morgans

1300 787 543

Google Finance

N/A

CommSec, Westpac Broking and E*TRADE examples

Here are step-by-step instructions for CommSec and Westpac Broking customers.

CommSec

1. Go to Portfolio

2. Click ‘Accounts’

3. Select the ‘Transactions’ tab

4. Choose the date range you’d like to export, then click Search

5. Click ‘Download CSV’. CommSec will export your transactions and save them to your desktop, or documents/downloads folder.

CommSec

Westpac Broking

1. Go to ‘My Account’

2. Click ‘Holdings & Accounts’

3. Select the ‘Transactions’ tab

4. Choose the date range you’d like to export, then click Search

5. Click ‘Download CSV’. Westpac will export your transactions and save them to your desktop, or documents/downloads folder.

Westpac Broking

 

E*TRADE

1. Go to ‘My Account’

2. Click ‘Accounts Records’

3. Select the ‘Yearly Trading Statement’ tab

4. Then select the account and period for export. Finally download the file to a spreadsheet format. E*TRADE will export your transactions and save them to your desktop, or documents/downloads folder.

ANZ Broking

Tips for exporting your buy and sell transactions

• Export your transactions/trades, NOT your holdings/portfolio. ShareAnalysis needs to know when you bought/sold the shares and the price paid/received to calculate performance.

• File format must be ‘CSV’

If all else fails…

Just use a Basic template and you’ll have your transactions ready to go into ShareAnalysis in no time.

 

Open an excel file, then populate it with the details of your transactions:

•  Stock code

•  Trade type (buy or sell)

•  Date of the transaction

•  Number of units (shares) you bought or sold

•  The price you paid for the shares/sold them for.

Here’s an example the data you need to put into the spreadsheet.

 

Make sure you save the file in the CSV format. DO NOT save it as an Excel file.

When you’re happy all your transactions are in the spreadsheet, all that’s left to do is import your transactions into ShareAnalysis.

Import your transactions into ShareAnalysis

Import your portfolio transactions and ShareAnalysis will do all the monitoring for you!

Once you’ve imported your transactions into ShareAnalysis, then the fun really beings! But first things first. Follow these steps to import your transactions into ShareAnalysis and replicate your portfolio. 

Import Transactions is only possible on your desktop computer or Android tablet.

Open the Portfolio panel, or click the pie icon in the top navigation.

Then click the Import Transactions button.

Click the Import Transactions button

Here are the fields you need to complete.

Field

ShareAnalysis suggests

Market

Make sure you are in the market that you wish to import

Add to or create portfolio?

If you’re importing your transactions, its best to ‘Create a new portfolio’.

Portfolio Name

Type a name for your portfolio, for example ‘My SMSF portfolio’ or ‘Personal Portfolio’.

Upload CSV file to be processed

Click ‘Choose File’ or ‘Browse’, then go and find the file you’d like to import

Click ‘Upload’

ShareAnalysis will load your transactions.

Click Load Transactions

You’ll be presented with a list of the trades to be loaded, which will be uploaded into ShareAnalysis.

If you’re happy with the list, and it matches your expectations of what you hold in your portfolio, click ‘Upload’.

ShareAnalysis will confirm the transactions that have been imported.

Share Analysis will confirm the transactions that have been imported.

To review your portfolio, click ‘View Portfolio’.

Important things to note when importing trades:

• ShareAnalysis will import all trades since 2000;

• To import a sell you must have purchased the equivalent number of shares;

• If you have participated in a DRP, you will need to import the individual DRP transactions before you are able to transact a sell;

• Portfolios are specific to each market. ShareAnalysis will import transactions for companies with primary listings.

Add buy and sell transactions

Each time you make a trade, add the buy or sell transaction to your ShareAnalysis portfolio.

Your portfolio never stands still. Each time you make a buy or sell trade, you’ll need to add that trade to your portfolio in ShareAnalysis.

 

Adding buy transactions

If you’ve bought more of a particular stock that you already own, follow these steps to adjust your holdings.

Open your portfolio and find the company you’ve bought more stock in. For the purpose of this example, we bought an additional 50 Apple shares on 24 February for $133.40 per share.

Click the green +

Click the green +

Now complete the transaction details, then click Save.

Complete the transaction details

Field to complete

What you need to do

Buy or sell

Select your transaction type

Number of shares

Type the number of shares you bought or sold

Date

Select the date you made the trade

Price

Type the price you paid/sold them for. By default, ShareAnalysis will populate the closing price for the day of your trade.

Save

When you’ve added all the transaction details, click Add

ShareAnalysis will adjust your holdings.

Click the ‘Transactions’ tab to see the second tranche of shares you purchased.

Click the ‘Transactions’ tab to see the second tranche of shares you purchased.

 

Adding a sell transaction

Selling a stock is almost the same as buying.

On the Stocks tab, click the red – to add a transaction.

On the Stocks tab, click the red - to add a sell transaction

Add the transaction details: number of shares, date and price you sold the shares for.

Select the ‘sell’ button and add the transaction details

Click Save.

Go to the Transactions tab to see the sell transaction. It’s shaded red.

Go to the Transactions tab to see the sell transaction.

Don’t forget to add your new transactions

Remember, each time you buy or sell shares, add the transactions to ShareAnalysis. With your portfolio holdings up-to-date you’ll be able to see how your portfolio has performed today, over three months/six months/one year/three years and since inception.

ShareAnalysis also tracks your unrealised and realised gains, and the income you have received.

Add a new stock to your portfolio

Each time you buy a new stock, add the transaction to your portfolio.

When you purchase a new stock (rather than adding to an existing holding), remember to add that trade to your portfolio.

Adding a new stock

If you’ve bought shares in a company that isn’t already in your portfolio, follow these steps to add the buy transaction.

Click the magnifying glass icon to open Search.

Click the magnifying glass icon to open Search.

Type the name or stock code of the company you’ve purchased, then click Add to Portfolio.

Type the name or stock code of the company you’ve purchased, then click Add to Portfolio.

Complete the transaction details.

Field to complete

What to do

Select a portfolio

Choose the portfolio for which you bought the shares

Number of shares

Type the number of shares you bought

Date

Select the date you bought the shares

Price

Type the price you paid for the shares (ShareAnalysis will tell you the high and low price for the date you select).

Complete the transaction details then click Add

Click Add to add the buy transaction to your portfolio.

Click the Transactions tab to see the buy transaction. If the company has paid dividends since you purchased the shares, ShareAnalysis will include those details.

Click the Transactions tab to see the buy transaction.

Repeat this process to add more new buy transactions to your portfolio.

 

Edit buy and sell transactions

Edit your buy and sell transactions to keep your portfolio up-to-date.

Adjusting your buy and sell transactions is simple. If you want to change the purchase price, purchase date, or the number of shares your bought/sold, follow these steps.

Open your portfolio and click the Transactions tab.

Next to the transaction you’d like to edit, click the pencil.

Edit your buy and sell transactions to keep your portfolio up-to-date.

Adjust the transaction details (number of shares/date/price) and then click Save.

ShareAnalysis will update the transaction and recalculate your portfolio’s market value and portfolio performance metrics.

To completely delete a transaction click Remove transaction

Monitor and evaluate your portfolio in ShareAnalysis

Instantly see future growth and income, and be notified when you need to place a trade.

Are your stocks positioned for growth? How much income could you receive this year? Is your portfolio overweight in one sector? ShareAnalysis’s portfolio tool has the answers for you.

With your portfolio loaded into ShareAnalysis, you can:

• Check out your portfolio’s historical performance, including share price appreciation and dividends received.

• Assess how your portfolio is spread across different industry sectors. Is your portfolio overweight in one sector?

• See the forecast future value of your portfolio. Are your stocks positioned for growth? Which stocks are dragging down the future growth prospects of your overall portfolio?

• Check out future dividends. How much income could your portfolio receive this year?

• Review your buy and sell transactions, and dividends received.

• Evaluate and compare your stocks in ShareAnalysis. See them as a list and check out a variety of historical and forecast financial ratios. You can also compare and evaluate the historical and forecast fundamentals of your stocks side-by-side.

• Set up stock alerts to be notified when share prices move above or below specific thresholds, if valuations change overnight, and when new annual or interim reports are released.

 

Check out your portfolio’s historical performance, including capital growth and dividends received

 

Check out your portfolio’s historical performance, including capital growth and dividends received

Colour of the performance chart

The price chart plots the daily performance of your portfolio, including capital growth and dividends received. A green chart indicates positive performance since the previous trading day, and a red chart indicates negative performance.

Change since inception

The percentage change in the Market Value of the shares held in the portfolio, plus income received, since the portfolio was created.

Unrealised Gains

Unrealised profits/losses on stocks currently held.

Realised Gains (inception)

Profits/losses on investments that have been sold.

Income (inception)

ShareAnalysis calculates the Income of each holding in the portfolio and adds them together to provide the total Income paid by your portfolio.

 Click to evaluate individual stocks

You’ll find the performance of individual stocks at the bottom of the page. To open the company’s Evaluate pages, click on the company name.

Assess how your portfolio is spread across different industry sectors

Assess how your portfolio is spread across different industry sectors

Instantly see how your stocks are spread across sectors. Hover your mouse over a section of the donut to see the percentage of your stocks in that sector.

A green sector indicates positive share price performance since the previous trading day, and a red segment negative performance. Grey means no change.

 

 

 

 

See the future value of your portfolio

 

See the future value of your portfolio

ShareAnalysis aggregates the intrinsic valuations of each share in your portfolio, multiplied by the number of shares you own, to estimate the future value of your portfolio.

This figure represents the intrinsic value of the stocks you own, and is not related to the Market Price. If the Future Value is less than the Market Value, this indicates some or all of your shares are trading at a negative safety margin – the share price is higher than the intrinsic value.

Are your stocks positioned for growth? Which stocks are dragging down the future growth prospects of your overall portfolio? Click the ‘Stock List’ icon to see your stocks as a list and check out a variety of historical and forecast financial ratios.

How much income is your portfolio forecast to pay this year and over the next two years?

 

Click ‘Future Income’ to see the total dividends ShareAnalysis forecasts your stocks will pay each year, for the next three years.

How much income is your portfolio forecast to pay this year and over the next two years?

Review your buy and sell transactions, and dividends received

 

Review your buy and sell transactions, and dividends received

Click the ‘Transactions’ tab to review buy and sell transactions, and dividends received.

Click the column headings to re-sort the list by a specific metric, for example Date.

Evaluate and compare your stocks in ShareAnalysis

 

Evaluate and compare your stocks in Share Analysis

With your portfolio in ShareAnalysis, evaluating and comparing your stocks is just one click away.

Click the ‘Stock List’ button to see your portfolio as a list of stocks. 

With your portfolio in Share Analysis, evaluating and comparing your stocks is just one click away. Click the ‘Stock List’ button to see your portfolio as a list of stocks.

To compare your stocks’ fundamentals side-by-side, click the ‘Compare’ button. 

To compare your stocks fundamentals side-by-side, click the ‘Compare’ button

Stay on top of changes with Stock Alerts

 

Create stock alerts specific to your portfolio and ShareAnalysis will send you an email when you need to place a buy or sell trade.