Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

HYP top up spreadsheet - Mercantile IT

Discussions regarding financial software
puffster
2 Lemon pips
Posts: 119
Joined: November 16th, 2016, 9:25 pm
Has thanked: 99 times
Been thanked: 39 times

HYP top up spreadsheet - Mercantile IT

#143036

Postby puffster » June 2nd, 2018, 11:31 am

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
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: HYP top up spreadsheet - Mercantile IT

#143056

Postby kiloran » June 2nd, 2018, 12:44 pm

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
2 Lemon pips
Posts: 119
Joined: November 16th, 2016, 9:25 pm
Has thanked: 99 times
Been thanked: 39 times

Re: HYP top up spreadsheet - Mercantile IT

#143123

Postby puffster » June 2nd, 2018, 8:13 pm

Hi Kiloran,

That fixed it, thanks!

Regards, Puffster


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 9 guests