Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to eyeball08,Wondergirly,bofh,johnstevens77,Bhoddhisatva, for Donating to support the site

HYPTUSS Divi Yield Error

Discussions regarding financial software
EssDeeAitch
Lemon Slice
Posts: 655
Joined: August 31st, 2018, 9:08 pm
Has thanked: 268 times
Been thanked: 251 times

HYPTUSS Divi Yield Error

#197551

Postby EssDeeAitch » January 30th, 2019, 11:27 am

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: 4112
Joined: November 4th, 2016, 9:24 am
Has thanked: 3249 times
Been thanked: 2853 times

Re: HYPTUSS Divi Yield Error

#197593

Postby kiloran » January 30th, 2019, 1:54 pm

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: 655
Joined: August 31st, 2018, 9:08 pm
Has thanked: 268 times
Been thanked: 251 times

Re: HYPTUSS Divi Yield Error

#197602

Postby EssDeeAitch » January 30th, 2019, 2:37 pm

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: 655
Joined: August 31st, 2018, 9:08 pm
Has thanked: 268 times
Been thanked: 251 times

Re: HYPTUSS Divi Yield Error

#197610

Postby EssDeeAitch » January 30th, 2019, 3:33 pm

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

kiloran
Lemon Quarter
Posts: 4112
Joined: November 4th, 2016, 9:24 am
Has thanked: 3249 times
Been thanked: 2853 times

Re: HYPTUSS Divi Yield Error

#197613

Postby kiloran » January 30th, 2019, 3:40 pm

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: 1338
Joined: November 4th, 2016, 12:11 pm
Has thanked: 123 times
Been thanked: 845 times

Re: HYPTUSS Divi Yield Error

#197642

Postby funduffer » January 30th, 2019, 4:30 pm

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: 655
Joined: August 31st, 2018, 9:08 pm
Has thanked: 268 times
Been thanked: 251 times

Re: HYPTUSS Divi Yield Error

#197645

Postby EssDeeAitch » January 30th, 2019, 4:37 pm

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: 4112
Joined: November 4th, 2016, 9:24 am
Has thanked: 3249 times
Been thanked: 2853 times

Re: HYPTUSS Divi Yield Error

#197647

Postby kiloran » January 30th, 2019, 4:39 pm

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: 1338
Joined: November 4th, 2016, 12:11 pm
Has thanked: 123 times
Been thanked: 845 times

Re: HYPTUSS Divi Yield Error

#197648

Postby funduffer » January 30th, 2019, 4:44 pm

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: 1338
Joined: November 4th, 2016, 12:11 pm
Has thanked: 123 times
Been thanked: 845 times

Re: HYPTUSS Divi Yield Error

#197650

Postby funduffer » January 30th, 2019, 4:45 pm

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


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 28 guests