Call us at 760-980-3090 |
Exchange Traded Fund 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 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)
|
|
|