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.
OTC Derivatives Data
Returns Discount Curve Data
OTC Derivatives Data
Returns XCCY Basis Swap Curve data
OTC Derivatives Data
Returns CapletFloorlet Absolute Strike
OTC Derivatives Data
Returns Yield Curve MKT data
OTC Derivatives Data
Returns CapFloor Absolute Strike
OTC Derivatives Data
Returns Inflation LPI Swap Data
OTC Derivatives Data
Returns Inflation Forward Curve Data
OTC Derivatives Data
Returns CapletFloorlet Absolute Strike with SABR parameters
OTC Derivatives Data
Returns Inflation Seasonality Data
OTC Derivatives Data
Returns Swaption Relative Strike with SABR parameters
OTC Derivatives Data
Returns Basis Swap Curve data
OTC Derivatives Data
Returns XCCY Swap Curve data
OTC Derivatives Data
Returns Swaption Absolute Strike
OTC Derivatives Data
Returns Swaption Absolute Strike with SABR parameters
OTC Derivatives Data
Returns CapletFloorlet Relative Strike with SABR parameters
OTC Derivatives Data
Returns CapletFloorlet Relative Strike
OTC Derivatives Data
Returns Yield Curve data
OTC Derivatives Data
Returns Inflation LPI Data
OTC Derivatives Data
Returns Inflation Swap Curve Data
OTC Derivatives Data
Returns Swaption Relative Strike
Visible Alpha Estimates
Link Security Identifiers To Visible Alpha Estimates
Panjiva Supply Chain Intelligence
Returns New Customers And HSCodes Imported By A Company
Business Relationships Analytics
Returns Revenue And Cost Segmentation By Industry
Business Relationships Analytics
Returns The Supplier Concentration Risk
Business Relationships Analytics
Returns The Most Valuable Customer Supplier Relationships
Business Relationships Analytics
Returns Sector And Industry Trends
Business Relationships Analytics
Returns Geographical Distribution Of S&P500 Companies Sorted By Value
Business Relationships Analytics
Returns High MarketCap Companies With Very Less Suppliers With High Relationships Value
Trucost Paris Alignment
Returns Emissions Data for BYD Company Limited
Trucost Paris Alignment
Returns Carbon Budget Summary for BYD Company Limited
CDS Pricing
Returns Credit Index Options Pricing Data
Global Events
Returns Past And Future Earnings Events For Companies
Company Connections: Detailed Estimates
Returns All Records From Factors Connections
Company Connections: Detailed Estimates
Returns TradingItem Data For Specific Factors Of Factors Connections
Municipal Bond Pricing
Returns Latest Instrument Details And Market Liquidity Scores
Municipal Bond Pricing
Returns All Bonds With Issuer Information And Count
Municipal Bond Pricing
Returns Time-Series Analysis Of Instrument Liquidity Scores
Municipal Bond Pricing
Returns Comprehensive Price Data For ISINs
Municipal Bond Pricing
Returns Latest Market Metrics And Instrument Analysis For ISINs
S&P Capital IQ Estimates, Visible Alpha Estimates
Blending Visible Alpha Estimates With CIQ Estimates For Industry Leaders In Pharmaceuticals
Visible Alpha Estimates
Returns SD Balance Sheet Template
Visible Alpha Estimates
Analyze Consensus Time Series
Base Data
Returns ISIN, CUSIP, BRD and Markit Ticker History For Input List Of Companies
Visible Alpha Estimates
Earnings Surprise For Every KPI For Every Company Within A Business Group
Market Data, Visible Alpha Estimates
Connecting Visible Alpha Estimates To CIQ Market Data To Get Daily Pricing And Market Capitalization
Base Data, Visible Alpha Estimates
Converting Visible Alpha Estimates Using SP Foreign Exchange Rates On A Specific Date
Visible Alpha Estimates
Measuring Financial Health Via Debt To Equity Ratio
Visible Alpha Estimates
Quarterly Earnings Trend For A Specific Company
Visible Alpha Estimates
Use VaCompanyId To Find Company Specific Line Items
Visible Alpha Estimates
Latest Revenue Growth Rate Calculation
Visible Alpha Estimates
Identify Companies With Financial Data
Visible Alpha Estimates
Recreate Insights Application Views
Base Data, Visible Alpha Estimates
Linking The Visible Alpha Esimates Vacompanyid To The SP Capital IQ CompanyID
Visible Alpha Estimates
Retrieve Latest Reported Revenue
Visible Alpha Estimates
Identify Business Groups For A Company
Visible Alpha Estimates
Identify Companies With Consensus Data
Visible Alpha Estimates
Discover KPIs For A Business Group
Visible Alpha Estimates
Revision History Of Estimates For A KPI
Visible Alpha Estimates
Discover Company Specific Parameters
Visible Alpha Estimates
Explore Industry And Business Groups For Companies
Visible Alpha Estimates
Access Latest Ticker Data
Visible Alpha Estimates
Retrieve Quarterly Actuals For A Company
Visible Alpha Estimates
Access Core Financial Templates
Visible Alpha Estimates
Identify Business Group And Industry For Tickers
Visible Alpha Estimates
Access Latest Consensus For Various Periods
Visible Alpha Estimates
Find Latest Estimated Revenue
Visible Alpha Estimates
Rank Key Performance Indicators
Visible Alpha Estimates
Explore Standard Financial Templates
Visible Alpha Estimates
Calculate Revenue Weight By Segment
Visible Alpha Estimates
Identify All Companies In A Business Group
Credit Analytics
Retrieves Different Absolute Contribution Ratios Under RiskGauge 3.0 Model
RatingsXpress®: Structured Finance Performance
Returns Liabilities Summary And Credit Enhancement Data
RatingsXpress®: Structured Finance Performance
Returns CLO Profile And Deal/Collateral Performance Data
RatingsXpress®: Structured Finance Performance
Returns Trustee Reported Tests With Performance Data
Credit Analytics
Retrieves RiskGauge 3.0 Country Benchmark Using Pdtype As IQ_RG3_SOV_1YR_PD
Credit Analytics
Retrieves Sovereign 1-100 Score In The Riskgauge 3.0 Model Using Different Restatementtypeids.
RatingsXpress®: Structured Finance Performance
Returns CLO Performance Distribution Metrics Data
Visible Alpha Estimates
Locate Business Model Templates
Credit Analytics
Retrieves Sovereign 1-100 score In The Riskgauge 3.0 Model
S&P Capital IQ Financials
Retrieves Annual Financial Data for Specified Companies While Handling Conflicts Across Multiple FiscalChainSeriesIDs
Visible Alpha Estimates
Track Revenue Estimate Changes
Visible Alpha Estimates
Track IPhone Sales Over Time
Visible Alpha Estimates
Calculate EPS Surprise
Visible Alpha Estimates
Find Companies In A Business Group
Credit Analytics
Retrieves Sovereign 1 Year PD In The Riskgauge 3.0 Model
RatingsXpress®: S&P Credit Ratings
Returns CLO Profile And Monitoring Metrics Data For Specific Instrument Symbol
RatingsXpress®: Structured Finance Performance
Returns S&P Generated Metrics For Summary Issuance By Specific Instrument Symbols
Commodities Energy Pricing
Returns Spark Spreads At Various Heat Rates And Implied Heat Rate For Gas Spark On A Specific Date
S&P Capital IQ Estimates
Returns the Current Year Revenue Estimate For a Company
Bond to Equity Factors
Returns Bond Equity Ratios Analysis
S&P Capital IQ Estimates
Returns all NTM mean EPS data as it existed at a particular point in time
Bond to Equity Factors
Returns Bond To Equity Ratios Records For Specific Date And UniverseID
S&P Capital IQ Estimates
Returns a Series of Current EPS Values For the 2024 Fiscal Year
Bond to Equity Factors
Returns Bond To Equity Factors For Specific Trading ItemID
S&P Capital IQ Estimates
Identifying Consensus Estimates Excluding Stock-Based Compensation and or Amortization of Intangibles Using Footnote
SNL Insurance Regulatory Data
Returns Solvency II Datapoints For Input European Countries
Visible Alpha Estimates
Returns CRM Visible Alpha Estimates Industry Metrics Pivot Module
Visible Alpha Estimates
Returns CRM Visible Alpha Estimates Industry Metrics Module
S&P Capital IQ Financials
Returns Financial Reporting Data By Company and Financial Statement Type
S&P Capital IQ Estimates
Returns 10 Year Average TEV/EBITDA Estimates For Reported Forward One Period For A Company
S&P Capital IQ Financials
Returns Financial Data for a Specific dataItem Across Multiple Companies in an Industry
Physical Risk
Returns Physical Risk Company Headquarters And Asset Exposure Score Data Compared To County, State, And Subnational Exposures For A Given Forecast Year And Scenario
Ownership
Returns Ownership Summary For Selected Tickers Over Last Five Periods With Categorized Owner Types
Ownership
Returns Ownership Detailed For Selected Ticker With Categorized Owner Types
SNL Insurance Regulatory Data
Returns Direct Written Premiums By Line Of Business For A Particular Company Across The US In 2024
Physical Risk
Returns Company Level Physical Risk Data For A Given Forecast Year And Scenario
SNL Insurance Regulatory Data
Returns Comprehensive Overview Of Direct Written Premiums By Line Of Business Across The US In 2024
S&P Capital IQ Financials
As Reported Transparency
SNL RateWatch Depository Rates
NY Branches
SNL RateWatch Depository Rates
Rates During A Specific Timeframe
SNL RateWatch Depository Rates
Average Bank Product Rate
SNL RateWatch Depository Rates
Standard Interest Rates
SNL RateWatch Depository Rates
Parent Operating Bank
SNL RateWatch Depository Rates
Competitive Interest Rates
SNL RateWatch Depository Rates
Branches And Location
SNL RateWatch Depository Rates
Bank Product Rates
Panjiva Supply Chain Intelligence
Leverages Snowflake Dynamic Scripting To Provide Import Statistics For Specified Companies,Ensuring Consistent Column Handling, Efficient Aggregation And Filtering By Region, Date, And Company,For All Panjiva Import Tables
S&P Capital IQ Estimates
Returns Estimate EPS Consensus Mean And P/E Ratio
OTC Derivatives Data
Returns Equity VarSwap Volatility And Discount Factor Data
OTC Derivatives Data
Returns Equity Index Bid Ask Volatility And Forward Curve Data
OTC Derivatives Data
Returns Equity Stock ETF Bid Ask Volatility And Forward Curve Data
OTC Derivatives Data
Returns Equity VolSwap Volatility And Discount Factor Data
Headcount Analytics
Headcount By Top 10 Next Employers
Headcount Analytics
Headcount By Top 10 Previous Employers
Headcount Analytics
Returns Monthly Headcount Changes For A Company
Headcount Analytics
Monthly Headcount Data With Transactions Rounds Of Funding Information For A Company
Headcount Analytics
Role And Department Tenure For A Company
Headcount Analytics
Top And Bottom 10 Companies In A Metro Area Based On 12 Months Growth Rate
Headcount Analytics
Returns Top And Bottom Metro Growth Areas For An Industry
Base Data
Returns 365 Days Average Fxrate Historical Data
S&P Capital IQ Financials
Returns Point In Time EVIC Data Available As Per The Observation Date For MI Keys
CDS Pricing
Returns Credit Default Swap Pricing Data For Credit Tranches
CDS Pricing
Returns Credit Default Swaps Data For Credit Indices
CDS Pricing
Return Credit Default Swaps Pricing Data For Single Names
S&P Capital IQ Financials
Returns Unconsolidated Financial EVIC Data Available As Per The LTM Holding Dates
Index Data
Returns Levels Of Index Hierarchy Using Index Key For A BMI Index
Private Company Financials
Returns Private Company Financials EVIC Data As Per The Observation Date
RatingsXpress®: S&P Credit Ratings
Returns Financials Metrics And Issuer Ratings With Filtered Out Muni Ratings
Market Data
Returns Carryforward Market Pricing Data For The Specified Date Range
RatingsXpress®: S&P Credit Ratings
Returns Financials Metrics And Bond Ratings With Filtered Out Muni Ratings
OTC Derivatives Data
Returns Equity Stock ETF Volatility Forward Curve And Dividend Yield Data
S&P Capital IQ Financials
Returns Latest EVIC Data Available As Per The Observation Date
S&P Capital IQ Financials
Returns Point In Time EVIC Data Available As Per The Observation Date
Trucost ESG Financial and Market Data
Returns Point In Time EVIC Data Available As Per The Observation Date
OTC Derivatives Data
Returns Equity Index Volatility Forward Curve And Dividend Yield Data
Key Developments
Query Maps Keydevs Events With CIQEstimates And CIQFinancials
Trucost Environmental
Returns Top 10 Private Companies In United Kingdom With Highest Scope 3 Downstream Emissions In 2019
Trucost Environmental
Returns Air Pollutants Direct Cost For Chinese Private Companies Involved In Bituminous Coal And Lignite Surface Mining
Trucost Environmental
Returns Intensity Metrics For Jaguar Land Rover Automotive Plc
Trucost Environmental, Trucost Environmental: Private Companies
Returns Latest Available Data For Greenhouse Gas(GHG) Scope Of An InstitutionId
Trucost Environmental
Returns The Latest Data On Absolute Carbon Emissions For Greenhouse Gas(GHG) Scope 1 By InstitutionIDs
Trucost Environmental
Returns Private Companies With Over 75 Percent Revenue In Crude Petroleum And Natural Gas Extraction Sector
CreditPro®
Returns The Instrument Level Details
Machine Readable Transcripts
Returns Fiscal Years And Fiscal Quarters For All Latest Transcripts
Market Data, S&P Capital IQ Estimates, S&P Capital IQ Financials
Returns Financial Multiples And Forward Estimates Data
Base Data
Returns Year On Year Average Exchange Rate For All Countries
S&P Capital IQ Estimates
Returns TEV/NTM EBITDA Values For Time Series
Market Data, S&P Capital IQ Financials
Returns TEV And EBITDA Ratios For Selected Companies As Of An Observation Date
Compustat® Financials
Returns Consolidated Financial Data For Company As Of Observation Date
S&P Capital IQ Financials
Returns Premium Financials, Market Capitalization, And Market Prices For The Trading Items Pivot
S&P Capital IQ Estimates
Returns Time Series Forward Estimate EBITDA For A Ticker
Business Entity Cross Reference Service (BECRS)
Returns Risk Score Analysis Data For DUNS And GICS Identifiers
Market Data
Returns Analysis Of Unadjusted Outstanding Shares For Stock Splits
Physical Risk: Country, Subnational & Municipal
Returns Physical Risk GDP Exposed Metric For All US Geographies
Index Data
Returns S&P500, R2000 And FALLWORLD Index Constituents And Market Data By Sector As Of A Specified Date
S&P Capital IQ Financials
Returns Latest LTM Total Revenue Value Along With Annual Values
Key Developments
Returns Key Developments In Venture Vapital (VC) And Private Equity (PE) Firms
Base Data, Market Data, S&P Capital IQ Financials
Returns Currency Adjusted Financial Metrics For Trading Item ID
Company Connections: Detailed Estimates
Returns Company Connections For Compustat Gvkey And Iid
S&P Capital IQ Estimates
Returns Estimates For Reported Forward Five Periods
S&P Capital IQ Estimates
Returns Forward Estimates With Currency Conversion
SNL Insurance Regulatory Data
Returns Paid Loss Ratios By Accident Year Loss Triangle
SNL Insurance Regulatory Data
Returns Type SubType And Location For Product Filings Using Legacy Insurance Packages
S&P Capital IQ Estimates
Returns Estimate Consensus Coverage Between 2014-2021 For Companies Listed On The Stock Exchange Of Hong Kong Ltd.
Ownership
Returns Recursive Fund Ownership Hierarchy With Company Information, Shareholding, And Ownership Metrics Across Multiple Levels
Base Data
Returns Comprehensive Company Details
Panjiva Supply Chain Intelligence
Returns First Instance Of The Fully Matching HS Code For A Given PanjivaRecordId
Physical Risk: Country, Subnational & Municipal
Returns Subnational Level Physical Risk Absolute Hazard Frequencies For All Countries
Government, Supranational, Agency and Corporate (GSAC) Bond Pricing
Returns The GSAC Pricing Data For ISINs
Physical Risk: Country, Subnational & Municipal
Returns Country Level Physical Risk Exposure Scores For All Countries Within Subregion
Physical Risk: Country, Subnational & Municipal
Return Comparison Of Portugal And Spain Population Percentage Exposure To Extreme Heat
Securitized Products Pricing
Returns The Recent Instrument Prices
Government, Supranational, Agency and Corporate (GSAC) Bond Pricing
Return Liquidity Average Per ISIN Or ISINs
Government, Supranational, Agency and Corporate (GSAC) Bond Pricing
Returns Comprehensive Trade Statistics
Government, Supranational, Agency and Corporate (GSAC) Bond Pricing
Returns The Comparative Liquidity For ISINs
Physical Risk
Returns Physical Risk Asset Level Data
Business Entity Cross Reference Service (BECRS), Company Intelligence
Returns Ultimateparent Details With Levels Recursively For A Given Company
Panjiva Supply Chain Intelligence
Returns Import And Export Shipment Statistics For A Specified Company And Its Subsidiaries Based On CompanyID, Country, Start Date, And EndDate, Including Imports And Exports Of All 19 Countries
Compustat® Financials
Returns MarketCap For All Compustat GVKeys On A Particular Day
Securities Finance: Short Interest Data
Returns All US Equity Instruments Ranked By Active Utilization
Securities Finance: Short Interest Data
Returns Buyside Instrument Data Over The Last Seven Years
Securities Finance: Short Interest Data
Returns Top Ten US Equity Instruments Ranked By The Percentage Of Outstanding Shares On Loan
Index Data
Returns Constituents And Weights Using MSCI Daily Index Data Using S&P Capital IQ Index Data Xpressfeed
Index Data
Returns Constituents And Weights Using MSCI Month-End Index Data Using S&P Capital IQ Index Data Xpressfeed
Securities Finance: Short Interest Data
Returns All US Equities With A Value On Loan Greater Than One Million
Securities Finance: Short Interest Data
Returns The Top Ten UK Equities Ranked By Percentage Of Shares Outstanding On Loan
Securities Finance: Short Interest Data
Returns Value On Loan For The Last Three Years
S&P Capital IQ Financials
Returns P/E Ratio For SP 500 As Per An Observation Date Using CIQ
Physical Risk: Country, Subnational & Municipal
Returns State Level Municipal Physical Risk Data
S&P Global EU Taxonomy Data
Returns EUT As Reported Data For Iberdrola S.A. For Year 2022
S&P Global EU Taxonomy Data
Returns Revenue Level Alignment Metrics For Iberdrola S.A.
S&P Global EU Taxonomy Data
Returns Companies In France With Eligible Revenue Exposure Percentage Revenue For Manufacturing Sector
S&P Global EU Taxonomy Data
Returns Sector Level EUT Independent Assessment Data For Iberdrola, S.A. For Latest Year
S&P Global EU Taxonomy Data
Returns The Total Eligible And Total Aligned Data Split By Revenue For Iberdrola, S.A.
S&P Global EU Taxonomy Data
Returns The Company Level EUT Independent Assessment Data For Iberdrola, S.A. For Latest Year
Physical Risk
Returns Physical Risk Asset Financial Impact Data For Companies For A Forecast Year And Scenario Level Using Dynamic Pivot
Market Data, S&P Capital IQ Estimates
Returns Average TEV/NTM Total Revenue Value For A Company For An Observation Year
Global Events
Returns Speakers Who Were CFOs At That Time For A Companys Conference
Global Events
Returns Earnings Calls For A Company With Additional Details
Global Events
Display List Of Speakers CFOs For A Company
Global Events
Display All Charles Schwab Corporation Board Meetings
Global Events
Returns Linkage Of Transcripts To Events
Global Events
Returns All Participants In Conferences Announced By A Company
Global Events
Display List Of Earnings Calls For Southwest Airlines
Global Events
Display All Participants In HSBCs Conferences Announced In The Last Three Years
Global Events
Display After Market Earnings Releases For A Specific Date