Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

ftse100 Total Return jumps 11% today !!?!

For discussion of the practicalities of setting up and operating income-portfolios which follow the HYP Group Guidelines. READ Guidelines before posting
Forum rules
Tight HYP discussions only please - OT please discuss in strategies
Breelander
Lemon Quarter
Posts: 4178
Joined: November 4th, 2016, 9:42 pm
Has thanked: 999 times
Been thanked: 1855 times

ftse100 Total Return jumps 11% today !!?!

#6562

Postby Breelander » November 18th, 2016, 7:08 pm

Can anyone explain this? Ftse100 drops 0.1% today but...
FT100 TOT RTN - UKX.T:FSI wrote:Price (GBP) 6,145.02
Today's Change614.84 / 11.12%
http://markets.ft.com/data/indices/tear ... =UKX.T:FSI

...because I'm at a loss to - a glitch? Or a very large number of whopping dividend rises declared today?

PLS1nve5t
Posts: 13
Joined: November 4th, 2016, 5:05 pm
Has thanked: 1 time
Been thanked: 1 time

Re: ftse100 Total Return jumps 11% today !!?!

#6585

Postby PLS1nve5t » November 18th, 2016, 7:53 pm

More than made up for with the All share total return - down 45%

http://markets.ft.com/data/indices/tearsheet/summary?s=ASX.T:FSI

Breelander
Lemon Quarter
Posts: 4178
Joined: November 4th, 2016, 9:42 pm
Has thanked: 999 times
Been thanked: 1855 times

Re: ftse100 Total Return jumps 11% today !!?!

#6589

Postby Breelander » November 18th, 2016, 8:05 pm

PLS1nve5t wrote:More than made up for with the All share total return - down 45%


I'm registered on the FT. I've emailed them to ask 'what gives?' - I've got a 'case number' now, let's see what they have to say for themselves :)

PLS1nve5t
Posts: 13
Joined: November 4th, 2016, 5:05 pm
Has thanked: 1 time
Been thanked: 1 time

Re: ftse100 Total Return jumps 11% today !!?!

#6594

Postby PLS1nve5t » November 18th, 2016, 8:20 pm

Thanks for raising the issue - my weekend spreadsheet updates are in jeopardy at the moment :!:

Breelander
Lemon Quarter
Posts: 4178
Joined: November 4th, 2016, 9:42 pm
Has thanked: 999 times
Been thanked: 1855 times

Re: ftse100 Total Return jumps 11% today !!?!

#6602

Postby Breelander » November 18th, 2016, 8:29 pm

PLS1nve5t wrote:Thanks for raising the issue - my weekend spreadsheet updates are in jeopardy at the moment :!:


Me too. For now I'm going to take the ft100 and ft100-TR from Monday and use an estimate I've previously found to be accurate to 1 decimal place:

    today's ft100-TR = ft100-TR(Monday)/ft100(Monday) x ft100(Friday)

That estimates the ft100-TR as 5512.38 today.
Last edited by Breelander on November 18th, 2016, 8:36 pm, edited 1 time in total.

spiderbill
Lemon Slice
Posts: 543
Joined: November 4th, 2016, 9:12 am
Has thanked: 155 times
Been thanked: 182 times

Re: ftse100 Total Return jumps 11% today !!?!

#6604

Postby spiderbill » November 18th, 2016, 8:33 pm

Something surely wrong there. By coincidence I was just looking at it yesterday to update the comparative progress of my Scottish Widows OEIC and it was about 5530. Maybe they got Yahoo to update it ;-)

Jon46
Posts: 47
Joined: November 4th, 2016, 11:45 am
Been thanked: 1 time

Re: ftse100 Total Return jumps 11% today !!?!

#6626

Postby Jon46 » November 18th, 2016, 10:39 pm

My favourite of the current howlers on the website is this one:

http://markets.ft.com/data/indices/tear ... =UKX.D:FSI

