Home Change Report New!  Trend Table  Trend Table Subscriber Reports Bloomberg Extensions Contact Us
ETF Constituents
Free Trial Access (no credit card required) Values in Constituent Lists Datafile Values in Fundamentals Datafile Subscription Info
760-980-3090 Additions and Updates

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.

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)

ETF Constituents
Charts/Reports MasterDATAReports Index/ETF Breadth Data Privacy Statement