Introduction
This page provides a list of all the terms that are usable in the Fintel Advanced Stock Screener and in the Fintel Workbench.
Terms that are retrieved from Capital IQ are marked [Capital IQ]. Note Capital IQ data is available in the new Fintel Workbench only and not in the Legacy Screener 2.0
Terms that are rankable - that is, where you can use the rank() or rankPercentile() function, are marked "Rankable" in the description.
AccountsPayable
[Capital IQ]
Excel Formula: IQ_AP
Accounts Payable, Total [1018] is a line item in the Standard template with the following components:
Accounts Payable [1083]
Reinsurance Payable - Current [1226]
Accounts Payable and Others [1086]
Customer Deposits: Interest Bearing - Under 100k [1091]
Customer Deposits: Interest Bearing - Over 100k [1245]
Customer Deposits: Non-Interest Bearing [1092]
Insurance and Annuity Liabilities - Current [1173]
Unpaid Claims - Current [1294]
AccountsPayableGrowth
AccountsPayablePerShare
AccountsReceivable
[Capital IQ]
Excel Formula: IQ_AR
Accounts Receivable, Total [1021] is a line item in the standard template
This item includes:
Accounts Receivable [1087]
Accumulated Allowance for Doubtful Accounts [20006]
Loans And Lease Receivables [1187]
Premium Due [1210]
Factored Accounts Receivable [1286]
Factored Loans And Lease Receivables [1288]
Accounts Receivables - Unbilled [45420]
AccountsReceivableGrowth
AccountsReceivablePerShare
AccumulatedDepreciationAndDepletion
[Capital IQ]
Excel Formula: IQ_AD
Accumulated Depreciation [1075] is a line item across all templates that represents the period-end balance of accumulated depreciation on property, plant and equipment with the following components:
Assets Under Capital Lease - Accumulated Depreciation [24197]
Assets On Operating Lease - Accumulated Depreciation [24200]
Accumulated Depreciation
Right-of-Use Assets - Accumulated Depreciation [48367]
Right-of-Use Assets - Capital Lease - Accumulated Depreciation [48373]
Right-of-Use Assets - Operating Lease - Accumulated Depreciation [48379]
This line item includes:
Accumulated depreciation
Depletion charges of mines or resource deposits
Oil and gas properties and other natural properties write-downs
Amortization of tools and dies and other related assets
This line item excludes:
Amortization of intangibles if included in depreciation and amortization
Amortization of deferred expenses if included in depreciation and amortization
Amortization of software costs
Depreciation on assets of discontinued operations
AccumulatedDepreciationAndDepletionGrowth
AccumulatedDepreciationAndDepletionPerShare
AdditionalPaidInCapital
[Capital IQ]
Excel Formula: IQ_APIC
Additional Paid in Capital [1084] is a line item across all templates that represents capital contributions by common shareholders that are in excess of the par or stated value of common stock.
This items includes:
General partner
Capital surplus not designated specifically
Contributed capital
Forfeited stock subscriptions
Detachable stock purchase warrants representing additional paid in capital
Dedicated, donated or contributed capital
This line item excludes:
Paid in capital relating to preferred stock/deferred compensation
Contributions receivable
AdditionalPaidInCapitalGrowth
AdditionalPaidInCapitalPerShare
AdvertisingExpense
[Capital IQ]
Excel Formula: IQ_ADVERTISING
Advertising Expense is a supplemental line item in the Standard, Real Estate, Utility and Insurance templates with the following components:
Advertising Expenses [24247]
Advertising Expenses (Supple) [24249]
AdvertisingExpenseA
[Capital IQ]
Excel Formula: IQ_ADVERTISING
Advertising Expense is a supplemental line item in the Standard, Real Estate, Utility and Insurance templates with the following components:
Advertising Expenses [24247]
Advertising Expenses (Supple) [24249]
AdvertisingExpenseGrowth
AdvertisingExpenseQ
[Capital IQ]
Excel Formula: IQ_ADVERTISING
Advertising Expense is a supplemental line item in the Standard, Real Estate, Utility and Insurance templates with the following components:
Advertising Expenses [24247]
Advertising Expenses (Supple) [24249]
AnalystEstimateRevenuePercentChange1Year
Rankable -
The projected change in revenue one year.
AnalystPriceTargetMeanDifference
The raw difference between the Analyst Price Target Mean value and the current price ( price target mean - current price).
AnalystPriceTargetMeanDifferencePercent
Rankable -
The percent difference between the Analyst Price Target Mean value and the current price - 100 * (Price Target Mean - Current Price ) / Current Price.
AnalystRecommendations
Rankable -
A raw score that helps compare analyst recommendations. Calculated as (strong buy * 10) + (buy * 5) - (strong sell * 10) - (sell * 5)
AnalystSentimentScore
Rankable -
A score from 0 to 100 that reflects the Analyst Sentiment
Assets
[Capital IQ]
Excel Formula: IQ_TOTAL_ASSETS
Total Assets [1007] is subtotal line item across all templates with the following components:
Standard template:
Total Current Assets [1008]
Net Property, Plant & Equipment [1004]
Long-term Investments [1054]
Goodwill [1171]
Other Intangibles, Total [1040]
Finance Div. Loans and Leases, LT [1033]
Finance Division Other Long-Term Assets, Total [1034]
Other Assets, Total [1272]
Banks template:
Cash And Equivalents [1096]
Total investments [1011]
Net Loans [1003]
Net Property, Plant & Equipment [1004]
Goodwill [1171]
Other Intangibles, Total - (Template Specific) [1041]
Investment in FHLB [1167]
Other Assets, Total - (Template Specific) [1273]
Capital Markets template:
Cash And Equivalents [1096]
Cash & Securities Segregated [1235]
Securities Owned [1236]
Securities Purch. Under Agreem. To Resell [1240]
Securities Borrowed [1234]
Accounts Receivable, (Summary Subtotal) - (Template Specific) [1274]
Net Property, Plant & Equipment [1004]
Goodwill [1171]
Other Intangibles, Total - (Template Specific) [1041]
Other Assets, Total - (Template Specific) [1273]
Financial Services template:
Cash And Equivalents [1096]
Long-Term Investments - (FS Template) [1038]
Trading Asset Securities [1244]
Loans and Lease Receivables - (FS Template) [1045]
Other Receivables [1206]
Net Property, Plant & Equipment [1004]
Goodwill [1171]
Other Intangibles, Total - (Template Specific) [1041]
Other Assets, Total - (Template Specific) [1273]
Insurance template:
Total investments [1011]
Cash And Equivalents [1096]
Reinsurance Recoverable - (IS) [1068]
Deferred Policy Acq. Costs [1115]
Separate Account Assets [1230]
Other Receivables - (Insurance Template) [1064]
Net Property, Plant & Equipment [1004]
Goodwill [1171]
Other Intangibles, Total - (Template Specific) [1041]
Other Assets, Total - (Template Specific) [1273]
Real Estate:
Total Real Estate Assets [1015]
Cash And Equivalents [1096]
Accounts Receivable, (Summary Subtotal) - (Template Specific) [1274]
Invest. in Debt and Equity Securities [1176]
Goodwill [1171]
Other Intangibles, Total - (Template Specific) [1041]
Other Assets, Total - (Template Specific) [1273]
Utility template:
Total Current Assets [1008]
Net Property, Plant & Equipment [1004]
Net Nuclear Fuel [1200]
Regulatory Assets [1220]
Goodwill [1171]
Other Intangibles, Total - (Template Specific) [1041]
Other Assets, Total - (Template Specific) [1273]
AssetsCurrent
[Capital IQ]
Excel Formula: IQ_TOTAL_CA
Total Current Assets [1008] is subtotal line item in the Standard and Utility templates with the following components:
Standard template:
Total Cash & ST Investments [1002]
Total Receivables [1001]
Inventory [1043]
Prepaid Exp. [1212]
Finance Div. Loans and Leases, ST [1032]
Finance Division Other Current Assets, Total [1029]
Other Current Assets, (Summary Subtotal) [1267]
Utility template:
Cash And Equivalents [1096]
Short Term Investments - (Utility Template) [1242]
Trading Asset Securities [1244]
Accounts Receivable, (Summary Subtotal) - (Template Specific) [1274]
Inventory - (Utility Template) [1179]
Prepaid Exp. [1212]
Other Current Assets, (Summary Subtotal) - (Template Specific) [1266]
AssetsCurrentGrowth
AssetsCurrentPerShare
AssetsGrowth
AssetsNonCurrent
AssetsNonCurrentGrowth
AssetsNonCurrentPerShare
AssetsOtherCurrent
[Capital IQ]
Excel Formula: IQ_OTHER_CA
Other Current Assets, (Summary Subtotal) [1267] is a summary line item in the Standard template with the following components:
Restricted Cash [1104]
Deferred Tax Assets Current [1117]
Other Current Assets, Total [1055]
Loans Held For Sale [1185]
AssetsOtherCurrentGrowth
AssetsOtherCurrentPerShare
AssetsOtherNonCurrent
AssetsOtherNonCurrentGrowth
AssetsOtherNonCurrentPerShare
AssetsPerShare
AssetTurnover
AssetTurnoverGrowth
BasicWeightedSharesOutstanding
[Capital IQ]
Excel Formula: IQ_BASIC_WEIGHT
Basic Weighted Average Shares Outstanding [3217] is a line item across all templates and represents the number of basic weighted average shares outstanding during the period (used by the reporting company as denominator in calculating Basic earnings per share/ADR equivalent).
When not disclosed directly by the reporting company, Basic Weighted Average Shares Outstanding [3217] is calculated using one of the following formulas or mapped from one of the following reported items depending on data availability in the particular period:
Net Income to Common Incl Extra Items [16] / Net EPS - Basic (As Reported)
Net Income to Common Excl. Extra Items [379] / Basic EPS - Continuing Operations (As Reported)
Diluted Weighted Average Shares Outstanding [342]
(Net Income to Common Incl Extra Items [16] - Earnings Of Discontinued Operations [40] - Extraordinary Item & Accounting Change [42]) / Basic EPS - Continuing Operations [3064]
Earnings Of Discontinued Operations [40] / Basic EPS - Discontinued Operations [3065]
Extraordinary Income (Loss) [140] / Basic EPS - Extraordinary Items [146]
Cumulative Effect of Accounting Change [115] / Basic EPS - Accounting Change [145]
Extraordinary Item & Accounting Change [42] / Basic EPS - Extraordinary Items & Accounting Change [45]
Net Income to Common Incl Extra Items [16] / Net EPS - Basic [9]
For all calculated periods where reported Basic WASO values are not available, Capital IQ calculates a weighted average count based on reported values for the component periods. For example, our LTM share count is calculated using the following formula:
(12 * Annual WASO + Number of Months YTD * (WASO (YTD) - WASO (Prior YTD)) / 12
Note:
1. This item is adjusted for historical stock splits
2. For multiple class companies, per share items are primary class equivalent, and for foreign companies listed in Capital IQ as primary ADRs, per share items are ADR-equivalent
BasicWeightedSharesOutstandingGrowth
BookToMarket
Rankable -
The Book Value (Equity) divided by the Market Cap
BookValue
BookValuePerShare
[Capital IQ]
Excel Formula: IQ_BV_SHARE
Book Value / Share is a ratio across all templates calculated using the following formula:
Total Common Equity [1006] - Hybrid Equity Securities [49555] / Total Shares Out. on Balance Sheet Date [24152]
Capex
[Capital IQ]
Excel Formula: IQ_CAPEX
Capital Expenditure [2021] is a line item in the Standard template that represents cash outflows towards purchase of plant, property and equipment by the company and has the following components:
Capital Expenditure - (Template Specific) [2114]
Nuclear Fuel Expenditures [2109]
Sale Proceeds from Rental Assets {42411}
This item excludes:
Purchase/ sale of real estate properties
Purchase/ sale of intangible assets like licenses, patents, trademarks etc.
Purchase/ sale of investments
Sale of property, plant and equipment
Additions to deferred charges
Cash restricted for capital expenditure
CapexA
[Capital IQ]
Excel Formula: IQ_CAPEX
Capital Expenditure [2021] is a line item in the Standard template that represents cash outflows towards purchase of plant, property and equipment by the company and has the following components:
Capital Expenditure - (Template Specific) [2114]
Nuclear Fuel Expenditures [2109]
Sale Proceeds from Rental Assets {42411}
This item excludes:
Purchase/ sale of real estate properties
Purchase/ sale of intangible assets like licenses, patents, trademarks etc.
Purchase/ sale of investments
Sale of property, plant and equipment
Additions to deferred charges
Cash restricted for capital expenditure
CapexQ
[Capital IQ]
Excel Formula: IQ_CAPEX
Capital Expenditure [2021] is a line item in the Standard template that represents cash outflows towards purchase of plant, property and equipment by the company and has the following components:
Capital Expenditure - (Template Specific) [2114]
Nuclear Fuel Expenditures [2109]
Sale Proceeds from Rental Assets {42411}
This item excludes:
Purchase/ sale of real estate properties
Purchase/ sale of intangible assets like licenses, patents, trademarks etc.
Purchase/ sale of investments
Sale of property, plant and equipment
Additions to deferred charges
Cash restricted for capital expenditure
CapitalLeaseObligations
[Capital IQ]
Excel Formula: IQ_LONG_TERM_LEASES
Long-Term Leases [1183] is a line item across all templates that represents the sum of the following components
Finance Leases, Long Term [48991]
Long Term Portion of Operating Lease Liabilities [48383]
Cash
[Capital IQ]
Excel Formula: IQ_CASH_EQUIV
Cash and Cash Equivalents [1096] is a line item across all templates that represents funds in the form of cash, readily convertible deposits, securities and other instruments having maturities of less than 3 months at the time of purchase. It includes short term, highly liquid investments that are readily convertible into known amounts of cash and are near their maturity as well as cash on hand consisting of coins, currency, undeposited checks, money orders and drafts, and deposits in banks.
This item includes:
Cash and equivalents
Cash and cash equivalents (unrestricted)
Cash and temporary cash investments
Cash
Cash, including cash equivalents
Cash and certificates of deposit
Cash and cash equivalents, principally time deposits
Cash and short-term investments
Cash and equivalents including restricted cash
Cash in transit from financial institutions
Joint venture cash and investments
Liquid Assets
CashAndEquivalents
[Capital IQ]
Excel Formula: IQ_CASH_EQUIV
Cash and Cash Equivalents [1096] is a line item across all templates that represents funds in the form of cash, readily convertible deposits, securities and other instruments having maturities of less than 3 months at the time of purchase. It includes short term, highly liquid investments that are readily convertible into known amounts of cash and are near their maturity as well as cash on hand consisting of coins, currency, undeposited checks, money orders and drafts, and deposits in banks.
This item includes:
Cash and equivalents
Cash and cash equivalents (unrestricted)
Cash and temporary cash investments
Cash
Cash, including cash equivalents
Cash and certificates of deposit
Cash and cash equivalents, principally time deposits
Cash and short-term investments
Cash and equivalents including restricted cash
Cash in transit from financial institutions
Joint venture cash and investments
Liquid Assets
CashAndEquivalentsGrowth
CashAndEquivalentsPerShare
CashFlow
[Capital IQ]
Excel Formula: IQ_NET_CHANGE
Net Change in Cash [2093] is a subtotal line item across all templates that represents net increase or decrease in cash or cash equivalents during the stated period of time and has the following components:
Cash from Operations [2006]
Cash from Investing [2005]
Cash from Financing [2004]
Foreign Exchange rate Adjustments [2144]
Miscellaneous Cash Flow Adjustments [2149]
CashFromFinancingActivities
[Capital IQ]
Excel Formula: IQ_CASH_FINAN
Cash from Financing [2004] is a subtotal line item across all templates with the following components:
Standard template:
Total Debt Issued [2161]
Total Debt Repaid [2166]
Issuance of Common Stock [2169]
Repurchase of Common Stock [2164]
Issuance of Preferred Stock [2181]
Repurchase of Preferred Stock [2172]
Total Dividends Paid [2022]
Other Financing Activities, (Summary Subtotal) [2175]
Non-standard templates:
Total Debt Issued - (Template Specific) [2162]
Total Debt Repaid - (Template Specific) [2163]
Issuance of Common Stock - (Template Specific) [2159]
Repurchase of Common Stock - (Template Specific) [2165]
Issuance of Preferred Stock - (Template Specific) [2174]
Repurchase of Preferred Stock - (Template Specific) [2170]
Total Dividends Paid [2022]
Other Financing Activities, (Summary Subtotal) - (Template Specific) [2176]
CashFromFinancingActivitiesA
[Capital IQ]
Excel Formula: IQ_CASH_FINAN
Cash from Financing [2004] is a subtotal line item across all templates with the following components:
Standard template:
Total Debt Issued [2161]
Total Debt Repaid [2166]
Issuance of Common Stock [2169]
Repurchase of Common Stock [2164]
Issuance of Preferred Stock [2181]
Repurchase of Preferred Stock [2172]
Total Dividends Paid [2022]
Other Financing Activities, (Summary Subtotal) [2175]
Non-standard templates:
Total Debt Issued - (Template Specific) [2162]
Total Debt Repaid - (Template Specific) [2163]
Issuance of Common Stock - (Template Specific) [2159]
Repurchase of Common Stock - (Template Specific) [2165]
Issuance of Preferred Stock - (Template Specific) [2174]
Repurchase of Preferred Stock - (Template Specific) [2170]
Total Dividends Paid [2022]
Other Financing Activities, (Summary Subtotal) - (Template Specific) [2176]
CashFromFinancingActivitiesGrowth
CashFromFinancingActivitiesQ
[Capital IQ]
Excel Formula: IQ_CASH_FINAN
Cash from Financing [2004] is a subtotal line item across all templates with the following components:
Standard template:
Total Debt Issued [2161]
Total Debt Repaid [2166]
Issuance of Common Stock [2169]
Repurchase of Common Stock [2164]
Issuance of Preferred Stock [2181]
Repurchase of Preferred Stock [2172]
Total Dividends Paid [2022]
Other Financing Activities, (Summary Subtotal) [2175]
Non-standard templates:
Total Debt Issued - (Template Specific) [2162]
Total Debt Repaid - (Template Specific) [2163]
Issuance of Common Stock - (Template Specific) [2159]
Repurchase of Common Stock - (Template Specific) [2165]
Issuance of Preferred Stock - (Template Specific) [2174]
Repurchase of Preferred Stock - (Template Specific) [2170]
Total Dividends Paid [2022]
Other Financing Activities, (Summary Subtotal) - (Template Specific) [2176]
CashFromInvestingActivities
[Capital IQ]
Excel Formula: IQ_CASH_INVEST
Cash From Investing [2005] is a subtotal line item across all templates with the following components:
Standard template:
Capital Expenditure [2021]
Sale of Property, Plant, and Equipment [2042]
Cash Acquisitions [2057]
Divestitures [2077]
Other Investing Activities, (Summary Subtotal) [2177]
Non-standard templates:
Capital Expenditure [2114]
Sale of Property, Plant and Equipment [2042]
Cash Acquisitions [2057]
Divestitures [2077]
Other Investing Activities, (Summary Subtotal) - (Template Specific) [2178]
Real Estate template - additional components:
Acquisition of Real Estate Assets, Total [2124]
Sale of Real Estate Assets, Total [2125]
Net Sale / Acquisition of Real Estate Assets [2009]
Purchase / Sale of Intangible Assets - (Template Specific) [2030]
Real Estate template - components excluded:
Capital Expenditure [2114]
Sale of Property, Plant and Equipment [2042]
CashFromInvestingActivitiesA
[Capital IQ]
Excel Formula: IQ_CASH_INVEST
Cash From Investing [2005] is a subtotal line item across all templates with the following components:
Standard template:
Capital Expenditure [2021]
Sale of Property, Plant, and Equipment [2042]
Cash Acquisitions [2057]
Divestitures [2077]
Other Investing Activities, (Summary Subtotal) [2177]
Non-standard templates:
Capital Expenditure [2114]
Sale of Property, Plant and Equipment [2042]
Cash Acquisitions [2057]
Divestitures [2077]
Other Investing Activities, (Summary Subtotal) - (Template Specific) [2178]
Real Estate template - additional components:
Acquisition of Real Estate Assets, Total [2124]
Sale of Real Estate Assets, Total [2125]
Net Sale / Acquisition of Real Estate Assets [2009]
Purchase / Sale of Intangible Assets - (Template Specific) [2030]
Real Estate template - components excluded:
Capital Expenditure [2114]
Sale of Property, Plant and Equipment [2042]
CashFromInvestingActivitiesGrowth
CashFromInvestingActivitiesQ
[Capital IQ]
Excel Formula: IQ_CASH_INVEST
Cash From Investing [2005] is a subtotal line item across all templates with the following components:
Standard template:
Capital Expenditure [2021]
Sale of Property, Plant, and Equipment [2042]
Cash Acquisitions [2057]
Divestitures [2077]
Other Investing Activities, (Summary Subtotal) [2177]
Non-standard templates:
Capital Expenditure [2114]
Sale of Property, Plant and Equipment [2042]
Cash Acquisitions [2057]
Divestitures [2077]
Other Investing Activities, (Summary Subtotal) - (Template Specific) [2178]
Real Estate template - additional components:
Acquisition of Real Estate Assets, Total [2124]
Sale of Real Estate Assets, Total [2125]
Net Sale / Acquisition of Real Estate Assets [2009]
Purchase / Sale of Intangible Assets - (Template Specific) [2030]
Real Estate template - components excluded:
Capital Expenditure [2114]
Sale of Property, Plant and Equipment [2042]
CashFromOperatingActivities
[Capital IQ]
Excel Formula: IQ_CASH_OPER
Cash From Operations [2006] is a subtotal line item across all templates with the following components:
Standard template:
Net Income [2150]
Depreciation and Amortization, Total [2160]
Amortization of Deferred Charges, Total - (CF) [2014]
Other Non-Cash Items, Total [2179]
Change in Net Operating Assets [2010]
Non-standard templates:
Net Income [2150]
Depreciation and Amortization, Total [2185]
Amortization of Deferred Charges, Total - (Template Specific) [2015]
Other Operating Activities, Total (Template Specific) [2180]
CashFromOperatingActivitiesA
[Capital IQ]
Excel Formula: IQ_CASH_OPER
Cash From Operations [2006] is a subtotal line item across all templates with the following components:
Standard template:
Net Income [2150]
Depreciation and Amortization, Total [2160]
Amortization of Deferred Charges, Total - (CF) [2014]
Other Non-Cash Items, Total [2179]
Change in Net Operating Assets [2010]
Non-standard templates:
Net Income [2150]
Depreciation and Amortization, Total [2185]
Amortization of Deferred Charges, Total - (Template Specific) [2015]
Other Operating Activities, Total (Template Specific) [2180]
CashFromOperatingActivitiesGrowth
Rankable -
CashFromOperatingActivitiesGrowth2Years
Rankable -
CashFromOperatingActivitiesGrowth3Years
Rankable -
CashFromOperatingActivitiesQ
[Capital IQ]
Excel Formula: IQ_CASH_OPER
Cash From Operations [2006] is a subtotal line item across all templates with the following components:
Standard template:
Net Income [2150]
Depreciation and Amortization, Total [2160]
Amortization of Deferred Charges, Total - (CF) [2014]
Other Non-Cash Items, Total [2179]
Change in Net Operating Assets [2010]
Non-standard templates:
Net Income [2150]
Depreciation and Amortization, Total [2185]
Amortization of Deferred Charges, Total - (Template Specific) [2015]
Other Operating Activities, Total (Template Specific) [2180]
CashGrowth
CashPerShare
[Capital IQ]
Excel Formula: IQ_CASH_SHARE
Cash Per Share - (Ratio) [4381] is a supplemental line item across all templates calculated using the following formula:
Cash And equivalents [1096] / Total shares out. on balance sheet date [24152]
cfo
CommonDividendsPaid
[Capital IQ]
Excel Formula: IQ_COMMON_DIV_CF
Common Dividends Paid [2074] is a line item across all templates that represents dividends paid or distributions made to common shareholders
This item includes:
Common stock dividends
Dividends on common stock
Common stock cash dividends paid
Dividends paid to common stockholders
Dividend distributions
Distribution to common stockholders
Dividends and distributions to common shareholders
Distributions to common unit holders
Cash distributions
Distributions to partners
Dividends paid on common and minority stockholders
This item excludes:
Payment of preferred stock dividend
Payment of dividend to minority shareholders
Payment of common and preferred stock dividend (when given as a combined data item)
Return of capital
Any special dividends paid
CommonDividendsPaidPerShare
CommonSharesOutstanding
[Capital IQ]
Total Common Shares Outstanding [1070] item represents the total number of shares of a Company. If the company has only one class of shares i.e. either Common Shares or Class A Shares or Class B Shares, then that class of shares will be treated as total common shares outstanding (CSO Common Shares Outstanding = Total Common Shares Outstanding; Class A Shares Outstanding = Total Common Shares Outstanding; Class B Shares Outstanding = Total Common Shares Outstanding). If the company has more than one class of shares i.e. common shares, class A shares and class B shares then we are calculating total common shares outstanding in the following manner:
1. If the non trading class is convertible to trading class on a one-to-one basis, then they are simply added together. (Total Common Shares Outstanding = Common Shares Outstanding + Class A Shares Outstanding + Class B Shares Outstanding).
2. If the non trading class is convertible to trading class on any other basis (i.e. where conversion factor is other than one) then the non trading class is converted to trading class by using the conversion factor given by the Company and showing the same as Total Common Shares outstanding. Example: Company XYZ has 2 classes of shares i.e., Class A common Stock and Class B common stock. Class B common stock is convertible at a later date in the ratio of 2 shares of Class A common shares for every share of Class B common share. The company has 1,000 Class A common shares and 250 Class B common shares. Therefore, Total Common Shares Outstanding = Class A Shares Outstanding + Class B Shares Outstanding * 2(conversion ratio). In this case Total Common Shares Outstanding = 1,000 + 250*2; Total Common Shares Outstanding = 1,500
*Common Shares Outstanding is defined as the Number of Common Shares issued excluding Common shares held in Treasury. This data is fully adjusted for all stock splits, stock dividends and ADR factors (if ADR issue made for that company)
CommonSharesOutstandingGrowth
CostOfSales
[Capital IQ]
Excel Formula: IQ_COST_REV
Cost of Revenues [1] is a line item in the Standard template with the following components:
Cost of Goods Sold, Total [34]
Finance Div. Operating Exp. [51]
Insurance Division Operating Expenses [69]
Interest Expense (Finance Division) [50]
CostOfSalesA
[Capital IQ]
Excel Formula: IQ_COST_REV
Cost of Revenues [1] is a line item in the Standard template with the following components:
Cost of Goods Sold, Total [34]
Finance Div. Operating Exp. [51]
Insurance Division Operating Expenses [69]
Interest Expense (Finance Division) [50]
CostOfSalesGrowth
CostOfSalesQ
[Capital IQ]
Excel Formula: IQ_COST_REV
Cost of Revenues [1] is a line item in the Standard template with the following components:
Cost of Goods Sold, Total [34]
Finance Div. Operating Exp. [51]
Insurance Division Operating Expenses [69]
Interest Expense (Finance Division) [50]
croic
Rankable -
croicGrowth
Rankable -
CurrentPortionOfCapitalLeases
[Capital IQ]
Excel Formula: IQ_CURRENT_PORT_LEASES
Current Portion of Leases [1090] is a line item across all templates that represents the sum of the following components
Finance Leases, Current [48990]
Current Portion of Operating Lease Liabilities [48385]
CurrentPortionOfLongTermDebt
[Capital IQ]
Excel Formula: IQ_CURRENT_PORT_DEBT
Current Portion of Long-Term Debt is a line item in the standard template represents the portion of long-term debt due within one year with the following components:
Current portion of long term debt [1023]
Federal home Loan bank debt - current portion [1164]
Curr. port. of LT debt derivatives [30917]
CurrentPortionOfLongTermDebtGrowth
CurrentPortionOfLongTermDebtPerShare
CurrentRatio
CurrentRatioGrowth
DaysToCover
Rankable -
DaysToCover1Month
Rankable -
This is the days to cover with one month volume lookback.
DaysToCover3Month
Rankable -
This is the days to cover with three months volume lookback.
DaysToCoverExchangeReported
This is the days to cover (aka Short Interest Ratio) as reported by the exchanges, twice monthly.
Debt
This is the total Debt = LongTermDebt + ShortTermDebt + CurrentPortionOfLongTermDebt
DebtGrowth
DebtPerShare
DeepValuePiotroskiScore
Rankable -
This is a proprietary scoring model that ranges from 0 to 100 that implements the strategy outlined in the original Piotroski F-Score paper.
DeferredIncomeTaxLiabilities
DeferredIncomeTaxLiabilitiesGrowth
DeferredIncomeTaxLiabilitiesPerShare
DeltaAssetTurnover
DeltaGrossMargin
DeltaRoa
DilutedWeightedSharesOutstanding
[Capital IQ]
Excel Formula: IQ_DILUT_WEIGHT
Diluted Weighted Average Shares Outstanding is a line item across all templates and represents the number of diluted weighted average shares outstanding during the period (used by the reporting company as denominator in calculating Basic earnings per share/ADR equivalent).
When not disclosed directly by the reporting company, Diluted Weighted Average Shares Outstanding is calculated using one of the following formulas or mapped from one of the following reported items depending on data availability in the particular period:
(Diluted Net Income [3522] + Earnings Of Discontinued Operations [40] + Extraordinary Item & Accounting Change [42]) / Net EPS - Diluted (As Reported)
Diluted Net Income [3522] / Diluted EPS - Continuing Operations (As Reported)
Basic Weighted Average Shares Outstanding [3217]
Diluted Net Income [3522] / Diluted EPS - Continuing Operations [142]
Earnings Of Discontinued Operations [40] / Diluted EPS - Discontinued Operations [143]
Extraordinary Income (Loss) [140] / Diluted EPS - Extraordinary Items [144]
Cumulative Effect of Accounting Change [115] / Diluted EPS - Accounting Change [141]
Extraordinary Item & Accounting Change [42] / Diluted EPS - Extraordinary Items & Accounting Change [44]
Diluted Net Income [3522] / Net EPS - Diluted [8]
For all calculated periods where reported Diluted WASO values are not available, Capital IQ calculates a weighted average count based on reported values for the component periods. For example, our LTM share count is calculated using the following formula:
(12 * Annual WASO + Number of Months YTD * (WASO (YTD) - WASO (Prior YTD)) / 12
For non-profitable calculated periods the formula above is replaced with a direct mapping from Basic Weighted Avg. Shares Outstanding [3217]
Note:
1. This item is adjusted for historical stock splits
2. For multiple class companies, per share items are primary class equivalent, and for foreign companies listed in Capital IQ as primary ADRs, per share items are ADR-equivalent
DilutedWeightedSharesOutstandingGrowth
DividendCashOpsPayoutRatio
DividendPayoutRatio
DividendRecoveryDays
The average number of days it takes the share price to recover after a dividend payout.
DividendScore
Rankable -
DividendsPaid
This is the total dividends paid for common and preferred shares.
DividendsPaidA
This is the total dividends paid for common and preferred shares.
DividendsPaidPerShare
This is the total dividends paid per share.
DividendsPaidQ
[Capital IQ]
Excel Formula: IQ_TOTAL_DIV_PAID_CF
Common & Preferred Stock Dividends Paid [2022] is a subtotal line item across all templates with the following components:
Common & Preferred Stock Dividends Paid - (Template Specific) [2072]
Common Dividends Paid [2074]
Preferred Dividends Paid [2116]
This item excludes:
Payment of dividend by subsidiary
Distributions on company-obligated Mandatorily redeemable preferred stock of subsidiary trust
Return of capital
DividendsPerShare
[Capital IQ]
Excel Formula: IQ_DIV_SHARE
Dividend Per Share [3058] represents gross dividend per common share declared in the form of cash. For companies that exist in countries with imputation systems, the cash dividend is net of tax credits and hence Dividend per share represents net dividend per share.
This item Includes:
Any cash dividends declared on various classes of common stock (i.e., Class A, Class B) that is being listed
This item excludes:
Special dividend
Liquidation distributions
Preferred stock dividends
Stock dividends
Spin off dividends
Extraordinary return of capital
Extraordinary capital gains distributions
Cash dividends paid in lieu of fractional shares
Minority shareholders distributions
Note:
1. This item is fully adjusted for all subsequent stock splits and stock dividends.
2. We consider the declaration date to determine the reporting period in which the dividend is included. In cases where dividends are normally declared quarterly but the two declarations fall within the same quarter, then only one dividend declaration is considered, which is related to the reporting quarter
DividendsPerShareGrowth
DividendsPerShareGrowth2Years
DividendsPerShareGrowth3Years
Rankable -
DividendYield
Rankable -
EarningsPerShare
EarningsPerShareBasic
[Capital IQ]
Basic Earnings Per Share - Total [3523] refers to the total basic earnings per share as reported by the Company. It includes the following per share items: Earnings per share from continuing operations, discontinued operations, accounting charges and extra-ordinary income/loss. This item is categorized only if it is given directly in the Income Statement or in the notes.
EarningsPerShareDiluted
[Capital IQ]
Diluted Earnings Per Share - Total [3524] refers the total diluted earnings per share as reported by the Company, which includes the following per share items: Earnings per share from continuing operations, discontinued operations, accounting changes and extra-ordinary income/loss. This item is categorized only if it is given directly in the Income Statement or in the notes.
EBIT
Earnings Before Income Taxes
EBit3YrAvgToEv
Rankable -
EBITGrowth
Rankable -
Earnings Before Income Taxes - Growth
EBITGrowth2Years
Rankable -
Earnings Before Income Taxes - Growth
EBITGrowth3Years
Rankable -
Earnings Before Income Taxes - Growth
EBitToEv
Rankable -
Equity
[Capital IQ]
Excel Formula: IQ_TOTAL_EQUITY
Total Equity [1275] is a subtotal line item across all templates with the following components:
Total Preferred Equity [1005]
Total Common Equity [1006]
Total Minority Interest [1052]
EquityGrowth
EquityPerShare
ev
EvToEbit
EvToRevenue
GammaSqueezeScore
Rankable -
Scoring model that ranks companies based on the likelihood of a gamma squeeze relative to their peers.
Goodwill
[Capital IQ]
Excel Formula: IQ_GW
Goodwill [1171] is a line item across all templates that represents premium purchase price paid over the book value of net assets acquired, net of amortization or writedowns for impairment in value. This data item is a combination of Gross Goodwill [24285] and Accumulated Amortization of Goodwill [24327]
In the absence of a detailed breakdown, this item includes:
Goodwill
Purchased intangible assets (consisting solely of Goodwill)
Excess of cost over net value of assets acquired
Customer base
Assembled work force
Excess of investments over fair value of assets acquired
Deposit related intangibles, unidentified intangible assets and branch premiums for banking companies when these items arise in the course of branch acquisition
This line item excludes:
Other intangibles
Intellectual property
Franchise agreements
Patents and trademarks
Agreements not to compete
GoodwillGrowth
GoodwillPerShare
GrossMargin
The Gross Margin is the ratio of revenue left after substracting the Cost of Goods Sold. It is calculated as 1.0 - (Revenue - COGS ) / Revenue.
GrossMarginGrowth
The Gross Margin is the ratio of revenue left after substracting the Cost of Goods Sold. It is calculated as 1.0 - (Revenue - COGS ) / Revenue.
GrossMarginGrowth2Years
The Gross Margin is the ratio of revenue left after substracting the Cost of Goods Sold. It is calculated as 1.0 - (Revenue - COGS ) / Revenue.
GrossMarginGrowth3Years
Rankable -
The Gross Margin is the ratio of revenue left after substracting the Cost of Goods Sold. It is calculated as 1.0 - (Revenue - COGS ) / Revenue.
GrossOperatingProfit
[Capital IQ]
Excel Formula: IQ_GP
Profit [10] is a subtotal line item in the Standard template and is the (difference) between the following data items:
Total Revenues[28]
- Cost of Revenues [1]
GrossOperatingProfitA
[Capital IQ]
Excel Formula: IQ_GP
Profit [10] is a subtotal line item in the Standard template and is the (difference) between the following data items:
Total Revenues[28]
- Cost of Revenues [1]
GrossOperatingProfitGrowth
GrossOperatingProfitQ
[Capital IQ]
Excel Formula: IQ_GP
Profit [10] is a subtotal line item in the Standard template and is the (difference) between the following data items:
Total Revenues[28]
- Cost of Revenues [1]
GrowthScore
Rankable -
The Growth Score is a proprietary score that describes how well the company is growing, both with revenue and income.
IncomeTaxes
IncomeTaxesA
IncomeTaxesGrowth
IncomeTaxesQ
InsiderBuyerCount
InsiderBuyerSharesVolume
InsiderBuyerSharesVolume1Year
InsiderBuyerVolume
Rankable -
InsiderBuySellRatio
Rankable -
InsiderNetBuyerCount
Rankable -
InsiderNetBuyerSharesVolume
InsiderNetBuyerSharesVolume1Year
InsiderNetBuyerSharesVolume1YearOverFloat
Rankable -
InsiderNetBuyerSharesVolumeOverFloat
Rankable -
InsiderNetBuyerVolume
Rankable -
InsiderNetSellerCount
InsiderNonOfficerDollarVolume1Month
Rankable -
Total dollar volume that NON officers have spent buying shares of their own companies in the last one month.
InsiderNonOfficerDollarVolume1Year
Rankable -
Total dollar volume that NON officers have spent buying shares of their own companies in the last 12 months.
InsiderNonOfficerDollarVolume3Months
Rankable -
Total dollar volume that NON officers have spent buying shares of their own companies in the last three months.
InsiderNonOfficerDollarVolume6Months
Rankable -
Total dollar volume that NON officers have spent buying shares of their own companies in the last six months.
InsiderOfficerBuyerCount
Total number of officers that have purchased shares in the last 90 days.
InsiderOfficerBuyerCount1Year
Rankable -
Total number of officers that have purchased shares in the last 12 months.
InsiderOfficerDollarVolume
Total dollar volume that insider officers have spent buying shares of their own company in the last 90 days.
InsiderOfficerDollarVolume1Month
Rankable -
Total dollar volume that insider officers have spent buying shares of their own companies in the last one month.
InsiderOfficerDollarVolume1Year
Rankable -
Total dollar volume that insider officers have spent buying shares of their own companies in the last 12 months.
InsiderOfficerDollarVolume3Months
Rankable -
Total dollar volume that insider officers have spent buying shares of their own companies in the last three months.
InsiderOfficerDollarVolume6Months
Rankable -
Total dollar volume that insider officers have spent buying shares of their own companies in the last six months.
InsiderOfficerPurchasePricePercentChange1Year
Rankable -
Percent difference between the current price of a security and the weighted average purchase price of the officers in the last 12 months.
InsiderOfficerScore
Rankable -
Quant model that finds significant buying by officers without a large increase in price. Useful for identifying companies with high management confidence before price movements.
InsiderOfficerWeightedAvgPurchasePrice
Weighted average purchase price of officer purchases in the last 90 days.
InsiderOfficerWeightedAvgPurchasePrice1Year
Rankable -
Weighted average purchase price of officer purchases in the last 12 months.
InsiderOwnershipPercentFloat
Rankable -
InsiderOwnershipPercentSharesOutstanding
Rankable -
InsiderScore
Rankable -
The Insider Accumulation Score is a multifactor quant model that ranks companies according to the level of buying by corporate insiders.
InsiderSellBuyRatio
Rankable -
InsiderSellerCount
InsiderSellerSharesVolume
InsiderSellerSharesVolume1Year
InsiderSellerVolume
Rankable -
InsidersOwnershipShares
InsiderWeightedAvgPurchasePrice
Rankable -
The weighted average purchase price of *all* insiders during the last quarter (90 days).
Intangibles
[Capital IQ]
Excel Formula: IQ_OTHER_INTAN
Other Intangibles, Total [1040] is a line item in the Standard template with the following components:
Goodwill and Intangible Assets [1172]
Other Intangibles [1178]
Deferred Policy Acquisition Costs - (BS) [1115]
Capitalized / Purchased Software [1243]
Mortgage Servicing Rights [1199]
Value of Business Acquired [1257]
Other Asset Servicing Rights [21560]
Film Contract & Broadcasting Rights - Long-Term [24243]
Gross Goodwill and Intangible Assets [24289]
Gross Intangible Assets [24293]
Accumulated Amortization of Goodwill and Intangible Assets [24329]
Accumulated Amortization of Intangible Assets [24331]
Gross Software Assets [25284]
Accumulated Amortization of Software Assets [25286]
IntangiblesGrowth
IntangiblesPerShare
InterestExpense
[Capital IQ]
Excel Formula: IQ_INTEREST_EXP
Interest Expense, Total [82] is a line item in the Standard template with the following components:
Debt Issuance Costs [133]
Interest Expense [208]
Preferred Stock Dividend of Subsidiary [282]
After Tax portion of Pref. Stock Dividend of Subsidiary [284]
Dividend on Trust Pref. Securities [286]
After Tax portion Dividend on Trust Pref. Securities [288]
InterestExpenseA
[Capital IQ]
Excel Formula: IQ_INTEREST_EXP
Interest Expense, Total [82] is a line item in the Standard template with the following components:
Debt Issuance Costs [133]
Interest Expense [208]
Preferred Stock Dividend of Subsidiary [282]
After Tax portion of Pref. Stock Dividend of Subsidiary [284]
Dividend on Trust Pref. Securities [286]
After Tax portion Dividend on Trust Pref. Securities [288]
InterestExpenseGrowth
InterestExpenseQ
[Capital IQ]
Excel Formula: IQ_INTEREST_EXP
Interest Expense, Total [82] is a line item in the Standard template with the following components:
Debt Issuance Costs [133]
Interest Expense [208]
Preferred Stock Dividend of Subsidiary [282]
After Tax portion of Pref. Stock Dividend of Subsidiary [284]
Dividend on Trust Pref. Securities [286]
After Tax portion Dividend on Trust Pref. Securities [288]
Inventory
[Capital IQ]
Excel Formula: IQ_INVENTORY
Inventory [1043] is a line item in the Standard template with the following components:
Inventories - Raw Materials [24224]
Inventories - Work In Process [24228]
Inventories - Finished Goods [24232]
Inventories - Progress Payments and Others [3147]
Other Real Estate Owned And Foreclosed [1207]
LIFO Reserve [24220]
Allowance for Inventory (BS) [30921]
Advances for Supplies[48956]
The line item includes:
Inventory
Supplies
Parts, spares and sub-assemblies
Merchandise inventories
Packing materials
Tubular goods
Customer service parts and equipment
Other items qualified as inventory with regard to the nature of business of the company such as residential homes and land, securities, timber or lumber, crude oil, fuel and petroleum products etc.
The following rules apply:
Prepayments or advances or any other line item given under the Inventory heading is categorized as Inventory.
If Work-In-Progress appears as a separate line item, then this item is searched in the notes. If attributable profit is included, then it is categorized as Accounts Receivable, otherwise it is categorized as Inventory.
The following rules apply for investment properties and properties under development:
In the case of Real Estate companies reporting both Properties for Sale and Rentals it is categorized as Inventory/Other Long Term Assets. If attributable profit is included, it is categorized as Accounts Receivable/Accounts Receivable Long Term.
In the case of Real Estate Operations having only a Property sales business, then it is categorized as Inventory/Other Long Term Assets.
In the case of Real Estate Operations having only a Rental business then this is categorized as Other Current Assets/Property Plant and Equipment.
In the case of other businesses it is categorized as Other Current Assets/Other Long Term Assets.
InventoryFinishedGoods
InventoryFinishedGoodsGrowth
InventoryFinishedGoodsPerShare
InventoryGrowth
InventoryPerShare
InventoryRawMaterials
InventoryRawMaterialsGrowth
InventoryRawMaterialsPerShare
InventoryWorkInProgress
InventoryWorkInProgressGrowth
InventoryWorkInProgressPerShare
InvestedCapital
Total Invested Capital = Equity + LongTermDebt + ShortTermDebt + CurrentPortionOfLongTermDebt + CapitalLeaseObligations
InvestedCapitalGrowth
IQVScore
Rankable -
The Inverse QV Score is the opposite of the QV Score and finds overvalued, unhealthy companies.
LeverageRatio
LeverageRatioGrowth
Liabilities
[Capital IQ]
Excel Formula: IQ_TOTAL_LIAB
Total Liabilities - (Standard / Utility Template) [1276] is a subtotal line item in the Standard and Utility templates with the following components:
Standard template:
Total Current Liabilities [1009]
Long-Term Debt [1049]
Long Term Leases [1183]
Finance Division Debt Non Current [1035]
Finance Division Other Non Current Liabilities, Total [1036]
Other Liabilities, Total [1282]
Utility template:
Total Current Liabilities [1009]
Long-Term Debt - (Template Specific) [1193]
Long Term Leases [1183]
Trust Preferred Securities (BS) [1071]
Other Liabilities, Total - (Template Specific) [1268]
LiabilitiesAndStockEquity
[Capital IQ]
Excel Formula: IQ_TOTAL_LIAB_EQUITY
Total Liabilities [1013] is a subtotal line item across all templates with the following components:
Standard and Utility templates:
Total Liabilities - (Standard / Utility Template) [1276]
Total Equity [1275]
Non-Standard, non-Utility templates
Total Liabilities - (Template Specific) [1012]
Total Equity [1275]
LiabilitiesAndStockEquityGrowth
LiabilitiesAndStockEquityPerShare
LiabilitiesCurrent
[Capital IQ]
Excel Formula: IQ_TOTAL_CL
Total Current Liabilities [1009] is a subtotal line item in the Standard and Utility templates with the following components:
Standard template:
Accounts Payable, Total [1018]
Accrued Expenses, Total [1016]
Short-term Borrowings [1046]
Current Portion of Long Term Debt/Capital Leases [1279]
Finance Division Debt Current [1030]
Finance Division Other Current Liabilities, Total [1031]
Other Current Liabilities, Total [1269]
Utility template:
Accounts Payable, Total - (Template Specific) [1019]
Accrued Expenses, Total - (Template Specific) [1017]
Short-Term Borrowings - (Template Specific) [1189]
Finance Division Other Current Liabilities, Total [1031]
Other Current Liabilities, Total - (Utility Template) [1271]
Current Portion of Long-Term Debt / Capital Leases - (Template Specific) [1279]
LiabilitiesCurrentGrowth
LiabilitiesCurrentPerShare
LiabilitiesGrowth
LiabilitiesOtherNonCurrent
LiabilitiesOtherNonCurrentGrowth
LiabilitiesOtherNonCurrentPerShare
LiabilitiesPerShare
LongTermDebt
[Capital IQ]
Excel Formula: IQ_LT_DEBT
Long-Term Debt [1049] is a line item in the Standard template with the following components:
Trust Preferred Securities (Other than Convertible) [1246]
Federal Home Loan Bank Debt - Long-Term [1165]
Long-Term Debt - (Template Specific) [1193]
Trust Preferred Securities - Convertible [1247]
LongTermDebtGrowth
LongTermDebtPerShare
MarketCap
MinorityInterest
[Capital IQ]
Excel Formula: IQ_MINORITY_INTEREST
Minority Interest, Total [1052] is a line item in the Standard template with the following components:
Minority Interest [1196]
Preferred Stock of Subsidiary [1218]
Finance Division Minority Interest [1151]
MinorityInterestGrowth
MinorityInterestPerShare
MomentumScore
Rankable -
Proprietary scoring model that ranks companies on their six-month momentum.
Ncav
Net Current Asset Value
NcavPerShare
NetIncome
[Capital IQ]
Excel Formula: IQ_NI
Net Income - (IS) [15] is a subtotal line item across all templates with the following components:
Standard template:
Earnings From Continuing Operations [7]
Earnings Of Discontinued Operations [40]
Extraordinary Item & Accounting Change [42] (Standard template)
Minority Interest in Earnings [83]
Non-Standard templates:
Earnings From Continuing Operations [7]
Earnings Of Discontinued Operations [40]
Extraordinary Item & Accounting Change - (Template Specific) [43]
Minority Interest in Earnings [83]
NetIncomeA
[Capital IQ]
Excel Formula: IQ_NI
Net Income - (IS) [15] is a subtotal line item across all templates with the following components:
Standard template:
Earnings From Continuing Operations [7]
Earnings Of Discontinued Operations [40]
Extraordinary Item & Accounting Change [42] (Standard template)
Minority Interest in Earnings [83]
Non-Standard templates:
Earnings From Continuing Operations [7]
Earnings Of Discontinued Operations [40]
Extraordinary Item & Accounting Change - (Template Specific) [43]
Minority Interest in Earnings [83]
NetIncomeGrowth
NetIncomePerShare
Another term for Earnings per Share or EPS
NetIncomeQ
[Capital IQ]
Excel Formula: IQ_NI
Net Income - (IS) [15] is a subtotal line item across all templates with the following components:
Standard template:
Earnings From Continuing Operations [7]
Earnings Of Discontinued Operations [40]
Extraordinary Item & Accounting Change [42] (Standard template)
Minority Interest in Earnings [83]
Non-Standard templates:
Earnings From Continuing Operations [7]
Earnings Of Discontinued Operations [40]
Extraordinary Item & Accounting Change - (Template Specific) [43]
Minority Interest in Earnings [83]
NetMargin
The Net Margin (aka Profit Margin) is the ratio of revenue left after substracting the Net Income. It is calculated as Net Income / Revenue.
NetMarginGrowth
The Net Margin (aka Profit Margin) is the ratio of revenue left after substracting the Net Income. It is calculated as Net Income / Revenue.
NetMarginGrowth2Years
The Net Margin (aka Profit Margin) is the ratio of revenue left after substracting the Net Income. It is calculated as Net Income / Revenue.
NetMarginGrowth3Years
Rankable -
The Net Margin (aka Profit Margin) is the ratio of revenue left after substracting the Net Income. It is calculated as Net Income / Revenue.
ocroic
Rankable -
ocroicAvg1Years
Rankable -
ocroicAvg2Years
Rankable -
ocroicAvg3Years
Rankable -
ocroicAvg4Years
Rankable -
ocroicAvg5Years
Rankable -
ocroicGrowth
Rankable -
ocroicGrowth2Years
Rankable -
ocroicGrowth3Years
Rankable -
ocroicSpecial
Rankable -
This is OCROIC less Capex.
ocroicSpecialAvg1Years
Rankable -
This is OCROIC less Capex.
ocroicSpecialAvg2Years
Rankable -
This is OCROIC less Capex.
ocroicSpecialAvg3Years
Rankable -
This is OCROIC less Capex.
ocroicSpecialGrowth3Years
Rankable -
This is OCROIC less Capex.
OperatingExpenses
[Capital IQ]
Excel Formula: IQ_TOTAL_OPER_EXPEN
Total Operating Expenses [373] is a subtotal line item in the Standard template with the following components:
Cost of Revenues [1]
Other Operating Expenses, Total [380]
OperatingExpensesA
[Capital IQ]
Excel Formula: IQ_TOTAL_OPER_EXPEN
Total Operating Expenses [373] is a subtotal line item in the Standard template with the following components:
Cost of Revenues [1]
Other Operating Expenses, Total [380]
OperatingExpensesGrowth
OperatingExpensesQ
[Capital IQ]
Excel Formula: IQ_TOTAL_OPER_EXPEN
Total Operating Expenses [373] is a subtotal line item in the Standard template with the following components:
Cost of Revenues [1]
Other Operating Expenses, Total [380]
OperatingIncome
[Capital IQ]
Excel Formula: IQ_OPER_INC
Operating Income [21] is a subtotal line item in the Standard template with the following components:
Total Revenues [28]
- Total Operating Expenses [373]
OperatingIncomeA
[Capital IQ]
Excel Formula: IQ_OPER_INC
Operating Income [21] is a subtotal line item in the Standard template with the following components:
Total Revenues [28]
- Total Operating Expenses [373]
OperatingIncomeGrowth
OperatingIncomeQ
[Capital IQ]
Excel Formula: IQ_OPER_INC
Operating Income [21] is a subtotal line item in the Standard template with the following components:
Total Revenues [28]
- Total Operating Expenses [373]
OperatingMargin
The Operaing Margin is the ratio of revenue left after substracting the Operating Income. It is calculated as Operating Income / Revenue.
OperatingMarginGrowth
The Operaing Margin is the ratio of revenue left after substracting the Operating Income. It is calculated as Operating Income / Revenue.
OperatingMarginGrowth2Years
The Operaing Margin is the ratio of revenue left after substracting the Operating Income. It is calculated as Operating Income / Revenue.
OperatingMarginGrowth3Years
Rankable -
The Operaing Margin is the ratio of revenue left after substracting the Operating Income. It is calculated as Operating Income / Revenue.
OptionAverageCallSize
The average call trade size
OptionAverageDailyCallVolume
The avg daily call volume (20d mov avg)
OptionAverageDailyPutVolume
The avg daily put volume (20d mov avg)
OptionAverageDailyVolume
The avg daily total volume (20d mov avg)
OptionAveragePutSize
The average put trade size
OptionCallBoughtVolume
The total call volume offer side, directional trades.
OptionCallDollarGamma
The dollar gamma is equal to the normal gamma multiplied by the square of the value of the underlying and divided by 100.
OptionCallMonthliesNetOpenInterestFloat
Rankable -
This is the net call open interest in short data options (monthlies) divided by the public float
OptionCallMonthliesOpenInterest
The total open interest in call options with expiration within the next month
OptionCallMonthliesOpenInterestChange1Month
Rankable -
The one-month change in OptionCallMonthliesOpenInterest
OptionCallMonthliesOpenInterestChange1Week
The one-week change in OptionCallMonthliesOpenInterest
OptionCallMonthliesOpenInterestFloat
Rankable -
This is the percent of total float that is held open in monthly call options.
OptionCallOpenInterest
The total call open interest.
OptionCallOpenInterestChange1Month
The change in total call open interest.
OptionCallPremium
The total $ call premium
OptionCallPremiumBought
The total $ call premium trading offer side, directional trades
OptionCallPremiumSold
The total $ call premium trading bid side, directional trades
OptionCallPremiumTraded
The total call premium traded
OptionCallVolume
The total call options traded for a ticker on a given day
OptionCustomerVolume
The occ clearing customer volume.
OptionDollarGamma
Rankable -
The dollar gamma is equal to the normal gamma multiplied by the square of the value of the underlying and divided by 100.
OptionExchangeVolumeAmex
NYSE AMEX Options Exchange Volume
OptionExchangeVolumeArca
NYSE ARCA Options Exchange Volume
OptionExchangeVolumeBox
BOX Options Exchange Volume
OptionExchangeVolumeBxo
NASDAQ BX Options Exchange Volume
OptionExchangeVolumeBzx
Cboe BZX Options Exchange Volume
OptionExchangeVolumeC2
Cboe C2 Options Exchange Volume
OptionExchangeVolumeCboe
Cboe Options Exchange Volume
OptionExchangeVolumeEdgx
Cboe EDGX Options Exchange Volume
OptionExchangeVolumeEmld
MIAX EMLD Options Exchange Volume
OptionExchangeVolumeGem
NASDAQ GEMX Options Exchange Volume
OptionExchangeVolumeIse
NASDAQ ISE Options Exchange Volume
OptionExchangeVolumeMerc
NASDAQ MRX Options Exchange Volume
OptionExchangeVolumeMiax
MIAX Options Exchange Volume
OptionExchangeVolumeNom
NASDAQ Options Exchange Volume
OptionExchangeVolumePearl
MIAX PEARL Options Exchange Volume
OptionExchangeVolumePhlx
NASDAQ PHLX Options Exchange Volume
OptionFirmVolume
The occ clearing firm volume.
OptionFlowPremiumAverage
The 20-Day Moving Average of Option Premium as recorded in the Options Flow
OptionFlowPremiumStdDev
The 20-Day Standard Deviation of Option Premium as recorded in the Options Flow
OptionGexPercentOfMarketCap
Rankable -
The percent of market cap gamma exposure
OptionImpliedBorrow
Market implied borrow cost, near term >7 dtx
OptionImpliedQuarterlyVolatility
At the money implied volatility, 90 day interpolated term
OptionImpliedVolatility
Rankable -
The at the money implied vol, 30 day interpolated term.
OptionImpliedVolatilityChange1Week
Rankable -
The change in implied volatility in the last week.
OptionMarketMakerVolume
The occ clearing market maker volume.
OptionMonthliesPutCallRatio
Rankable -
OptionMonthliesPutCallRatioChange1Week
Rankable -
The one week change in the put/call ratio of stock options with expirations within the next month.
OptionNetDelta
The net option delta for directional trades (direction is relative to the midpoint; if above midpoint, trade is
considered a Buy, and below midpoint - a Sell. Spread, late and tied trades are excluded)
OptionOtmCallOpenInterest
Out of the money call open interest
OptionOtmPutOpenInterest
Out of the money put open interest
OptionPutBoughtVolume
The total put volume offer side, directional trades.
OptionPutCallRatio
Rankable -
The total put option interest / total call option interest.
OptionPutDollarGamma
The dollar gamma is equal to the normal gamma multiplied by the square of the value of the underlying and divided by 100.
OptionPutMonthliesOpenInterest
The total open interest in put options with expirations within the next month.
OptionPutMonthliesOpenInterestChange1Month
Rankable -
The one-month change in OptionPutMonthliesOpenInterest
OptionPutMonthliesOpenInterestChange1Week
Rankable -
The one-week change in OptionPutMonthliesOpenInterest
OptionPutOpenInterest
The total put open interest.
OptionPutOpenInterestChange1Month
The change in total put open interest.
OptionPutPremium
The total $ put premium
OptionPutPremiumBought
The total $ put premium trading offer side, directional trade
OptionPutPremiumSold
The total $ put premium trading bid side, directional trades
OptionPutPremiumTraded
The total put premium traded
OptionPutVolume
The total put options traded for a ticker on a given day.
OptionSplitAdjustedClosePrice
The option spot closing price, adjusted for splits.
OptionSpotPrice
The option spot closing price
OptionTotalCallTrades
The count of call trades
OptionTotalPutTrades
The count of put trades
OptionTotalTrades
The count of all option trades
OptionTradingVolatility
The realized 20 trading day volatility
OptionUnderlyingVolume
The total underlying volume
OptionVegaTraded
The total $ vega traded.
OptionVolatilitySkew
The volatility skew.
OptionVolume
Total trade volume of put and call options traded for a ticker on a specific day.
OwnersAllocationChange
Rankable -
The absolute change in allocation from one quarter to the next
OwnersAllocationPercent
Rankable -
The average percent porfolio allocation of each holder of the security.
OwnersAllocationPercentChange
Rankable -
The percent change in average allocation.
OwnersCallShares
OwnersCallValue
OwnersCount
Rankable -
OwnersCountChange
Change in number of owners in the last 90 days
OwnersCountPercentChange
Rankable -
Percent change in number of owners in the last 90 days
OwnersCountPrior
Rankable -
Total number of owners in the prior quarter
OwnershipScore
Rankable -
The Fund Sentiment (fka Ownership) score is a proprietary quantitative model that ranks companies based on levels of ownership accumulation.
OwnersPercentOwnership
Rankable -
OwnersPutCallRatio
Rankable -
OwnersPutShares
OwnersPutValue
OwnersSharesLong
The number of shares held in long positions
OwnersSharesLongChange
The change in the number of shares during the last quarter. OwnersShares - OwnersSharesPrior
OwnersSharesLongPercentChange
The percent change in the number of shares held over the quarter. Formula is 100 * (OwnersSharesLong - OwnersSharesLongPrior) / OwnersSharesLongPrior
OwnersSharesLongPrior
The number of shares held in long positions one quarter prior.
pe
Rankable -
PiotroskiScore
Rankable -
PreferredStockValueOutstanding
[Capital IQ]
Excel Formula: IQ_PREF_EQUITY
Total Preferred Equity [1005] is a subtotal line item across all templates with the following components:
Standard template:
Preferred Stock Redeemable [1217]
Preferred Stock Non Redeemable [1216]
Preferred Stock Convertible [1214]
Preferred Stock - Others [1065]
Non-standard templates:
Preferred Stock Redeemable [1217]
Preferred Stock Non Redeemable [1216]
Preferred Stock Convertible [1214]
Preferred Stock - Others - (Template Specific) [1066]
PreferredStockValueOutstandingGrowth
PreferredStockValueOutstandingPerShare
PreTaxIncome
PreTaxIncomeA
PreTaxIncomeGrowth
PreTaxIncomeQ
Price
Synonym for PriceClose
PriceChange1Day
The percent change in closing price since the prior day.
PriceChange1Month
The percent change in closing price during the last month.
PriceChange1Week
The percent change in closing price during the last week.
PriceChange1Year
The percent change in closing price during the last year.
PriceChange3Months
The percent change in closing price during the last three months.
PriceChange6Months
The percent change in closing price during the last six months.
PriceClose
The closing price on the given market day.
PriceGrowth1Years
Rankable -
The change in price over the last year.
PriceHigh
The highest price on a given market day.
PriceHigh1Year
The highest price in the last year.
PriceLow
The lowest price on a given market day.
PriceLow1Year
The lowest price in the last year.
PriceMomentum1Month
Rankable -
This is a proprietary metric that represents the general change in price over the last month.
PriceMomentum1Year
Rankable -
PriceMomentum3Months
Rankable -
PriceMomentum6Months
Rankable -
PriceMomentumAustralia1Month
Rankable -
PriceMomentumCanada1Month
Rankable -
PriceMomentumHongKong1Month
Rankable -
PriceOpen
The opening price on the given market day.
PricePercentChange1Month
Rankable -
The percent change in closing price during the last month.
PricePercentChange1Week
Rankable -
The percent change in closing price during the last week.
PriceToBook
Rankable -
The current closing price divided by the book value per share.
PriceToBookValue
PriceToNCAV
PriceToNetIncome
PriceToSales
The current price divided by the sales per share.
PriceToTangibleBookValue
PriceToTBV
Rankable -
The current price divided by the tangible book value per share.
ProfitabilityScore
Rankable -
The Profitability Score is a proprietary score that describes how efficiently the company generates revenue and cash.
PropertyPlantAndEquipment
[Capital IQ]
Excel Formula: IQ_GPPE
Gross Property Plant and Equipment [1169] is a line item across all templates that represents the gross value (not net of depreciation), stated at cost, of tangible assets that are durable in nature and are used in the normal course of business as opposed to being held for sale.
This item includes:
Leasehold Improvements [24449]
Natural Resources, at Cost [24457]
Other Property, Plant and Equipment [24465]
Assets under Capital Lease (Buildings) - Gross [24341]
Assets under Capital Lease (Machinery) - Gross [24343]
Assets under Capital Lease (Others) - Gross [24345]
Assets under Operating Lease (Buildings) - Gross [24347]
Assets under Operating Lease (Machinery) - Gross [24349]
Assets under Operating Lease (Others) - Gross [24351]
Buildings [24204]
Land [24208]
Machinery [24212]
Construction In Progress [24216]
Right-of-Use Assets - Gross [48365]
Right-of-Use Assets - Operating Lease - Gross [48377]
Right-of-Use Assets - Capital Lease - Gross [48371]
In the absence of the above detailed breakdown, this item includes:
Property, plant and equipment
Construction in progress
Oil, gas and petroleum reserves
Assets acquired under capital leases and given under operating leases
Land, Building, Machinery, Furniture and equipment
Leasehold properties, improvements or interests
Real estate properties of REIT companies
Mining properties and wells including exploration and development costs of such mines and wells
Mining, oil and gas properties
This line item excludes:
Assets related to discontinued operations
Software assets
Nuclear Fuel in case of utility companies
Other intangibles or deferred expenses included in the property heading
Advances made for purchase of fixed assets
PropertyPlantAndEquipmentGross
PropertyPlantAndEquipmentGrossGrowth
PropertyPlantAndEquipmentGrossPerShare
PropertyPlantAndEquipmentGrowth
PropertyPlantAndEquipmentNet
[Capital IQ]
Excel Formula: IQ_NPPE , IQ_NPPE_RE
Net Property Plant And Equipment is a subtotal line item across all templates with the following components:
Gross Property Plant And Equipment [1169]
Accumulated Depreciation [1075]
Right-of-Use Assets - Gross [48365]
Right-of-Use Assets - Operating Lease - Gross [48377]
Right-of-Use Assets - Capital Lease - Gross [48371]
Right-of-Use Assets - Accumulated Depreciation [48367]
Right-of-Use Assets - Capital Lease - Accumulated Depreciation [48373]
Right-of-Use Assets - Operating Lease - Accumulated Depreciation [48379]
Note: In the cases where a breakdown of Net Property into Gross and Accumulated Depreciation is not reported the following Net Values are collected directly
Net PP&E
Right-of-Use Assets – Net [48369]
Right-of-Use Assets - Capital Lease – Net [48375]
Right-of-Use Assets - Operating Lease – Net [48381]
PropertyPlantAndEquipmentNetGrowth
PropertyPlantAndEquipmentNetPerShare
PropertyPlantAndEquipmentPerShare
QOScore
Rankable -
Combined Quality and Fund Sentiment (Ownership) score.
QualityScore
Rankable -
The QualityScore is a proprietary scoring model that identifies high quality companies, based on cash generating efficiencies.
QuickRatio
QuickRatioGrowth
QVMScore
Rankable -
The QVM Score is a proprietary scoring model that combines Quality, Value, and Momentum into a single metric that ranks companies from 0 to 100.
QVOScore
Rankable -
Combined Quality, Value, and Ownership score.
QVScore
Rankable -
The QV Score is a proprietary scoring model that combines Quality + Value into a single metric that ranks companies from 0 to 100.
ResearchAndDevelopmentExpense
[Capital IQ]
Excel Formula: IQ_RD_EXP
R&D Expenses [100] is an item in the Standard and Utility templates and represents the following costs incurred by the following activities, which can occur in-house or be undertaken at leading universities and outside research facilities:
Development of a new product
Innovation relating to technology formulation
Process development
The process undertaken in upgrading the existing product or service line
This items also includes Stock-Based Compensation R&D [23518]
This item includes:
Research and development
Research and development - related party
Product development
Investment tax credits
Engineering and product development expense
Product and content development expenses
Technology and development
Software development costs, net
Product testing and government grants, net
Regulatory and clinical
Clinical trials
Media project development
Amortization - research and development
Recovery of research and development costs
This item excludes:
Capitalized development
Customer funded development
Government assistance
Research tax credits
Note: For companies where R&D is the main line of business research and development expenses will be classified as Cost of Goods Sold [129]
ResearchAndDevelopmentExpenseA
[Capital IQ]
Excel Formula: IQ_RD_EXP
R&D Expenses [100] is an item in the Standard and Utility templates and represents the following costs incurred by the following activities, which can occur in-house or be undertaken at leading universities and outside research facilities:
Development of a new product
Innovation relating to technology formulation
Process development
The process undertaken in upgrading the existing product or service line
This items also includes Stock-Based Compensation R&D [23518]
This item includes:
Research and development
Research and development - related party
Product development
Investment tax credits
Engineering and product development expense
Product and content development expenses
Technology and development
Software development costs, net
Product testing and government grants, net
Regulatory and clinical
Clinical trials
Media project development
Amortization - research and development
Recovery of research and development costs
This item excludes:
Capitalized development
Customer funded development
Government assistance
Research tax credits
Note: For companies where R&D is the main line of business research and development expenses will be classified as Cost of Goods Sold [129]
ResearchAndDevelopmentExpenseGrowth
ResearchAndDevelopmentExpenseQ
[Capital IQ]
Excel Formula: IQ_RD_EXP
R&D Expenses [100] is an item in the Standard and Utility templates and represents the following costs incurred by the following activities, which can occur in-house or be undertaken at leading universities and outside research facilities:
Development of a new product
Innovation relating to technology formulation
Process development
The process undertaken in upgrading the existing product or service line
This items also includes Stock-Based Compensation R&D [23518]
This item includes:
Research and development
Research and development - related party
Product development
Investment tax credits
Engineering and product development expense
Product and content development expenses
Technology and development
Software development costs, net
Product testing and government grants, net
Regulatory and clinical
Clinical trials
Media project development
Amortization - research and development
Recovery of research and development costs
This item excludes:
Capitalized development
Customer funded development
Government assistance
Research tax credits
Note: For companies where R&D is the main line of business research and development expenses will be classified as Cost of Goods Sold [129]
RetailFundsFlowShareWeek
Rankable -
This is the percent of total retail fund flows allocated to this stock in the last seven days.
RetailMarketShareStock
Rankable -
This is the retail market share for a single stock.
RetailPercentFloat
Rankable -
Total number of share owned by Fintel Investing Panel divided by the float times 100.
RetainedEarnings
[Capital IQ]
Excel Formula: IQ_RE
Retained Earnings [1222] is a line item across all templates that represents earnings not distributed to shareholders nor apportioned for any specific purpose and can therefore be reinvested in the business. This item includes Unrestricted Retained Earnings [24473] and in the absence of breakdown includes:
Earnings reinvested in business
Legal reserve
Income reinvested in the business
Deficit accumulated during development stage
This data item excludes:
Accredited dividends
Market securities valuation reserves
RetainedEarningsGrowth
RetainedEarningsPerShare
Revenue
[Capital IQ]
Excel Formula: IQ_TOTAL_REV
Total Revenues [28] is subtotal line item in the Standard template with the following components:
Revenues [112]
Other Revenues, (Summary Subtotal) [357]
RevenueA
[Capital IQ]
Excel Formula: IQ_TOTAL_REV
Total Revenues [28] is subtotal line item in the Standard template with the following components:
Revenues [112]
Other Revenues, (Summary Subtotal) [357]
RevenueGrowth
Rankable -
RevenueGrowth2Years
Rankable -
RevenueGrowth3Years
Rankable -
RevenueQ
[Capital IQ]
Excel Formula: IQ_TOTAL_REV
Total Revenues [28] is subtotal line item in the Standard template with the following components:
Revenues [112]
Other Revenues, (Summary Subtotal) [357]
roa
RoaGrowth
roe
roic
Rankable -
Sales
[Capital IQ]
Excel Formula: IQ_TOTAL_REV
Total Revenues [28] is subtotal line item in the Standard template with the following components:
Revenues [112]
Other Revenues, (Summary Subtotal) [357]
SalesA
[Capital IQ]
Excel Formula: IQ_TOTAL_REV
Total Revenues [28] is subtotal line item in the Standard template with the following components:
Revenues [112]
Other Revenues, (Summary Subtotal) [357]
SalesGrowth
SalesQ
[Capital IQ]
Excel Formula: IQ_TOTAL_REV
Total Revenues [28] is subtotal line item in the Standard template with the following components:
Revenues [112]
Other Revenues, (Summary Subtotal) [357]
Sec13dCountTTM
SellingGeneralAndAdministrativeExpense
[Capital IQ]
Excel Formula: IQ_SGA
Selling General & Admin Expenses, Total [23] is a summary line item in the Standard template with the following components:
Selling General & Admin Expenses [102]
Exploration / Drilling Costs [49]
Stock-Based Compensation (IS) [101]
Provision for Bad Debts [95]
Pre-Opening Costs [96]
SellingGeneralAndAdministrativeExpenseA
[Capital IQ]
Excel Formula: IQ_SGA
Selling General & Admin Expenses, Total [23] is a summary line item in the Standard template with the following components:
Selling General & Admin Expenses [102]
Exploration / Drilling Costs [49]
Stock-Based Compensation (IS) [101]
Provision for Bad Debts [95]
Pre-Opening Costs [96]
SellingGeneralAndAdministrativeExpenseGrowth
SellingGeneralAndAdministrativeExpenseQ
[Capital IQ]
Excel Formula: IQ_SGA
Selling General & Admin Expenses, Total [23] is a summary line item in the Standard template with the following components:
Selling General & Admin Expenses [102]
Exploration / Drilling Costs [49]
Stock-Based Compensation (IS) [101]
Provision for Bad Debts [95]
Pre-Opening Costs [96]
shares
This is another term for SharesOutstanding
SharesFloat
The public float of the company. This is generally the total shares outstanding less shares that are restricted from selling, such as insider shares or shares owned by strategic investors.
SharesFloatGrowth
sharesGrowth
SharesOutstanding
The total number of shares outstanding.
SharesOutstandingGrowth
SharpeRatio
Rankable -
The Sharpe Ratio is a measure of risk adjusted return.
ShortBorrowRate
Rankable -
The borrow fee rate provide by our prime brokerage partner. This is the lending rate that a borrower of the shares must pay to the owner, and is represented as an annual percentage rate (APR).
ShortBorrowRateAustralia
Rankable -
The borrow fee rate provide by our prime brokerage partner. This is the lending rate that a borrower of the shares must pay to the owner, and is represented as an annual percentage rate (APR).
ShortBorrowRateCanada
Rankable -
The borrow fee rate provide by our prime brokerage partner. This is the lending rate that a borrower of the shares must pay to the owner, and is represented as an annual percentage rate (APR).
ShortBorrowRateHongKong
Rankable -
The borrow fee rate provide by our prime brokerage partner. This is the lending rate that a borrower of the shares must pay to the owner, and is represented as an annual percentage rate (APR).
ShortBorrowShares
Rankable -
ShortInterest
ShortInterestChange1Month
Rankable -
ShortInterestChange1MonthAustralia
Rankable -
ShortInterestChange1MonthCanada
Rankable -
ShortInterestChange1MonthHongKong
Rankable -
ShortInterestFromFloat
Rankable -
The total floating sharse that are not shorted. Calculated by subtracting short interest from float.
ShortInterestPercentFloat
Rankable -
ShortInterestPercentFloatAustralia
Rankable -
ShortInterestPercentFloatCanada
Rankable -
ShortInterestPercentFloatHongKong
Rankable -
ShortInterestPercentSharesOutstanding
Rankable -
ShortInterestRatio
Rankable -
ShortInterestRatioExchangeReported
This is the short interest ratio as reported by the exchanges, twice monthly.
ShortSales1MonthAustraliaPercentFloat
Rankable -
ShortSalesAustraliaPercentFloat
Rankable -
ShortScore
Rankable -
This Short Score is the opposite of the Short Squeeze Score - it finds companies that are the best candidates to short and unlikely to squeeze.
ShortSqueezeAustraliaScore
Rankable -
The Short Squeeze Score is a multifactor quant model that predicts the likelhood of a short squeeze. The value ranges from 0 to 100, with higher numbers indicating a higher likelihood of a short squeeze.
ShortSqueezeCanadaScore
Rankable -
The Short Squeeze Score is a multifactor quant model that predicts the likelhood of a short squeeze. The value ranges from 0 to 100, with higher numbers indicating a higher likelihood of a short squeeze.
ShortSqueezeHongKongScore
Rankable -
The Short Squeeze Score is a multifactor quant model that predicts the likelhood of a short squeeze. The value ranges from 0 to 100, with higher numbers indicating a higher likelihood of a short squeeze.
ShortSqueezeScore
Rankable -
The Short Squeeze Score is a multifactor quant model that predicts the likelhood of a short squeeze. The value ranges from 0 to 100, with higher numbers indicating a higher likelihood of a short squeeze.
ShortTermDebt
[Capital IQ]
Excel Formula: IQ_ST_DEBT
Short-term Borrowings [1046] is a line item in the standard template with the following components:
Federal home loan bank debt - short-term [1166]
Short-term borrowings - (template specific) [1189]
Commercial paper [1095]
Short-term borrowing derivatives [30919]
ShortVolume
ShortVolumeRatio
Rankable -
SortinoRatio
Rankable -
A measure of risk adjusted return that only accounts for downside deviation.
StabilityScore
Rankable -
Stability is the opposite of Volatility. This score is a ranking from 0 to 100 and indicates the stability of the security, relative to the rest of the market. It is calculated as 100 - Volatility Score. Lower values indicate a more volatility security, and higher values indicate a less volatile security.
TangibleBookValue
[Capital IQ]
Excel Formula: IQ_TBV
Tangible Book Value [1310] represents book value of common equity, net of goodwill and intangible assets
Total Common Equity [1006]
- Goodwill [1171]
- Other Intangibles, Total [1040]
- Finance Division Goodwill [1141]
- Finance Division Goodwill and Intangible Assets [1142]
- Finance Division Intangibles [1143]
Insurance template - components excluded:
Deferred Policy Acquisition Costs - (BS) [1115]
TangibleBookValuePerShare
[Capital IQ]
Excel Formula: IQ_TBV_SHARE
Tangible Book Value Per Share is a ratio across all templates calculated using the following formula:
Tangible Book Value [1310] - Hybrid Equity Securities [49555] / Total Shares Out. on Balance Sheet Date [24152]
TreasuryStock
[Capital IQ]
Excel Formula: IQ_TREASURY_OTHER_EQUITY
Treasury Stock & Other [1281] is a summary line item in the Standard template with the following components:
Treasury Stock [1248]
Comprehensive Income and Other [1028]
TreasuryStockGrowth
TreasuryStockPerShare
ValueScore
Rankable -
Proprietary scoring model that ranks companies based on their relative valuation. Scores range from 0 to 100, with 100 being the most undervalued.
Volatility
Rankable -
This is the volatility of the security.
VolatilityScore
Rankable -
This is simply the percentile rank of the security's volatility, relative to the rest of the market. Higher numbers indicate a more volatile security, and lower numbers indicate a less volatile (more stable) security.
Volume
VolumeAvg1Month
VolumeAvg1MonthPrior
VolumeAvg1Week
Average trading volume for the prior week.
VolumeMomentum1Month
Rankable -
VolumeMomentum1Week
Rankable -
VolumeMomentumAustralia1Month
Rankable -
VolumeMomentumCanada1Month
Rankable -
VolumeMomentumHongKong1Month
Rankable -
VolumePercentChange1Month
Rankable -
WeightedAverageNumberOfSharesOutstandingBasic
WeightedAverageNumberOfSharesOutstandingBasicGrowth
WorkingCapital
WorkingCapitalGrowth
