Pension fund returns

Pat38493

Can anyone help me understand the difference between the "Trailing returns" number and the chart information (for example on Morningstar).

e.g. - looking at fund "HSBC FTSE All-World Index Fund Accumulation C", the 1 year performance trailing returns is 6.01 but if I set the chart screen to 1 year, it appears that it grew by 7.01%.  If I set the chart to 3 years, I see growth of 31.19% so 10.39% per year, but the training returns performance number is 7.69%.  

What is the difference there and which one should I be paying most attention to?

Linton

The Trustnet charts and data match at 6.1% and 7.69%. The Morningstar table data agrees with Trustnet. Which Morningstar charts are you looking at? 

31.19% over 3 years is 9.47% per year - it is compounded.  But that is not sufficient to explain the difference.

Linton

Got it I think…

The Morningstar X-ray data is only updated once a month so its chart is currently showing up to end September 2023.

Pat38493

Linton said:

Got it I think…

The Morningstar X-ray data is only updated once a month so its chart is currently showing up to end September 2023.

I wondered if that might be the case - it is the interactive chart on the "chart" tab that was showing different numbers to the "performance" tab.  That said, I also changed the date to 1st October 2022, to 30th September 2023 on the interactive chart and the number still didn't match.

Pat38493

Linton said:

The Trustnet charts and data match at 6.1% and 7.69%. The Morningstar table data agrees with Trustnet. Which Morningstar charts are you looking at? 

31.19% over 3 years is 9.47% per year - it is compounded.  But that is not sufficient to explain the difference.

What is the Excel formula then to calculate that reverse compounding?  

Linton

Pat38493 said:

Linton said:

The Trustnet charts and data match at 6.1% and 7.69%. The Morningstar table data agrees with Trustnet. Which Morningstar charts are you looking at? 

31.19% over 3 years is 9.47% per year - it is compounded.  But that is not sufficient to explain the difference.

What is the Excel formula then to calculate that reverse compounding?  

1+Annual/100=(1+total/100)^(1/years)

Linton

Pat38493 said:

Linton said:

Got it I think…

The Morningstar X-ray data is only updated once a month so its chart is currently showing up to end September 2023.

I wondered if that might be the case - it is the interactive chart on the "chart" tab that was showing different numbers to the "performance" tab.  That said, I also changed the date to 1st October 2022, to 30th September 2023 on the interactive chart and the number still didn't match.

From Morningstar xray  with HSBC FTSE ALL World C Acc as sole member of portfolio
1) Chart shows 12969 for 30 sep 2020-30 sep 2023
2) 1.2969^(1/3)=1.0905
3) Annualised 3 year trailing data on performance page =9.05%

From trustnet for period up to 30 sep 2023
1) Chart shows overall return approx 30%

Trustnet period 27/10/2020 to 27/10/2023
1) Chart shows overall return approx 25%
2) Table shows 24..9% 3 year return
3) 1.249^(1/3)=1.077
4) table shows 7.7% 3 year annualised retun 

Pat38493

Linton said:

Pat38493 said:

Linton said:

Got it I think…

The Morningstar X-ray data is only updated once a month so its chart is currently showing up to end September 2023.

I wondered if that might be the case - it is the interactive chart on the "chart" tab that was showing different numbers to the "performance" tab.  That said, I also changed the date to 1st October 2022, to 30th September 2023 on the interactive chart and the number still didn't match.

From Morningstar xray  with HSBC FTSE ALL World C Acc as sole member of portfolio
1) Chart shows 12969 for 30 sep 2020-30 sep 2023
2) 1.2969^(1/3)=1.0905
3) Annualised 3 year trailing data on performance page =9.05%

From trustnet for period up to 30 sep 2023
1) Chart shows overall return approx 30%

Trustnet period 27/10/2020 to 27/10/2023
1) Chart shows overall return approx 25%
2) Table shows 24..9% 3 year return
3) 1.249^(1/3)=1.077
4) table shows 7.7% 3 year annualised retun 

I am not using the portfolio xray as it's a paid feature (although I might have access to the data from it through II, but it will be locked to my II portfolio).  

I am just doing a fund search and looking at that one fund, and then clicking "chart" on the left.  However looking closer, if I manually change the chart dates, it seems to only allow me to pick days which are a Friday.

However as of today - the chart when clicking "1 year" shows the same figure (6.1%) as the trailing returns on the performance page, so I'm maybe thinking its more an issue of the data on each page getting updated at different times of day.