Remove ads

Introducing the LemonFools Personal Finance Calculators

Forecast Dividend error

Discussions regarding financial software
kogsawelly
Posts: 17
Joined: November 5th, 2016, 6:58 pm
Has thanked: 9 times

Forecast Dividend error

#188302

Postby kogsawelly » December 20th, 2018, 12:32 pm

Hi Chaps
It's that time of year when i update my HYP portfolio.
i'm running the hyp top up spreadsheet v11. Unfortunately i get a "run time error. The operation timed out" when it gets to the Pheonix Group line.
I've updated the digital look data sheet kindly added by Kiloran earlier this month.
I had a trawl through other discussions but can't find this problem mentioned.
The line from the data sheet is...
/equity/Phoenix_Group_Holdings_DI Phoenix Group Holdings (DI) PHNX Life Insurance PHNX 2366179

Any ideas?

Merry Xmas to all !!!

kiloran
Lemon Quarter
Posts: 1848
Joined: November 4th, 2016, 9:24 am
Has thanked: 479 times
Been thanked: 810 times

Re: Forecast Dividend error

#188355

Postby kiloran » December 20th, 2018, 2:09 pm

I'm not at home right now, but changing the first column of the Digital Look Data Sheet to

/equity/Phoenix_Group_Holdings-14038

should solve the problem.

--kiloran

kogsawelly
Posts: 17
Joined: November 5th, 2016, 6:58 pm
Has thanked: 9 times

Re: Forecast Dividend error

#188426

Postby kogsawelly » December 20th, 2018, 5:41 pm

Wow, thanks for the quick response Kiloran.

That was the last issue/update i had to deal with.
That's what happens when you only update 4 times a year...

Many thanks
Kogsawelly

kiloran
Lemon Quarter
Posts: 1848
Joined: November 4th, 2016, 9:24 am
Has thanked: 479 times
Been thanked: 810 times

Re: Forecast Dividend error

#188694

Postby kiloran » December 21st, 2018, 3:44 pm

I've updated the file digital_look_data_sheet.txt at http://lemonfoolfinancialsoftware.weebl ... op-up.html to accommodate the change to PHNX

--kiloran

TUK020
Lemon Slice
Posts: 660
Joined: November 5th, 2016, 7:41 am
Has thanked: 137 times
Been thanked: 286 times

Re: Forecast Dividend error

#195175

Postby TUK020 » January 21st, 2019, 7:06 am

Hi,
I am getting the same for F&C Investment Trust (FCIT) and Law Debenture (LWDB) which are not returning forecast yields
tuk020

kiloran
Lemon Quarter
Posts: 1848
Joined: November 4th, 2016, 9:24 am
Has thanked: 479 times
Been thanked: 810 times

Re: Forecast Dividend error

#195202

Postby kiloran » January 21st, 2019, 10:05 am

TUK020 wrote:Hi,
I am getting the same for F&C Investment Trust (FCIT) and Law Debenture (LWDB) which are not returning forecast yields
tuk020

If you click on the button "Open DL Site", you will see that there is no data for Forecast Yields for these shares on the Digital Look (Webfg) site.
I can modify the code so that it reports Forecast Yield of 12% if that makes you feel good :D

--kiloran

AJC5001
2 Lemon pips
Posts: 132
Joined: November 4th, 2016, 4:55 pm
Has thanked: 17 times
Been thanked: 27 times

Re: Forecast Dividend error

#195258

Postby AJC5001 » January 21st, 2019, 12:31 pm

kiloran wrote:
TUK020 wrote:Hi,
I am getting the same for F&C Investment Trust (FCIT) and Law Debenture (LWDB) which are not returning forecast yields
tuk020

If you click on the button "Open DL Site", you will see that there is no data for Forecast Yields for these shares on the Digital Look (Webfg) site.
I can modify the code so that it reports Forecast Yield of 12% if that makes you feel good :D

--kiloran


As far as I am aware, there are no Forecast Yields for any Investment Trusts. I thought HYPTUSS returned the Latest Yield (in red) for all Investment Trusts instead.

Unfortunately, FCIT and LWDB aren't showing Latest Yield either. :(

Adrian

kiloran
Lemon Quarter
Posts: 1848
Joined: November 4th, 2016, 9:24 am
Has thanked: 479 times
Been thanked: 810 times

Re: Forecast Dividend error

#195260

Postby kiloran » January 21st, 2019, 12:35 pm

AJC5001 wrote:As far as I am aware, there are no Forecast Yields for any Investment Trusts. I thought HYPTUSS returned the Latest Yield (in red) for all Investment Trusts instead.

Unfortunately, FCIT and LWDB aren't showing Latest Yield either. :(

Adrian

Correct!

--kiloran

