HYPTUSS Divi Yield Error
-
- Lemon Slice
- Posts: 703
- Joined: August 31st, 2018, 9:08 pm
HYPTUSS Divi Yield Error
Am getting an error message at SLA on Get Digital Look Yield, I have uploaded the latest Digital Look Data Sheet, can anyone help?
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: HYPTUSS Divi Yield Error
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
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
-
- Lemon Slice
- Posts: 703
- Joined: August 31st, 2018, 9:08 pm
Re: HYPTUSS Divi Yield Error
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 )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 am using Win 10 with Excel 2016
-
- Lemon Slice
- Posts: 703
- Joined: August 31st, 2018, 9:08 pm
Re: HYPTUSS Divi Yield Error
Now working, not that I did anything else, but case closed, many thanks
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: HYPTUSS Divi Yield Error
Very odd!EssDeeAitch wrote: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 )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 am using Win 10 with Excel 2016
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
-
- Lemon Quarter
- Posts: 1129
- Joined: November 4th, 2016, 12:11 pm
Re: HYPTUSS Divi Yield Error
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 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
-
- Lemon Slice
- Posts: 703
- Joined: August 31st, 2018, 9:08 pm
Re: HYPTUSS Divi Yield Error
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.
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: HYPTUSS Divi Yield Error
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
-
- Lemon Quarter
- Posts: 1129
- Joined: November 4th, 2016, 12:11 pm
Re: HYPTUSS Divi Yield Error
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
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
-
- Lemon Quarter
- Posts: 1129
- Joined: November 4th, 2016, 12:11 pm
Re: HYPTUSS Divi Yield Error
Thanks, ignore my last post!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
FD