Pull Share (Stock) Prices from Yahoo! Finance

Hi all

I have found a formula that looks up share (stock) prices from Yahoo! Finance, based on the company name in another cell, as shown in the attached workbook. The file shows two US organisations (working) and three UK organisations quoted on the London Stock Exchange (not working). There are two formulae, one to return the company name, and one to return the most recent price.

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

This works really well, apart from one little problem : it only works for US corporations. Can this formula be modified to show stocks for UK PLCs instead of US ones?

Thanks for reading

DJB