Class: Financials

API Request Format

Financials datasets store fundamental financial metrics at multiple frequencies (Yearly, Quarterly). Each dataset type is identified by a unique filter and can be queried at different frequencies.

{
  "identifier": "SPGI",
  "type": "FUNDAMENTALS_INCOMESTMT",
  "properties": {
    "filters": "IQ_TOTAL_REV",
    "frequency": "Yearly",
	   "startDate": "MM/DD/YYYY",
	   "endDate": "MM/DD/YYYY"
  }
}

API Request Types

Each financials dataset category has a unique type constant:

• FUNDAMENTALS_INCOMESTMT - Income Statement datasets (EBIT, EBITDA, EPS, Gross Profit, Net Income, Total Revenue)
• FUNDAMENTALS_BALANCESHEET - Balance Sheet datasets (Total Assets, Total Debt, Total Equity, Total Liabilities)
• FUNDAMENTALS_MARKETDATA - Market Data datasets (Close Price, Dividend Yield, Market Cap, TEV, Volume)
• FUNDAMENTALS_MULTIPLES - Multiples datasets (P/BV, P/Normalized EPS, P/TangBV, Price/LTM EPS, TEV/EBIT, TEV/EBITDA, TEV/Total Revenues)
• FUNDAMENTALS_CAPSTRUCTURE - Capital Structure datasets (Net Debt/EBITDA, Total Debt/EBITDA and CAPEX-adjusted variants)
• FUNDAMENTALS_CASHFLOW - Cashflow datasets (CapEx, Cash From Operations)
• FUNDAMENTALS_RATIOS - Financial ratio datasets (Margins, Turnover, Days, Debt, Return, Coverage)

API Request Filters

Income Statement (FUNDAMENTALS_INCOMESTMT):

• IQ_EBIT - Earnings Before Interest and Taxes
• IQ_EBITDA - Earnings Before Interest, Taxes, Depreciation, Amortization
• IQ_DILUT_EPS_EXCL - Diluted Earnings Per Share (excluding extraordinary items)
• IQ_GP - Gross Profit
• IQ_NI - Net Income
• IQ_TOTAL_REV - Total Revenue

Balance Sheet (FUNDAMENTALS_BALANCESHEET):

• IQ_TOTAL_ASSETS - Total Assets
• IQ_TOTAL_DEBT - Total Debt
• IQ_TOTAL_EQUITY - Total Equity (Shareholders' Equity)
• IQ_TOTAL_LIAB - Total Liabilities

Market Data (FUNDAMENTALS_MARKETDATA):

• IQ_CLOSEPRICE - Close Price (unadjusted)
• IQ_CLOSEPRICE_ADJ - Close Price (adjusted for splits and dividends)
• IQ_DIVIDEND_YIELD - Dividend Yield
• IQ_MARKETCAP - Market Capitalization
• IQ_TEV - Total Enterprise Value
• IQ_VOLUME - Trading Volume

Multiples (FUNDAMENTALS_MULTIPLES):

• IQ_PBV - Price-to-Book Value ratio
• IQ_PE_NORMALIZED - Price-to-Normalized EPS ratio
• IQ_PTBV - Price-to-Tangible Book Value ratio
• IQ_PE_EXCL - Price-to-LTM EPS ratio
• IQ_TEV_EBIT - TEV-to-EBIT ratio
• IQ_TEV_EBITDA - TEV-to-EBITDA ratio
• IQ_TEV_TOTAL_REV - TEV-to-Total Revenues ratio

Cap Structure (FUNDAMENTALS_CAPSTRUCTURE):

• IQ_NET_DEBT_EBITDA - Net Debt / EBITDA
• IQ_NET_DEBT_EBITDA_CAPEX - Net Debt / (EBITDA - CAPEX)
• IQ_TOTAL_DEBT_EBITDA - Total Debt / EBITDA
• IQ_TOTAL_DEBT_EBITDA_CAPEX - Total Debt / (EBITDA - CAPEX)

Cashflow (FUNDAMENTALS_CASHFLOW):

• IQ_CAPEX - Capital Expenditure
• IQ_CASH_OPER - Cash From Operations

Ratios (FUNDAMENTALS_RATIOS):

Margin Ratios:

• IQ_SGA_MARGIN - SG&A Margin %
• IQ_EBIT_MARGIN - EBIT Margin %
• IQ_EBITA_MARGIN - EBITA Margin %
• IQ_EBITDA_MARGIN - EBITDA Margin %
• IQ_GROSS_MARGIN - Gross Margin %
• IQ_NI_MARGIN - Net Income Margin %
• IQ_NI_AVAIL_EXCL_MARGIN - Net Income Available for Common Margin %
• IQ_NI_NORM_MARGIN - Normalized Net Income Margin %
• IQ_LFCF_MARGIN - Levered Free Cash Flow Margin %
• IQ_UFCF_MARGIN - Unlevered Free Cash Flow Margin %

Turnover Ratios:

• IQ_AR_TURNS - Accounts Receivable Turnover
• IQ_ASSET_TURNS - Asset Turnover
• IQ_FIXED_ASSET_TURNS - Fixed Asset Turnover
• IQ_INVENTORY_TURNS - Inventory Turnover

Days Ratios:

• IQ_DAYS_INVENTORY_OUT - Average Days Inventory Outstanding
• IQ_DAYS_SALES_OUT - Average Days Sales Outstanding
• IQ_DAYS_PAYABLE_OUT - Average Days Payable Outstanding
• IQ_CASH_CONVERSION - Average Cash Conversion Cycle

Debt Ratios:

• IQ_CURRENT_RATIO - Current Ratio
• IQ_QUICK_RATIO - Quick Ratio
• IQ_TOTAL_DEBT_EQUITY - Total Debt / Equity
• IQ_TOTAL_DEBT_CAPITAL - Total Debt / Capital
• IQ_LT_DEBT_EQUITY - Long-Term Debt / Equity
• IQ_LT_DEBT_CAPITAL - Long-Term Debt / Capital
• IQ_TOTAL_LIAB_TOTAL_ASSETS - Total Liabilities / Total Assets

Return Ratios:

• IQ_RETURN_ASSETS - Return on Assets
• IQ_RETURN_EQUITY - Return on Equity
• IQ_RETURN_COMMON_EQUITY - Return on Common Equity
• IQ_RETURN_CAPITAL - Return on Capital

Coverage Ratios:

• IQ_EBIT_INT - EBIT / Interest Expense
• IQ_EBITDA_INT - EBITDA / Interest Expense
• IQ_CFO_CURRENT_LIAB - Cash From Operations / Current Liabilities

API Response Format

Response structure uses the query's filters value as the response key. The API returns an array with an object whose key matches the filter sent in the request.

Example: If query sends "filters": "IQ_TOTAL_REV", response key is also "IQ_TOTAL_REV":

[
  {
    "IQ_TOTAL_REV": {
      "data": [
        {
          "DT": "2023-12-31",
          "Total Revenue": 383285000000,
          "Operating Income": 128698000000,
          "Net Income": 96995000000,
          "...": "... more financial metrics ..."
        },
        {
          "DT": "2023-09-30",
          "Total Revenue": 81797000000,
          "Operating Income": 24318000000,
          "Net Income": 22861000000,
          "...": "... more financial metrics ..."
        }
      ]
    }
  }
]