import data from website

I want to put share price data from a website (LSE, MSN money) onto a spreadsheet, I can get the data onto a sheet (new book or existing book) via a query or from the get external data but it wont re...