Sharesight Blog

All the latest updates from the Sharesight team

Sharesight and Xero

We are pleased to announce that Sharesight has become a certified Xero network partner. Xero is a market leading online accounting system. Sharesight has partnered with Xero in order to provide a seamless solution between portfolio management and portfolio accounting. Learn more about Xero at www.xero.com, free trial accounts are available.

The Xero Synchronisation feature allows you to connect your portfolio to your Xero account. This allows you to send details of share purchases, sales, and dividends to Xero as draft invoices, which can then approved for inclusion in your financial accounts and used to reconcile against your bank account.

If you have a Xero account, Xero synchronisation can be set up by clicking settings, then ‘Xero Synchronisation’ for the portfolio that you wish to connect. Note that you must first generate a Sharesight Network key from within Xero. Full instructions can be found in the Sharesight help documentation here.

Below is a short video we prepared for Xero customers:



Calculating Share Returns

One of our most important objectives in setting up Sharesight was to give you the true return on your shares. One of the many shortcomings of the so called ‘free’ sites is that they fail miserably in this vital area.

One of the reasons they fail is that providing you with the true, annualised return on your shares is trickier than it sounds. For a start you need to have a large amount of data at your fingertips and you need to be able to account for corporate actions like dividends, share splits, amalgamations and bonus issues because these will make nonsense of return calculations if you don’t.

To further complicate matters, there are two common arithmetically correct ways to calculate returns and in some circumstances they can give radically different answers. The two methods are the compounding method and the simple or non-compounding method.

The easiest way to appreciate the difference between the two methods is to consider a deposit account at the bank. If the bank quotes you a 7% interest rate this is a compounding rate. This means that if you do not withdraw your interest it will remain in your account and you will receive interest on that interest. Under the simple or non-compounding method, interest is calculated only on the original amount invested.

It is clear from the table below that $1000 invested for 10 years at 10% using the simple method does not equal 10% using the compound method. The simple method results in the return of your initial investment of $1000 plus a further $1000 of interest at the end of 10 years, whereas the compounding method results in the return your original investment of $1000 plus $1593.74 of interest. In fact an investment of $1000 that results in a return of that investment plus a further $1000 of interest over 10 years, equates to a compound return of approximately 7%.

Rate
Time 10% Compounding* 10% Simple 7% compounding*
Y0 1000 1000 1000
y1 1100 1100 1072
y2 1210 1200 1149
y3 1331 1300 1231
y4 1464 1400 1320
y5 1611 1500 1414
y6 1772 1600 1516
y7 1949 1700 1625
y8 2144 1800 1741
y9 2358 1900 1866
y10 2594 2000 2000
*figures have been rounded for simplicity. This example illustrates annual compounding



To compare apples with apples a compound return calculation must be applied to your share portfolio if you want to compare its returns with a bank deposit. In the example above the correct return to compare to a bank deposit is 7% compound not 10% simple.

So what does Sharesight do?

Until now Sharesight has used a simple return calculation. This method is widely used to calculate share returns. Although it is arithmetically correct, it produces figures that overstate share returns in comparison to a compound return on a bank deposit.

This is why we have introduced a compound return calculation that you can select and apply to all tables in Sharesight that display return information. We use a daily compounding formula as this is standard practice among banks. Although simple interest will remain as the default setting you can choose to switch to compounding returns on a per portfolio basis by editing the portfolio settings (found under the settings link at the top right of the screen). There is also a link to change the percentage return method at the bottom of each page for which compounding return figures are available.
compound return selector
So which is correct and what should you do?
Both methods are arithmetically correct. We at Sharesight do not wish to get embroiled in a debate concerning the merits of one method over the other. You are free to choose which ever method you prefer.

Some more technical information about the formulas that Sharesight uses to calculate returns can be found here.

We also answer some common questions about compounding interest (and a variety of other questions) in the frequently asked questions section of the help documentation, which can be found here.



Sold Shares Report

In the latest Sharesight update we have put some finishing touches on the Sold Shares report which includes links back to the Share Details page for each share on the report. This is really handy if you need to edit historic dividend or trade details for a share that you have sold out of.

The sold shares report shows capital, dividend, and currency gains associated with shares that have been sold and are therefore not reported under your current holdings. As with the main portfolio page, the return figures in the report may be displayed in dollars or as annualised percentages.

Sold Shares Report

Other recent changes include the addition of a quantity column on the main portfolio page to show the total quantity of shares owned for each holding (by popular demand!). Thanks to everyone who has provided feedback, and please keep it coming!



Watch your investment grow

We’ve added a new graph option to the portfolio overview page that lets you visualise the value of your portfolio over time. You can switch between this and the portfolio gains graph by clicking the ‘change’ link to the top right of the graph. As with the other selection criteria, Sharesight will remember your graph choice next time you login, so you will always see your preferred graph right away.

Portfolio Value Graph

Thanks to all of you who have been providing us with feedback. We have some more great features on the way soon, please keep the feedback coming!



Price Alerts & Weekly portfolio performance newsletter

As you have requested…

By simply enabling portfolio alerts you will be

  • Emailed a weekly report showing how well your portfolio has performed over the past week
  • Emailed if any share within your portfolio is rising (or falling) by 5% or more
  • Emailed any new corporate events for any instrument that you hold within your portfolio



ASX historic data now in Sharesight

We have had live ASX data in Sharesight for several weeks now, but after a lengthy data import we now have a full 10 years of ASX data in our database as well.

This is great news for all of you that own Australian shares as Sharesight will now provide full dividend and corporate action data for all of your historic ASX share purchases, and allow comprehensive reporting for the last 10 years of market activity.



Using Sharesight is now easier than ever

Each of the tables on the Portfolio and Share Details screens has been enhanced with rollover effects. Also, each row of the table is clickable, so navigating should be a whole lot easier.

Table hover

We’ve got more usability improvements on the way, so stay tuned!



Sales & Acquisitions Report

Updates to Sharesight this week include the new addition of the Sales and Acquisitions report.

The Sales and Acquisitions report is designed to show opening and closing balances at cost price. This report is particularly useful for anyone holding shares under a company or family trust that is required to prepare annual accounts each year. The report also includes a ‘market value’ column to allow a quick comparison between cost price and market value at the end of the chosen period.

Sales and Acquisitions Report



Painless Tax Returns

Today we have added the first of the report pages to Sharesight – the Taxable Income report. This report is designed to take the pain out of declaring dividends in your end of year tax return by producing all of the information you need at the click of a button. Gross dividend, imputation credits, and withholding tax information is collated and summarised in an easy to read format. Sharesight provides separate reports for NZ income and overseas income to match the format of your IR3 return.



UI enhancements

We’ve just deployed a number of UI enhancements, including:

  • A growth chart on the Portfolio page
  • Updated look and feel for forms, buttons

Coming up next will be a style makeover for the Share Details pages.