The Lemon Fool

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

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

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

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

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

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

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.

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

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

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