Query Library
Search a comprehensive library of pre-built queries designed to help you quickly maximize the value of our data offerings. For each query, the library provides a brief description along with the data packages necessary to execute the query.
S&P Capital IQ Financials
Linking the ArFinInstance table to the S&P Capital IQ Premium core files to obtain important metadata
S&P Capital IQ Financials
Returns Income Statement Items For Nestle
Compustat® Financials
Returns ROA For An Index
Compustat® Financials
Returns Primary And Secondary SIC Codes For A Company
Base Data
Returns Data Item ID From CIQ Plugin Formula
Compustat® Financials
Total Debt To EBIT Percentage For Companies Incorporated In The USA
Compustat® Financials
Returns Quarterly Book Value Per Share
Compustat® Financials
Returns Debt-To-Equity-Ratio Annual And Quarterly
Global Instruments Cross Reference Service (GICRS)
Returns CIQ Primary Identifiers By Ticker
Base Data
Returns CIQ Equities Trading On U.S Exchanges
Base Data
Returns 365 Days Average Fxrate Historical Data
Company Relationships
Returns All Company Relationships Recursively
SNL Insurance Regulatory Data
Returns Loss Triangle For Number Of Claims Closed With Loss Payment Direct Assumed At Year End
S&P Capital IQ Estimates
Returns Current EPS Performance Adjusted For Stock Splits
S&P Capital IQ Estimates
Returns Point-In-Time Current Year Revenue Estimates For A Company
Ownership
Return Latest Company Ownership Holdings With Owner Type And Investment Orientation
Credit Analytics
To Retrieve Portfolio Adjusted MaxLimit And Company IDs For Watchlist ID 1198095291
Credit Analytics
Retrieves Full Workflow - Portfolio And Adjusted Portfolio MaxLimit
S&P Capital IQ Estimates
Returns Adjusted FFO Guidance By Company And Period
Credit Analytics
Retrieve All Watchlists - Watchlistname And WatchlistIDs To Allow The User To Select A Watchlist ID For Retrieving Portfolio And Portfolio Adjusted MaxLimit
Credit Analytics
Retrieve A Specific Watchlist ID Or Watchlist Name To Fetch The Portfolio Maxlimit
S&P Capital IQ Estimates
Returns Annual Capital Expenditure Guidance Estimates
S&P Capital IQ Estimates
Returns Effective Adjusted FFO Guidance Estimates By Company
Credit Analytics
Retrieve Company Standalone MaxLimit In Multiple Currencies
S&P Capital IQ Estimates
Returns Capital Expenditure Guidance By Company And Period
Credit Analytics
Retrieve Portfolio MaxLimit For A Watchlist
Visible Alpha Estimates
Returns Peer Companies with Topic Tag Name of AI
Trucost Sovereign Carbon Exposure
Returns Top 10 Contributors To Sovereign Territorial GHG Emissions For Italy
Trucost Sovereign Carbon Exposure
Returns Sovereign GHG Emissions History For Italy
Trucost Sovereign Carbon Exposure
Returns Power Generation Data For Italy From 2021 To 2025
Trucost Sovereign Carbon Exposure
Returns Key Economic Data For Italy For 2024
Transactions
Returns Analysis Of Sector Level Buybacks Within The S&P 500
S&P Capital IQ Financials
Returns The Latest LTM Financials Based On Filing Date Relative To Observation Date
Transactions
Returns Peer Buybacks Relative To Market Capitalization
Transactions
Returns Event Study Using Price Close Around Buyback Announcements
Transactions
Returns Analysis Of Buyback Activity Based On Valuation Signals
Business Entity Cross Reference Service (BECRS)
Returns The SQL Equivalent For The API Mnemonic SP_ENTITY_NAME (Entity Name)
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic IQ_EST_REV_SURPRISE_PERCENT (Revenue Surprise Percentage)
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic SP_EST_ACT_EPS (EPS Normalized Actual)
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic SP_EPS_EST (EPS Normalized Consensus Mean)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_DEBT_EBITDA (Total Debt By EBITDA)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_NET_INC_MARGIN (Net Income Margin Percentage)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_REV (Total Revenues)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_GROSS_MARGIN (Gross Profit Margin)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_CASH_CONVERSION (Cash Conversion Cycle)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_REV_1YR_ANN_GROWTH (Total Revenues 1 Year Growth Percentage)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_NET_INTEREST_INC (Net Interest Income)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_RD_EXP_FN (Research And Development Expense)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_CAPEX (Capital Expenditure)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_RETURN_EQUITY (Return On Equity Percentage)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_AUM_NET_CLIENT_FLOWS (AUM Net Client Flows)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_ROE (Return On Average Shareholders Equity)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_TIER_1_COMMON_RATIO (Tier 1 Common Capital Ratio)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_NET_INVEST_INC (Net Investment Income)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_TOTAL_REV_TO_AVG_EMPLOYEES (Total Revenue By Avg Employees)
Transactions
Returns Capital Allocation Strategy Buyback Versus Dividends
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic IQ_EST_ACT_NI (Net Income Normalized Actual)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_PBV (Last Close Price By Book Value)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_EBIT_INT (EBIT By Interest Expense)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_LFCF_MARGIN (Levered Free Cash Flow Margin)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_EBIT_MARGIN (EBIT Margin Percentage)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_DEBT_EQUITY (Total Debt By Equity)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_DAYS_PAYABLE_OUT (Average Days Payable Outstanding)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_UFCF_MARGIN (Unlevered Free Cash Flow Margin)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_AUM (Assets Under Management)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_EFFECT_TAX_RATE (Effective Tax Rate Ratio)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_SGA_MARGIN (SGA Margin)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_DAYS_SALES_OUT (Days Sales Outstanding Average Receivables)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_RETURN_ASSETS (Return on Assets)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_NET_DEBT_EBITDA (Net Debt By EBITDA)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_AUM_NET_ACQUISITIONS_TRANSFERS_OTHER (AUM Net Acquisitions Transfers And Other)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_OPER_INC_GROWTH (Operating Income Growth)