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.
Click here for a truly
free look at the US ETF holdings list files.
- Current holding lists for 3982 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
of holdings, ETF
(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 (immediate access for
- Never outsourced. Completely "Made
What We Do Every Day...
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
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:
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.
- in-house use, non-distribution
- web site use and / or distribution
Trial Subscriber html Links
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
To sign up for immediate access to the current
(no credit card
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
• 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
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.