Pretty sure they held the Christmas office party a little early!

Jon

tjh290633
Lemon Half
Posts: 8207
Joined: November 4th, 2016, 11:20 am
Has thanked: 913 times
Been thanked: 4096 times

Re: ftse100 Total Return jumps 11% today !!?!

#6632

Postby tjh290633 » November 18th, 2016, 10:46 pm

Bree, doesn't your data refer to Thursday's close? That's a day with a couple of XD shares at least, IMB and MKS, so the Total Return will have risen more than the market, which rose by 0.67%. The 11% does seem to be an aberration, however.

TJH

Gengulphus
Lemon Quarter
Posts: 4255
Joined: November 4th, 2016, 1:17 am
Been thanked: 2628 times

Re: ftse100 Total Return jumps 11% today !!?!

#6648

Postby Gengulphus » November 19th, 2016, 12:02 am

Breelander wrote:Can anyone explain this? Ftse100 drops 0.1% today but...
FT100 TOT RTN - UKX.T:FSI wrote:Price (GBP) 6,145.02
Today's Change614.84 / 11.12%
http://markets.ft.com/data/indices/tear ... =UKX.T:FSI

...because I'm at a loss to - a glitch? Or a very large number of whopping dividend rises declared today?


For what it's worth, the total return index takes dividends into account when they go ex-dividend, not when they're declared. It's quite noticeable that the ratio of the total-return index to the capital-only index shifts up on the standard ex-dividend day of the week, then remains unchanged for the remaining days of the week apart from a bit of jitter caused by rounding of the index values, companies occasionally choosing to use a non-standard ex-dividend date, and very occasional events like BP cancelling its Q1 dividend in 2010 after it had gone ex-dividend.

If you collect large volumes of data for both versions of an index, calculating their ratio and looking for dates where it deviates from that pattern is a useful way to detect errors.

Gengulphus

ReformedCharacter
Lemon Quarter
Posts: 3120
Joined: November 4th, 2016, 11:12 am
Has thanked: 3590 times
Been thanked: 1509 times

Re: ftse100 Total Return jumps 11% today !!?!

#6821

Postby ReformedCharacter » November 19th, 2016, 6:43 pm

I take the figure from here:

http://uk.investing.com/indices/ftse-10 ... rical-data

It gives Friday's closing price as 5514.76

RC

Breelander
Lemon Quarter
Posts: 4178
Joined: November 4th, 2016, 9:42 pm
Has thanked: 999 times
Been thanked: 1855 times

Re: ftse100 Total Return jumps 11% today !!?!

#6881

Postby Breelander » November 19th, 2016, 10:27 pm

ReformedCharacter wrote:I take the figure from here:
http://uk.investing.com/indices/ftse-10 ... rical-data
It gives Friday's closing price as 5514.76
RC


Thanks, I have confirmed that is the correct figure. It's also in the FT Actuaries Share Indices for Friday as published in the latest 'World Markets at a glance' pdf here http://markets.ft.com/data/archive Included are all the standard ftse indices (100, 250, 350 All Share, etc.) in £ sterling, euro and Total Return form - yields and p/e too. For the ftse100 it says:

Code: Select all

FTSE ACTUARIES SHARE INDICES                                                                   UK SERIES
                                                                                     www.ft.com/equities
Produced in conjunction with the Institute and Faculty of Actuaries
               £ Strlg  Day's  Euro     £ Strlg  £ Strlg  Year     Div            P/E    X/D     Total
                Nov 18  chge%  Index    Nov 17   Nov 16   ago      yield%  Cover  ratio  adj     Return
FTSE 100 (100) 6775.77 -0.28   6145.02  6794.71  6749.72  6329.93  3.83    0.81   32.12  243.65  5514.76
http://markets.ft.com/data/dataarchive/ ... WSM_161119

I await the FT's response to my email query with interest, I wonder how they're going to explain their error? :)

