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

Constituent Lists subscription  Index and ETF Values Included In the Datafiles

Following ia a listing and definitions of the fields included in the ConstituentData42.csv datafile.  The values provided in our downloadable datafile are based upon data provided by the sponsor and several other reliable market data sources.
The
ConstituentData42.csv datafile can be downloaded by subscribers at http://www.masterdatareports.com/Reports/ConstituentData42.csv.  This file is included in the trial subscription. Data listed below in green is data as provided by the ETF sponsor.

Field Definitions

Sponsor Name of index or ETF provider
Composite Ticker Ticker symbol of index or ETF.  Tickers with the initial characters "^" or "$" are indexes.
Composite Name Name of index or ETF
Constituent Ticker Ticker symbol of index or ETF constituent.  All constituent tickers begin with an apostrophe.  This preserves the leading zeros on many tickers (mainly Asian issues)
Constituent Name      Name of index or ETF constituent
Weighting The percentage the constituent represents of the index or ETF total value
Identifier The CUSIP, ISIN, or Bloomberg Global ID as provided by the sponsor. An apostrophe precedes all identifiers to preserve the leading zeros (0) in many identifiers.  All identifiers begin with an apostrophe.  This preserves the leading zeros found on many identifiers.
Date The date of the data received from the sponsor - as stated by the sponsor
Location Location of the exchange upon which the constituent trades.
Exchange The exchange upon which the constituent trades.
Total Shares Held The total number of shares held of this particular constituent by the index or ETF
Notional Value In a swap, no principal changes hands at inception (start) or expiry (end), and in the meantime, interest payments are computed based on a notional amount, which acts as if it were the principal amount of a bond, hence the term notional principal amount, abbreviated to notional.
Market Value The current market value of shares held of this particular constituent by the index or ETF
Sponsor Sector The constituent issue's sector as stated by the index or ETF sponsor
Last Trade The last closing price at which the component traded
Currency The currency used to quote the Last Trade (above)
Bloomberg Symbol The Bloomberg ticker for this constituent
Bloomberg Exchange The exchange upon which the constituent trades as stated by Bloomberg
Sector North American Industry Classification Constituent sector - This field is duplicated in a subsequent column of data and will be replaced in the future with another value.
Industry North American Industry Classification Constituent industry - This field is duplicated in a subsequent column of data and will be replaced in the future with another value.
Coupon Constituent stated coupon rate (Fixed Income ETFs)
Maturity Constituent stated maturity date  (Fixed Income ETFs)
Rating Constituent Rating (Fixed Income ETFs)
Type US Equity, Fixed Income, etc.
Shares Outstanding Total constituent shares outstanding
Market Capitalization Constituent market cap
Earnings Constituent earnings
PE Ratio Constituent Price to Earnings Ratio
Face Par value of the cinstituent  (Fixed Income ETFs)
eSignal Ticker The eSignal (Interactive Data) ticker for the constituent
Time Zone The time zone for the exchange upon which the component is traded.  This value is stated in terms of its relation to Greenwich Mean Time is zero (-5 is New York).
Dividend Amount Per share dividend paid on Last Dividend Date
Last Dividend Date  Date of last paid dividend
Dividend Yield The ratio of the annual dividend to the current market price of the constituent.
FutVal Future Value
Sector North American Industry Classification Constituent sector.
SubSector North American Industry Classification Constituent sub sector.
Industry North American Industry Classification Constituent industry.
CUSIP All CUSIPs begin with an apostrophe.  This preserves the leading zeros found on many CUSIPs.
ISIN For consistency, all ISINs begin with an apostrophe.
Bloomberg Global ID (BBGID)  All BBGIDs begin with an apostrophe for consistency with other identifiers.
ETF Constituents
Charts/Reports MasterDATAReports Index/ETF Breadth Data Privacy Statement