The Complete List of DAX Index Stocks [Free Excel Download] - Sure Dividend Sure Dividend

Sure Dividend

High Quality Dividend Stocks, Long-Term Plan
Newsletters & CoursesMember's Area

The Complete List of DAX Index Stocks [Free Excel Download]


Published on February 7th, 2018

The Dax Index is composed of approximately 30 blue-chip stocks that trade on the Frankfurt Stock Exchange. It is widely considered to be the most accurate barometer of the performance of German equities.

You can download a free list of all the stocks within the Dax Index, including important investing metrics, using the link below:

 

The Dax Index Stocks List available for download at the link above contains the following information for each stock in the index:

Keep reading this article to learn more about the Dax Index and how to use our Dax Index List to find investment ideas.

How To Use The Dax Index List To Find Investment Ideas

Having an Excel document that contains the names, tickers, and financial information for every security within the Dax Index is extremely useful.

This document becomes even more powerful when combined with a working knowledge of how to use Microsoft Excel to apply insightful investing screens.

With that in mind, this tutorial will demonstrate how to apply two financial screens to our database of Dax Index stocks.

The first screen that will implement is for stocks with reasonably low price-to-earnings ratios and above-average returns on equity.

Screen 1: Low Price-to-Earnings Ratios and High Returns on Equity

This screen will filter for Dax Index stocks with price-to-earnings ratios below 18 and returns on equity above 10%.

Step 1: Download our list of Dax Index Stocks by clicking here.

Step 2: Click on the filter icon at the top of the price-to-earnings ratio column, as shown below.

Dax Index Stocks Excel Tutorial 1

Step 3: Change the filter setting to “Less Than” and input 18 into the field beside it, as shown below.

Dax Index Stocks Excel Tutorial 2

Step 4: Exit out of the filter window (by clicking the exit button, not by clicking the “Clear Filter” button in the bottom right corner). Then, click on the filter icon at the top of the Return on Equity column, as shown below.

Dax Index Stocks Excel Tutorial 3

Step 5: Change the filter setting to “Greater Than” and input 0.1 into the field beside it. Note that since return on equity is measured in percentage points, filtering for stocks with returns on equity above “0.1” is equivalent to screening for stocks with returns on equity above 10%.

Dax Index Stocks Excel Tutorial 4

The remaining stocks in this Excel document are Dax Index stocks with price-to-earnings ratios below 18 and returns on equity above 10%.

The next screen that will be demonstrated is for Dax Index stocks with above-average dividend yields and large market capitalizations.

Screen 2: High Dividend Yields, Large Market Capitalizations

This filter will screen for Dax Index stocks with dividend yields above 2.5% and market capitalizations above $100 billion.

Step 1: Download our list of Dax Index Stocks by clicking here.

Step 2: Click on the filter icon at the top of the dividend yield column, as shown below.

Dax Index Stocks Excel Tutorial 5

Step 3: Change the filter setting to “Greater Than” and input 0.025 into the field beside it. Note that since dividend yield is measured in percentage points, this is equivalent to filtering for Dax Index stocks with dividend yields above 2.5%.

Dax Index Stocks Excel Tutorial 6

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 market capitalization column, as shown below.

Dax Index Stocks Excel Tutorial 7

Step 5: Change the filter setting to “Greater Than” and input 100000 into the field beside it. This will filter for Dax Index stocks with market capitalizations above $100 billion.

Dax Index Stocks Excel Tutorial 8

The remaining stocks in this Excel sheet are Dax Index stocks with dividend yields above 2.5% and market capitalizations above $100 billion.

You now have a solid fundamental understanding of how to use the Dax Index Stocks List to identify compelling dividend investment ideas.

The remainder of this article will provide more information on the Dax Index before concluding by referring you to other useful investing resources.

The History and Current Composition of the Dax Index

The Dax Index was created in December of 1987 and had a base value of 1,000. Today, the Index is above 12,000 and has two components:

The Dax Performance Index includes the impact of reinvested dividends while the Dax Price Index accounts for stock price changes alone. For this reason, the Performance Index is more accurate for calculating long-term total returns while the Price Index is useful to analyzing short-term fluctuations in the prices of German stocks.

Final Thoughts & Other Investing Databases

The Dax Index is perhaps the best resource for identifying investment opportunities from the country of Germany. The downside to using the Dax Index

If you are looking for other international investment opportunities, the following Sure Dividend databases will prove useful:

Alternatively, you may be interested in searching for investment opportunities right here within the United States. If that is the case, the following domestic stock market indices are excellent resources:

Applying dividend history screens to these domestic stock market indices can help us to search for high-quality businesses. With that in mind, Sure Dividend maintains the following monthly stock market databases:

A last strategy is to search within particular stock market sectors for investment ideas. Sure Dividend maintains detailed databases of every stock market sector, which are available for download below:

Thanks for reading this article. Please send any feedback, corrections, or questions to support@suredividend.com.


More from sure dividend
Newsletters & CoursesMember's Area