Page 1 of 1
HYP top up spreadsheet - Mercantile IT
Posted: June 2nd, 2018, 11:31 am
by puffster
When using the Get Digital Look Forecast Yields button I get a "run time error 91 - object variable or with block variable not set". This seems to be triggered by the Mercantile (MRC) IT which recently went for a 10 for 1 split and it has only happened since this event. The latest HYP 11-54 shows the same issue under MS Excel. If someone could have a look when they get a chance that would be good please.
Regards, Puffster.
Re: HYP top up spreadsheet - Mercantile IT
Posted: June 2nd, 2018, 12:44 pm
by kiloran
Looks like Webfg (Digital Look) have changed the URL.
In the "Digital Look Data Sheet", cell A316 of the Digital Look Data Sheet is currently:
/equity/Mercantile_Investment_Trust_The
Change this to:
/equity/Mercantile_Investment_Trust_The-13676
I've updated "digital_look_data_sheet.txt" at
http://lemonfoolfinancialsoftware.weebl ... op-up.html so you can import this if you prefer.
--kiloran
Re: HYP top up spreadsheet - Mercantile IT
Posted: June 2nd, 2018, 8:13 pm
by puffster
Hi Kiloran,
That fixed it, thanks!
Regards, Puffster