HYP top up spreadsheet - Mercantile IT

[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.

[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

[puffster]

Hi Kiloran,

That fixed it, thanks!

Regards, Puffster