Download Up to Date Index and ETF Holdings Lists and Data

In your behalf, we collect data directly from the ETF issuers and other industry standard sources and put that data into a few .csv format (Excel) files for your use. You can use this data in reports distributed to your clients or on your web site or, for a significantly less cost, use the data only for yourself and firm, in-house. We update our index and ETF holdings lists daily including weights, sectors and much more. Our clients include many of the largest exchanges, data vendors, banks, hedge funds and money managers and ETF focused web sites in the world. Just as you take pride in your work, we take great pride in ours and will do nothing to jeopardize your trust.

Click here for a truly free look at the US ETF holdings list files

Current holding lists for 2976 major stock indexes and US traded ETFs (click here for the current coverage list).

Includes current ETF holdings lists, ETF constituent weighting, constituent shares held, sector and much more. Click here for the current list of values provided.
Constituent values include sector, industry, sub-industry, shares outstanding, market cap, earnings, P/E ratio, dividend, CUSIP and ISIN.
ETF fundamentals file includes numerous current values including ETF description, expense ratio, number of holdings, ETF type, inception date, identifiers (CUSIP and ISIN) and much more. Click here for the current list of values provided.
All files are in .csv format. This structure makes sorting on any value, searching, finding relationships and importing to your database very easy. Individual ETF datafiles are also available.
Compiled and managed by over 40 years of professional investment industry experience.
Updated daily directly from the ETF sponsors.
Includes constituent list archives beginning as early as July, 2009.
Never outsourced. Completely "Made in America".

What We Do Every Day... Since 2000

We gather the most current and most accurate data available. Sources include the index and ETF sponsors as well as numerous other main stream industry sources. This data is combined into .csv format files and published to our website servers. Subscribers download these datafiles nightly via http or ftp.

Index and ETF Data Collection Methodology

Starting at about 8:00 pm est, we collect constituent list data directly from the ETF and index sponsors. Those lists and related data are combined with data gathered from numerous other reliable sources. These values are processed and written to ,csv datafiles. Finally, these files are published to the website for download by about 2:00 am est. An additional update for several ETF sponsors is started shortly after the US stock market open and completed and published by approximately noon est.

Subscribe to Index and ETF Holdings Lists and Data

Two subscription types are currently offered:

in-house use, non-distribution
web site use and / or distribution

For more information, please consider requesting trial access to the primary files. You will receive both access to the current constituent list datafile, the ETF fundamentals file as well as subscription information.

Trial Subscriber html Links

Right click on the links below and save the files with a ".csv" extension.

• ConstituentData42.csv: This full file contains major US and global indexes as well as current US traded ETF constituent lists. 42 columns of data provide numerous current fundamental values. This file is updated daily (about 440,000 rows).

• Constituents-3.csv: This file is a portion of the entire file immediately above with exactly the same format. As with the above file, it is updated daily. This file is small enough to open in earlier versions of Microsoft Excel (about 60,000 rows). There are currently five to seven of this type of file generated daily (1 through 7).

• SPY.csv: This example file contains constituent data for the SPDR S&P 500 ETF (SPY). It is updated daily. Constituent lists are available both in one large file containing all lists as well as individual lists like this one.

• Fundamentals.csv: This file contains ETF fundamentals such as ETF inception date, number of holdings in the ETF, description, net asset value, market cap, and much more. Additionally, this report includes several breadth values such as percentage of constituents trading above their 200 day moving average, advancing issues, declining issues, new highs/lows, etc. It is updated daily.

To sign up for immediate access to the current files, click here (no credit card required)