| key |
id |
string(30)* |
= |
Unique identifier for the entity. |
| timeline |
date |
date* |
=< >= |
The as of date when the value was calculated. |
|
advisedRk |
long(0,100) |
|
Self Advised Rank: defined as a REIT that provides its own asset management services (investment acquisition/ disposition decisions) or the advisor is a subsidiary. |
|
affoGrwthRk |
long(0,100) |
|
AFFO Growth Rank: defined as the equal-weighted analysts' AFFO Growth estimates over the next 3 years |
|
affoPayRk |
long(0,100) |
|
AFFO Payout Rank: defined as the equal-weighted analysts' AFFO Payout estimates over the next 3 years |
|
avgWMatureRk |
long(0,100) |
|
Wgt Avg Debt Maturity Rank: defined as the average, usually weighted average, term to maturity on all debt in number of months |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the entity is sent. |
|
benchmarkfee |
long(0,100) |
|
Implied Loan Rate: defined as the value and time weighted average fee for the rate charged by the custodian to the borrower of a security. |
|
bsrComposite |
long(0,100) |
|
Business Strategy Composite Rank: defined as the composite of Location Attraciveness, Sector Attractiveness, Demography, Property Quality & Age, Geographic Concentration, NOI/Gross Properties, Occupancy Rate, Partnership Income/Investments and Rent Margin Ranks. |
|
bsrCompositeSN |
long(0,100) |
|
Business Strategy SN Composite Rank: defined as the Sector Neutral Rank of the Busines Strategy Composite |
|
chgLTDebtRk |
long(0,100) |
|
% Change in Long-term Debt: defined as the Year over Year Change in Long-term Debt |
|
chgSharesOutRk |
long(0,100) |
|
% Change in Shares Outstanding: defined as the Year over Year Change in Common Shares Outstanding |
|
ciqTradingItemId |
long |
|
Unique identifier for a trading item. |
|
csrComposite |
long(0,100) |
|
Capital Structure Composite Rank: defined as the composite of Exposure to Variable Rate Debt, Exposure to Debt Maturity Risk, Debt to Market Cap, Debt to Total Cap, EBITDA to Interest Expense and Average Weighted Debt Maturity |
|
csrCompositeNew |
long(0,100) |
|
REIT Model II Capital Structure Composite Rank: defined as the composite of Exposure to Variable Rate Debt, Exposure to Debt Maturity Risk, Debt to Market Cap, Debt to Total Cap, EBITDA to Interest Expense and Average Weighted Debt Maturity |
|
csrCompositeSN |
long(0,100) |
|
Capital Structure SN Composite Rank: defined as the Sector Neutral Rank of the Capital Structure Composite |
|
csrCompositeSNNew |
long(0,100) |
|
REIT Model II Capital Structure SN Composite Rank: defined as the Sector Neutral Rank of the REIT 2 Model Capital Structure Composite |
|
debtEntValueRk |
long(0,100) |
|
Debt to Enterprise Value Rank: defined as Total Debt as a percentage of Total Enterprise Value (TEV) |
|
debtTotCapRk |
long(0,100) |
|
Debt to Total Capital Rank: defined as Total Debt + Preferred Equity as a percentage of Total Capitalization |
|
demographyRk |
long(0,100) |
|
Demography Rank: defined as the aggregate of a REIT's underlying properties' location demography measured by residents' Age and Income distribution. |
|
dilSharesRk |
long(0,100) |
|
Wgt Avg Diluted Shares Rank: defined as the weighted-average number of common shares outstanding, including the potential dilutive effect of exercising warrants and options, and conversion of convertible bonds or convertible preferred shares. |
|
div12MonTDY |
long(0,100) |
|
Leading 12 Month Total Dividend Yield: defined as forecasted regular and special dividend payment over next year divided by current stock price. |
|
div1YRGrowth |
long(0,100) |
|
1-Year Ahead Regular Dividend growth: defined as the difference between forecasted regular dividends over next year and the actual regular dividends over previous year, scaled by current stock price. |
|
divGrwthRk |
long(0,100) |
|
Dividend Growth Rank: defined as the growth rate of regular cash dividends paid during the period |
|
dmdSupply |
long(0,100) |
|
Demand Supply Ratio: defined as the amount of stock borrowed in the market relative to the lendable inventory of the stock. |
|
ebitdaIntRk |
long(0,100) |
|
EBITDA to Interest Expense: defined as Recurring Earnings Before Interest Taxes Depreciation and Amortization (EBITDA) as a multiple of Interest Expense and Preferred Dividends declared during the period |
|
emrCVFY2EPS |
long(0,100) |
|
FY2 FFO Forecast Dispersion: defined as the standard deviation of a stock's most recent anlaysts' individual FFO estimates for fiscal year 2 divided the mean of these forecasts. |
|
emrChgSup |
long(0,100) |
|
Change in FFO Surprise (EMR): Quarterly Change in EPS Surprise |
|
emrComposite |
long(0,100) |
|
Earnings Momentum Composite Rank: defined as QSG Earnings Momentum Model Composite ranked within the QSG REIT Universe, substituting Funds from Operations (FFO) for EPS. |
|
emrCompositeNew |
long(0,100) |
|
REIT Model II Earnings Momentum Composite Rank: defined as Markit Earnings Momentum Model Composite ranked within the Markit REIT Universe, substituting Funds from Operations (FFO) for EPS and removing the Inverse of PEG Ratio factor |
|
emrEGP |
long(0,100) |
|
Inverse of PEG Ratio (EMR): defined as the next 4-quarter FFO mean estimates times long-term mean FFO growth forecast for a stock divided by its month-end trading price. |
|
emrFCFROEY1P |
long(0,100) |
|
Product of TTM FCF Yield and Forward ROE (EMR): defined as the trailing 12-month free cash flow per share for a stock times its consensus next 4-quarter FFO forecasts divided by the most recently reported book value per share scaled by its month-end trading price. |
|
emrFQSURStd |
long(0,100) |
|
Most Recent Quarterly FFO Surprise: defined as a stock's most recent quarterly FFO surprise (actual fiscal quarter FFO less the consensus FFO estimate) adjusted by the standard deviation of its ananlysts' individual FFO forecasts. |
|
emrLTG |
long(0,100) |
|
Long-Term Growth Rate Estimates (EMR): defined as mean long term growth forecast. It generally represents an expected annual increase in operating earnings over the company's next full busines cycle. |
|
emrNumRevY1 |
long(0,100) |
|
Net # of Revisions for Fiscal Year 1 (EMR): defined as the weighted average of the number of analyst FFO forecasts for fiscal year 1 raised less the number lowered within a month divided by the total number of analyst forecasts. |
|
emrREV3Y2 |
long(0,100) |
|
3-M Revision in FY2 FFO Forecasts: defined as the change in a stock's current analysts mean FFO estimate for fiscal year 2 less that of three months ago deflated by its month-end trading price. |
|
emrY2REpsG |
long(0,100) |
|
2-Year Projected FFO Growth: defined as a stock's most recent consensus analysts FFO forecast for fiscal year 2 minus the most recent reported fiscal year actual FFO tracked by and then deflated by its month-end trading price. |
|
equityGrwthRk |
long(0,100) |
|
Equity Growth Rank: defined as the period-over-period equity growth, annualized |
|
expDebtMaturRk |
long(0,100) |
|
Exposure to Debt Maturity Risk Rank: defined as (Debt Maturing in Current Year + Debt Maturing Next Year - Cash) / QSG's Estimate of Gross Asset Value |
|
expDebtMaturRkNew |
long(0,100) |
|
REIT Model II Exposure to Debt Maturity Risk Rank: defined as (Debt Maturing in Current Year + Debt Maturing Next Year - Cash) / REIT 2 Model Estimate of Gross Asset Value |
|
expVarDebtRk |
long(0,100) |
|
Exposure to Variable Rate Debt Rank: defined as (Unhedged Variable Rate Debt - Cash) / QSG's Estimate of Gross Asset Value |
|
expVarDebtRkNew |
long(0,100) |
|
REIT Model II Exposure to Variable Rate Debt Rank: defined as (Unhedged Variable Rate Debt - Cash) / REIT Model 2 Estimate of Gross Asset Value |
|
ffoGrwth5YrRk |
long(0,100) |
|
5-Yr FFO Growth Rank: defined as 5-year compound annual growth rate in FFO per share |
|
ffoGrwthRk |
long(0,100) |
|
FFO Growth Rank: defined as the equal-weighted analysts' FFO Growth estimates over the next 3 years |
|
ffoPayRk |
long(0,100) |
|
FFO Payout Rank: defined as the equal-weighted analysts' FFO Payout estimates over the next 3 years |
|
gATotRevRk |
long(0,100) |
|
G&A Expense to Tot Revenue Rank: defined as General and Administrative (G&A) expense as a percentage of Total Revenue. |
|
gdrComposite |
long(0,100) |
|
Growth & Dividend Policy Composite Rank: defined as the composite of NOI Growth, Revenue Growth, Dividend Growth, FFO & AFFO Payout, FFO & AFFO Growth, 5-yr FFO Growth, Equity Growth, Price to FFO & Price to AFFO Estimates Ranks |
|
gdrCompositeNew |
long(0,100) |
|
REIT Model II Growth & Dividend Policy Composite Rank: defined as the composite of NOI Growth, Revenue Growth, Dividend Growth, FFO Payout, FFO Growth, 5-yr FFO Growth, Equity Growth, Price to FFO Estimates and Leading 12 Month Total Dividend Yield Ranks |
|
gdrCompositeSN |
long(0,100) |
|
Growth & Dividend Policy SN Composite Rank: defined as the Sector Neutral Rank of the Growth & Dividend Policy Composite |
|
gdrCompositeSNNew |
long(0,100) |
|
REIT Model II Growth & Dividend Policy SN Composite Rank: defined as the Sector Neutral Rank of the REIT 2 Model Growth & Dividend Policy Composite |
|
geoConcRk |
long(0,100) |
|
Geographical Concentration Rank: defined as the computation of each REIT's % dollar exposure to each of the 8 NCREIF Regions using the Herfindahl-Hirschman Index (HHI) methodology. |
|
impMktCapRk |
long(0,100) |
|
Implied Market Capitalization Rank: defined as the market capitalization of common equity, assuming the conversion of all Operating Partnership (OP) units into common stock. Calculated on an End Of Period basis as (all classes of Common Shares Outstanding + OP Units Outstanding) * Price per Share. |
|
instConcRk |
long(0,100) |
|
Institutional Concentration Rank: defined as the Ratio of the sum of the % holdings of the top 5 Institutions and the % Institutional Ownership |
|
locationRk |
long(0,100) |
|
Location Attractiveness Rank: defined as the aggregate of a REIT's underlying properties' location attractiveness measured by current population, expected 5-yr population growth, current median HHI, expected 5-yr HHI growth, Per capita Income, expected 5-yr per capital income growth and average occupancy levels. |
|
managedRk |
long(0,100) |
|
Self Managed Rank: defined as a REIT that manages the day-to-day operations of its own properties or the management firm that does manage the properties is a subsidiary. |
|
mqrComposite |
long(0,100) |
|
Management Quality Composite Rank: defined as the composite of the Self-Advised, Self-Managed, ROAA, ROAE, ROACE, G&A Expenses/Total Revenue, G&A Expenses/Assets, % Change in Shares Outstanding and % Change in Long-term Debt Ranks |
|
mqrCompositeNew |
long(0,100) |
|
REIT Model II Management Quality Composite Rank: defined as the composite of the Self-Advised, Self-Managed, ROAA, ROACE, G&A Expenses/Total Revenue, G&A Expenses/Assets, % Change in Shares Outstanding and % Change in Long-term Debt Ranks |
|
mqrCompositeSN |
long(0,100) |
|
Management Quality SN Composite Rank: defined as the Sector Neutral Rank of the Management Quality Composite |
|
mqrCompositeSNNew |
long(0,100) |
|
REIT Model II Management Quality SN Composite Rank: defined as the Sector Neutral Rank of the REIT 2 Management Quality Composite |
|
nOIAvgPptyRk |
long(0,100) |
|
NOI/Avg Gross Properties Rank: defined as Net Operating Income (NOI) from both rental and operating activities as a percentage of Average Gross Properties |
|
navComposite |
long(0,100) |
|
NAV to Price Composite Rank: defined as QSG's NAV premium/discount computation using a systematic cap rate derivation methodology at the individual porperty level, aggregated at the REIT level |
|
navCompositeSN |
long(0,100) |
|
NAV to Price SN Composite Rank: defined as the Sector Neutral Rank of the NAV/Price Composite |
|
navPRk |
long(0,100) |
|
REIT II NAV to Price Rank: defined as Markit"s NAV premium/discount computation using a systematic cap rate derivation methodology at the individual property level, aggregated at the REIT level |
|
numInstRk |
long(0,100) |
|
Number of Institutional Investors Rank: defined as the total number of institutional investors, as provided by Vickers Stock Research Group. |
|
olrComposite |
long(0,100) |
|
Ownership & Liquidity Composite Rank: defined as the aggregate of the number of Institutional Investors, % Institutional Ownership, % Operating Partnership, Institutional Concentration, Avg 12-month Trading Volume, 20-day Avg Trading Volume, Implied Market Capitalization and Number of Fully Diluted Shares Outstanding. |
|
olrCompositeNew |
long(0,100) |
|
REIT Model II Ownership & Liquidity Composite Rank: defined as the aggregate of the % of Institutional Ownership, % of Insider Ownership, 20-day Average Trading Volume and Number of Fully Diluted Shares Outstanding. |
|
olrCompositeSN |
long(0,100) |
|
Ownership & Liquidity SN Composite Rank: defined as the Sector Neutral Rank of the Ownership & Liquidity Composite |
|
olrCompositeSNNew |
long(0,100) |
|
REIT Model II Ownership & Liquidity SN Composite Rank: defined as the Sector Neutral Rank of the REIT 2 Model Ownership & Liquidity Composite |
|
ovHeadExpRk |
long(0,100) |
|
G&A Expense to Gross Assets Rank: defined as General and Administrative (G&A) expense as a percentage of QSG's Estimate of Gross Assets. |
|
ovHeadExpRkNew |
long(0,100) |
|
REIT II G&A Expense to Gross Assets Rank: defined as General and Administrative (G&A) expense as a percentage of Markit's Estimate of Gross Assets in REIT II. |
|
partIncPcntRk |
long(0,100) |
|
Partnership Income/Investments: defined as Partnership Income as a percentage of Average Partnerships |
|
pcntInsidersRk |
long(0,100) |
|
% Insider Ownership Rank: defined as the percentage of the total shares owned by insiders, as specificed in the most recent proxy statement |
|
pcntInstRk |
long(0,100) |
|
% Institutional Ownership Rank: defined as the Percentage of the total shares owned by institutions according to 13F filings, as provided by Vickers Stock Research Group. |
|
pmrComposite |
long(0,100) |
|
Price Momentum Composite Rank: defined as QSG Price Momentum Seed Model ranked within the QSG REIT Universe |
|
pmrIndRelRtn5D |
long(0,100) |
|
5-day Industry Relative Return (PMR): 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. |
|
pmrRationalAlpha |
long(0,100) |
|
Rational Decay Alpha (PMR): 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. |
|
pmrRelPriceStrength |
long(0,100) |
|
Industry-adjusted 12-month Relative Price Strength (PMR): 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. |
|
pmrVisiRatio |
long(0,100) |
|
The Visibility Ratio (PMR): It equals to a stock's most recent daily trading volume divided by the average daily trading volume in previous 50 trading days. |
|
pmrVolDiffPC |
long(0,100) |
|
ATM Put Volatility - ATM Call Volatility (PMR): defined as the difference between the time weighted average implied volatility of the 2 nearest to expiration at the money put options and 2 nearest to expiration at the money call options |
|
portOccuRk |
long(0,100) |
|
Portfolio Occupancy Rate Rank: defined as the aggregate occupancy rate for all the underlying properties of a REIT |
|
priceAFFORk |
long(0,100) |
|
Price/ (FY1 + FY2 AFFO Estimates) Rank: defined as the ratio of Price to the average of FY1 and FY2 AFFO Estimates |
|
priceCurFFORk |
long(0,100) |
|
Price to Current FFO Rank: defined as the ratio of Price to the most recent FFO. |
|
priceFFORk |
long(0,100) |
|
Price/ (FY1 + FY2 FFO Estimates) Rank: defined as the ratio of Price to the average of FY1 and FY2 FFO Estimates |
|
propAttRk |
long(0,100) |
|
Property Sector Attractiveness Rank: defined as the composite rank derived from a Sector Fundamental Model (70%) and a Macroeconomic Model (30%) |
|
qrmComposite |
long(0,100) |
|
REIT Model Composite Rank: defined as the composite of the Management Quality, Earnings Momentum, Price Momentum, Ownership & Liquidity, NAV to Price, Business Strategy, Capital Structure and Growth & Dividend Policy Ranks |
|
qrmCompositeNew |
long(0,100) |
|
REIT Model II Composite Rank: defined as the composite of the Management Quality, Earnings Momentum, Price Momentum, Ownership & Liquidity, NAV to Price, Business Strategy, Capital Structure and Growth & Dividend Policy Ranks |
|
qrmCompositeSN |
long(0,100) |
|
REIT Model SN Composite Rank (QRM): defined as the Sector Neutral rank of the REIT Model Composite |
|
qrmCompositeSNNew |
long(0,100) |
|
REIT Model II SN Composite Rank: defined as the Sector Neutral rank of the REIT 2 Model Composite |
|
qualityRk |
long(0,100) |
|
Property Quality & Age Rank: defined as the aggregate of a REIT's underlying properties' Age and Class characteristics. |
|
rentMarginRk |
long(0,100) |
|
Rent Margin Rank: defined as Net Operating Income (NOI) from real estate rental activities as a percentage of Total Rental Revenue. |
|
roaARk |
long(0,100) |
|
Return on Avg Assets (ROAA) Rank: defined as Net Income as a percentage of Average Assets. (Annualized) |
|
roaCERk |
long(0,100) |
|
Return on Avg Common Equity (ROACE) Rank: defined as Net Income Available to Common as a percentage of Average Common Equity. (Annualized) |
|
roaERk |
long(0,100) |
|
Return on Avg Equity (ROAE) Rank: defined as Net Income as a percentage of Average Equity. (Annualized) |
|
sSNOIGrwthRk |
long(0,100) |
|
NOI Growth Rank: defined as the percentage change in the Net Operating Income (NOI). |
|
sSRevGrwthRk |
long(0,100) |
|
Revenue Growth Rank: defined as the percent change in rental revenue from the year-ago period. |
| link |
security |
Security |
|
Describes the linked security details of the Security |
|
ssrComposite |
long(0,100) |
|
REIT II Short Sentiment Composite: defined as the composite of Demand Supply Ratio and Implied Loan Rate Ranks. |
|
universeId |
long |
|
Universe Id |
|
vlrComposite |
long(0,100) |
|
REIT II Value Composite Rank: defined as the composite of NAV to Price, Price to Current FFO and Leading 12 Month Total Dividend Yield Ranks |
|
vlrCompositeSN |
long(0,100) |
|
REIT II Value SN Composite Rank: defined as the Sector Neutral Rank of the NAV/Price Composite |
|
volume12MRk |
long(0,100) |
|
12-Month Average Trading Volume Rank: defined as the average trading volume over the last 12 months |
|
volume20DRk |
long(0,100) |
|
20-Day Average Trading Volume Rank: defined as the average trading volume over the last 20 days |