Home > Business Databases > Total shareholder return (share price return)

Total shareholder return (share price return)

Thomson ReutersWhen using Datastream the datatype RI (return index) includes the re-investment of dividends. The total return can be calculated from the change in the return index over the chosen time period. The basic fomula is:

Retit = ( RIit – RIit-1 ) / RIit-1  (multiply by 100 for percentage return)

The percentage return can be calculated using a Datastream formula.

For example,  PCH#( X(RI), 1M )

  • percentage change (PCH#) of
  • the series return index (X(RI))
  • over 1 month (1M) (you can have 1D for one day, 1Y for one year etc.)

This gets the return for a company when X is an equity series, for an index when X is a index series, and for a group of companies when X is a list.

If you want the percentage change in price, that is without re-investment of dividends, you can use P rather than RI,  PCH#( X(P), 1M ), or PCH#( X(PI), 1M ) for an index.

The screenshot below illustrates calculating daily returns for the FTSE100 using Datastream

Datastream calculating returns (click to expand)

Datastream calculating returns (click to expand)

The columns B-K are all daily data (therefore daily returns) – Excel file  DSftse1100rtn.xlsx without Datastream macros

  • FTSE100(PI) – The FTSE100 Index  (Price Index)
  • formula ((PIt-PIt-1)/PIt-1)*100 – Percentage price return calculated in Excel from the PI figures
  • PCH#(FTSE100(PI),1D) – Percentage price return calculated using Datastream expression
  • DPL#(PCH#(FTSE100(PI),1D),4) – Percentage price return to 4 decimal places (using Datastream expression)
  • FTSE100(RI) – The FTSE100 Total Return Index  (Total Return Index)
  • formula ((RIt-RIt-1)/RIt-1)*100 – Percentage total return calculated in Excel from the RI figures
  • PCH#(FTSE100(RI),1D) – Percentage total return calculated using Datastream expression
  • DPL#(PCH#(FTSE100(RI),1D),4) – Percentage total return to 4 decimal places (using Datastream)

The daily returns do not show the difference between the price return and the total return very clearly. If you compare the yearly return for 2010 the price return is 8.9981 and the total return 12.6248.  See also Returns for 2012 (posted Jan 2012).

Getting the returns for a group of companies (equities), or a group of indices, by using a Datastream list  X where FSTE100 appears in the formulas above – for example DPL#(PCH#(X(RI),1M),4) will give you the monthly return to four decimal places for each company, or index, in your list. When Datastream processes the list request it assigns X to each item in the list. The list can be a pre-defined Datastream constituent list, e.g. LFTSE100, or a user-defined list.

Categories: Business Databases Tags:
  1. markgreenwood
    19 February 2014 at 11:29 pm
  2. MB
    10 March 2015 at 10:17 am

    Thanks a lot. Could I change the currency of the total return calculation in the same formula?

  3. Phil Reed
    11 March 2015 at 11:05 am

    Currency can be changed for any variable such as RI by substituting with something like
    X(RI)~U$ for US dollars or X(RI)~E for Euros. This will work in the calculations above too.

    More information is available from this post:

  4. 14 August 2015 at 2:34 pm

    Reblogged this on Aberconway Library blog.

  1. 7 January 2013 at 5:09 pm
  2. 26 March 2013 at 11:55 pm
  3. 15 April 2013 at 11:39 pm
  4. 5 December 2013 at 9:38 pm
  5. 30 April 2014 at 1:08 pm
  6. 27 May 2014 at 11:43 am
  7. 10 July 2015 at 3:38 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.