Published on December 30th, 2017
The Dow Jones Industrial Average is an index of 30 large cap stocks that was first calculated in 1896. As its name implies, the index was originally focused on industrial stocks, but currently contains businesses from a wide variety of industries that have little or nothing to do with the industrial sector.
The Dow Jones is one of the two main large-cap indices in the United States (along with the S&P 500 Index) and is a great place to look for investment ideas. With that in mind, we’ve compiled a list of Dow Jones stocks that you can access below:
The Excel document available for download above contains the following financial metrics for each stock in the index:
Dividend yield Price-to-earnings ratio Market capitalization Beta Return on Equity Debt-to-Equity RatioKeep reading this article to learn about how to maximize the utility of the Dow Jones Industrial Average Excel document before also learning about other resources to find investment ideas.
How To Use The Dow Jones Industrial Average To Find Investment Ideas
Having an Excel document containing the tickers, names, and financial metrics for each constituent of the Dow Jones Industrial Average is highly useful.
This resource becomes even more powerful when combined with a rudimentary knowledge of Microsoft Excel.
With that in mind, this section will show you how to implement two useful investing screens to the Dow Jones Industrial Stocks list. The first screen we’ll implement is for stocks with high returns on equity and low price-to-earnings ratios.
Screen 1: High Returns on Equity, Low Price-to-Earnings Ratios
This screen will filter for stocks with returns on equity exceeding 15% and price-to-earnings ratios below 15.
Step 1: Download the Dow Jones Industrial Stocks List by clicking here.
Step 2: Click the filter icon at the top of the return on equity column, as shown below.
Step 3: Change the filter setting to “Greater Than” and input 0.15 into the field beside it, as shown below.
Step 4: Close out of the filter window (by clicking the exit button, not by clicking the “Clear Filter” button in the bottom right hand corner). Then, click on the filter icon at the top of the price-to-earnings ratio column, as shown below.
Step 5: Change the filter setting to “Less Than” and input 15 into the field beside it, as shown below.
The remaining stocks in this Excel spreadsheet are Dow Jones Industrial Average constituents with returns on equity above 15% and price-to-earnings ratios below 15, as desired.
The next screen we’ll implement is for the conservative investor: stocks with low volatility and low debt-to-equity ratios.
Screen 2: Low Volatility, Low Debt-to-Equity Ratios
Step 1: Download the Dow Jones Industrial Stocks List by clicking here.
Step 2: Click on the filter icon at the top of the beta column, as shown below.
Step 3: Change the filter setting to “Less Than” and input 1 into to the field beside it, as shown below. Thi will filter for stocks with 3-year betas less than 1.
Step 4: Close out of the filter window (by clicking the exit button, not by clicking the “Clear Filter” button in the bottom right corner). Then, click the filter icon at the top of the debt-to-equity ratio column, as shown below.
Step 5: Change the filter setting to “Less Than” and input 1 into the field beside it, as shown below. This will filter for stocks with debt-to-equity ratios less than 1.
The remaining stocks in this Excel sheet are Dow Jones Industrial Average stocks with 3-year betas below 1 and debt-to-equity ratios below 1.
Final Thoughts
The Dow Jones Industrial Average is an excellent place to look for high-quality investment opportunities because its constituents are generally large, established companies with proven business models. With that said, the Dow Jones Industrial Average is not the only place where high-quality investments can be found.
If you’re looking for other large, stable businesses, it’s worth considering blue chip stocks with 3%+ dividend yields and 100+ year operating histories. We maintain a database of blue chip stocks that you can access below:
The Blue Chip Stocks List: 3%+ Dividend Yields and 100+ Year Operating HistoriesIf you’re looking for smaller businesses to invest in, Sure Dividend also maintains a database of the most well-known small-cap index in the United States:
The Complete List Of Russell 2000 StocksYou may also be interested in finding attractive investments within certain sectors of the stock market. If that is the case, the following Sure Dividend databases will prove useful:
The Complete List Of Dividend-Paying Consumer Cyclical Stocks The Complete List Of Dividend-Paying Consumer Staples Stocks The Complete List Of Dividend-Paying Industrial Stocks The Complete List Of Dividend-Paying Materials Stocks The Complete List Of Dividend-Paying Financial Stocks The Complete List Of Dividend-Paying Energy Stocks The Complete List Of Dividend-Paying Utility Stocks The Complete List Of Dividend-Paying Telecommunications Stocks The Complete List Of Dividend-Paying Technology Stocks The Complete List Of Divided-Paying Healthcare StocksMuch of the Sure Dividend readerbase is composed of dividend growth investors. If you’re looking for databases containing some of the world’s best dividend growth stocks, these three databases are an excellent place to start:
The Dividend Aristocrats: stocks with 25+ years of consecutive dividend increases. The Dividend Achievers: stocks with 10+ years of consecutive dividend increases. The Dividend Kings: widely considered to be the best-of-the-best when it comes to dividend longevity, the Dividend Kings are a group of exclusive dividend stocks with a remarkable 50+ years of consecutive dividend increases.Warren Buffett’s stock portfolio is another place to look for interesting dividend growth investment opportunities. While Buffett is best-known as a value investor, his portfolio is full of dividend growth stocks:
Warren Buffett’s Top 20 Highest Conviction Stock PicksThe last place that we’ll recommend for finding investment opportunities is among the international stock market indices. With that in mind, the following two international stock market indices are useful resources:
The Complete List Of Nikkei 225 Stocks (for securities in the Japan market) The Complete List Of FTSE 100 Stocks (for securities on the London stock exchange)