• C#
  • Java
  • VB
  • C++
  • Python
Contact us
Fundamental Ratios

The Fundamental Ratios tick type is delivered as is from external sources. IB does not reformat/re-parse XML Data, and provides a maximum of 105 tags.

  • For older data, it is feasible you may receive less tags (refer to LATESTADATE tag).
  • A tag with the value of -99999.99 is an indicator that data is not available for that security.

Also see Fundamental Data for requesting other fundamental data type using IBApi.EClient.reqFundamentalData.

See below for all available tag values:

TagDescription
AATCATotal current assets - MRY
This value is the sum of all current assets reported for the most recent fiscal year.
NOTE:
Insurance companies, Banks, and Industrial companies with captive finance subsidiaries do not distinguish between current and long term assets. They report only Total Assets. For these companies this value will be Not Meaningful.
ACFSHRCash Flow per share - MRY
This is Cash Flow for the most recent fiscal year divided by the Average Shares Outstanding for the same period. Cash Flow is defined as the sum of Income After Taxes minus Preferred Dividends and General Partner Distributions plus Depreciation, Depletion and Amortization.
ADIV5YAVGDividend per share - 5 Yr. Avg.
This is the average of the Annual Dividends Per Share for the last 5 years.
AEBITEBIT - MRY
Earnings before Interest and Tax (EBIT) is computed as Total Revenues for the most recent fiscal year minus Total Operating Expenses plus Operating Interest Expense for the same period. This definition excludes non-operating income and expenses.
NOTE:
This item is only available for Industrial and Utility companies.
AEBTNORMEarnings before taxes Normalized
This is the Income Before Tax number excluding the impact of all unusual/one-time/special charges items for the most recent annual period.
AEPSNORMEPS Normalized
This is the Normalized Income Available to Common Stockholders for the most recent annual period divided by the same period's Diluted Weighted Average Shares Outstanding.
AEPSXCLXOREPS excluding extraordinary items - MRY
This is the Adjusted Income Available to Common Stockholders for the most recent fiscal year divided by the most recent fiscal year's Diluted Weighted Average Shares Outstanding.
AFEEPSNTMAnalyst Forecast of EPS - N12
Analyst Forecast Estimate of EPS for the next twelve months
AFPRDNet issuance of debt - MRY
Net issuance of debt for the most recent fiscal year
AFPSSNet issuance of stock - MRY
Net issuance of stock for the most recent fiscal year
ALSTDNotes payable/short term debt - MRY
Notes payable/short term debt for the most recent fiscal year
ALTCLTotal current liabilities - MRY
This is the sum of all current and long term liabilities reported for the most recent fiscal year.
ANIACNORMNet Income Available to Common, Normalized
This is the annual dollar amount accruing to common shareholders for dividends and retained earnings excluding the impact of all unusual/one-time/special charges items.
AOTLOCash from operating activities - MRY
Total Cash From Operating Activities represents the sum of Net Income, Depreciation and Amortization, Non-Cash Items, Cash Receipts and Payments, Cash Taxes and Interest Paid, Changes in Working Capital for the most recent fiscal year.
APENORMP/E Normalized
This is the Current Price divided by the latest annual Normalized Earnings Per Share value.
APTMGNPCTPretax margin %
This value represents Income Before Taxes for the most recent fiscal year expressed as a percent of Total Revenue for the most recent fiscal year.
AREVPSRevenue/share - MRY
This value is the Total Revenue for the most recent fiscal year divided by the Average Diluted Shares Outstanding for the same period.
AROAPCTReturn on average assets - MRY %
This value is calculated as the Income After Taxes for the most recent fiscal year divided by the Average Total Assets, expressed as a percentage. Average Total Assets is the average of the Total Assets at the beginning and the end of the year.
AROIPCTReturn on investment - MRY %
This value is the annual Income After Taxes divided by the average Total Long Term Debt, Other Long Term Liabilities, and Shareholders Equity, expressed as a percentage.
ASCEXCapital expenditures - MRY
Capital expenditures for the most recent fiscal year
ASFCFFinancing cash flow items - MRY
Financing cash flow items for the most recent fiscal year
ASICFInvesting cash flow items - MRY
Investing cash flow items for the most recent fiscal year
ASINNInterest exp.(inc.), net-operating - MRY
This is the Total Operating and Non-Operating Interest Expense for the most recent fiscal year.
NOTE:
This item is Not Meaningful for Banks and Insurance companies.
ASOPIOperating income - MRY
This is the amount of profit realized from a business's operations after taking out operating expenses for the most recent fiscal year.
BETABeta
Beta is a measure of a company's common stock price volatility relative to the market. Beta is the slope of the 60 month regression line of the percentage price change of the stock relative to the percentage price change of the local index. Beta values are not calculated if less than 40 months of pricing is available
CURRENCYCurrency
The currency in which ratios are denominated.
DIVGRPCTGrowth rate % - dividend
The Dividend Growth Rate is the compound annual growth rate in dividends per share. DIVGR% is calculated for 3 years whenever 4 years of dividends are available.
EPSCHNGYREPS Change Y/Y %
This value is calculated as the most recent interim period EPS minus the EPS for the same interim period 1 year ago divided by the EPS for the same interim period one year ago, multiplied by 100.
NOTE:
EPS must be positive for both periods. If either EPS value is negative, the result in Not Meaningful (NM).
EPSTRENDGREPS growth rate %
This growth rate is the compound annual growth rate of Earnings Per Share Excluding Extraordinary Items and Discontinued Operations over the last 5 years.
NOTE:
If the value for either the most recent year or the oldest year is zero or negative, the growth rate cannot be calculated and a 'NA' (Not Available) code will be used.
EV_CurCurrent Enterprise Value
This is the sum of Market Capitalization and Net Debt for the most recent fiscal period.
NOTE:
This item is reported only for Industrial, Utility & Banking companies.
EV2EBITDA_CurEnterprise Value to EBITDA - TTM
This is the current enterprise value divided by the EBITDA for the most recent trailing twelve months period.
NOTE:
This item is reported only for Industrial and Utility companies.
Frac52Wk52 Week Fraction
This is calculated as (Last - 52 week low) / (52 week high - 52 week low).
LATESTADATELast available date
This value is the date when the ratio data was last updated.
MKTCAPMarket capitalization
This value is calculated by multiplying the current Price by the current number of Shares Outstanding.
NetDebt_INet Debt, LFI
This value is the sum of all short term debt, and notes payables, Long Term debt, minority interest, and preferred equity minus the total cash and equivalents and short term investments for the most recent interim period.
NOTE:
This item is reported only for Industrial, Utility companies Utility & Banking companies.
NHIGHigh Price
This price is the highest Price the stock traded at in the last 12 months. This could be an intra-day high.
NLOWLow Price
This price is the lowest Price the stock traded at in the last 12 months. This could be an intra-day low.
NPRICEClosing Price
This is the close price for the issue from the day it last traded. It is also referred to as the Current Price. Note that some issues may not trade every day, and therefore it is possible for this price to come from a date prior to the last business day.
PEEXCLXORP/E excluding extraordinary items
This ratio is calculated by dividing the current Price by the sum of the Diluted Earnings Per Share from continuing operations BEFORE Extraordinary Items and Accounting Changes over the last four interim periods.
PR13WKPCTPrice - 13 week price percent change
This is the percentage change in the company's stock price over the last thirteen weeks.
PR1WKPCTPrice - 1 week price percent change
This is the percentage change in the company's stock price over the last week.
PR2TANBKPrice/Tang.Book Ratio
This is the Current Price divided by the latest interim period Tangible Book Value Per Share. Tangible Book Value Per Share is defined as Book Value minus Goodwill and Intangible Assets divided by the Shares Outstanding at the end of the interim period.
PR4WKPCTPrice - 4 week price percent change
This is the percentage change in the company's stock price over the last four weeks.
PR52WKPCTPrice - 52 week price percent change
This is the percentage change in the company's stock price over the last fifty two weeks.
PRICE2BKPrice to Book
This is the Current Price divided by the latest interim period Book Value Per Share.
PRYTDPCTRRelative (S&P500) price percent change - YTD
This is the percentage change in price since the close of the last trading day of the previous year as compared to the change in price of the S&P 500 during that same period.
QATCATotal current assets - MRQ
This value is the sum of all current assets reported for the most recent interim period.
NOTE:
Insurance companies, Banks, and Industrial companies with captive finance subsidiaries do not distinguish between current and long term assets. They report only Total Assets. For these companies this value will be Not Meaningful.
QBVPSBook Value (Common Equity) per share
This is defined as the Common Shareholder's Equity divided by the Shares Outstanding at the end of the most recent interim period. Book Value is the Total Shareholder's Equity minus Preferred Stock and Redeemable Preferred Stock.
QCASHCash and short term investments - MRQ
This is the Total Cash plus Short Term Investments for the most recent interim period.
NOTE:
This does NOT include cash equivalents that may be reported under long term assets.
QCSHPSCash per share
This is the Total Cash plus Short Term Investments divided by the Shares Outstanding at the end of the most recent interim period.
NOTE:
This does NOT include cash equivalents that may be reported under long term assets.
QCURRATIOCurrent ratio
This is the ratio of Total Current Assets for the most recent interim period divided by Total Current Liabilities for the same period.
NOTE:
This item is Not Available (NA) for Banks, Insurance companies and other companies that do not distinguish between current and long term assets and liabilities.
QEBITEBIT - MRQ
Earnings before Interest and Tax (EBIT) is computed as Total Revenues for the most recent interim period minus Total Operating Expenses plus Operating Interest Expense for the same period. This definition excludes non-operating income and expenses.
NOTE:
This item is only available for Industrial and Utility companies.
QEBITDAEBITD - MRQ
Earnings Before Interest, Taxes, Depreciation and Amortization (EBITDA) is EBIT for the most recent interim period plus the same period's Depreciation and Amortization expenses (from the Statement of Cash Flows).
NOTE:
This item is only available for Industrial and Utility companies.
QFPRDNet issuance of debt - MRQ
Net issuance of debt for the most recent interim period
QFPSSNet issuance of stock - MRQ
Net issuance of stock for the most recent interim period
QLSTDNotes payable/short term debt - MRQ
Notes payable/short term debt for the most recent interim period
QLTCLTotal current liabilities - MRQ
This is the sum of all current and long term liabilities reported for the most recent interim period.
QLTD2EQLT debt/equity
This ratio is the Total Long Term Debt for the most recent interim period divided by Total Shareholder Equity for the same period.
QOTLOCash from operating activities - MRQ
Total Cash From Operating Activities represents the sum of Net Income, Depreciation and Amortization, Non-Cash Items, Cash Receipts and Payments, Cash Taxes and Interest Paid, Changes in Working Capital for the most recent interim period.
QPR2REVPrice to revenues - MRQ
This is the current Price divided by the Sales Per Share for the most recent interim period. If there is a preliminary earnings announcement for an interim period that has recently ended, the revenue (sales) values from this announcement will be used in calculating the interim Revenues Per Share.
NOTE:
This value has been annualized to make it more readily comparable to the annual and TTM values. Additionally, most Banks and Insurance companies do not report revenues when they announce their preliminary interim financial results in the press. When this happens, the interim value will not be available until the complete interim period filing is released.
QPRCFPSPrice to Cash Flow per share - MRQ
This is the current Price divided by Cash Flow Per Share for the most recent interim period. Cash Flow is defined as Income After Taxes minus Preferred Dividends and General Partner Distributions plus Depreciation, Depletion and Amortization.
QQUICKRATIQuick ratio
Also known as the Acid Test Ratio, this ratio is defined as Cash plus Short Term Investments plus Accounts Receivable for the most recent interim period divided by the Total Current Liabilities for the same period.
NOTE:
This item is Not Available (NA) for Banks, Insurance companies and other companies that do not distinguish between current and long term assets and liabilities.
QSCEXCapital expenditures - MRQ
Capital expenditures for the most recent interim period
QSFCFFinancing cash flow items - MRQ
Financing cash flow items for the most recent interim period
QSICFInvesting cash flow items - MRQ
Investing cash flow items for the most recent interim period
QSINNInterest exp.(inc.), net-operating - MRQ
This is the Total Operating and Non-Operating Interest Expense for the most recent interim period.
NOTE:
This item is Not Meaningful for Banks and Insurance companies.
QSOPIOperating income - MRQ
This is the amount of profit realized from a business's operations after taking out operating expenses for the most recent interim period.
QTATotal assets - MRQ
This is the sum of all short and long term asset categories reported for the most recent interim period.
QTANBVPSBook Value (tangible) per share
This is the interim Tangible Book Value divided by the Shares Outstanding at the end of the most recent interim period. Tangible Book Value is the Book Value minus Goodwill and Intangible Assets for the same period.
QTLTotal liabilities - MRQ
This is the sum of all current and long term liabilities reported for the most recent interim period.
QTOTCETotal common equity - MRQ
Also referred to as Common Shareholder's Equity, this is the Total Shareholder's Equity as of the most recent interim period Balance Sheet minus Preferred Stock and Redeemable Preferred Stock.
QTOTD2EQTotal debt/total equity
This ratio is Total Debt for the most recent interim period divided by Total Shareholder Equity for the same period.
NOTE:
This is Not Meaningful (NM) for banks.
QTOTLTDTotal long-term debt - MRQ
This is the sum of all Long Term Debt and Capitalized Lease Obligations for the most recent interim period.
REVCHNGYRRevenue Change Y/Y %
This value is calculated as the most recent interim period Sales minus the Sales for the same interim period 1 year ago divided by the Sales for the same interim period one year ago, multiplied by 100.
REVTRENDGRRevenue growth rate %
The Five Year Revenue Growth Rate is the annual compounded growth rate of Revenues over the last 5 years.
TTMCFSHRCash Flow per share
This value is the trailing twelve month Cash Flow divided by the trailing twelve month Average Shares Outstanding. Cash Flow is defined as the sum of Income After Taxes minus Preferred Dividends and General Partner Distributions plus Depreciation, Depletion and Amortization.
TTMDIVSHRDividends per share
This is the sum of the Cash Dividends per share paid to common stockholders during the last trailing twelve month period.
TTMEBITDEBITD
Earnings Before Interest, Taxes, Depreciation and Amortization (EBITDA) is EBIT for the trailing twelve months plus the same period's Depreciation and Amortization expenses (from the Statement of Cash Flows).
NOTE:
This item is only available for Industrial and Utility companies.
TTMEBTEarnings before taxes
Also known as Pretax Income and Earnings Before Taxes, this is Total Revenue for the most recent TTM period minus Total Expenses plus Non-operating Income (Expenses) for the same period.
TTMEPSCHGEPS Change TTM %
This is the percent change in the trailing twelve month EPS as compared to the same trailing twelve month period one year ago. It is calculated as the trailing twelve month EPS minus the trailing twelve month EPS one year ago divided by the trailing twelve month EPS one year ago, multiplied by 100.
NOTE:
If either value has a negative value, the resulting value will be Not Meaningful (NM).
TTMEPSXCLXEPS exc. extr. items
This is the Adjusted Income Available to Common Stockholders for the trailing twelve months divided by the trailing twelve month Diluted Weighted Average Shares Outstanding.
TTMFCFFree Cash Flow - TTM
This value is calculated from the Quarterly Statement of Cash Flows. It is calculated as the TTM Cash From Operations minus Capital Expenditures and Dividends Paid for the same period.
TTMFCFSHRFree Cash Flow per share - TTM
This is the trailing twelve month Free Cash Flow divided by the trailing twelve month Average Shares Outstanding found on the Income Statement.
TTMGROSMGNGross Margin %
This value measures the percent of revenue left after paying all direct production expenses. It is calculated as the trailing 12 months Total Revenue minus the trailing 12 months Cost of Goods Sold divided by the trailing 12 months Total Revenue and multiplied by 100.
NOTE:
This item is only available for Industrial and Utility companies.
TTMINTCOVNet Interest coverage - TTM
Also known as Times Interest Earned, this is the ratio of Earnings Before Interest and Taxes for the trailing twelve months divided by the trailing twelve month Interest Expense, Net.
NOTE:
If TTM Total Interest Expense, Net is less or equal 0 (equivalent of Interest Income), then Interest Coverage is Not Meaningful (NM). This item is NM for Banks and Insurance companies.
TTMINVTURNInventory turnover - TTM
This value measures how quickly the Inventory is sold. It is defined as Cost of Goods Sold for the trailing twelve months divided by Average Inventory. Average Inventory is calculated by adding the Inventory for the 5 most recent quarters and dividing by 5.
NOTE:
This value is Not Meaningful (NM) for Banks and Insurance companies.
TTMNIACNet Income available to common
This is the trailing twelve month dollar amount accruing to common shareholders for dividends and retained earnings. Income Available to Common Shareholders is calculated as trailing twelve month Income After Taxes plus Minority Interest and Equity in Affiliates plus Preferred Dividends, General Partner Distributions and US GAAP Adjustments.
NOTE:
Any adjustment that is negative (ie. Preferred Stock Dividends) would be subtracted from Income After Taxes.
TTMNIPEREMNet Income/Employee - TTM
This value is the Income After Taxes for the trailing twelve months divided by the number of employees at the end of the last reported fiscal year.
TTMNPMGNNet Profit Margin %
Also known as Return on Sales, this value is the Income After Taxes for the trailing twelve months divided by Total Revenue for the same period and is expressed as a percentage.
NOTE:
Most Banks and Finance companies do not report revenues when they announce their preliminary quarterly financial results in the press. When this happens, the trailing twelve month value will not be available (NA).
TTMOPMGNOperating margin %
This value measures the percent of revenues remaining after paying all operating expenses. It is calculated as the trailing 12 months Operating Income divided by the trailing 12 months Total Revenue, multiplied by 100. Operating Income is defined as Total Revenue minus Total Operating Expenses.
TTMPAYRATPayout ratio %
This ratio is the percentage of the Primary/Basic Earnings Per Share Excluding Extraordinary Items paid to common stockholders in the form of cash dividends during the trailing twelve months.
TTMPR2REVPrice to sales
This is the current Price divided by the Sales Per Share for the trailing twelve months. If there is a preliminary earnings announcement for an interim period that has recently ended, the revenue (sales) values from this announcement will be used in calculating the trailing twelve month revenue per share.
NOTE:
Most Banks and Finance companies do not report revenues when they announce their preliminary interim financial results in the press. When this happens, the trailing twelve month values will not be available (NA) until the complete interim filing is released.
TTMPRCFPSPrice to Cash Flow per share
This is the current Price divided by Cash Flow Per Share for the trailing twelve months. Cash Flow is defined as Income After Taxes minus Preferred Dividends and General Partner Distributions plus Depreciation, Depletion and Amortization.
TTMPRFCFPSPrice to Free Cash Flow per share - TTM
This is the current Price divided by the trailing twelve month Free Cash Flow Per Share. Free Cash Flow is calculated from the Statement of Cash Flows as Cash From Operations minus Capital Expenditures and Dividends Paid.
TTMPTMGNPretax margin - TTM
This value represents the trailing twelve month Income Before Taxes expressed as a percent of Total Revenue for the same period.
TTMRECTURNReceivables turnover - TTM
This is the ratio of Total Revenue for the trailing twelve months divided by Average Accounts Receivables. Average Receivables is calculated by adding the Accounts Receivables for the 5 most recent quarters and dividing by 5.
NOTE:
This item is Not Meaningful (NM) for Banks.
TTMREVRevenue
This is the sum of all revenue (sales) reported for all operating divisions for the most recent TTM period.
NOTE:
Most banks and Insurance companies do not report revenues when they announce their preliminary quarterly financial results in the press. When this happens, the quarterly value will not be available (NA).
TTMREVCHGRevenue Change TTM %
This is the percent change in the trailing twelve month Sales as compared to the same trailing twelve month period one year ago. It is calculated as the trailing twelve month Sales minus the trailing twelve month Sales one year ago divided by the trailing twelve month Sales one year ago, multiplied by 100.
TTMREVPERERevenue/Employee - TTM
This value is the trailing twelve month Total Sales divided by the number of Employees at the end of the last reported fiscal year.
TTMREVPSRevenue/share
This value is the trailing twelve month Total Revenue divided by the Average Diluted Shares Outstanding for the trailing twelve months.
NOTE:
Most Banks and Insurance companies do not report revenues when they announce their preliminary quarterly financial results in the press. When this happens, the trailing twelve month values will not be available (NA).
TTMROAPCTReturn on average assets %
This value is the Income After Taxes for the trailing twelve months divided by the Average Total Assets, expressed as a percentage. Average Total Assets is calculated by adding the Total Assets for the 5 most recent quarters and dividing by 5.
TTMROEPCTReturn on average equity %
This value is the Income Available to Common Stockholders for the trailing twelve months divided by the Average Common Equity and is expressed as a percentage. Average Common Equity is calculated by adding the Common Equity for the 5 most recent quarters and dividing by 5.
TTMROIPCTReturn on investment %
This value is the trailing twelve month Income After Taxes divided by the average Total Long Term Debt, Other Long Term Liabilities and Shareholders Equity, expressed as a percentage.
YIELDDividend Yield
This value is the current percentage dividend yield based on the present cash dividend rate. It is calculated as the Indicated Annual Dividend divided by the Current Price, multiplied by 100.
YLD5YAVGDividend Yield - 5 Yr. Avg.
This value is the average of the dividend yield over the last 60 months.