Forecast Dividend error
-
- Posts: 18
- Joined: November 5th, 2016, 6:58 pm
Forecast Dividend error
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 !!!
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 !!!
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: Forecast Dividend error
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
/equity/Phoenix_Group_Holdings-14038
should solve the problem.
--kiloran
-
- Posts: 18
- Joined: November 5th, 2016, 6:58 pm
Re: Forecast Dividend error
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
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
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: Forecast Dividend error
I've updated the file digital_look_data_sheet.txt at http://lemonfoolfinancialsoftware.weebl ... op-up.html to accommodate the change to PHNX
--kiloran
--kiloran
-
- Lemon Quarter
- Posts: 1915
- Joined: November 5th, 2016, 7:41 am
Re: Forecast Dividend error
Hi,
I am getting the same for F&C Investment Trust (FCIT) and Law Debenture (LWDB) which are not returning forecast yields
tuk020
I am getting the same for F&C Investment Trust (FCIT) and Law Debenture (LWDB) which are not returning forecast yields
tuk020
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: Forecast Dividend error
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.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
I can modify the code so that it reports Forecast Yield of 12% if that makes you feel good
--kiloran
-
- Lemon Slice
- Posts: 385
- Joined: November 4th, 2016, 4:55 pm
Re: Forecast Dividend error
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.kiloran wrote: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.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
I can modify the code so that it reports Forecast Yield of 12% if that makes you feel good
--kiloran
Unfortunately, FCIT and LWDB aren't showing Latest Yield either.
Adrian
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: Forecast Dividend error
Correct!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
--kiloran
-
- Lemon Quarter
- Posts: 1623
- Joined: November 4th, 2016, 1:39 pm
Re: Forecast Dividend error
At least on my sheets it shows n/a. So it recognises them as IT's.kiloran wrote:Correct!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
--kiloran
Raptor.
-
- Lemon Quarter
- Posts: 1915
- Joined: November 5th, 2016, 7:41 am
Re: Forecast Dividend error
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
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
-
- Lemon Half
- Posts: 8675
- Joined: November 4th, 2016, 1:16 pm
Re: Forecast Dividend error
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.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
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/f ... ment-trust
https://www.trustnet.com/factsheets/t/i ... ration-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
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: Forecast Dividend error
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.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
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
-
- Lemon Quarter
- Posts: 1915
- Joined: November 5th, 2016, 7:41 am
Re: Forecast Dividend error
thanks chaps
tuk020
tuk020
-
- Lemon Quarter
- Posts: 1623
- Joined: November 4th, 2016, 1:39 pm
Re: Forecast Dividend error
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.
Raptor.