| 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 |