Got a credit card? use our Credit Card & Finance Calculators
Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site
HYPTUS SLA error
-
- Lemon Slice
- Posts: 411
- Joined: November 4th, 2016, 10:43 am
- Has thanked: 189 times
- Been thanked: 159 times
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: 4137
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3293 times
- Been thanked: 2871 times
Re: HYPTUS SLA error
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
Are you sure you mean "Updating Dividends"? That works fine for me on all 3 dividend data sources.
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: 162
- Joined: November 4th, 2016, 4:52 pm
- Has thanked: 181 times
- Been thanked: 15 times
Re: HYPTUS SLA error
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
Same error with me.
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
-
- The full Lemon
- Posts: 10554
- Joined: November 4th, 2016, 9:33 am
- Has thanked: 3682 times
- Been thanked: 5339 times
Re: HYPTUS SLA error
kiloran 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
Thanks you Kiloran: you published the solution before I even noticed the problem
Arb.
-
- Lemon Quarter
- Posts: 3553
- Joined: November 19th, 2016, 2:02 pm
- Has thanked: 1213 times
- Been thanked: 1306 times
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: 655
- Joined: August 31st, 2018, 9:08 pm
- Has thanked: 268 times
- Been thanked: 251 times
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.
-
- Lemon Quarter
- Posts: 4137
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3293 times
- Been thanked: 2871 times
Re: HYPTUS SLA error
Bena48 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.
Just tried version 11.55 with 6 shares and it updated the forecast yields very rapidly. Windows 7 and Excel 2010
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
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: 8507
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1569 times
- Been thanked: 3463 times
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: 4137
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3293 times
- Been thanked: 2871 times
Re: HYPTUS SLA error
monabri 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.
Forecast Yields for SLA and ITV are fine for me, using v11.55
For SLA, did you make the change to the URL Suffix highlighted up-thread?
--kiloran
-
- Lemon Half
- Posts: 9109
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10061 times
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 -
https://i.imgur.com/UGktbet.png
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 ... calculator
https://i.imgur.com/UGktbet.png
Cheers,
Itsallaguess
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 28 guests