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.
HYP top up spreadsheet - Mercantile IT
-
- 2 Lemon pips
- Posts: 104
- Joined: November 16th, 2016, 9:25 pm
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: HYP top up spreadsheet - Mercantile IT
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:
--kiloran
In the "Digital Look Data Sheet", cell A316 of the Digital Look Data Sheet is currently:
/equity/Mercantile_Investment_Trust_TheChange this to:
/equity/Mercantile_Investment_Trust_The-13676I've updated "digital_look_data_sheet.txt" at http://lemonfoolfinancialsoftware.weebl ... op-up.html so you can import this if you prefer.
--kiloran
-
- 2 Lemon pips
- Posts: 104
- Joined: November 16th, 2016, 9:25 pm
Re: HYP top up spreadsheet - Mercantile IT
Hi Kiloran,
That fixed it, thanks!
Regards, Puffster
That fixed it, thanks!
Regards, Puffster