S P 500 List Of Companies Excel

Information on s p 500 index used to be available on the official webpage on the standard and poor s website but until they publish it back wikipedia is the best up to date and open data source.
S p 500 list of companies excel. Fortune global 500 list is the excel list of largest corporations worldwide which are measured by their total fiscal year revenues. Information is provided as is and solely for informational purposes not for trading purposes or advice disclaimer. The index contains the 500 largest stocks by market capitalization that also meet the post 2020 list of all s p 500 stocks companies free excel list. The s p 500 stock market index maintained by s p dow jones indices comprises 505 common stocks issued by 500 large cap companies and traded on american stock exchanges including the 30 companies that compose the dow jones industrial average and covers about 80 percent of the american equity market by capitalization.
List of companies in the s p 500 standard and poor s 500. List of companies in the s p 500 standard and poor s 500. S p 500 companies or s p 500 index. Index listing see data constituents csv extracted from wikipedia s sp500 list of companies.
Fortune global 500 list is a ready to print and free to download spreadsheet. Download data tables in csv excel and json formats. The s p 500 is a free float capitalization weighted index of the top 500 publicly listed stocks in the us top 500 by market cap. Excel list of global companies which made the highest revenue in a year.
Top 500 stocks in the us by market cap. Enjoy quick access to historical stock quotes metrics and free s p 500 downloads in excel spreadsheet format daily. Quotes are not sourced from all markets and may be delayed up to 20 minutes. Fortune 500 excel list is the ranked list of largest united states corporations by total revenue for their respective fiscal years.
The dataset includes a list of all the stocks. Research s p 500 stock prices company info numerous kpi metrics p e rsi beta roi. List of s p 500 companies stock marketcap price change change symbol company eps dividend rate dividend yield sector industry employees type microsoft corporation msft 1 62t 214 25 3 05 1 40 msft 5 76.