Where can I get downloadable stock market data?
October 23, 2021 6:49 PM Subscribe
I'm looking for a source of downloadable stock market data. I'm a software developer and my father-in-law has asked me if I can help him with a simple project. He's retired from a successful career in the financial world but still dabbles in the stock market.
He wants access to what sounds like fairly basic data on all publicly traded companies on the US exchanges. I think he said there are about 10,000 of them.
He wants:
Number of shares issued.
Number of shares in the "float". I think that means available for public trading.
Market capitalization.
Recent share price.
He wants to do some filtering as a prescreening exercise for further research. It doesn't have to be anything remotely real time. It sounds like monthly would be good enough. A big CSV file would do it. It will probably be too big for a spreadsheet so I'll build him a simple database application. We want raw data so he can do his own research.
I have no idea if I'm asking for something crazy or very expensive but we're not expecting it to be free. Something that could be downloaded automatically by my code would be good but we could cope with a manual download requiring a captcha if necessary.
I've done some searching and can find lots of APIs which return data on one stock symbol / company but nothing like this sort of bulk download useful for local import and searching.
He wants access to what sounds like fairly basic data on all publicly traded companies on the US exchanges. I think he said there are about 10,000 of them.
He wants:
Number of shares issued.
Number of shares in the "float". I think that means available for public trading.
Market capitalization.
Recent share price.
He wants to do some filtering as a prescreening exercise for further research. It doesn't have to be anything remotely real time. It sounds like monthly would be good enough. A big CSV file would do it. It will probably be too big for a spreadsheet so I'll build him a simple database application. We want raw data so he can do his own research.
I have no idea if I'm asking for something crazy or very expensive but we're not expecting it to be free. Something that could be downloaded automatically by my code would be good but we could cope with a manual download requiring a captcha if necessary.
I've done some searching and can find lots of APIs which return data on one stock symbol / company but nothing like this sort of bulk download useful for local import and searching.
I don’t know the price, but through work I have access to S&p capital iq, which has everything you want and more. It also has a handy excel plugin.
posted by Valancy Rachel at 1:25 PM on October 24, 2021
posted by Valancy Rachel at 1:25 PM on October 24, 2021
Friends in the UK had usable data from Yahoo Finance which unfortunately may be unavailable in your jurisdiction. I don't know about stock counts at registration but would assume they're information held by the exchange that hosts the trades -- but historical prices and valuation or market cap will give total counts of the shares but not breakdown of their series and seniority etc.
posted by k3ninho at 3:07 PM on October 24, 2021
posted by k3ninho at 3:07 PM on October 24, 2021
There are plenty of existing stock screening tools that can handle not only the four fields you mentioned, but quite a lot besides -- for instance TradingView and even Yahoo Finance; search for 'stock screener'.
posted by Superilla at 9:11 PM on October 24, 2021
posted by Superilla at 9:11 PM on October 24, 2021
There's a simple to use API built into Google Sheets that I suspect will do most of this.
posted by turkeyphant at 5:57 PM on October 25, 2021
posted by turkeyphant at 5:57 PM on October 25, 2021
This thread is closed to new comments.
posted by miasma at 6:59 PM on October 23, 2021