The Lemon Fool

Investors Chronicle have redesigned their website and it looks like the link to Week-Ahead data no longer works.

I'll look at it this evening

--kiloran

kiloran wrote:
Investors Chronicle have redesigned their website and it looks like the link to Week-Ahead data no longer works.

I'll look at it this evening

Bugger(s)....

It looks like we need to change the IC_SHARES_URL, and also change the 'Week Ahead' capture to not include the colon, and it'll all work again -

First change -

Let ic_shares_url = "https://www.investorschronicle.co.uk/shares/?limit=350"

Second change -

If Left(tdElement.innerText, 10) = "Week Ahead" Then

Tested on the Excel version, so I assume the OO version will be similar?

The above 'limit=350' currently brings back 6 'Week Ahead' entries, which I assume will be enough of a historical-look?

Cheers,

Itsallaguess