|
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.
Bloomberg IDs (FIGIs) now included in
constituent list holdings files.
-
To sign up for immediate access to the current
files, click
here
(no credit card
required)
- Current holding lists for 2974 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 (immediate access for
annual subscriptions.).
- 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 (numbered 1 through 15) 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
fifteen of this type of file generated daily (1
through 15).
• 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, please
click here
(no credit card
required). |
|
|
Trend Table
