Page 1 of 1

request to add Quilter to HYPTUSS

Posted: August 9th, 2018, 11:35 am
by mrbrightside
Quilter (QLT) was formed from a spin-off from Old Mutual in June 2018.

Would it be possible to add this to the HYP Top-Up spreadsheet ?

https://uk.webfg.com/equity/Quilter

Re: request to add Quilter to HYPTUSS

Posted: August 9th, 2018, 1:32 pm
by kiloran
I've updated "digital look data sheet.txt" at http://lemonfoolfinancialsoftware.weebl ... op-up.html

It will be included in future versions of HYPTUSS

--kiloran

Re: request to add Quilter to HYPTUSS

Posted: August 9th, 2018, 3:24 pm
by mrbrightside
Many thanks. Much appreciated.

[ As an aside, I note that OML isn't listed by Webfg (not sure if this is a DL migration problem or related to the QLT spinoff) but I have contacted them to see if that can be fixed. ]

Re: request to add Quilter to HYPTUSS

Posted: August 9th, 2018, 4:18 pm
by kiloran
mrbrightside wrote:Many thanks. Much appreciated.

[ As an aside, I note that OML isn't listed by Webfg (not sure if this is a DL migration problem or related to the QLT spinoff) but I have contacted them to see if that can be fixed. ]

Does OML still exist? I can't see it on https://www.londonstockexchange.com/home/homepage.htm or on a few other sites I looked at.

--kiloran

Re: request to add Quilter to HYPTUSS

Posted: August 9th, 2018, 4:41 pm
by mrbrightside
Indeed. I need to read these Corporate Actions more carefully :-) Thanks.

28 June 2018 - Old Mutual will be deleted from all FTSE Indexes, and within the Global Equity Series it will be replaced by the JSE listed Old Mutual Ltd (ZA, BDVPYN5) on a one for one basis with a nationality of South Africa.

Re: request to add Quilter to HYPTUSS

Posted: August 24th, 2018, 9:54 pm
by kempiejon
I'm finding Quilter is not being picked up in forecast dividends on the High Yield Portfolio tab and the Dividends tab but I can get a value if I add quilter to my Watchlist. Is this just me?
W10, newest download of the HYPTUSS 11-54, Excel '13

Re: request to add Quilter to HYPTUSS

Posted: August 25th, 2018, 5:23 am
by Itsallaguess
kempiejon wrote:
I'm finding Quilter is not being picked up in forecast dividends on the High Yield Portfolio tab and the Dividends tab but I can get a value if I add quilter to my Watchlist. Is this just me?

W10, newest download of the HYPTUSS 11-54, Excel '13


Works fine for me on Excel 2007 (Windows 10 - HYPTUSS v11.54)-

https://i.imgur.com/Tl3lpVl.png

Link to the Digital Look page -

https://uk.webfg.com/equity/Quilter

Cheers,

Itsallaguess

Re: request to add Quilter to HYPTUSS

Posted: August 25th, 2018, 9:04 am
by kempiejon
Thanks, might well be me then. Time to test.

Re: request to add Quilter to HYPTUSS

Posted: August 25th, 2018, 9:16 am
by Itsallaguess
kempiejon wrote:
Thanks, might well be me then. Time to test.


Just checked again and it's still working.

Do you want to check that you've got the Data Sheet info entered correctly?

Here's what my working data looks like -

https://i.imgur.com/pe8knr2.png

Cheers,

Itsallaguess

Re: request to add Quilter to HYPTUSS

Posted: August 25th, 2018, 9:32 am
by kempiejon
Thanks again, yes I confirm I have the details right. In fact I have just downloaded a virgin HYPTUSS added quilter as the only share and all seems fine. There must be something amiss in my moded SS. I'll have a poke about and if I can't find why.

Re: request to add Quilter to HYPTUSS

Posted: August 25th, 2018, 3:27 pm
by kempiejon
Itsallaguess wrote:
Works fine for me on Excel 2007 (Windows 10 - HYPTUSS v11.54)-

https://i.imgur.com/Tl3lpVl.png

Link to the Digital Look page -

https://uk.webfg.com/equity/Quilter

Cheers,

Itsallaguess


Quilter seems to be happy now, I'm not sure exactly how I fixed it. I found another couple of problems, a 7000% yield from Old Mutual, and Fergusun needed its data updating to /equity/Ferguson-13339