Breelander
Lemon Quarter
Posts: 4178
Joined: November 4th, 2016, 9:42 pm
Has thanked: 999 times
Been thanked: 1855 times

Re: ftse100 Total Return jumps 11% today !!?!

#7568

Postby Breelander » November 21st, 2016, 11:04 pm

Breelander wrote:I await the FT's response to my email query with interest...


No reply from FT yet, despite their auto-reply promising 'within 24 hours'. In the mean time, at least the error has been corrected. The Historical prices page now says: Friday, November 18, 2016 5,514.76 http://markets.ft.com/data/indices/tear ... =UKX.T:FSI

Breelander
Lemon Quarter
Posts: 4178
Joined: November 4th, 2016, 9:42 pm
Has thanked: 999 times
Been thanked: 1855 times

Re: ftse100 Total Return jumps 11% today !!?!

#9061

Postby Breelander » November 25th, 2016, 6:49 pm

Here we go again! yield up 53 million percent !!!

markest.FT.com wrote:FT100 DIV YLD UKX.D:FSI
Today's Change ... 53,242,708.40%
http://markets.ft.com/data/indices/tear ... =UKX.D:FSI

Hpoefully (like last week) it will be corrected on Monday.

Breelander
Lemon Quarter
Posts: 4178
Joined: November 4th, 2016, 9:42 pm
Has thanked: 999 times
Been thanked: 1855 times

Re: ftse100 Total Return jumps 11% today !!?!

#9065

Postby Breelander » November 25th, 2016, 7:12 pm

Update: It has now been changed (NOT corrected). The ft100-TR now shows Thursday' figure for the Friday value.

Code: Select all

Friday, November 25, 2016   5,564.00
Thursday, November 24, 2016 5,564.00
http://markets.ft.com/data/indices/tear ... =UKX.T:FSI

The correct figure for Friday 25th seems to be 5573.41
http://uk.investing.com/indices/ftse-10 ... rical-data

Jon46
Posts: 47
Joined: November 4th, 2016, 11:45 am
Been thanked: 1 time

Re: ftse100 Total Return jumps 11% today !!?!

#9072

Postby Jon46 » November 25th, 2016, 7:46 pm

At first it was just funny, ridiculous figures, but now it is getting really irritating, why don't they just leave entries for the day blank or unpublished until they have the correct data, because the errors are so large that they should know at one glance it is not worth posting it on their web site.

It is difficult to believe that the FT cannot sort this rogue data feed/computer glitch over a whole week. This data is used worldwide.

I have given up my near daily download(FTAS TR, FTSE TR, FTSE Yield, FTAS Yield) until they sort themselves out.

Jon

Breelander
Lemon Quarter
Posts: 4178
Joined: November 4th, 2016, 9:42 pm
Has thanked: 999 times
Been thanked: 1855 times

Re: ftse100 Total Return jumps 11% today !!?!

#9076

Postby Breelander » November 25th, 2016, 8:28 pm

Jon46 wrote:I have given up my near daily download(FTAS TR, FTSE TR, FTSE Yield, FTAS Yield) until they sort themselves out.


Just give up Friday's - it only seems to 'glitch' on a Friday. I reported it again today (and moaned about the lack of a response to my report last week - one promised 'within 24 hours').

Breelander
Lemon Quarter
Posts: 4178
Joined: November 4th, 2016, 9:42 pm
Has thanked: 999 times
Been thanked: 1855 times

Re: ftse100 Total Return jumps 11% today !!?!

#9088

Postby Breelander » November 25th, 2016, 10:00 pm

Breelander wrote:Update: It has now been changed (NOT corrected). The ft100-TR now shows Thursday' figure for the Friday value.


Update to the Update: It's changed yet again - at last to the correct value <sigh>


Return to “HYP Practical (See Group Guidelines)”

Who is online

Users browsing this forum: No registered users and 15 guests