Importing share prices

BriNylon

I want to import current share prices from the FTSE 250 into a spreadsheet.  
I am pretty sure that you cannot import it into excel but can do it into google sheets.  Is that right?
So I want to set up a spreadsheet with all of the shares in that index.  I would like to look at the high and low over a given period, eg over the day, week, month etc. Is it possible to do this using imported data, which continually updates itself?  I would imagine I would have to set up the initial info myself, but would like a continuous feed thereafter so that it is automatically updated.

bowlhead99

Google Sheets has generally had functionality to pull data via the google finance features and also allows you to specify dates if you wanted to pull a range of historic prices. Or if you literally just want current share prices you could refresh it when you went into the sheet. It doesn't always work for obscure stocks or funds but seemed to be fine for mainstream FTSE stuff last time I used it. 

Excel could be configured to get external data by scraping a table on a particular website, so you could set one up for each stock, and perhaps that place you are pulling the data from will also show the high and low for the year so you could grab that at the same time.  Or if you didn't want to do 250 separate feeds you could find a website which shows all the prices in one place for (e.g.) the current day or yesterday.  However if you're pulling live data into your excel sheet it won't be going out and connecting in the background and saving down the new data on the days you don't log into it.

There are various (paid) data services that you could subscribe to which will offer access to download historic data dumps of prices (open, close, high, low, volume) including intraday data, whenever you like. For example Advfn.com's Bronze service is about £7 a month.  Depending on the purpose of your project this may not be much of a barrier, you could just download csv data from time to time and then play around with it in Excel whenever you like.

eskbanker

Current versions of Excel have a 'Stocks' data type, which allows you to populate a variety of data attributes relating to mainstream shares, including current price, plus opening price, previous close, 52-week high/low, etc - not sure exactly what you have in mind by automatic updates but it's straightforward once set up to refresh these.

Read up on this at the likes of https://support.microsoft.com/en-us/office/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54 and other non-MS sites returned when googling 'import stocks into excel'!

[Deleted User]

The excel one from memory is live (I am guessing with a 15 min delay) for ITs/Shares (when you press refresh) and weekly for funds (but it has been a while since I played with it).
EDIT - just did it in excel and the above with regards to timings is correct
ie Smithson last trade date is 19/11 and BG Positive Change is 13/11