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

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

Constituent Lists subscription 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 Fundamentals.csv datafile can be downloaded by subscribers at http://www.masterdatareports.com/Reports/Fundamentals.csv.  This file is included in the trial subscription.

Field Definitions

Composite Ticker Ticker symbol of ETF
Composite Name Name of ETF
Bloomberg Symbol Symbol as used on Bloomberg's system
FutVal This column is reserved for a future value in the report.  By allowing for a future value, the structure of the report will remain consistent and adding the value will not disrupt user input routines.
Exchange The exchange where the ETF is traded
52 Week Price Range The highest price and the lowest price traded by the ETF.
Average Volume Average daily trading volume.
Description Brief description of the ETF as provided by the ETF Sponsor
NAV Date Date of the NAV below.
NAV Current net asset value of the ETF
AUM Current assets under managment of the ETF
Market Cap 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
Leverage The leveraged objective of the ETF, if any.  A value of 1 indicates no leverage objective.
Inception Date First day of trading for ETF.
Expense Ratio The expense ratio, also known as the management expense ratio (MER), measures how much of a fund's assets are used for administrative and other operating expenses. 
MorningStar Category ETF category as defined by Morningstar.com
ETF Type ETF category as defined by MasterDATA.  Category of ETF such as equity, fixed income, commodity based, etc.
Total Holdings Current number of constituents in the E
YTD Return Price yield since the first of the current year
1 month Return Price yield over the last month
1 Year Return Price yield over the last full year period
3 Year Return Price yield over the last full three year period
Percent Above Constituent's 200 Day Moving Average The percentage of constituent issues of the ETF that currently trade above their 200 Day Moving Average.
Advances The number of constituent issues with a positive price change for the day.
Declines The number of constituent issues with a negative price change for the day.
Advancing Volume The total trade volume of all constituent advancing issues for the day.
Declining Volume The total trade volume of all constituent declining  issues for the day.
New 1 Year Highs Number of constituent issues setting new one year highs.
New 1 Year Lows Number of constituent issues setting new one year lows.
CUSIP CUSIP is an acronym that refers to Committee on Uniform Security Identification  This value is provided for the specific constituent or ETF listed.
ISIN The International Securities Identification Number (ISIN) is a code that uniquely identifies a specific securities issue.  This value is provided for the specific constituent or ETF listed.
 
MasterDATA
MasterDATA  |  MasterETFdata  |  MasterDATACSV MasterDATA CompositePlug-in  |  Privacy Statement  |  MetaStockCSV
 
ETF Constituents