Type ETFFactorsFundamental
Type category Entity
Description Global dataset of Exchange Traded Fund-level factor scores derived from ETF constituent data and equity fundamental factors, calculated as the weighted sum of individual common stock constituents for global equity ETFs.
Timeseries key id, dateavailable from 2015-01-02
Fields
Name Type Filters Description
key id string(30)* = Unique identifier for the entity.
timeline date date* =< >= The as of date when the value was calculated.
annVol12m decimal{24,5} The annualized volatility of monthly stock returns over the prior twelve months.
annVol12mCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain VOL - 12M Realized Price Volatility AFL Value
annVol1m decimal{24,5} The annualized volatility of daily returns over the prior month.
annVol1mCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain VOL - 1M Realized Price Volatility AFL Value
astAdjChg1yFcf decimal{24,5} The 1 year change in trailing four quarter free cash flow, divided by average total assets over the year.
astAdjChg1yFcfCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain HG - 1YChgin Asset Adjusted Free Cash Flow AFL Value
astAdjChg1yOcf decimal{24,5} The 1 year change in trailing four quarter operating cash flow, divided by average total assets over the year.
astAdjChg1yOcfCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain HG - 1YChgin Asset Adjusted Operating Cash Flow AFL Value
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The BatchRun in which the entity is sent.
beta60m decimal{24,5} The sensitivity of a stock's return to the return on the market.
beta60mCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain VOL - 60M CAPM Beta AFL Value
bp decimal{24,5} The factor is a ratio of book value to market value of common equity.
bpCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain VAL - Book to Price AFL Value
capAcqratio decimal{24,5} The factor is a ratio of trailing four quarter operating cash flow (net of cash dividends) to trailing four quarter capital expenditures. It measures how efficiently a company generates cash from its capital expenditures.
capAcqratioCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain CE - Capital Acquisition Ratio AFL Value
cashCycle decimal{24,5} It's defined as the sum of average receivable collection period and average inventory processing period, minus payables payment period.
cashCycleCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain EQ - Cash Conversion Cycle AFL Value
cfRoic decimal{24,5} The factor measures a ratio of trailing four quarter operating net cash flow to average invested capital over the same period.
cfRoicCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain CE - Cash Flow Return on Invested Capital AFL Value
chg1yAstto decimal{24,5} The percentage change from a year ago in the ratio of trailing four quarter sales to average total assets over the same period.
chg1yAsttoCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain HG - 1YChgin Sales Turnover AFL Value
chg1yEps decimal{24,5} The percentage change from a year ago in trailing four quarter earnings per share.
chg1yEpsCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain HG - 1YChgin Earnings per Share AFL Value
ciqTradingItemId long(-2147483648,2147483647) Unique identifier assigned to a trading item.
constituentCount long(0,2147483647) ETF - Total number of ETF constituent holdings
cv90d decimal{24,5} The ratio of the standard deviation of daily closing prices over the past 90 days to the average of daily closing prices over the past 90 days.
cv90dCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain VOL - 90 Day Coefficient of Variation AFL Value
divP decimal{24,5} The ratio of trailing four quarter dividends per share to current stock price.
divPCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain VAL - Dividends to Price Ratio AFL Value
ebitdaEvCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain VAL - EBITDA to Enterprise Value AFL Value
ebitdaev decimal{24,5} The ratio of trailing four quarter earnings before interest, taxes, depreciation and amortization expense to enterprise value.
ep decimal{24,5} The ratio of trailing four-quarter earnings per share to current stock price.
epCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain VAL - Earnings to Price AFL Value
epsNumRevFy1c decimal{24,5} The factor is weighted average of number of net upward 1 month revisions in consensus estimate of FY1 earnings per share in current month, and the number of net upward 1 month revisions in the previous month.
epsNumRevFy1cCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain AE - Number of EPS FY1 Revisions AFL Value
equityCount long(0,2147483647) ETF - Total number of ETF equity constituents (Common Stock, ADR, and GDR holdings)
estDiffc decimal{24,5} The factor measures difference between the number of upward 1month revisions and the number of downward 1 month revisions in analyst estimates of FY1 earnings per share, divided by the number of analyst earnings estimates. For US & Canada, Normalized EPS is used; for ex-NA, we use GAAP EPS.
estDiffcCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain AE - Analyst Earnings Estimate Diffusion AFL Value
link etfSecurity ETFSecurity Describes the linked security details of the ETF Security
fcfP decimal{24,5} The ratio of trailing four quarter free cash flow to average market value of equity over the same period.
fcfPCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain VAL - Free Cash Flow to Price AFL Value
hhi decimal{24,5} ETF - Herfindahl-Hirschman Index Value - calculated by squaring the market share of each holding, summing the squares, and multiplying by 10000 (a higher HHI indicates higher concentration)
hl1m decimal{24,5} The ratio of the monthly high minus the current price to the current price minus the monthly low price.
hl1mCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain PM - 1M Price High - 1M Price Low AFL Value
logMktcap decimal{24,5} The natural logarithm of market capitalization (month-end number of shares outstanding multipled by month-end price per share)
logMktcapCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain SZ - Log Market Cap AFL Value
logttmSales decimal{24,5} The natural logarithm of the trailing four quarter sum of sales.
logttmSalesCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain SZ - Log TTM Sales AFL Value
ltdE decimal{24,5} The ratio of long term debt to total shareholders' equity. It's an indicator of a company's financial leverage.
ltdECoverage decimal{24,5} Percent of all the ETF's equity constituents that contain CE - Long Term Debt to Equity Ratio AFL Value
ltgc decimal{24,5} This factor is consensus estimate of long-term growth in earnings per share.
ltgcCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain AE - Expected LTG AFL Value
netprofitMargin decimal{24,5} It's defined as the ratio of trailing four quarter income before extraordinary items to trailing four quarter sales. Note: From 2010 onward, this factor is not calculated for Banks (GICS 4010).
netprofitMarginCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain EQ - Net Profit Margin AFL Value
niStabCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain EQ - Net Income Stability AFL Value
nistab decimal{24,5} This factor is measured by the ratio of 5-year average of the one year percentage change in Net Income over the mean absolute deviation in the one year percentage change in Net Income going 5 years back.
pm12m1m decimal{24,5} The cumulative percentage stock price change over the prior twelve months, excluding the most recent month.
pm12m1mCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain PM - 12M - 1M Price Momentum AFL Value
pm1m decimal{24,5} The simple stock return over the past month.
pm1mCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain PM - 1M Price Reversal AFL Value
pm5d decimal{24,5} This is a short term signal that measures a stock's 5-day price reversal.
pm5dCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain PM - 5 Day Price Reversal AFL Value
pm9m decimal{24,5} The simple stock return over the past nine months.
pm9mCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain PM - 9 Month Price Momentum AFL Value
roe decimal{24,5} The ratio of trailing four quarter income before extraordinary items available for common equity to average book value of common equity over the same period.
roeCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain CE - Return on Equity AFL Value
sEv decimal{24,5} The ratio of trailing four quarter sales to average enterprise value over the same period.
sEvCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain VAL - Sales to EV Ratio AFL Value
shareChg decimal{24,5} The percentage change in common shares outstanding from four quarters ago to the current quarter.
shareChgCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain CE - 1YChgin Shares Outstanding AFL Value
suec decimal{24,5} The difference between realized quarterly earnings per share and the consensus estimate , relative to the standard deviation of the past differences. For US & Canada, Normalized EPS is used; for ex-NA, we use GAAP EPS.
suecCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain AE - Standardized Unexpected Earnings AFL Value
susGrwRate decimal{24,5} The product of retention ratio and return on equity.
susGrwRateCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain HG - Sustainable Growth Rate AFL Value
tradingItemId long(-2147483648,2147483647) Unique identifier for a trading item.
universeId long(0,32767) Universe Id
wcaccruals decimal{24,5} The factor is defined as the change from four quarters ago in non-cash assets, minus the change in current liabilities (excluding short term debt and taxes payable) and minus depreciation, relative to average total assets over the past year.
wcaccrualsCoverage decimal{24,5} Percent of all the ETF's equity constituents that contain EQ - Working Capital Accruals AFL Value
81 rows of 81 total
API Open API Specification