Arborbridge wrote:kiloran wrote:Arborbridge wrote:Is there a similar problem with sharecast and Law Debenture, LWDB?
My forecast yield stops at that, though the Sharecast website checked manually does show a "0.0%" yield.
Price download works fine.
Using v11-75
Arb.
That's strange Arb, it's fine for me with 11.75 and also the new version I am testing. They correctly show the Latest Yield of 3.3%
Windows 10 and Excel 2016
--kiloran
Very odd - still gets to MRC, and stops, the next share being LWDB. Clicking on the sharecast icon in HYPTUSS launches sharecast webpage, and as you say shows 3.3% and 0%. (Not sure why I didn't put 3.3% in my previous post!)
The error box is "Object variabl or With Block variable not set." Never failed at LWDB previously.
I went back to an previous edition of HYPTUSS and the same thing happened, so it isn't something I have corrupted recently. It was OK last Saturday. I might delete LWDB from my list and see if the rest run normally
Arb.
Hi Arb.
I can reproduce your problem with 11.75, but I don't get the error message. Don't know why, maybe a different version of Excel? I'm on 2016.
Starting with 11.75, the retrieval of forecast yields was modified. If the share is an IT, and the latest yield in Sharecast = n/a, HYPTUSS tries to get a latest yield from the AIC website. LWDB does get a latest yield of 3.3% from Sharecast, so no problem.
However, MRC shows a latest yield of n/a in Sharecast, so goes to
https://www.theaic.co.uk/companydata/0P00008ZO2 to get the yield. This used to work, but AIC changed the layout of the website so now fails.
The good news is that I picked this up a while ago and the fix (which I had forgotten about!) is included in the new version I am testing.
--kiloran