Importing Index Constituents into Google Sheets

Importing Index Constituents into Google Sheets

Last Updated on 15/05/2024 by Ndanileka

Building a robust watchlist is an important step for any trader. It allows for focused analysis and selection of potential trading opportunities. However, manually constructing and maintaining a watchlist can be a time-consuming task.

Index constituents offer a valuable solution. These pre-defined lists of established companies from major stock indexes provide a solid foundation for your watchlist creation.  This not only saves you time but also ensures a diverse selection of companies representing various sectors within the market.  

Beyond convenience, index constituents offer an additional benefit. The underlying index serves as a benchmark which you can measure your trading performance against. This allows you to track your progress and effectiveness in comparison to the broader market movement.

Here are some index constituents that can be used as building blocks for a trading system. Data is sourced from Wikipedia using Google’s built-in functions.


The ASX 200, also referred to as the S&P/ASX 200 Index, serves as the benchmark index for the Australian stock market. Comprising the 200 largest and most liquid companies listed on the Australian Securities Exchange (ASX), it provides a holistic view of the Australian stock market’s vitality and trajectory.

=QUERY(IMPORTHTML("","table"),"SELECT Col1, Col2, Col3")


The CAC 40 is a stock market index that serves as a benchmark for France. It monitors the 40 largest companies that are listed on the Euronext Paris. The index follows a capitalization-weighted system, which means that the value of each company on the index is proportional to its size. The CAC 40’s composition is reviewed quarterly to keep it current and reflective of the overall health of the French stock market.

a screenshot of a computer


The DAX is the main benchmark index for the German stock market and is comprised of the 30 largest and most actively traded companies listed on the Frankfurt Stock Exchange. These companies represent a variety of industries including automotive, finance, technology, and healthcare. The DAX accurately reflects the performance of the German economy and investor sentiment, as it calculates the collective value of its constituent companies using market capitalization weighting methodology.

=QUERY(IMPORTHTML("","TABLE",5),"SELECT Col4,Col2,Col3 Label Col4 'Symbol' , Col2 'Company', Col3 'Sector'" )


The Dow Jones Industrial Average (DJIA) is one of the world’s most well-known and widely followed stock market indices. Comprised of 30 prominent companies listed on the New York Stock Exchange (NYSE) and NASDAQ, the DJIA serves as a barometer of the overall health and performance of the U.S. economy. The index includes companies from a variety of sectors, including technology, finance, healthcare, and consumer goods, providing a comprehensive snapshot of American industrial and economic strength.

=QUERY(IMPORTHTML("","table",2),"SELECT Col3,Col1,Col4")
Dow Jones Industrial Average (DJIA) stock list in google sheets


The FTSE 100 is an index of the top 100 companies listed on the London Stock Exchange based on market capitalization. It is a widely used benchmark for the performance of the UK stock market and includes companies from various sectors such as finance, energy, and retail.

=QUERY(IMPORTHTML("","TABLE",5),"SELECT* LABEL Col1 'Company', Col2 'Ticker', Col3 'Industry'",1)


The Ibovespa is the main benchmark index for the Brazilian stock market. It includes around 86 highly traded stocks made available on the B3 (Brasil Bolsa Balcão) exchange. The Ibovespa is a total return index that is weighted by free float, which means only shares available for trading are considered for the index calculation. It aims to reflect the movement of stock prices and the reinvestment of dividends, providing investors with a comprehensive view of the Brazilian capital market’s performance over time.

=QUERY(IMPORTHTML("","TABLE",1),"SELECT Col1,Col2 LIMIT 86 LABEL Col1 'Symbol' ,Col2 'Name' " )
Ibovespa stock list google sheets


The Nasdaq 100 is a stock market index comprised of the 100 largest non-financial companies listed on the Nasdaq stock exchange. It includes companies from various industries, including technology, retail, biotechnology, and more. The index is often used as a benchmark for the performance of growth stocks and the technology sector.

nasdaq100 stocklist google sheets

Nifty 50

The Nifty 50 is a stock market index in India comprising the top 50 companies listed on the National Stock Exchange (NSE). It is a key benchmark for the performance of the Indian stock market and encompasses companies from various sectors, representing the overall economic landscape of the country.

=QUERY(IMPORTHTML("","table",3),"SELECT Col1, Col2, Col3")
nifty50 stock list google sheets


The S&P 100, or the Standard & Poor’s 100, is a stock market index of 100 large companies listed on the New York Stock Exchange (NYSE) or NASDAQ. It is designed to track the performance of some of the largest and most established companies in the United States.  As a result, the S&P 100 is often used as a benchmark for large-cap stocks and is considered a barometer of the overall health of the US stock market.



The S&P 500 is an important index in the world of finance as it serves as a premier benchmark for the United States stock market. It consists of 500 “leading” American companies listed on the exchanges and reflects the performance of various sectors including technology, finance, healthcare, and consumer goods. Although it is not an exact list of the top 500 U.S. companies by market cap, it is widely regarded as one of the best indicators of the performance of prominent American equities, and therefore, the stock market overall.

=QUERY(IMPORTHTML("","table"),"SELECT Col1, Col2, Col3, Col4")
S&P500 stock list google sheets

Leave a Reply

Back To Top

Discover more from DEUS HARVEST

Subscribe now to keep reading and get access to the full archive.

Continue reading