Raptor
Lemon Quarter
Posts: 1656
Joined: November 4th, 2016, 1:39 pm
Has thanked: 148 times
Been thanked: 307 times

Re: Forecast Dividend error

#195311

Postby Raptor » January 21st, 2019, 3:51 pm

kiloran wrote:
AJC5001 wrote:As far as I am aware, there are no Forecast Yields for any Investment Trusts. I thought HYPTUSS returned the Latest Yield (in red) for all Investment Trusts instead.

Unfortunately, FCIT and LWDB aren't showing Latest Yield either. :(

Adrian

Correct!

--kiloran


At least on my sheets it shows n/a. So it recognises them as IT's.

Raptor.

TUK020
Lemon Slice
Posts: 660
Joined: November 5th, 2016, 7:41 am
Has thanked: 137 times
Been thanked: 286 times

Re: Forecast Dividend error

#195392

Postby TUK020 » January 21st, 2019, 8:09 pm

I am now thoroughly confused.

For some of my ITs (e.g. CTY, MYI, HFEL) HYPTUSS returns a yield figure in red, giving a latest yield.

For a couple (FCIT, LWDB) it shows n/a. This in itself is not an issue, but then this messes up the suggested top up priorities for everything.
So I wind up manually overtyping 0 in the yield column, which fixes the other top up priorities, but don't know what else I am breaking

Itsallaguess
Lemon Quarter
Posts: 3512
Joined: November 4th, 2016, 1:16 pm
Has thanked: 1142 times
Been thanked: 2149 times

Re: Forecast Dividend error

#195395

Postby Itsallaguess » January 21st, 2019, 8:19 pm

TUK020 wrote:I am now thoroughly confused.

For some of my ITs (e.g. CTY, MYI, HFEL) HYPTUSS returns a yield figure in red, giving a latest yield.

For a couple (FCIT, LWDB) it shows n/a. This in itself is not an issue, but then this messes up the suggested top up priorities for everything.

So I wind up manually overtyping 0 in the yield column, which fixes the other top up priorities, but don't know what else I am breaking


You're not breaking anything, other than perhaps not creating the best data for the two missing yields, which might then mess up the ordering calculations.

On the occasions where yields go missing for IT's, then I always find that Trustnet yield figures are readily available.

Trustnet currently show yields of 1.61% for FCIT and 3.13% for Law Deb -

https://www.trustnet.com/factsheets/t/fj19/foreign--colonial-investment-trust

https://www.trustnet.com/factsheets/t/im38/law-debenture-corporation-plc (select the 'Detailed Info' section..)

On occasions where I've had a number of holdings with yield data becoming unavailable for a while, I've been known to copy the previous Forecast Yield figures into a spare column on the right-hand-side of the main portfolio area, and then back-fill any missing yield figures with the previously scraped ones.

This is often near enough for my use-patterns most of the time, as I tend to find most yield figures are relatively stable to some degree.

Cheers,

Itsallaguess

kiloran
Lemon Quarter
Posts: 1848
Joined: November 4th, 2016, 9:24 am
Has thanked: 479 times
Been thanked: 810 times

Re: Forecast Dividend error

#195396

Postby kiloran » January 21st, 2019, 8:21 pm

TUK020 wrote:I am now thoroughly confused.

For some of my ITs (e.g. CTY, MYI, HFEL) HYPTUSS returns a yield figure in red, giving a latest yield.

For a couple (FCIT, LWDB) it shows n/a. This in itself is not an issue, but then this messes up the suggested top up priorities for everything.
So I wind up manually overtyping 0 in the yield column, which fixes the other top up priorities, but don't know what else I am breaking

This is frustrating but normal. It often happens when a company name or epic changes, and Digital Look then has no history to create Latest Yield, so it results in n/a, or, sometimes, 0.
The correct response is to overtype with your own estimate of yield, based, for example, on the total dividend over the past rolling 12 months and the current share price.
Ultimately, Digital Look tends to get its data cleaned up.

--kiloran

TUK020
Lemon Slice
Posts: 660
Joined: November 5th, 2016, 7:41 am
Has thanked: 137 times
Been thanked: 286 times

Re: Forecast Dividend error

#195399

Postby TUK020 » January 21st, 2019, 8:23 pm

thanks chaps
tuk020

Raptor
Lemon Quarter
Posts: 1656
Joined: November 4th, 2016, 1:39 pm
Has thanked: 148 times
Been thanked: 307 times

Re: Forecast Dividend error

#195415

Postby Raptor » January 21st, 2019, 9:19 pm

I over type all my ITs using data from Theaic website. SCF seems to show 1/2 what it should from webfg. MCT comes back as ???? On my own entry to hyptuss, so am used to doing this now.

Raptor.


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 3 guests