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.
Credit Analytics
To Retrieve Portfolio Adjusted MaxLimit And Company IDs For Watchlist ID 1198095291
S&P Capital IQ Estimates
Returns Adjusted FFO Guidance By Company And Period
Credit Analytics
Retrieve Portfolio MaxLimit For A Watchlist
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 A Specific Watchlist ID Or Watchlist Name To Fetch The Portfolio Maxlimit
Credit Analytics
Retrieves Full Workflow - Portfolio And Adjusted Portfolio MaxLimit
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 Company Standalone MaxLimit In Multiple Currencies
S&P Capital IQ Estimates
Returns Capital Expenditure Guidance By Company And Period
Trucost Sovereign Carbon Exposure
Returns Key Economic Data For Italy For 2024
Trucost Sovereign Carbon Exposure
Returns Top 10 Contributors To Sovereign Territorial GHG Emissions For Italy
Trucost Sovereign Carbon Exposure
Returns Power Generation Data For Italy From 2021 To 2025
Trucost Sovereign Carbon Exposure
Returns Sovereign GHG Emissions History For Italy
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
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_LFCF_MARGIN (Levered Free Cash Flow Margin)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_WORKING_CAP (Working Capital)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_OPER_INC (Operating Income)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_PE_NORM (PE Normalized)
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_EQUITY (Return On Equity Percentage)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_OPER_EXP_GROWTH (Operating Expense Growth)
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 IQ_EST_ACT_REV (Revenue Actual)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_DAYS_INVENTORY_OUT (Days Outstanding Inventory)
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_TOTAL_REV (Total Revenues)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic SP_TOTAL_RETURN (Total Return)
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_SGA_MARGIN (SGA Margin)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_CL (Total Current Liabilities)
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_CORE_EPS_GROWTH (Core EPS Growth)
Transactions
Returns Buyback Execution Versus Authorization Analysis
Business Entity Cross Reference Service (BECRS)
Returns The SQL Equivalent For The API Mnemonic SP_ENTITY_ID (Entity ID)
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic SP_EST_ACT_EPS (EPS Normalized Actual)
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_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_EBITDA_MARGIN (EBITDA Margin 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_TOTAL_POLICY_INC (Total Policy 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 Share Buybacks And EPS Contribution Analysis
Transactions
Returns Capital Allocation Strategy Buyback Versus Dividends
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_ASSET_TURNS (Asset Turnover)
SNL Sector Financials
Returns The SQL Equivalent For The API Mnemonic SNL_AUM_NET_ACQUISITIONS_TRANSFERS_OTHER (AUM Net Acquisitions Transfers And Other)
S&P Capital IQ Estimates
Returns The SQL Equivalent For The API Mnemonic SP_EST_EPS_SURPRISE_PERCENT (EPS Surprise Percentage)
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_MARGIN (EBIT Margin Percentage)
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_UFCF_MARGIN (Unlevered Free Cash Flow Margin)
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_ASSETS_UNDER_ADMINISTRATION (Assets Under Administration)
Key Developments
Returns The SQL Equivalent For The API Mnemonic SP_EARNINGS_ANNOUNCE_DATE (Earnings Date)
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_OPER_INC_GROWTH (Operating Income Growth)
Transactions
Returns The Buyback Announcements For S&P 500 Constituents
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_REVENUE_EST (Revenue Consensus Mean)
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_EBIT_INT (EBIT By Interest Expense)
S&P Capital IQ Financials
Returns the SQL Equivalent For The API Mnemonic IQ_DA_SUPPL_CF (Depreciation And Amortization)
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_ROCE (Return On Capital Employed)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_OPER_EXPEN (Total Operating Expenses)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_TOTAL_ASSETS (Total Assets)
S&P Capital IQ Financials
Returns The SQL Equivalent For The API Mnemonic IQ_AUM (Assets Under Management)
Credit Analytics
Retrieves time-series EWS 1.0 metrics at daily frequency using GDST
Credit Analytics
Retrieves EWS 1.0 Risk Metrics For Proactive Credit Monitoring
Credit Analytics
Retrieves Historical EWS 1.0 Metrics For A Specified Period Using GDSHE
Business Relationships Analytics
Returns Multi Level Subsidiary Hierarchy with Supplier and Customer Relationships
Institutional Ownership Factors
Returns Institutional Ownership Activity Net Flow and Trading Behavior over the Past Year
Cybersecurity Factors
Returns Top Percentile by Average Application Security Rank
Cybersecurity Factors
Returns Diligence Score Response of 5 Worst US Performers
Cybersecurity Factors
Returns Cybersecurity Performance by Region
Institutional Ownership Factors
Returns Top Institutional Ownership Concentration
Institutional Ownership Factors
Returns Hedge Fund Ownership Trend For Selected Company
Cybersecurity Factors
Returns Application Patching Cadence and BitSight Rating Compared to Distance from Industry Median BitSight Rating