HYPTUS SLA error
-
- Lemon Slice
- Posts: 398
- Joined: November 4th, 2016, 10:43 am
HYPTUS SLA error
Updating dividends on my HYPTUS today repeatedly failed on Standard life Aberdeen.
RT error 91
Object variable or With block variable not set.
Deleting SLA cures this.
Win 7
Excel 2003
HYPTUS 11.52
There doen't seem to be anything obviously wrong on the DL page
Rob
RT error 91
Object variable or With block variable not set.
Deleting SLA cures this.
Win 7
Excel 2003
HYPTUS 11.52
There doen't seem to be anything obviously wrong on the DL page
Rob
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: HYPTUS SLA error
Are you sure you mean "Updating Dividends"? That works fine for me on all 3 dividend data sources.robbelg wrote:Updating dividends on my HYPTUS today repeatedly failed on Standard life Aberdeen.
RT error 91
Object variable or With block variable not set.
Deleting SLA cures this.
Win 7
Excel 2003
HYPTUS 11.52
There doen't seem to be anything obviously wrong on the DL page
Rob
I do see the error when getting Digital Look Forecast Yields.
It looks like Digital Look (Webfg) have, in their infinite wisdom, changed the URL for Standard Life Aberdeen.
Go to the Digital Look Data Sheet and locate SLA (around row 457 depending on your version)
Change column A from:
/equity/Standard_Life_Aberdeen
to
/equity/Standard_Life_Aberdeen-13454
I'll update the digital_look_data_sheet.txt at http://lemonfoolfinancialsoftware.weebl ... op-up.html in the next hour or so
--kiloran
-
- 2 Lemon pips
- Posts: 155
- Joined: November 4th, 2016, 4:52 pm
Re: HYPTUS SLA error
Same error with me.robbelg wrote:Updating dividends on my HYPTUS today repeatedly failed on Standard life Aberdeen.
RT error 91
Object variable or With block variable not set.
.....
There doen't seem to be anything obviously wrong on the DL page
Rob
But the URL Suffix in the "Digital Look Data Sheet" needs to be set to /equity/Standard_Life_Aberdeen-13454
HTH
InStep
Edit:As Kiloran has already pointed out while I was testing it
-
- Lemon Slice
- Posts: 398
- Joined: November 4th, 2016, 10:43 am
Re: HYPTUS SLA error
Yes I did mean forecast yields
Yes that fixes it
Thank you
Rob
Yes that fixes it
Thank you
Rob
-
- Lemon Half
- Posts: 9905
- Joined: November 4th, 2016, 9:33 am
Re: HYPTUS SLA error
Thanks you Kiloran: you published the solution before I even noticed the problemkiloran wrote: It looks like Digital Look (Webfg) have, in their infinite wisdom, changed the URL for Standard Life Aberdeen.
Go to the Digital Look Data Sheet and locate SLA (around row 457 depending on your version)
Change column A from:
/equity/Standard_Life_Aberdeen
to
/equity/Standard_Life_Aberdeen-13454
I'll update the digital_look_data_sheet.txt at http://lemonfoolfinancialsoftware.weebl ... op-up.html in the next hour or so
--kiloran
Arb.
-
- Lemon Quarter
- Posts: 3843
- Joined: November 19th, 2016, 2:02 pm
Re: HYPTUS SLA error
Note the 22nd October was the effective date when SLA did the 7 for 8 adjustment to the number of shares held, if that had any bearing on the situation.
-
- Lemon Slice
- Posts: 703
- Joined: August 31st, 2018, 9:08 pm
Re: HYPTUS SLA error
I had the same problem, many thanks for the fix kiloran!
-
- Posts: 44
- Joined: August 13th, 2017, 5:02 pm
Re: HYPTUS SLA error
Having a problem effecting a transfer from version 11.30 to current version. Digital forecast yields times out after downloading the divs for the first few shares.
help.
help.
-
- Posts: 44
- Joined: August 13th, 2017, 5:02 pm
Re: HYPTUS SLA error
Error reads
Runtime error
21470128294 (8007200)
The operation timed out
Runtime error
21470128294 (8007200)
The operation timed out
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: HYPTUS SLA error
Just tried version 11.55 with 6 shares and it updated the forecast yields very rapidly. Windows 7 and Excel 2010Bena48 wrote:Having a problem effecting a transfer from version 11.30 to current version. Digital forecast yields times out after downloading the divs for the first few shares.
help.
Do other macros work OK (Update Yahoo price, update dividends etc)
What OS and Excel version are you using?
What happens if you download a fresh version of 11.55 and update forecast yields without making any changes?
--kiloran
-
- Posts: 44
- Joined: August 13th, 2017, 5:02 pm
Re: HYPTUS SLA error
The other macros seem to work ok. Win 7 excel 2010.
I will try again and get back to you.
I will try again and get back to you.
-
- Lemon Half
- Posts: 7482
- Joined: January 7th, 2017, 9:56 am
Re: HYPTUS SLA error
I'm using "v11_52" in Excel 2010 (32 bit) on a Windows 10 o/s.
The forecast yield info for SLA (and ITV) comes backs as ??? (and after a while it crashes with a runtime error).
The share prices come back correct and very quickly.
The forecast yield info for SLA (and ITV) comes backs as ??? (and after a while it crashes with a runtime error).
The share prices come back correct and very quickly.
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: HYPTUS SLA error
Forecast Yields for SLA and ITV are fine for me, using v11.55monabri wrote:I'm using "v11_52" in Excel 2010 (32 bit) on a Windows 10 o/s.
The forecast yield info for SLA (and ITV) comes backs as ??? (and after a while it crashes with a runtime error).
The share prices come back correct and very quickly.
For SLA, did you make the change to the URL Suffix highlighted up-thread?
--kiloran
-
- Lemon Half
- Posts: 8675
- Joined: November 4th, 2016, 1:16 pm
Re: HYPTUS SLA error
As Kiloran has noted, the solution to the Excel SLA issue has been captured earlier in this thread, but for the sake of completeness, here's what my Digital Look Data Sheet currently holds, and with these details both SLA and ITV are working fine for Forecast Yield retrieval -
Cheers,
Itsallaguess
URL Suffix | Data Sheet Name | EPIC | New Data Sheet Sector | Divi Code | CSI | Corporate Dividends / Investor URL /equity/ITV | ITV | ITV | Media | ITV | 54450 | http://www.itvplc.com/investors/shareholder-services /equity//Standard_Life_Aberdeen-13454 | Standard Life Aberdeen plc | SLA | Life Insurance | SLA | 186960 | https://www.standardlifeaberdeen.com/in ... calculatorhttps://i.imgur.com/UGktbet.png
Cheers,
Itsallaguess