The Sunday Times publishes a really useful list of current UK share prices. The list shows the current price, and 52 week low and 52 week high. The problem is it only shows the top 250 UK Companies.
Can anyone guide me please towards a FREE online source that a) shows a more expansive list of UK companies over and above this list of 250 , but which includes the 52 week high and 52 week low figures, and b) where I can find a similar expansive list for US stocks with the 52 week high, 52 week low figures included please?
Thanks in advance guys.
If you can source the list of the tickers then you can use google sheets to pull out the highs and lows
I’d suggest looking for the index constituent lists (such as FTSE for UK, S&P for US, etc) and add the tickers to a Google Sheet, or use stock tracking services such as Apple Stocks, Yahoo Finance, MSN Money, etc for the 52-week values.
Here’s the FTSE All-Share index: London Stock Exchange | London Stock Exchange
Thank you very much for your suggestions Roy and for providing the link. Thank you.
Use the Freetrade Stock Universe and Googlefinance - it will take about 10 mins as a one off exercise.
Great Stuff, thanks for sharing
Hi Jim, many thanks for.your response and suggestion.
I have access to Freetrade Stock Universe and to Google Finance. Are you saying that I can Import the Freetrade Stock Universe Spreadsheet of Companies into Google Finance and I can create the facility to display the 52 week high and 52 week low figures within Google Finance? If so, how? I’ve had a look at this and I can’t see any obvious way of doing either? Any guidance would be greatly appreciated. Thank you.
@Murph Import the company list from the FT universe into a Google Sheet then use the stock tickers in GOOGLEFINANCE functions, eg:
=GOOGLEFINANCE(“AAPL”, “high52”) for the Apple 52 week high
=GOOGLEFINANCE(“AAPL”, “low52”) for the Apple 52 week low
If you need a hand let me know and I can put something together for you.
Hi Jim, thank you very much for providing some additional information on this. I shall give this a go.
Also, thank you so much for offering to give me a hand with this and put something together for me. That’s really nice of you. Thank you.
Let me try this first with the information you have kindly provided and see how I get on. If I hit a wall, I’ll come back to you.
Thank you Jim.
This topic was automatically closed 416 days after the last reply. New replies are no longer allowed.