| key |
id |
string(30)* |
= |
Unique identifier for the entity. |
| timeline |
date |
date* |
=< >= |
The as of date when the value was calculated. |
| 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. |
|
ccd |
long(0,100) |
|
Current Cash Flow Debt Coverage Ratio: defined as the most recently reported quarterly cash flow from operations less the cash dividends divided by the current interest-bearing debt. |
|
cfroi |
long(0,100) |
|
Cash Flow Return on Invested Capital: defined as the trailing 12-month cash flow divided by the average invested capital in the same period. Invested capital equals the sum of common equity,long-term debt,minority interest and preferred stock. |
|
chg3YFCFPINT |
long(0,100) |
|
3-yr Change in Price-adj TTM FCF (Intl): defined as the difference between the most recently reported trailing 12-month free cash flow per share and that of 12-quarters ago for a stock divided by its month-end trading price. |
|
chgCF |
long(0,100) |
|
1-yr Change in Assets-adj TTM Cash Flow: defined as the the trailing 12-month cash flow minus comparable trailing 12-month cash flow from 4-quarters ago scaled by the average total assets. |
|
chgEPSINT |
long(0,100) |
|
1-yr Change in Assets-adj TTM EPS (Intl): defined as the the trailing 12-month earnings per share before extra items (EPS) minus 4 quarter ago EPS deflated by the average total assets per share. |
|
chgOCFINT |
long(0,100) |
|
1-yr Chg in Assets-adj TTM Oper Cash Flow (Intl): defined as the most recently reported trailing 12-month operating cash flow minus 4 quarter ago trailing 12-month operating cash flow divided by the average total assets. |
|
ciqTradingItemId |
long |
|
Unique identifier for a trading item. |
|
dvmCANComposite |
long(0,100) |
|
Deep Value (CAN): Deep Value Model Composite |
|
dvmVMMCAN |
long(0,100) |
|
Valuation Rank (VMMCAN): Valuation Rank |
|
emmCANComposite |
long(0,100) |
|
Earning Momentum (CAN): Earning Momentum Model Composite |
|
emmVMMCAN |
long(0,100) |
|
Earning Momentum Rank (VMMCAN): Earning Momentum Rank |
|
eqVMMCAN |
long(0,100) |
|
Earnings Quality Rank (VMMCAN): Earnings Quality Rank |
|
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. |
|
fcEstEP |
long(0,100) |
|
Leading 12-Month Median Earnings Yield: defined as the next fiscal year median consensus earnings estimate divided by trading price. |
|
fcF12MEPSSEV |
long(0,100) |
|
Forward 12-M EPS-to-Enterprise Value: defined as the consensus forward 12-month earnings per share forecast divided by the sum of market value of common equity per share and book value of long-term debt per share. |
|
fcF12MEPSSEVINT |
long(0,100) |
|
Forward 12-M EPS-to-Enterprise Value (Intl): defined as the consensus forward 12-month earnings per share forecast divided by the sum of market value of common equity per share and book value of long-term debt per share. |
|
fcFWDEPINT |
long(0,100) |
|
Leading 12-Month Mean Earnings Yield (Intl): defined as the most recent next 4-quarter's mean earnings estimates for a stock divided by the its month-end price. |
|
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. |
|
fcREV3Y1 |
long(0,100) |
|
3-M Revision in FY1 EPS Forecasts: defined as the change in the current mean consensus earnings estimate for fiscal year 1 less that of three months ago, deflated by its trading price. |
|
fcRev3Y1INT |
long(0,100) |
|
3-M Revision in FY1 EPS Forecasts (Intl): defined as the change in a stock's current analysts mean earnings estimate for fiscal year 1 less that of three months ago deflated by its month-end trading price. |
|
fcfSale |
long(0,100) |
|
TTM Free Cash Flow-to-TTM Sales: defined as the trailing 12-month free cash flow divided by the trailing 12-month sales. |
|
high52WINT |
long(0,100) |
|
52-Week High (Intl): defined as the month-end price divided by the highest monthly closing price in the past 12-month. |
|
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. |
|
mgtEffVMMCAN |
long(0,100) |
|
Profitability Rank (VMMCAN): Profitability Rank |
|
mgtLevVMMCAN |
long(0,100) |
|
Liquidity and Leverage Rank (VMMCAN): Liquidity and Leverage Rank |
|
npm |
long(0,100) |
|
Net Profit Margin: defined as the most recently reported quarterly net income after tax divided by the corresponding quarterly sales. |
|
npmINT |
long(0,100) |
|
Net Profit Margin (Intl): defined as the most recently reported quarterly net income after tax divided by the corresponding quarterly sales. |
|
numRevY2 |
long(0,100) |
|
Net # of Revisions for Fiscal Year 2: defined as the weighted average of the number of FY2 analyst earnings forecasts raised less the number lowered within a month, divided by the total number of analyst forecasts. |
|
oCFMarginINT |
long(0,100) |
|
Operating Cash Flow Profit Margin (Intl): defined as the trailing 12-month cash flow from operations scaled by the trailing 12-month sales. |
|
ocfroiINT |
long(0,100) |
|
Oper Cash Flow Return on Invested Capital (Intl): defined as the trailing 12-month operating cash flow divided by the average invested capital in the same period. Invested capital equals the sum of common equity,long-term debt,minority interest and preferred stock. |
|
ollevINT |
long(0,100) |
|
Operating Liability Leverage (Intl): defined as 1 minus the ratio of (short-term debt + long-term debt + common equity + preferred equity - cash) to (total assets - cash) in the current quarter |
|
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. |
|
pmmCANComposite |
long(0,100) |
|
Price Momentum (CAN): Price Momentum Model Composite |
|
pmmVMMCAN |
long(0,100) |
|
Price Momentum Rank (VMMCAN): Price Momentum Rank |
|
pr1536 |
long(0,100) |
|
15/36 Week Stock Price Ratio: defined as the moving average of a stock's prices in last 15-week divided by the moving average of its prices in last 36-week. |
|
pr1536INT |
long(0,100) |
|
15/36 Week Stock Price Ratio (Intl): defined as the moving average of a stock's prices in last 15-week divided by the moving average of its prices in last 36-week. |
|
ratRev6M |
long(0,100) |
|
Street Rating Revision: defined as the 6-month average of the monthly change in the average analyst recommendation. � |
|
ratRev6MINT |
long(0,100) |
|
Street Rating Revision (Intl): defined as the 6-month average of the change in the average analyst recommendation tracked by |
|
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. |
|
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. |
|
rvmCANComposite |
long(0,100) |
|
Relative Value (CAN): 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. |
|
sucf |
long(0,100) |
|
Standardized Unexpected Cash Flow: defined as the most recent quarterly operating cash flow minus that of 4 quarters ago, divided by the standard deviation of this difference over the preceding 8 quarters. |
|
sue |
long(0,100) |
|
Standardized Unexpected Earnings: defined as the most recent quarterly earnings per share minus that of 4 quarters ago, divided by the standard deviation of this difference over the preceding 8 quarters. |
|
totalCov |
long(0,100) |
|
Total Coverage: It equals (Cash Flow from Operations + Interest Paid + Tax Paid)/ (Interest + Principal Paid). |
|
ttmAccuINT |
long(0,100) |
|
Accounting Accruals (Intl): defined as the difference between the trailing 12-month net income and the trailing 12-month operating cash flow scaled by the beginning total assets. |
|
ttmEPbINT |
long(0,100) |
|
TTM EPS before Extra Items-to-Price (Intl): defined as the most recently reported trailing 12-month earnings per share before extraordinary items for a stock divided by its month-end trading price. |
|
ttmocfp |
long(0,100) |
|
TTM Operating Cash Flow-to-Price: defined as the trailing 12-month operating cash flow per share for a stock divided by its trading price. |
|
ttmocfpINT |
long(0,100) |
|
TTM Operating Cash Flow-to-Price (Intl): defined as the trailing 12-month operating cash flow per share for a stock divided by its month-end trading price. |
|
universeId |
long |
|
Universe Id |
|
visiRatio |
long(0,100) |
|
The Visibility Ratio: It equals to a stock's most recent daily trading volume divided by the average daily trading volume in previous 50 trading days. |
|
visiRatioINT |
long(0,100) |
|
The Visibility Ratio (Intl): It equals to a stock's most recent daily trading volume divided by the average daily trading volume in previous 50 trading days. |
|
vmmCANComposite |
long(0,100) |
|
Value Momentum (CAN): Value Momentum Model Composite |
|
volTO |
long(0,100) |
|
Trading Turnover Ratio: defined as the monthly total trading volume divided by the most recently reported total outstanding shares. |
|
wcAcc |
long(0,100) |
|
Working Capital Accruals: It equals to: Increase in Accounts Receivables + Increase in Inventory + Decrease in Accounts Payable and Accrued Liabilities + Decrease in Accrued Income Taxes + Increase (Decrease) in Asssets (Liabilities). |