Home Subscriber Downloads Constituent Change Report Bloomberg Extensions Contact Us
Exchange Traded Fund Constituents

Trial Datafile Access Values in Constituent Lists Datafile Values in ETF Fundamentals Datafile Email Update List Subscription Info    
Monthly Reports of New and Removed ETFs
 
 

Constituent Lists subscription  ETF Fundamentals Included In the Datafiles

Following ia a listing and definitions of the fields included in the ETF_Fundamentals.csv datafile.  The values provided in our downloadable datafile are based upon data provided by the ETF sponsosr and numerous other reliable market data sources.  The values in this file are updated daily.

The current ETF_Fundamentals.csv datafile can be downloaded by subscribers at http://www.masterdatareports.com/ETF_Fundamentals.csv.  This file is included in the trial subscription.

Field Definitions

Sponsor Name of ETF provider
ETF Ticker Ticker symbol of ETF
ETF Name Name of ETF
Description Brief description of the ETF as provided by the ETF Sponsor
ETF Type Category of ETF such as equity, fixed income, commodity based, etc.
BBFundType
ETF type as provided by Bloomberg.com
BBObjective
ETF objective as provided by Bloomberg.com
BBAssetClass
ETF asset class as provided by Bloomberg.com
BBGeographicFocus
ETF geographic focus as provided by Bloomberg.com
MorningStarCategory
ETF category as defined by Morningstar.com
Leveraged
Is the ETF leveraged?
LeveragedAmount
The leveraged objective of the ETF
Inception Date   First day of trading for ETF
RelatedIndex If the ETF is index based, the name or symbol of the index. We are in the middle of a project to determine the ticker of each ETF using one common ticker structure (Reuters).
RelatedIndexBBSymbol  
The underlying index symbol (Bloomberg) of the ETF or comparison index if there is no underlying index
RelatedIndexName
The underlying index of the ETF or comparison index if there is no underlying index
FactSheet Factsheet on the ETF (when available)
Prospectus Prospectus for the ETF (when available)
TotalHoldings Number of constituents currently held by ETF
ExpenseRatio Current expense ratio for the ETF
MaturityDate
The maturiy date of the ETN
LastDividendDate
The most recent date the ETF or ETN paid a dividend
DividendAmt
The amount of the most recently paid dividend
DividendYield
The percentage yield of the most recently paid dividend
ReutersTicker
 
NAVDate
The date of the Net Asset Value stated in the next column
NAV
Net Asset Value
SharesOutstanding The shares of the ETF that have been authorized, issued and purchased by investors and are held by them.
MarketCap Market capitalization (or market cap) is the total value of the issued shares of a publicly traded company; it is equal to the share price times the number of shares outstanding
AUMDate The date of the Assets Under Management stated in the next column
AUM Assets Under Management
YieldYTD Price yield since the first of the current year
Yield1Yr Price yield over the last full year period
FutVal Future value
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 apostrophefor consistency with the other identifiers.
    
   
 
MasterDATA
MasterDATA  |  MasterETFdata  |  MasterDATACSV MasterDATA CompositePlug-in  |  Privacy Statement  |  MetaStockCSV
 
ETF Constituents