| key |
id |
string(30)* |
= |
Unique identifier for the entity. |
| timeline |
date |
date* |
=< >= |
The as of date when the value was calculated. |
|
actRtn24M |
long(0,100) |
|
24-Month Active Return with 1-Month Lag: defined as the percent change in price for a stock from month t-25 to month t-1. |
|
actRtn24MINT |
long(0,100) |
|
24-Month Active Return with 1-Month Lag (Intl): defined as the percent change in price for a stock from month t-25 to month t-1. |
|
actRtn6M |
long(0,100) |
|
6-Month Active Return with 1-Month Lag: It is defined the percent change in price for a stock from month t-7 to month t-1. |
|
actRtn6MINT |
long(0,100) |
|
6-Month Active Return with 1-Month Lag (Intl): It is defined the percent change in price for a stock from month t-7 to month t-1. |
|
balShtRankQVAEUR |
long(0,100) |
|
Balance Sheet Strength Rank (QVAEUR): defined as the equal weighted average of the Book-to-Price, Cash-to-Price and Total Assets-to-Price Ranks. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the entity is sent. |
|
bp |
long(0,100) |
|
Book-to-Market: defined as the most recently reported book value per share for a stock deflated by its trading price. |
|
capacqINT |
long(0,100) |
|
Capital Acquisition Ratio (Intl): defined as the trailing 12-month operating cash flow less than the trailing 12-month cash dividends and then divided by the total expenditures in the same period. |
|
cashP |
long(0,100) |
|
Cash-to-Price: defined as the most recently reported cash and equivalents per share of a company divided by trading price. |
|
chg3YEPSP |
long(0,100) |
|
3-yr Change in Price-adj TTM EPS: defined as the difference between the the trailing 12-month earnings per share and that of 12-quarters ago for a stock divided by its rading price. |
|
chg3YEPSPINT |
long(0,100) |
|
3-yr Change in Price-adj TTM EPS (Intl): defined as the difference between the the trailing 12-month earnings per share and that of 12-quarters ago for a stock divided by its month-end trading price. |
|
chgEPSP |
long(0,100) |
|
1-yr Change in Price-adj TTM EPS: defined as the difference between the most recently reported trailing 12-month earnings per share and that of 4 quarters ago for a stock deflated by its trading price. |
|
chgEPSPINT |
long(0,100) |
|
1-yr Change in Price-adj TTM EPS (Intl): defined as the difference between the most recently reported trailing 12-month earnings per share and that of 4 quarters ago for a stock deflated by its month-end trading price. |
|
chgFCFP |
long(0,100) |
|
1-yr Chg in Price-adj TTM Free Cash Flow: defined as the difference between the the trailing 12-month free cash flow per share and that of 4 quarters ago for a stock divided by its trading price. |
|
chgNOA |
long(0,100) |
|
Change in Net Operating Assets: defined as the year-over-year change of net operating assets to total assets, where net operating assets equal most recent quarterly short-term debt plus long-term debt + preferred equity plus common equity minus cash |
|
chgOLLEV |
long(0,100) |
|
Change in Operating Liability Leverage: defined as the current quarter operating liability leverage less the operating liability leverage 4 quarters ago, where operating liability leverage equals 1 minus the ratio of (short-term debt + long-term debt + common equity + preferred equity - cash) to (total assets - cash) |
|
chgOLLEVINT |
long(0,100) |
|
Change in Operating Liability Leverage (Intl): defined as the current quarter operating liability leverage less the operating liability leverage 4 quarters ago, where operating liability leverage equals 1 minus the ratio of (short-term debt + long-term debt + common equity + preferred equity - cash) to (total assets - cash) |
|
ciqTradingItemId |
long(-2147483648,2147483647) |
|
Unique identifier for a trading item. |
|
divYield |
long(0,100) |
|
TTM Dividend Yield: defined as the trailing 12-month dividends per share for a stock divided by its trading price. |
|
dvmEURComposite |
long(0,100) |
|
Deep Value (EUR): Deep Value Model Composite |
|
dvmQVAEUR |
long(0,100) |
|
Valuation Rank (QVAEUR): defined as the aggregate of the Financial Statement Rank (40%) and Earnings Valuation Rank (60%). |
|
eVRankQVAEUR |
long(0,100) |
|
Earnings Valuation Rank (QVAEUR): defined as the equal weighted composite of the Time Weighted Earnings Yield and Dividend Yield Ranks. |
|
ebitdaev |
long(0,100) |
|
TTM EBITDA-to-Enterprise Value: defined as the trailing 12-month earnings before interest,taxes,depreciation and amortization for a stock deflated by its enterprise value (EV). EV= Equity Market Value + Long-term Debt + Short-term Debt + Preferred Stock + Minority Interest -Cash. |
|
ebitdaevINT |
long(0,100) |
|
TTM EBITDA-to-Enterprise Value (Intl): defined as the trailing 12-month earnings before interest,taxes,depreciation and amortization for a stock deflated by its enterprise value (EV). EV= Equity Market Value + Long-term Debt + Short-term Debt + Preferred Stock + Minority Interest -Cash. |
|
emmEURComposite |
long(0,100) |
|
Earnings Momentum (EUR): Earnings Momentum Model Composite |
|
estRevRankQMAEUR |
long(0,100) |
|
Estimate Revision Rank (QMAEUR): defined as the equal weighted average of the Net Number of Fiscal Y1 Revisions, Standard Deviation of FY1 EPS Estimates-to-Price, Street Revision Magnitude and 3month Revision in FY2 EPS Forecasts Ranks. |
|
fcDYPEGINT |
long(0,100) |
|
Reciprocal of Dividend Yield-adjusted PEG (Intl): defined as the reciprocal of a stock's forward 12-month P/E ratio divided by the total growth rate. The total growth rate is the sum of the forecasted long-term growth rate and the indicated dividend yield. |
|
fcEPSRM |
long(0,100) |
|
Street Revision Magnitude: defined as the 3-month change in the median FY1 consensus earnings forecast, scaled by the current mean earnings estimate. |
|
fcEPSRMINT |
long(0,100) |
|
Street Revision Magnitude (Intl): defined as the 3-month change in analysts' median earnings forecast for a stock's fiscal 1 scaled by the current mean estimate. |
|
fcNumRevY1 |
long(0,100) |
|
Net # of Revisions for Fiscal Year 1: defined as the weighted average of the number of FY1 analyst earnings forecasts raised less the number lowered within a month, divided by the total number of analyst forecasts. |
|
fcNumRevY1INT |
long(0,100) |
|
Net # of Revisions for Fiscal Year 1 (Intl): defined as the weighted average of the number of analyst earnings forecasts for fiscal year 1 raised less the number lowered within a month divided by the total number of analyst forecasts. |
|
fcRev3Y2 |
long(0,100) |
|
3-M Revision in FY2 EPS Forecasts: defined as the change in the current mean consensus earnings estimate for fiscal year 2 less that of three months ago, deflated by its trading price. |
|
fcRev3Y2INT |
long(0,100) |
|
3-M Revision in FY2 EPS Forecasts (Intl): defined as the change in a stock's current analysts mean earnings estimate for fiscal year 2 less that of three months ago deflated by its month-end trading price. |
|
fcStdevFY1EPSP |
long(0,100) |
|
Std Dev of FY1 EPS Estimates-to-Price: defined as the standard deviation of analyst forecasts for fiscal year 1 earnings scaled by closing price. |
|
fcStdevFY1EpsPINT |
long(0,100) |
|
Std Dev of FY1 EPS Estimates-to-Price (Intl): defined as the standard deviation of a stock's analysts' individual forecasts for fiscal year 1 earnings scaled by its month-end closing price. |
|
finStmtRankQVAEUR |
long(0,100) |
|
Financial Statement Rank (QVAEUR): defined as the equal weighted composite of the Income Statement, Balance Sheet Strength and TTM Operating Cash Flow-toPrice Ranks. |
|
gwthRankQMAEUR |
long(0,100) |
|
Earnings and Expected Growth Rank (QMAEUR): defined as the equal weighted composite of the 1-Yr Change in EPS and 3-Yr Change in EPS Ranks. |
|
incStmtRankQVAEUR |
long(0,100) |
|
Income Statement Rank (QVAEUR): defined as the equal weighted composite of the TTM Growth Flow-to-Price and TTM Ebitda -to-Enterprise Value Ranks. |
|
indRelRtn4W |
long(0,100) |
|
4-week Industry Relative Return: defined as a stock's return in last 4-weeks minus the average of the comparable returns of all stocks in the same industry deflated by the standard deviation of these returns. |
|
indRelRtn4WINT |
long(0,100) |
|
4-week Industry Relative Return (Intl): defined as a stock's return in last 4-weeks minus the average of the comparable returns of all stocks in the same industry deflated by the standard deviation of these returns. |
|
indRelRtn5D |
long(0,100) |
|
5-day Industry Relative Return: defined as a stock's return in the last 5 days minus the average of the comparable returns of all stocks in the same industry, then deflated by the standard deviation of these returns. |
|
indRelRtn5DINT |
long(0,100) |
|
5-day Industry Relative Return (Intl): defined as a stock's return in the last 5 days minus the average of the comparable returns of all stocks in the same industry, then deflated by the standard deviation of these returns. |
|
intCov |
long(0,100) |
|
Interest Coverage: defined as the most recently reported quarterly operating income before depreciation divided by the quarterly long-term debt interest expenses. |
|
mgtEffQVAEUR |
long(0,100) |
|
Profitability & Earnings Quality Rank (QVAEUR): defined as the equal weighted average of the Change in Net Operating Assets, Net Income Per Employee, Return on Equity and 1-yr Change in Price-adj TTM Free Cash Flow Ranks. |
|
mgtLevQVAEUR |
long(0,100) |
|
Liquidity and Leverage Rank (QVAEUR): defined as the equal weighted average of Tobin Q, Change in Operating Liability Leverage and Interest Coverage Ranks. |
|
nIPer |
long(0,100) |
|
Net Income per Employee: defined as the income after taxes for the trailing 12-months divided by the number of employees at the end of the last reported fiscal year. |
|
p50200Ratio |
long(0,100) |
|
50-200 Day Stock Price Ratio: defined as the moving average of a stock's prices in last 50 days divided by the moving average of its prices in last 200 days. |
|
p50200RatioINT |
long(0,100) |
|
50-200 Day Stock Price Ratio (Intl): defined as the moving average of a stock's prices in last 50 days divided by the moving average of its prices in last 200 days. |
|
past |
long(0,100) |
|
Price-to-Total Assets: defined as a stock's trading price divided most recent quarterly reported total assets per share. |
|
pastINT |
long(0,100) |
|
Price-to-Total Assets (Intl): defined as a stock's month-end trading price divided most recent quarterly reported total assets per share. |
|
pmmEURComposite |
long(0,100) |
|
Price Momentum (EUR): Price Momentum Model Composite |
|
priceMoRankQMAEUR |
long(0,100) |
|
Price Momentum Rank (QMAEUR): defined as the equal weighted average of the 24-Month Active Return, 6-Month Active Return, 50-200 Day Stock Price Ratio, Rational Decay Alpha, 5-Day Industry Relative Return, 4-Week Industry Relative Return and Industry-adjusted 12-month Relative Price Strength Ranks. |
|
qmaEURComposite |
long(0,100) |
|
Momentum Analyst (EUR): defined as the agrregate of the Price Momentum (50%), Estimate Revision (30%) and Earnings and Expected Growth (20%) Ranks |
|
qvaEURComposite |
long(0,100) |
|
Value Analyst (EUR): defined as the aggregate of the Valuation Rank (60%), Liquidity and Leverage Rank (15%) and Profitability & Earnings Quality Rank(25%) |
|
qvmEURComposite |
long(0,100) |
|
Value Momentum Analyst (EUR): defined as the aggregate of the Value Analyst (50%) and Momentum Analyst (50%) Ranks |
|
rationalAlpha |
long(0,100) |
|
Rational Decay Alpha: It evaluates stocks based on their historical 12-month market (S&P 500) adjusted excess return (the Y intercept from an OLS regression equation) using a proprietary rational decay function. |
|
rationalAlphaINT |
long(0,100) |
|
Rational Decay Alpha (Intl): It evaluates stocks based on their historical 12-month market (S&P 500) adjusted excess return (the Y intercept from an OLS regression equation) using a proprietary rational decay function. |
|
relPriceStrength |
long(0,100) |
|
Industry-adjusted 12-month Relative Price Strength: defined as a stock's 12-month relative price-strength (PS) minus the PSs of all stocks in the same industry deflated by the standard deviation of these PSs. |
|
relPriceStrengthINT |
long(0,100) |
|
Industry-adjusted 12-month Relative Price Strength (Intl): defined as a stock's 12-month relative price-stength (PS) minus the PSs of all stocks in the same industry deflated by the standard deviation of these PSs. |
|
roe |
long(0,100) |
|
Return on Equity: defined as the trailing 12-month income before extra items divided by the average of common equity in the same period. |
|
roeINT |
long(0,100) |
|
Return on Equity (Intl): defined as the trailing 12-month income before extra items divided by the average of common equity in the same period. |
|
rvmEURComposite |
long(0,100) |
|
Relative Value (EUR): Relative Value Model Composite |
| link |
security |
Security |
|
Describes the linked security details of the Security |
|
slope52WP |
long(0,100) |
|
Slope of 52 Week Price Trend Line: defined as the 4-week lagged slope coefficient of the least squares regression line of the last 52-week weekly stock's closing price against the corresponding weekly dates. |
|
slope52WPINT |
long(0,100) |
|
Slope of 52 Week Price Trend Line (Intl): defined as the 4-week lagged slope coefficient of the least squares regression line of the last 52-week weekly stock's closing price against the corresponding weekly dates. |
|
susGrowth |
long(0,100) |
|
Sustainable Growth Rate: It is the maximum growth rate a firm can sustain without having to increase financial leverage. defined as: ROE x (1 - dividend-payout ratio), where ROE is the trailing 12-month return on book equity. |
|
tobinQ |
long(0,100) |
|
Tobin q: defined as the market value of equity (E) plus debt (D) divided by assets (A), or (E + D)/A. D is measured using book values. |
|
tradingItemId |
long(-2147483648,2147483647) |
|
Unique identifier for a trading item. |
|
ttmfcfp |
long(0,100) |
|
TTM Free Cash Flow-to-Price: defined as the trailing 12-month free cash flow per share for a stock divided by its trading price. Free cash flow equals operating cash flow minus capital expenditures and cash dividends. |
|
ttmfcfpINT |
long(0,100) |
|
TTM Free Cash Flow-to-Price (Intl): defined as the trailing 12-month free cash flow per share for a stock divided by its month-end trading price. Free cash flow equals operating cash flow minus capital expenditures and cash dividends. |
|
ttmgfp |
long(0,100) |
|
TTM Growth Flow-to-Price: defined as the sum of trailing 12-month growth flow value per share for a stock divided by its trading price. Growth flow is the sum of Research & Development expenses and reported net income. |
|
ttmgfpINT |
long(0,100) |
|
TTM Growth Flow-to-Price (Intl): defined as the sum of trailing 12-month growth flow value per share for a stock divided by its month-end trading price. Growth flow is the sum of Research & Development expenses and reported net income. |
|
ttmspINT |
long(0,100) |
|
TTM Sales-to-Price (Intl): defined as the most recently reported trailing 12-month sales per share for a stock deflated by its month-end trading price. |
|
twEP |
long(0,100) |
|
Time Weighted Earnings Yield: This factor uses a time-weighted combination of FY1 and FY2 earnings estimates to create a twelve-month forward earnings forecast. This earnings factor is a unique compliment to the wide variety of earnings-related metrics available to determine a company's fair value. |
|
twEPINT |
long(0,100) |
|
Time Weighted Earnings Yield (Intl): This factor uses a time-weighted combination of FY1 and FY2 earnings estimates to create a twelve-month forward earnings forecast. This earnings factor is a unique compliment to the wide variety of earnings-related metrics available to determine a company's fair value. |
|
universeId |
long(0,32767) |
|
Universe Id |