HYPTUSS Divi Yield Error

Discussions regarding financial software
Post Reply
EssDeeAitch
Lemon Slice
Posts: 703
Joined: August 31st, 2018, 9:08 pm

HYPTUSS Divi Yield Error

Post by EssDeeAitch »

Am getting an error message at SLA on Get Digital Look Yield, I have uploaded the latest Digital Look Data Sheet, can anyone help?

kiloran
Lemon Quarter
Posts: 3865
Joined: November 4th, 2016, 9:24 am

Re: HYPTUSS Divi Yield Error

Post by kiloran »

It's working fine for me. HYPTUSS 11.55, Windows 10, Excel 2010

Check that Column A of Digital Look Data Sheet is:
/equity/Standard_Life_Aberdeen-13454

That is the correct value and is in the digital_look_data_sheet.txt at: http://lemonfoolfinancialsoftware.weebl ... op-up.html

Which version are you using? Which operating system?

--kiloran

EssDeeAitch
Lemon Slice
Posts: 703
Joined: August 31st, 2018, 9:08 pm

Re: HYPTUSS Divi Yield Error

Post by EssDeeAitch »

kiloran wrote:It's working fine for me. HYPTUSS 11.55, Windows 10, Excel 2010

Check that Column A of Digital Look Data Sheet is:
/equity/Standard_Life_Aberdeen-13454

That is the correct value and is in the digital_look_data_sheet.txt at: http://lemonfoolfinancialsoftware.weebl ... op-up.html

Which version are you using? Which operating system?

--kiloran
I have copied the sheet into my workbook and made the change as you suggest to /equity/Standard_Life_Aberdeen-13454 and although it now runs through without error message 91, I have question marks against IMB, SLA, VOD & WPP (that's literally, I also have some figurative question marks :? )

I am using Win 10 with Excel 2016

EssDeeAitch
Lemon Slice
Posts: 703
Joined: August 31st, 2018, 9:08 pm

Re: HYPTUSS Divi Yield Error

Post by EssDeeAitch »

Now working, not that I did anything else, but case closed, many thanks

kiloran
Lemon Quarter
Posts: 3865
Joined: November 4th, 2016, 9:24 am

Re: HYPTUSS Divi Yield Error

Post by kiloran »

EssDeeAitch wrote:
kiloran wrote:It's working fine for me. HYPTUSS 11.55, Windows 10, Excel 2010

Check that Column A of Digital Look Data Sheet is:
/equity/Standard_Life_Aberdeen-13454

That is the correct value and is in the digital_look_data_sheet.txt at: http://lemonfoolfinancialsoftware.weebl ... op-up.html

Which version are you using? Which operating system?

--kiloran
I have copied the sheet into my workbook and made the change as you suggest to /equity/Standard_Life_Aberdeen-13454 and although it now runs through without error message 91, I have question marks against IMB, SLA, VOD & WPP (that's literally, I also have some figurative question marks :? )

I am using Win 10 with Excel 2016
Very odd!
If you copied the current digital_look_data_sheet.txt to your HYPTUSS, there should be no need to change the entry to SLA. It is already correct. The other shares you mention are also OK. I downloaded the current HYPTUSS 11.55, updated the Digital Look Data Sheet and all the shares are fine. Do you have any other shares which are working OK, or are they all failing?

Which version of HYPTUSS are you using?

If you select SLA in Column C of the High Yield Portfolio sheet, then click on the "Open DL Site" button, what web page do you see? It should be:
https://uk.webfg.com/equity/Standard_Li ... deen-13454

--kiloran

funduffer
Lemon Quarter
Posts: 1129
Joined: November 4th, 2016, 12:11 pm

Re: HYPTUSS Divi Yield Error

Post by funduffer »

Hi kiloran,

I have the same problem with SLA.

Using version 11-55, Windows 10, Excel 2013:

the Open DL site opens up:

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

Whereas it should open this:

https://uk.webfg.com/equity/Standard_Li ... deen-13454

i.e. the -13454 is missing for some reason.

Any ideas?

Regards

FD

EssDeeAitch
Lemon Slice
Posts: 703
Joined: August 31st, 2018, 9:08 pm

Re: HYPTUSS Divi Yield Error

Post by EssDeeAitch »

I had the same as funduffer but this is now resolved. I had to manually add the "-13454" to the new digital look sheet which you (kiloran) pointed me to.

kiloran
Lemon Quarter
Posts: 3865
Joined: November 4th, 2016, 9:24 am

Re: HYPTUSS Divi Yield Error

Post by kiloran »

funduffer wrote:Hi kiloran,

I have the same problem with SLA.

Using version 11-55, Windows 10, Excel 2013:

the Open DL site opens up:

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

Whereas it should open this:

https://uk.webfg.com/equity/Standard_Li ... deen-13454

i.e. the -13454 is missing for some reason.

Any ideas?

Regards

FD

Webfg keep changing the URL of the shares in the HYP. Since HYPTUSS 11.55 was published,the website for SLA has changed. That is why we publish updated versions of the Digital Look Data Sheet as frequently as possible at: http://lemonfoolfinancialsoftware.weebl ... op-up.html

Replace the digital look data sheet in your HYPTUSS and you will be OK.

--kiloran

funduffer
Lemon Quarter
Posts: 1129
Joined: November 4th, 2016, 12:11 pm

Re: HYPTUSS Divi Yield Error

Post by funduffer »

Hi kiloran,

Another observation on the SLA issue:

The other shares in my mini-HYP (BP., CTY, MYI) all retrieve the forecast yield successfully.

The problem is just with SLA.

I tried the 'Open DL site' button on each of them.

For BP., CTY and MYI, then open the DL web-site without a -xxxxx number at the end.

For SLA, it opens up the site without -13454 at the end, but you have to add the -13454 to the web address to get to the page with the forecast yield on it.

I am guessing this is a problem with DL, or there is something special about SLA data for some reason.

Hope this helps.

FD

funduffer
Lemon Quarter
Posts: 1129
Joined: November 4th, 2016, 12:11 pm

Re: HYPTUSS Divi Yield Error

Post by funduffer »

kiloran wrote:
funduffer wrote:Hi kiloran,

I have the same problem with SLA.

Using version 11-55, Windows 10, Excel 2013:

the Open DL site opens up:

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

Whereas it should open this:

https://uk.webfg.com/equity/Standard_Li ... deen-13454

i.e. the -13454 is missing for some reason.

Any ideas?

Regards

FD

Webfg keep changing the URL of the shares in the HYP. Since HYPTUSS 11.55 was published,the website for SLA has changed. That is why we publish updated versions of the Digital Look Data Sheet as frequently as possible at: http://lemonfoolfinancialsoftware.weebl ... op-up.html

Replace the digital look data sheet in your HYPTUSS and you will be OK.

--kiloran
Thanks, ignore my last post!

FD

Post Reply

Return to “Financial Software - Discussion”