0

Are the trade prices for every stock publicly available in real time? How could I generate my own database of historical trade prices for every stock on the US market? How could I also update that database with realtime stock information?

Apps like Yahoo Finance and Schwab provide this information in real time, but I can't seem to sort the entire list of US stocks by the criteria of my choice. I want to access a sortable, live updating, table of every stock on the US market.

For instance, I would simply like to sort every stock by current market value. These apps do not seem to provide the complete list of stocks for sorting. They allow sorting smaller categories of stocks, where the companies have already been filtered down by some criteria.

Improve this question
1
  • 1
    You can simply make url requests to download the data you are interested in. Yahoo is very Restful in that sense, or you can make a portfolio and scrape the data from a single URL request.
    – Pete B.
    Mar 3, 2020 at 17:23

2 Answers 2

Reset to default
1

Are the trade prices for every sick publicly available in real time?

The prices of all publicly traded stocks are available in real time.

How could I generate my own database of historical trade prices for every stock on the US market? How could I also update that database with real time stock information?

You could collect historical data from Yahoo Finance (or similar) but given that there are about 7-1/2 thousand stocks trading, that could be a daunting task. Plan B would be to subscribe to a data service.

Some brokers offer a DDE connection which enables Excel to be live in real time. However, brokers tend to limit the number of quotes allowed. Google offers intraday updating but I don't know if there is a quote limit.

Apps like Yahoo Finance and Schwab provide this information in real time, but I can't seem to sort the entire list of US stocks by the criteria of my choice. I want to access a sortable, live updating, table of every stock on the US market. For instance, I would simply like to sort every stock by current market value.

Finviz.com offers multiple free stock screeners with dozens of pre-set criteria. However, it has delayed quotes. They have subscriptions to greater content but I don't know specifics. If value means price then FINVIZ can be sorted on that.

Improve this answer
7

Yes, they are publicly available.

The exchanges allow you to access this data real-time for money.
Yahoo Finance et al pay them and run web servers that show them to the public, making their cost back by displaying ads.

I don't know the prices, but unless you run a business from it, I would excpect you cannot afford it.

Improve this answer
5
  • Sorry, I did not understand: Are you saying you can pay a company for access to the data, but the data is also publicly available somewhere else? I'm interpreting 'publicly available' as free and posted information. Also, what actual entity is the US exchange? Is there a website? Is the exchange a single body?
    – daDib
    Mar 3, 2020 at 17:02
  • 1
    Exchanges (New York Stock Exchange, for example) create the 'price' of a stock by matching up buy/sell orders. You can buy that information off them. In that sense, no, it is not publicly available from the exchange. Websites like Yahoo Finance buy that information, then show it to users for free, so in that sense, it is publicly available to you. Just be aware that anything you get off secondary sources like Yahoo is going to be significantly delayed (by several minutes), so it's no good for high-frequency trading.
    – Josh Eller
    Mar 3, 2020 at 17:27
  • 1
    For example, here's where you would go if you wanted to purchase real-time data directly from the NYSE: nyse.com/market-data/real-time
    – Josh Eller
    Mar 3, 2020 at 17:32
  • Could you update your answer with that link, and a comment about screeners? That summarizes everything I was looking for! Thank you
    – daDib
    Mar 3, 2020 at 17:47
  • there is better link, where actual prices are shown. What these numbers mean is different question (pay model) nyse.com/publicdocs/nyse/data/NYSE_Market_Data_Pricing.pdf and can be found here: marketsmedia.com/market-data-fees-an-overview
    – aaaaa says reinstate Monica
    Mar 3, 2020 at 18:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .