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.
Recently Added
Returns Physical Risk Asset Level Data
Version Date:11/12/2024
The following sample query returns Physical Risk Asset Level Data for Ford Motor Company for scenario 'High' and forecast year 2050.
Data Packages
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
Version Date:11/04/2024
Returns shipment data for a specified company and its subsidiaries based on company ID, country, start date, and end date, including imports and exports of all 19 countries
Data Packages
Returns MarketCap For All Compustat GVKeys On A Particular Day
Version Date:11/01/2024
The following sample query provides market cap for all GVKeysas well as the currency for a given GVKey.
Data Packages
Returns Constituents And Weights Using MSCI Month-End Index Data Using S&P Capital IQ Index Data Xpressfeed
Version Date:10/08/2024
This query returns constituents and weights using MSCI month-end index data using S&P Capital IQ index data.
Data Packages
Returns All US Equities With A Value On Loan Greater Than One Million
Version Date:10/08/2024
The following sample query returns all US Equities with a value on loan greater than one million.
Data Packages
Returns The Top Ten UK Equities Ranked By Percentage Of Shares Outstanding On Loan
Version Date:10/08/2024
The following sample query returns the top ten UK Equities ranked by the percentage of shares outstanding on loan.
Data Packages
Returns Value On Loan For The Last Three Years
Version Date:10/08/2024
The following sample query returns Value On Loan for the last three years for BYND.
Data Packages
Returns Constituents And Weights Using MSCI Daily Index Data Using S&P Capital IQ Index Data Xpressfeed
Version Date:10/08/2024
Returns constituents AND weights using MSCI daily index data using S&P Capital IQ index data.
Data Packages
Returns P/E Ratio For SP 500 As Per An Observation Date Using CIQ
Version Date:09/18/2024
This query returns the Price-to-Earnings (PE) ratio for S&P 500 on an observation date using the S&P Capital IQ Premium Financials packages in Xpressfeed. Note: The Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values by using either a SET or SELECT statement.
Data Packages
Returns State Level Municipal Physical Risk Data
Version Date:08/30/2024
The following sample SQL query returns GDP Exposed metrics for Extreme Heat Hazard for all US states under a Scenario Level High and Forecast Year of 2030.
Data Packages
Returns EUT As Reported Data For Iberdrola S.A. For Year 2022
Version Date:08/23/2024
This following sample query returns EUT As Reported data for Iberdrola, S.A. for year 2022.
Data Packages
Returns Revenue Level Alignment Metrics For Iberdrola S.A.
Version Date:08/23/2024
This following sample query returns revenue level alignment metrics for Iberdrola, S.A.
Data Packages
Returns Companies In France With Eligible Revenue Exposure Percentage Revenue For Manufacturing Sector
Version Date:08/12/2024
This following sample query returns companies in france with eligible revenue exposure Percentage Revenue for manufacturing sector
Data Packages
Returns The Total Eligible And Total Aligned Data Split By Revenue For Iberdrola, S.A.
Version Date:07/17/2024
This following sample query returns total eligible and total aligned data split by revenue for iberdrola, S.A.
Data Packages
Returns The Company Level EUT Independent Assessment Data For Iberdrola, S.A. For Latest Year
Version Date:07/17/2024
This following sample query returns company level EUT independent assessment data for iberdrola, S.A. for latest year
Data Packages
Returns Physical Risk Asset Financial Impact Data For Companies For A Forecast Year And Scenario Level Using Dynamic Pivot
Version Date:07/16/2024
The sample query returns Physical Risk Asset Financial Impact Data for companies(here Tesla Inc) for forecast year as 2050 and scenario level as High.
Data Packages
Returns Average TEV/NTM Total Revenue Value For A Company For An Observation Year
Version Date:07/12/2024
This sample query returns average TEV/NTM Total Revenue Value for a company for an observation year.
Data Packages
Display List Of Earnings Calls For Southwest Airlines
Version Date:07/03/2024
This query lists the earnings calls for Southwest Airlines with additional details. Note: The Global Events Plus package is required to run this query.
Data Packages
Display All Charles Schwab Corporation Board Meetings
Version Date:07/03/2024
This query lists all board meetings of Charles Schwab Corporation. Note: The Global Events Plus package is required to run this query.
Data Packages
Returns Linkage Of Transcripts To Events
Version Date:07/03/2024
This query links transcripts to events for Apple Inc. Note: The Global Events Plus package is required to run this query.
Data Packages
Returns Earning Calls For A Company
Version Date:07/03/2024
The following sample query returns earnings calls for a company using specific keywords. Note: The Global Events Plus package is required to run this query.
Data Packages
Display List Of Speakers CFOs For A Company
Version Date:07/03/2024
This query returns a list of speakers who were CFOs at the time for a specific company in 2016. Note: The Global Events Plus package is required to run this query.
Data Packages
Returns Speakers Who Were CFOs At That Time For A Companys Conference
Version Date:07/03/2024
This query returns details of conference speakers who were CFOs at the time for a specific company in 2023. Note: The Global Events Plus package is required to run this query.
Data Packages
Returns All Participants In Conferences Announced By A Company
Version Date:07/03/2024
This query returns all participants in conferences announced by HSBC Holdings in the last three years. Note: The Global Events Plus package is required to run this query.
Data Packages
Display After Market Earnings Releases For A Specific Date
Version Date:07/03/2024
This query displays after-market earnings releases for a specific date. Note: The Global Events Plus package is required to run this query.
Data Packages
Earnings Call Analysis
Version Date:07/03/2024
This query returns an analysis of the number of distinct analysts who asked questions during Apple's quarterly earnings call. Note: The Global Events Plus package is required to run this query.
Data Packages
Display All Participants In HSBCs Conferences Announced In The Last Three Years
Version Date:07/03/2024
This query retrieves all participants in HSBC\x92s conferences announced in the last three years. Note: The Global Events Plus package is required to run this query.
Data Packages
Returns SFDR Data And EVIC In USD And EUR
Version Date:06/27/2024
This following sample query returns SFDR data and EVIC in USD and EUR for a given company.
Data Packages
Sales Volume By Company
Version Date:06/25/2024
This query calculates the total sales volume for each company.
Data Packages
Engine Performance Comparison By Configuration And Aspiration
Version Date:06/25/2024
This query compares the performance of engines based on their configuration and aspiration.
Data Packages
Average Sales Volume By Region
Version Date:06/25/2024
This query calculates the average sales volume for each region.
Data Packages
Vehicle Sales Volume By BodyType
Version Date:06/25/2024
This query calculates the total sales volume by BodyType.
Data Packages
Sales Volume By Vehicle And Cab Type
Version Date:06/25/2024
This query calculates the total sales volume by vehicle and cab type.
Data Packages
Forecasted Versus Actual Production Volumes By Period And Region
Version Date:06/25/2024
This query compares forecasted and actual production volumes by period and region.
Data Packages
Key Developments Announced In The Last Month
Version Date:06/25/2024
This query retrieves key developments announced in the past 30 days. Note: The Key Developments Plus package is required to run this query.
Data Packages
Vehicle Count By Emission Level
Version Date:06/25/2024
This query counts the number of vehicles for each emission level.
Data Packages
Key Developments With Most Frequent Modifications
Version Date:06/25/2024
This query identifies the key developments with the highest number of modifications. Note: The Key Developments Plus package is required to run this query.
Data Packages
Key Developments By Source Type
Version Date:06/25/2024
This query counts key developments by their source type. Note: The Key Developments Plus package is required to run this query.
Data Packages
Total Sales Volume By Vehicle Type
Version Date:06/25/2024
This query calculates the total sales volume for each vehicle type.
Data Packages
Key Developments By Event Type In The Last Week
Version Date:06/25/2024
This query counts the number of key developments by event type in the last week. Note: The Key Developments Plus package is required to run this query.
Data Packages
Impact Analysis Of Executive Changes
Version Date:06/25/2024
Analyzes the frequency of key developments related to executive changes over the past five years. Note: The Key Developments Plus package is required to run this query.
Data Packages
Top 5 Countries By Sales Volume
Version Date:06/25/2024
This query identifies the top 5 countries by total sales volume.
Data Packages
Sales Volume Trend By Period
Version Date:06/25/2024
This query shows the trend of total sales volume over different sales periods.
Data Packages
Top 5 Event Types By Number Of Changes Within 15 Minutes
Version Date:06/25/2024
This query identifies the top 5 event types with the highest number of changes within a 15-minute span. Note: The Key Developments Plus package is required to run this query
Data Packages
Total Production Powertrain Volume By Country
Version Date:06/25/2024
This query calculates the total production powertrain volume of commercial vehicles by country.
Data Packages
Top Manufacturers By Region And Vehicle Type
Version Date:06/25/2024
This query identifies the top manufacturers in each region by vehicle type and production powertrain volume.
Data Packages
Detailed Emission Levels By Vehicle Type And Manufacturer
Version Date:06/25/2024
This query provides detailed emission levels categorized by vehicle type and manufacturer.
Data Packages
Average Engine Displacement By Manufacturer
Version Date:06/25/2024
This query calculates the average engine displacement by manufacturer.
Data Packages
Average Battery Capacity By Alternative Propulsion System
Version Date:06/25/2024
This query calculates the average battery capacity for each alternative propulsion system.
Data Packages
Duration Of Key Developments In Database
Version Date:06/25/2024
This query calculates how long each key development remained in the database before being marked as no longer valid. Note: The Key Developments Plus package is required to run this query.
Data Packages
Returns Year On Year Average Exchange Rate For All Countries
Version Date:06/12/2024
The following sample SQL query returns Year on Year average exchange rates for all countries.
Data Packages
Returns Median PD Fundamentals Country Industry Benchmark Data As Per A Company
Version Date:06/11/2024
The following sample query returns latest Median PD Fundamentals Data Item values like total revenue, corporate risk score, return on equity etc. as per a company.
Data Packages
BEV Sales Growth Comparison By Brands In China From 2023 To 2024
Version Date:06/07/2024
This query compares the sales growth of BEV brands in China between the years 2023 and 2024.
Data Packages
Total BEV Sales Volume Trend Globally
Version Date:06/07/2024
This query provides the annual trend of global sales volumes for Battery Electric Vehicles (BEVs), highlighting the growth over the years.
Data Packages
BEV Market Share By Company For A Specific Year
Version Date:06/07/2024
This query shows the market share of various companies in terms of BEV sales for the year 2023.
Data Packages
Production Volume Of Top 10 Assembly Plants For A Specific Year
Version Date:06/07/2024
This query lists the top 10 assembly plants by production volume in 2023.
Data Packages
Sales Volume By Country In A Specific Year
Version Date:06/07/2024
The query shows the total sales volume for China in the year 2023.
Data Packages
Sales Volume Trend For Company And Cybertruck By Year
Version Date:06/07/2024
The query shows the sales volume trend for the Cybertruck over the years.
Data Packages
Production Volume For Sub Segments Globally For A Specific Year
Version Date:06/07/2024
This query shows the total global production volume for each sales sub-segment in 2023.
Data Packages
Sales Volume By Global Sales Segment In A Specific Year
Version Date:06/07/2024
The query displays the sales volume by global sales segment for the year 2023.
Data Packages
Sales By Propulsion System Design For A Specific Country And Year
Version Date:06/07/2024
This query outlines the sales volume for different types of propulsion systems in China for the year 2023.
Data Packages
Production Volume Trend For A Specific Country
Version Date:06/07/2024
This query shows the yearly production volume trend for China.
Data Packages
Auto Brand Growth Comparison By Country From 2023 To 2024
Version Date:06/07/2024
The query compares the growth of different auto brands in China between the years 2023 and 2024.
Data Packages
Production Volume By Country In A Specific Year
Version Date:06/07/2024
This query provides the total production volume for China in the year 2024.
Data Packages
Global Propulsion System Design Trend Volume
Version Date:06/07/2024
This query illustrates the global sales volume trends for different propulsion systems across years.
Data Packages
Domestic Versus Import Sales Volume Trend For China
Version Date:06/07/2024
The query compares domestic versus import sales volume trends for China over the years.
Data Packages
Total BEV Sales Volume By Country In A Specific Year
Version Date:06/07/2024
This query displays the total sales volume of Battery Electric Vehicles (BEVs) in China for the year 2023.
Data Packages
Production Volume By Production Type For A Country And Specific Year
Version Date:06/07/2024
This query provides the total production volume by production type for China in 2023.
Data Packages
Unique Vehicle Models Sold By A Specific Company In A Specific Year
Version Date:06/07/2024
The query lists unique vehicle models sold by a specific companyID (Mercedes-Benz) in the year 2023.
Data Packages
Models With Production Volume By Region For A Specific Quarter And Year
Version Date:06/07/2024
This query lists the models with the highest production volume in Europe for the fourth quarter of 2023.
Data Packages
Market Share Percentage By Company For A Specific Year And Country
Version Date:06/07/2024
The query calculates the market share percentage of different companies in China for the year 2023.
Data Packages
Returns All Firms Using A Specific Manager By Name And/Or Managed Allocation
Version Date:05/17/2024
This following sample query returns all firms using a specific manager by Name and/or managed allocation.
Data Packages
Returns Low, High, Close And Average TEV/LTM EBITDA Values For A Company As Per An Observation Date
Version Date:05/16/2024
The following sample SQL query returns low, high, close and average TEV/LTM EBITDA values for a company as per an observation date.
Data Packages
Returns All The Exchangecodes For The MmdentityIds Using Dynamic Pivot
Version Date:05/16/2024
This following sample query returns all the exchangeCodes for the mmdentityids using dynamic pivot
Data Packages
Returns The Industry Hierarchy For The Company
Version Date:04/29/2024
This following sample query returns the industry hierarchy for a selected company
Data Packages
Returns Company Tree And Associated Ratings
Version Date:04/25/2024
This following sample query returns company tree with entity relationships and its associated ratings
Data Packages
Returns Issue Level Municipal Physical Risk Data For Fixed Income Securities
Version Date:04/15/2024
The following sample SQL query returns Issue Level Municipal Physical Risk Data for Fixed Income Securities(GO/Municipal Debt) for Issuer - Wayne County, Michigan, for Pluvial Flood, Forecast Year 2050 and Scenario Level High.
Data Packages
Returns GDP Weighted US Exposure Score
Version Date:04/15/2024
The following sample SQL query returns GDP Weighted US Exposure Score greater than or equal to 50 to Pluvial Flood Hazard of Counties in Michigan for Scenario Level High and Forecast Years 2030, 2040 and 2050.
Data Packages
Retrieve All Unique Country List
Version Date:03/26/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Tender Information Modified With Date Range
Version Date:03/26/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Tenders For Company
Version Date:03/26/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Consummated Platts Dubai Trades For November 1 2022
Version Date:03/25/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Trade Data Between 2020-12-31, Limit The Fields Returned, Sort The Response By Market Maker
Version Date:03/25/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve The Price Each Product Was Traded At By Each Seller Between Specific Time Range
Version Date:03/25/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Flow Data For The Past 5 Years
Version Date:03/21/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For A Specific PipelineName
Version Date:03/21/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All FlowData Values For The Past 5 Years
Version Date:03/21/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Flow Data For The Past Two Days
Version Date:03/21/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data
Version Date:03/21/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Short-Term Refined Product Price Forecast For 2024
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Long-Term Historical And Forecast Prices For Commodity Dated Brent
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Get The Total Crude Supply For December 2022 In Iran With Breakdown
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Historical Contract Values For a List Of Curves And Assessment Date Range
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Return All Unplanned Outages Happening In The US On a Specific Date
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Get The Total Crude Supply For December 2022 In Iran
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Get Annual Crude Production For Iran In 2022
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Return All Outages For Refineries Operated By BP In 2020
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve Aggregated Values
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Returns Margins For Dubai Singapore Topping
Version Date:03/20/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/18/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/18/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/18/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/18/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/18/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/14/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/13/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Market Data Category (MDC)
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Corrections Published On a Specific Date
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Column And View Definitions From The Data Dictionary
Version Date:03/12/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Weighted Average MSRP Model Pricing Overview In 2023
Version Date:03/05/2024
This query calculates the weighted average Manufacturer's Suggested Retail Price (MSRP) for each car model in 2023.
Data Packages
2023 BEV Market Insights
Version Date:03/05/2024
This query provides insights into the Battery Electric Vehicle (BEV) market in 2023 by segment and subsegment, using the sales volumes and market share percentages to highlight the impact and penetration of BEVs in the automotive market.
Data Packages
2023 Make Sales Rankings By Subsegment
Version Date:03/05/2024
This query calculates the total sales volume for each vehicle make's subsegment in 2023.
Data Packages
2023 Propulsion System Model Sales
Version Date:03/05/2024
This query ranks the model sales by their propulsion systems in 2023, showing which types of propulsion systems were most popular.
Data Packages
Top Electrified Model Markets In 2023
Version Date:03/05/2024
This query identifies the top five markets for electrified models in 2023, focusing on electric propulsion systems.
Data Packages
Top 5 United States Vehicle Makes By 2023 Sales
Version Date:03/05/2024
This query lists the top 5 vehicle makes in the United States, by sales volume in 2023.
Data Packages
2023 Sales Volume By Propulsion Systems
Version Date:03/05/2024
This query aggregates sales volume by propulsion system for the year 2023.
Data Packages
AutoCompany Growth Rates
Version Date:03/05/2024
This query assesses the growth rate of AutoCompanies by comparing their sales in the current year (2023) against the previous year (2022).
Data Packages
2023 Best Selling Toyota Models
Version Date:03/05/2024
This query identifies the top 5 best selling Toyota models in 2023, showing which models were most popular.
Data Packages
2023 Price Versus Revenue Model Analysis
Version Date:03/05/2024
This query evaluates AutoCompanies in 2023 by comparing their total revenue and average Manufacturer's Suggested Retail Price (MSRP) per model sold.
Data Packages
Year Over Year Make Sales Growth For 2023
Version Date:03/05/2024
These queries calculate the year-over-year growth in sales for automotive makes for the year 2023 compared to 2022. Sales are only considered if they are greater in 2023 than in 2022.
Data Packages
Detailed Make Features And Types For 2023
Version Date:03/05/2024
This query provides a detailed overview of vehicle make features and types for the year 2023.
Data Packages
2023 Model Revenue
Version Date:03/05/2024
This query calculates the total revenue for each model, for the year 2023.
Data Packages
Weighted Average MSRP Vehicle Make Prices In 2023
Version Date:03/05/2024
This query calculates the weighted average MSRP for each vehicle make in 2023.
Data Packages
Propulsion System Make Sales And Prices In 2023
Version Date:03/05/2024
These queries analyze the sales and prices of vehicles by their propulsion system for the year 2023.
Data Packages
2023 Greece Model Market Share
Version Date:03/05/2024
The query calculates the market share of different vehicle models in Greece for the year 2023.
Data Packages
Fuel Data Accuracy In 2023
Version Date:03/05/2024
This query assesses the accuracy of fuel data for each model by calculating the percentage of estimates versus actual data in 2023.
Data Packages
Country Vehicle Makes Sales Summary For 2023
Version Date:03/05/2024
This query aggregates the total sales volume by country for the year 2023.
Data Packages
2023 Model Country Sales Overview
Version Date:03/05/2024
This query provides a sales overview for each country in 2023, highlighting the countries with the highest vehicle sales.
Data Packages
AutoCompanies Revenue In Q4 Of 2023
Version Date:03/05/2024
This query calculates the total revenue for auto companies in the fourth quarter of 2023.
Data Packages
Top 10 Best Selling Vehicle Makes Of 2023
Version Date:03/05/2024
This query calculates the average sales volume per company for the year 2023, ranking the top 10 best selling vehicle makes.
Data Packages
Tesla Model 3 Sales Trends
Version Date:03/05/2024
This query presents the monthly sales trends of Tesla Model 3 for the year 2023.
Data Packages
Seasonal Sales Make Impact Analysis For 2023
Version Date:03/05/2024
This query analyzes the average seasonality and total sales by year and ISO country code for the year 2023.
Data Packages
Retrieve all Column And View Definitions From The Data Dictionary
Version Date:03/04/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Reference Data For a Specific Symbol
Version Date:03/04/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Assessments Published Today
Version Date:03/04/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Retrieve All Market Data Categories (MDC) Per User
Version Date:03/04/2024
Please reach out to CI.support@spglobal.com for any assistance on the below query.
Data Packages
Capital Expenditure Breakdown By CompanyIDs And Latest Segment With GICS Codes
Version Date:03/01/2024
This query provides the capital expenditures (Capex) for approximately 26,000 companies, each identified by their companyID, with the latest segment financial data, and then categorizes these expenditures according to the Global Industry Classification Standard (GICS) code.
Data Packages
Returns Net Zero Pathway Data For British American Tobacco Company
Version Date:03/01/2024
The following sample SQL query returns net zero pathway for British American Tobacco company (SBTI commitment to set net zero target).
Data Packages
Returns Commitment Level Data For British American Tobacco Company
Version Date:03/01/2024
The following sample SQL query returns commitment level data(interims) for British American Tobacco company (SBTI commitment to set net zero target).
Data Packages
Returns Point In Time EVIC Data Available As Per The Observation Date for MI Keys
Version Date:02/21/2024
The following sample query Returns Point In Time EVIC Data Available As Per The Observation Date for MI Keys
Data Packages
Returns Business Involvement Screens Data For S&P 500 Companies For All Groups FY 2022
Version Date:02/20/2024
The following sample SQL query returns business involvement screens data for S&P 500 companies for all groups for the year 2022.
Data Packages
Returns The Datacenter List From Datacenter Knowledgebase
Version Date:01/26/2024
The following sample query returns the datacenter list for a selected period.
Data Packages
Returns Datacenters Aggregated By 451 Market
Version Date:01/26/2024
The following sample query returns values from the Datacenter Knowledgebase aggregated by 451 Market for a selected period.
Data Packages
Returns Active Liens In A State
Version Date:01/17/2024
The following sample query returns active liens filed in Mississippi.
Data Packages
Returns The Business Listings Link To SNL Institutions
Version Date:01/17/2024
The following sample query returns business listings with their link to institutionId.
Data Packages
Returns SIC Hierarchy For Businesses
Version Date:01/17/2024
The following sample query returns the SIC hierarchy for a selected business.
Data Packages
Returns Business Listings With UCC Filings And Commercial Properties
Version Date:01/17/2024
The following sample query returns the business listing for Six Flags New England and its link to UCC Filings and Commerical Properties.
Data Packages
Returns Businesses With Sales In A County And Their Contacts
Version Date:01/17/2024
The following sample query returns businesses with sales in a county and their contacts.
Data Packages
Returns Mortgages Expiring Within 6 Months In Texas
Version Date:01/17/2024
The following sample query returns mortgages expiring within 6 months in Texas.
Data Packages
Returns Commercial Properties Sustainability Data
Version Date:01/17/2024
The following sample query returns sustainability data for the Leed and Energy Star certification year of 2020.
Data Packages
Returns The Probability Of Default At The State Level
Version Date:01/17/2024
The following sample query returns the probability of default at the state level for a selected business listing.
Data Packages
Parent Operating Bank
Version Date:12/18/2023
This query lists parent banking institutions by the number of banking products they offer.
Data Packages
Competitive Interest Rates
Version Date:12/18/2023
This query identifies the top 10 banks in California offering the most competitive 30-year fixed mortgage rates
Data Packages
Standard Interest Rates
Version Date:12/18/2023
Standard interest rates for 30-year fixed mortgages at Citibank, N.A. branches in California.
Data Packages
Branches And Location
Version Date:12/18/2023
How many branches does Hanmi Bank have in California, and where are they located?
Data Packages
Returns All Data (Facts) Of All Companies With An Involvement In All The Screens Under Healthcare (Abortion, Contraception, Stem Cells) For A FY 2021
Version Date:12/15/2023
Returns All Data (Facts) Of All Companies With An Involvement In All The Screens Under Healthcare (Abortion, Contraception, Stem Cells) For A FY 2021
Data Packages
Returns All Companies With A Specific Revenue Range Or Ownership Range In A Screen For The Latest FY
Version Date:12/15/2023
Returns All Companies With A Specific Revenue Range Or Ownership Range In A Screen For The Latest FY (i.e. more than 10% revenues from Alcohol screens under group name - Consumer Product & Services)
Data Packages
Returns All Involvement Data (Facts) Of A Specific Company (KI - 4004205) For The Latest FY
Version Date:12/15/2023
Returns All Involvement Data (Facts) Of A Specific Company (KI - 4004205) For The Latest FY
Data Packages
Returns Companies With An Involvement In The Screen Military Contracting For FY 2021
Version Date:12/15/2023
Returns Companies With An Involvement In The Screen Military Contracting For FY 2021
Data Packages
Earnings Call Analysis
Version Date:11/16/2023
This query provides the count of distinct analysts participating in Apple Inc.'s earnings calls during the fourth fiscal quarter, grouped by the company ID and the specific quarter in the fiscal year.
Data Packages
Identify All The Topic Tags Along With Keyword Combination
Version Date:11/10/2023
The following sample SQL query identifies all the topic tags along with keyword combination.
Data Packages
Returns Topic Tags And Keywords For IBM
Version Date:11/10/2023
The following sample SQL query returns topic tags and keywords for IBM.
Data Packages
Market Cap To Float USD Currency Conversion With Average 30 Day Trading volume
Version Date:11/03/2023
The query finds and shows the public trading portion, total value, and the average trading volume over the last 30 days for main stocks and trading entities of companies that are currently in business. It adjusts these figures to US dollars by applying past currency exchange rates and focuses on the data for a specific company identified by its unique ID.
Data Packages
Assets With Overlapping Key Biodiversity Areas And Key Protected Areas
Version Date:10/30/2023
For Toyota Motors, in fiscal year 2021, here are the assets with overlapping Key Biodiversity area(s) and Key Protected area(s).
Data Packages
Top 3 Ecosystem Services A Company Depends Upon
Version Date:10/30/2023
For Toyota Motors, in the fiscal year of 2021, here are the top 3 ecosystem services the company depends upon.
Data Packages
Trucost EVIC As Per Financial PeriodEndDate
Version Date:10/26/2023
The following query provides the Enterprise Value to Invested Capital for Trucost.
Data Packages
Returns Latest EVIC Data Available As Per The Observation Date
Version Date:10/26/2023
The following SQL query returns latest data available as per the ObservationDate where the FilingDate can be greater than ObservationDate.
Data Packages
Returns Point In Time EVIC Data Available As Per The Observation Date
Version Date:10/26/2023
The following SQL query returns point in time data as per the ObservationDate, the FilingDate where PeriodEndDate will be less than or equal to ObservationDate.
Data Packages
Returns Point In Time EVIC Data Available As Per The Observation Date
Version Date:10/26/2023
The following SQL query returns point in time data as per the ObservationDate, the FilingDate where PeriodEndDate will be less than or equal to ObservationDate.
Data Packages
Returns Premium Financials Data Items Like Net Income, Net Income Margin, Total Revenue Etc
Version Date:10/19/2023
This sample query uses observationDate,currencyCode,periodtypeid and companyIDs to give data items like AP, Total Revenue, Net Income, Net Income Margin, ROE, Return Assets, Non Performing Loans, Total Capital Ratio, Current Ratio, Quick Ratio and Total Assets.
Data Packages
Returns Net Income Margin Estimates
Version Date:10/19/2023
This sample query uses CompanyID, datobserve and currencyCode to give Estimates data items like Net Income Margin CY+0 and Net Income Margin CY+2.
Data Packages
Returns Return on Invested Capital(ROIC) For Premimum Financials
Version Date:10/19/2023
This sample query uses CompanyID, datobserve and currencyCode to give ROIC.
Data Packages
Returns The Total Number Of Companies With Market Cap Greater Than USD 25 Million Grouped By The Year Ranges And Region The Primary TID Is Trading At
Version Date:09/27/2023
This following sample query returns the total number of companies with market cap greater than usd 25 million grouped by the year ranges and region the primary ttd is trading at
Data Packages
Returns The Total Number Of Companies With Market Cap Greater Than USD 25 Million In The Database Grouped By The Region The Primary TID Is Trading At
Version Date:09/27/2023
This following sample query returns the total number of companies with market Cap Greater than usd 25 million in the database grouped by the region the primary ttd is trading at
Data Packages
Returns The Total Number Of Operating And Operating Subsidiary Companies Grouped By Simple Industry Description And Company Type
Version Date:09/26/2023
This following sample query returns the total number of operating and operating subsidiary companies grouped by simple industry description and company type
Data Packages
Returns The Total Number Of Operating And Operating Subsidiary Companies Grouped By The 4th Level Primary Industry Classification And Company Type
Version Date:09/26/2023
This following sample query returns the total number of operating and operating subsidiary companies grouped by the 4th level primary industry classification and company type
Data Packages
Recommended Update
Version Date:09/18/2023
The following query provides the suggested changes or updates related to leveraged loan facilities, accompanied by industry identifiers (lxids), to assist in portfolio management, risk assessment, and trading strategies up-to-date.
Data Packages
Basic Reference Data With Organization
Version Date:09/18/2023
The following query provides the foundational industry identifiers and organizational information related to specific leveraged loan facilities, offering context but not necessarily detailed pricing or liquidity data, useful for general portfolio management and initial market analysis.
Data Packages
Liquidity With Basic Reference Data For Specific ASOF
Version Date:09/18/2023
The following query provides insights into the liquidity metrics, such as the number and size of dealer quotes, for leveraged loan facilities as of a designated date, along with static data information related to leveraged loan facilities, aiding in liquidity analysis , risk management and building of security master.
Data Packages
Liquidity For Specific Asof
Version Date:09/18/2023
The following query obtains liquidity metrics, such as the number of dealers quoting and the average size quoted, for loan facility/ies on a particular date ("asof"), to assess liquidity and make informed trading or risk management decisions.
Data Packages
Price And Liquidity With Reference Data For A Specific Pricing Batch And ASOF
Version Date:09/18/2023
The following query provides the targeted pricing and liquidity data for a specific batch of leveraged loan facilities as of a given date, along with associated liquidity metrics and industry identifiers to aid in market analysis, risk management, and trading decisions.
Data Packages
Live Pricing For Specific Asof
Version Date:09/18/2023
The following query provides current live pricing information for a loan facility/ies as of a particular date ("asof"), to make real time decisions, price discovery, risk assessment, or portfolio management.
Data Packages
Evaluated Price For A Specific Asof
Version Date:09/18/2023
The following query retrieves the evaluated market price of a loan facility/ies for a specified date ("asof"), along with relevant analytics and liquidity metrics, for risk management, trading decisions, or portfolio strategy.
Data Packages
Price With Reference Data For Specific ASOF
Version Date:09/18/2023
The following query provides detailed pricing information for a specific leveraged loan facility as of a certain date ("ASOF" stands for "As of Date"), along with static data information related to leveraged loan facilities associated.
Data Packages
Recommended Updates With Basic Reference Data
Version Date:09/18/2023
The following query provides the suggested changes or updates related to specific leveraged loan facilities, accompanied by foundational industry identifiers, to assist in keeping portfolio management, risk assessment, and trading strategies up-to-date.
Data Packages
Close Pricing For Specific ASOF
Version Date:09/18/2023
The following query retrieves the close bid-offer prices for loan facilities as of a specific date, enabling the end user to assess market conditions, risk, and liquidity for that date for better portfolio management and to be able to mark their books where applicable.
Data Packages
Searches For All Contacts Of Family Offices Firm For Cazenove Capital Management Limited
Version Date:09/11/2023
This following sample query Searches for all contacts of Family Offices firm for Cazenove Capital Management Limited.
Data Packages
Returns List All Family Offices Firms In United States With Assets Greater Than 1 Bn
Version Date:09/11/2023
This following sample query returns List all Family Offices firms in United States with assets greater than 1 Bn.
Data Packages
Lists All Family Offices Firms Where Charles Schwab Is Custodian
Version Date:09/11/2023
This following sample query Lists all Family Offices firms where Charles Schwab is Custodian.
Data Packages
Returns All The Distinct Risk Categories Including Aggregates And Sub-Aggregates
Version Date:08/30/2023
The following sample query returns all the distinct risk categories including aggregates and sub-aggregates.
Data Packages
Returns Outlook And Risk Scores For US Sub-Aggregate Categories In The Last 180 Days
Version Date:08/30/2023
The following sample query returns outlook and risk scores for US sub-aggregate categories in the last 180 days.
Data Packages
Returns The Risk Of Currency Depreciation Between USD vs GBP vs CAD Since 2015
Version Date:08/30/2023
The following sample query returns the risk of currency depreciation between USD vs GBP vs CAD since 2015.
Data Packages
Returns Security Risk Worldwide In The Last 90 Days
Version Date:08/30/2023
The following sample query returns security risk worldwide in the last 90 days.
Data Packages
Returns Risk Of Inflation For Europe Vs Asia/Pacific Since The Last Year
Version Date:08/30/2023
The following sample query returns risk of inflation for Europe vs Asia/Pacific since the last year.
Data Packages
Returns Countries And Their Categories That Fall In The Extremely Risky Band In The Last 90 Days
Version Date:08/30/2023
The following sample query Returns Countries and their categories that fall in the extremely risky band in the last 90 days.
Data Packages
Returns Current Business Relationships Of A Company
Version Date:08/28/2023
The following sample SQL query takes a parent company (Apple Inc.) and displays its current Business Relationships.
Data Packages
Returns Companies Coverage By Region In Business Relationships Dataset
Version Date:08/28/2023
The following sample SQL query returns total number of companies per region included in the Business Relationships Dataset.
Data Packages
Returns Count Of Current Business Relationships For A Company
Version Date:08/28/2023
The following sample SQL query takes a parent company (Apple Inc., IBM and Samsung) and displays the count for each of its current business relationships.
Data Packages
Returns Current Strategic Alliances Of A Company
Version Date:08/28/2023
The following sample SQL query takes a parent company (Apple Inc.) and displays its current strategic alliances.
Data Packages
Returns Top 5 Current Customers Of A Company With Respect To Marketcap
Version Date:08/28/2023
The following sample SQL query returns takes a parent company (Apple Inc.) and displays its top five current customers with respect to the marketcap for Business Relationships dataset.
Data Packages
Returns Coverage By Business Relationship Source Type Of Companies
Version Date:08/28/2023
The following sample SQL query finds count of unique companies in Business Relationships dataset for each Business Relationship Source Type.
Data Packages
Returns Current Distributor/Customers For A Supplier Company
Version Date:08/28/2023
The following sample SQL query returns current distributors/customers for a supplier company(Apple Inc.) from the CIQ Business Relationships tables.
Data Packages
Returns Current Business Relationships Of A Company With Their Source Type
Version Date:08/28/2023
The following sample SQL query returns takes a parent company (Apple Inc.) and displays its current business relationships with their source type.
Data Packages
Returns Counter For An Upgrade Or Downgrade In Value For Estimates And Revisions
Version Date:08/24/2023
The following sample SQL query counts number of times the dataitemvalue has gone up/down/no change for each analyst on the given input companyid.
Data Packages
Returns Employment Index Of Different Sectors
Version Date:07/13/2023
The following sample SQL query demonstrates the global employment index values across various private sectors such as Banking, Beverages and Food, Metals and Mining, Pharaceuticals and BioTechnology, Real estate, Technology, Tourism and Transportation.
Data Packages
Returns Copper Input Price Index For Europe Vs Asia
Version Date:07/13/2023
The following sample SQL query demonstrates the comparable Copper input price index for geographical regions Europe and Asia.
Data Packages
Returns Global Manufacturing Costs Vs Prices
Version Date:07/12/2023
The following sample SQL query demonstrates difference between Input Price (cost of materials) and Output Price (sales price) is the profit margin. High input price + high output price indicates inflationary trend, where high input price + low output price indicates softening demand in the inflationary condition. Quartile distribution visualizes which economies are in what profit margin condition.
Data Packages
Returns The Subscribed Data Packages And The Count Of Available TimeseriesIDs
Version Date:07/10/2023
The following sample SQL query returns the subscribed Data Packages and the count of available TimeseriesIDs
Data Packages
Returns All The TimeseriesIDs That Are Overlapping Across Different Packages
Version Date:07/10/2023
The following sample SQL query returns all the timeseriesIDs that are overlapping across different packages.
Data Packages
Returns Concepts And Count Of TimeseriesID For PMI Data
Version Date:07/10/2023
The following sample SQL query Returns Concepts and Count Of TimeseriesID For PMI Data.
Data Packages
Platform Representation Of CIQ Premium Financials(Annual) Via Xpressfeed Data
Version Date:06/16/2023
The Following Sample Query Provides platform representation of CIQ Premium Financials(Annual) via Xpressfeed Data.
Data Packages
Platform Representation Of CIQ Latest Financials(Annual) Via Xpressfeed Data
Version Date:06/16/2023
The Following Sample Query Provides platform representation of CIQ Latest Financials(Annual) via Xpressfeed Data.
Data Packages
Company coverage by Broker and Region in 2022
Version Date:06/08/2023
The following sample query returns Company coverage by Broker and Region in 2022
Data Packages
Company Coverage By Broker, Region, And Capitalization in 2022
Version Date:06/08/2023
The following sample query returns list of all company reports issued by Liberum Capital In 2022 With The Report Type Indication
Data Packages
Number Of Company Report Filings In The S&P500 Universe By Industry Sector Over The Last Five Years
Version Date:06/08/2023
The following sample query returns Number of Company Report filings in the S&P500 universe by Industry Sector over the last five years
Data Packages
Returns List Of Research Report Filings In 2022 With Broker, Analyst And Target Company Name
Version Date:06/08/2023
The following sample query returns List of Research Report Filings in 2022 with Broker, Analyst and Target Company Name
Data Packages
Returns List Of All Company Reports Issued By Liberum Capital In 2022 With The Report Type Indication
Version Date:06/08/2023
The following sample query returns list of all company reports issued by Liberum Capital In 2022 With The Report Type Indication
Data Packages
Returns Number Of Company Report Filings By Country In 2022
Version Date:06/08/2023
The following sample query returns Number of Company Report filings by country in 2022
Data Packages
Returns Latest SFDR Data for Textiles, Apparel and Luxury Goods Companies for year 2021
Version Date:06/06/2023
The following sample query returns Latest SFDR Data for Textiles, Apparel and Luxury Goods Companies for year 2021
Data Packages
Returns SFDR Data For Walmart Inc. For 2021
Version Date:06/05/2023
The following sample query returns SFDR data for Walmart Inc. for 2021
Data Packages
XIRR Will Calculate The Internal Rate Of Return For A Series Of Cash Flows That May NOT Be Periodic
Version Date:05/25/2023
XIRR will calculate the Internal Rate of Return (IRR) for a series of cash flows that may not be periodic. It does this by assigning specific dates to each individual cash flow. The main benefit of using the XIRR is that such unevenly timed cash flows can be accurately modeled.
Data Packages
Showing The Key Developments For A Company As It Was Available On A Particular Date Historically
Version Date:05/23/2023
The following sample query shows the Key Developments for a company as it was available on a particular date historically. Note: The Key Developments Plus package is required to run this query.
Data Packages
Shows Point-In-Time Updates For A Particular Action, Showing Only The Specific Columns That Changed With Each Row
Version Date:05/23/2023
The following sample query shows point-in-time updates for a particular action, showing only the specific columns that changed with each row Note: The Key Developments Plus package is required to run this query.
Data Packages
Showing Only The Specific Columns With Changed Values To The CiqKeyDev Table Over A 24 Hour Period
Version Date:05/23/2023
The following sample query all of the changes that happened to the ciqKeyDev table over a 24 hour period (adds/updates/deletes), showing only the specific columns with changed values. Note: The Key Developments Plus package is required to run this query.
Data Packages
Total Debt To EBIT Percentage For Companies Incorporated In The USA
Version Date:05/18/2023
The output of the query provides the total debt and total EBIT (Earnings Before Interest and Taxes) annually for each year, along with the calculated percentage of total debt to total EBIT. The calculation excludes all rows with nulls in either of the following columns: b.dltt, b.dlc, and b.ebit. The query does EXCLUDE corporations NOT incorporated in the United States of America (USA). Finally, we also EXCLUDED Financials Services Firms and Banks incorporated in the USA.
Data Packages
Gross Profit And Gross Margin Quarterly Totals For All Companies Incorporated In The United States of America
Version Date:05/18/2023
The output of the query provides the total revenue, the total cost of goods sold, and total EBIT (Earnings Before Interest and Taxes) quarterly for each year. In addition, the query uses those columns to calculate the gross profit and the gross margin (as a percentage).
Data Packages
Shows All Announced/Completed Transactions For A Company
Version Date:05/04/2023
This sample query shows all Announced/Completed Transactions for a company. Note: The Key Developments Plus package is required to run this query
Data Packages
Shows Only The Specific Columns That Changed With Each Row In Key Developments
Version Date:05/04/2023
The following sample query shows only the specific columns that changed with each row in key developments. Note: The Key Developments Plus package is required to run this query
Data Packages
Query Maps Keydevs Events with CIQEstimates And CIQFinancials
Version Date:04/19/2023
The following sample SQL query returns Net EPS from CIQFinancials and EPS Normalized Consensus Mean, EPS Normalized Consensus Median from CIQEstimates based on MostImportantDateUTC for an event from Keydevs
Data Packages
Returns Disclosure Analysis Data For Walmart Inc. In 2022 Assessment
Version Date:03/31/2023
The following sample SQL query returns Disclosure Analysis Data for Walmart Inc. in 2022 Assessment
Data Packages
Returns Question Level Scores, Weights, Disclosure Data, And Industry Level Aggregate Scores For Walmart Inc. For Corporate Governance Criteria in 2022 Assessment
Version Date:03/31/2023
The following sample SQL query returns Question Level Scores, Weights, Disclosure Data, and Industry Level Aggregate ', "Scores for Walmart Inc. for 'Corporate Governance' Criteria in 2022 Assessment
Data Packages
Returns Disclosure Analysis Data For Companies In 'Health Care' Sector In 2022 Assessment
Version Date:03/31/2023
The following sample SQL query returns Disclosure Analysis Data for Companies in 'Health Care' Sector in 2022 Assessment
Data Packages
Question Description And Survey Level Data For Question 'Biodiversity Commitment' In 2022 Assessment
Version Date:03/31/2023
The following sample SQL query returns Question Description and Survey Level Data for Question 'Biodiversity Commitment' in 2022 Assessment
Data Packages
Returns Fact Level Responses to Question 'Board Gender Diversity' for Companies in 'Consumer Staples' for 2022 Assessment
Version Date:03/31/2023
The following sample SQL query returns Fact Level Responses to Question 'Board Gender Diversity' for Companies in 'Consumer Staples' for 2022 Assessment
Data Packages
Find All Securities Issued By A Company And Displays The SP Global Ratings
Version Date:03/22/2023
The following query finds all securities issued by a company and display the S&P Global Ratings.
Data Packages
Find All Trading Items For A Security
Version Date:03/22/2023
The following query finds all trading items for a security.
Data Packages
Find All Security Identifiers For A Particular Company
Version Date:03/22/2023
The following query finds all security identifiers for a particular company.
Data Packages
Find All Security Level Identifiers For A Private Fund
Version Date:03/22/2023
The following query finds all security level identifiers (CUSIP9, ISIN, SEDOL, CINS) for a private fund.
Data Packages
The Ultimate Parent
Version Date:03/20/2023
The following query rolls up to the Ultimate Parent then display all companyId\x92s that would fall under that ultimate parent (all levels).
Data Packages
Estimates Multiples
Version Date:03/20/2023
The following query can return the Primary EPS of a company or companies, which will be dynamically returned.
Data Packages
Mapping Listing Level SEDOLs To CIQ Market Data
Version Date:03/20/2023
The overall main goal of this query is mapping listing level SEDOLs to CIQ Market Data.
Data Packages
SNL Data Items In A Singular Row
Version Date:03/20/2023
The following query pulls numerous SNL Data Items and displays them in a singular row.
Data Packages
PIT Ratio Where Levered Free Cash Flow Is Divided By The Last Five Quarters Average Total Assets
Version Date:03/20/2023
The resulting query is a PIT ratio that provides a measure of how efficiently a company is generating cash flow in relation to its total assets.
Data Packages
Returns Fundamental PD and Implied Scores For IBM For A Specific Period
Version Date:03/17/2023
The following sample query returns Fundamental PD and Implied Scores for IBM for a specific period (Q1-2017Y).
Data Packages
Returns Inter-Dataitemid Relationship(Dataitemid's Hierarchy)
Version Date:03/17/2023
The following Query Passes DataitamDescription and returns parent and child DataitemIDs Hierarchy
Data Packages
Returns The Latest Index-based Median Credit Model Score And Implied PD For S&P 500
Version Date:03/17/2023
The following sample query returns the latest Index-based Median Credit Model Score and Implied PD for S&P 500
Data Packages
Returns The Latest Index-Based Median Market Signal PD and Implied Score For S&P 500
Version Date:03/17/2023
The following sample query returns the latest Index-based Median Market Signal PD and Implied Score for S&P 500
Data Packages
Returns Share Buyback Data For US Corporates For The Last 10 Years
Version Date:03/14/2023
The following query returns share buyback data for US corporates for the last 10 years.
Data Packages
Returns Volume Of Stock For A Company
Version Date:03/11/2023
The following sample SQL query retrieves volume of stock for a company(Here Apple Inc.)
Data Packages
Returns Top 5 Equity Inflows
Version Date:03/11/2023
The following sample SQL query retrieves top 5 equity inflows.
Data Packages
Returns Total Number Of Factors By Style For International Companies
Version Date:03/11/2023
The following sample SQL query retrieves the total number of factors by style using daily international data.
Data Packages
Returns Global Monthly Universe Populations
Version Date:03/11/2023
The following sample SQL query retrieves global monthly universe population for each global universe in Alpha Factor Library.
Data Packages
Returns Correlation Between In/Outflows And Stock Price For A Company
Version Date:03/11/2023
The following sample SQL query retrieves correlation between in/outflows and stock price for retail flow equity data.
Data Packages
Returns Unique Number Of Companies By TradingItemIDs For Each Fiscal Year
Version Date:03/11/2023
The following sample SQL query retrieves unique number of companies by tradingitemIDs for each fiscal year.
Data Packages
Returns Non Standard Fund Data Items For Retail Flow
Version Date:03/11/2023
The following sample SQL query retrieves non standard fund data against each company.
Data Packages
Returns Base And Historical Relative Factor Data For A Company(North America)
Version Date:03/11/2023
The following sample SQL query retrieves base and historical relative factor data for a North America based company(Here IBM).
Data Packages
Returns Standard And Non Standard Volume For Retail Flow Equity Data
Version Date:03/11/2023
The following sample SQL query retrieves Standard Volume and Non Standard Volume for retail flow equity data.
Data Packages
Returns Total Number Of TradingItemIDs By Style
Version Date:03/11/2023
The following sample SQL query retrieves the total number of tradingItemIDs covered by style using daily international data.
Data Packages
Returns Short Position Profit Concentration For A Company
Version Date:03/11/2023
The following sample SQL query returns short position profit concentration for a company(here Netflix Inc.).
Data Packages
Returns Global Daily Universe Populations
Version Date:03/11/2023
The following sample SQL query retrieves universe population for each universe in Alpha Factor Library.
Data Packages
Returns Number Of Factors By Relative Factor For Each Year For International Companies
Version Date:03/11/2023
The following sample SQL query returns number of factors by relative factor for each year for international companies.
Data Packages
Returns Market Sentiment Composition Score And Market Sentiment Factors For A Company
Version Date:03/11/2023
The following sample SQL query returns market sentiment composition score and market sentiment factors for a company(here Netflix Inc.) in a particular region.
Data Packages
Returns Earliest And Latest File Delivery Date For Retail Flow Equity Data
Version Date:03/11/2023
The following sample SQL query retrieves coverage for each company starting from the minimum File delivery and File record Date.
Data Packages
Returns Base And Historical Relative Factor Data For A Company(Global)
Version Date:03/11/2023
The following sample SQL query retrieves base and historical relative factor data for a global based company(Here IBM).
Data Packages
Returns Count Of Securities By Style By Year
Version Date:03/11/2023
The following sample SQL query retrieves count of securities by style by year.
Data Packages
Returns Retail Flow Data For Assessing Liquidity Of Funds For A company
Version Date:03/11/2023
The following sample SQL query retrieves Retail Flow data for a company(Here iShares ESG Aware MSCI USA ETF) for assessing liquidity of funds.
Data Packages
Returns Change Through Time Of Company Types Ranked In Short Squeeze Score
Version Date:03/11/2023
The following sample SQL query change through time of company types ranked in short squeeze score.
Data Packages
Returns Count Of Trading Items By Country
Version Date:03/11/2023
The following sample SQL query retrieves count of securities by style by year.
Data Packages
Returns Trading Item Counts By Industry
Version Date:03/11/2023
The following sample SQL query returns trading item counts by industry for Short Squeeze Data.
Data Packages
Returns Stock Popularity For A Company
Version Date:03/11/2023
The following sample SQL query retrieves stock populairty for a company(Here AMC Entertainment Holdings, Inc.)
Data Packages
Returns Non Standard Equity Data
Version Date:03/11/2023
The following sample SQL query retrieves 'OTHER' quantity and notional value is representing Non-Standard Equity that the company is trading.
Data Packages
Returns Changes In Stock Market Prices For Investor Sentiment Analysis
Version Date:03/11/2023
The following sample SQL query retrieves changes in stock market prices that are a reflection of how the public feels about the companies.
Data Packages
Returns Global Coverage By ISO Country Of Unqiue Trading Item IDs
Version Date:03/11/2023
The following sample SQL query displays global coverage by ISO Country of unqiue trading item IDs since 2011.
Data Packages
Returns Transaction Level Securities Finance Data With Event Indicators For Companies
Version Date:03/11/2023
The following sample SQL query displays the transaction level securities finance data with event indicators to provide insights into predicting short squeeze events for all companies.
Data Packages
Returns Specific Asset Classes
Version Date:03/11/2023
The following sample SQL query retrieves specific asset classes.
Data Packages
Returns Minimum File Record Date And maximum File Record Date For Each Company
Version Date:03/11/2023
The following sample SQL query retrieves minimum file record date and maximum file record date for each company.
Data Packages
Returns All Factors Available In Alpha Factor Library
Version Date:03/11/2023
The following sample SQL query displays all of the factor idenfifiers and correspdonging names, abbreviations, defintions, and indentifier that are all found within the ciqAfFactor table.
Data Packages
Returns Stock Selection Of ETFs In Different Companies Or Within A Company
Version Date:03/11/2023
The following sample SQL query retrieves stock selection of ETFs in different companies or within a company ensures that your asset allocation remains in line with your investment objectives and risk tolerance level.
Data Packages
Returns Count Per Industry For Retail Flow Equity Data
Version Date:03/11/2023
The following sample SQL query retrieves count per industry for retail flow equity.
Data Packages
Returns Aggregate Weighted PnL, PnL Daily Maximum And PnL Daily Minimum For A Company
Version Date:03/11/2023
The following sample SQL query returns aggregate weighted PnL, PnL daily maximum and PnL daily minimum for a company(here Netflix Inc.).
Data Packages
Returns Distribution Of Short Loan Position Based On Predefined Set Of Bins For Companies
Version Date:03/11/2023
The following sample SQL query displays the distribution of a stock\x92s short loan position profit/loss based on a predefined set of bins for all companies.
Data Packages
Returns Total Volume To Analyze Risk Management
Version Date:03/11/2023
The following sample SQL query retrieves total volume to analyze low or negative correlations between asset classes to manage risk.
Data Packages
Returns Relative Factors Available In Alpha Factor Library
Version Date:03/11/2023
The following sample SQL query provides the identifier and name of the relative factor.
Data Packages
Returns Volume To Price Change For A Company
Version Date:03/11/2023
The following sample SQL query retrieves volume to price change for a company(Here Vanguard World Fund - Vanguard Energy ETF).
Data Packages
Returns Standard Fund Data Items For Retail Flow
Version Date:03/11/2023
The following sample SQL query retrieves quantities and values of daily traded funds in terms of selling, buying and short selling against each company.
Data Packages
Returns Short Squeeze Comp Score And Maximum OTM Across 20 Days, With Positive Market Sentiment Events Score For A Company
Version Date:03/11/2023
The following sample SQL query returns Short Squeeze Comp Score and Maximum OTM Across 20 days, with Positive Market Sentiment Events Score for a company(here Netflix Inc.).
Data Packages
Returns Yearly Coverage Of Companies
Version Date:03/11/2023
The following sample SQL query retrieves unique number of companies by trading item that got there data coverage each fiscal year.
Data Packages
Returns Equity File Status
Version Date:03/11/2023
The following sample SQL query retrieves equity file status : 1 - Preliminary File and 2 - Final File.
Data Packages
Returns Styles Available In Alpha Factor Library
Version Date:03/11/2023
The following sample SQL query provides the style Ids and style names associated with each factor.
Data Packages
Returns Various Thematic Funds
Version Date:03/11/2023
The following sample SQL query retrieves various thematic funds in specific investment themes, trends, or sectors.
Data Packages
Returns Total Number Of Unique Trading Items Per Year And The Average Unique Trading Items Per Day By Year
Version Date:03/11/2023
The following sample SQL query returns total number of unique trading items per year and the average unique trading items per day by year.
Data Packages
Returns North America Daily Universe Populations
Version Date:03/11/2023
The following sample SQL query retrieves North America daily universe population for each North America universe in Alpha Factor Library.
Data Packages
Returns Transaction Level Securities Finance Data For Companies
Version Date:03/11/2023
The following sample SQL query displays the transaction level securities finance data for all companies including PnL, OTM (Out-of-the-money) and Transaction Duration used to build the Short Squeeze Model.
Data Packages
Returns Count Of Securities By Relative Factor By Year
Version Date:03/11/2023
The following sample SQL query retrieves count of securities by relative factor by year.
Data Packages
Ranks Companies In EMEA Region By ROE Factor
Version Date:03/11/2023
The following sample SQL query ranks companies in the EMEA region by ROE factor.
Data Packages
County Level Branch Stats
Version Date:03/09/2023
This following sample query provides county level branch stats.
Data Packages
MSA Level Branch Stats
Version Date:03/09/2023
This following sample query provides MSA level branch stats.
Data Packages
City Level Branch Stats
Version Date:03/09/2023
This following sample query provides city level branch stats.
Data Packages
State Level Branch Stats
Version Date:03/09/2023
This following sample query provides State level branch stats.
Data Packages
Aggregated Data For Deposits And Branches By Institution In A State
Version Date:03/09/2023
The following sample query provides aggregated data for deposits and branches by institution in a state.
Data Packages
Historical Deposits Aggregated At An Institution Level
Version Date:03/09/2023
This following sample query provides historical deposits, aggregated at an institution level.
Data Packages
Link The SNL InstitutionId To The S&P Capital IQ CompanyId
Version Date:03/09/2023
This following sample query links the SNL institutionId to the S&P Capital IQ companyId.
Data Packages
Aggregated Data For Deposits And Branches By Institution In A City
Version Date:03/09/2023
The following sample query provides aggregated data for deposits and branches by institution in a city.
Data Packages
Aggregated Data For Deposits And Branches By Institution In A Federal Market
Version Date:03/09/2023
The following sample query provides aggregated data for deposits and branches by institution in a federal market.
Data Packages
Link The SNL InstitutionId To The Compustat GVKEY
Version Date:03/09/2023
This following sample query links the SNL institutionId to the Compustat GVKEY.
Data Packages
Zip Code Level Branch Stats
Version Date:03/09/2023
The following sample query provides zip code level branch stats.
Data Packages
Query To Look Up Branch Service Values
Version Date:03/09/2023
The following sample query provides the ability to look up branch service values .
Data Packages
Federal Market Level Branch Stats
Version Date:03/09/2023
This following sample query provides Federal market level branch stats.
Data Packages
Aggregated Data For Deposits And Branches By Institution In An MSA
Version Date:03/09/2023
The following sample query provides aggregated data for deposits and branches by institution in an MSA.
Data Packages
Compares Annual Index Value vs. Monthly Percent Change From A Year Ago For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query Compares Annual index value vs. monthly percent change from a year ago
Data Packages
Returns Product, BankId and Count Of TimeseriesID For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query returns Product, BankId and count of TimeseriesID
Data Packages
Pulls Data For Spot Price Of COMEX High Grade Copper In United States For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query pulls data for COMEX High Grade Copper, United States, Spot Price
Data Packages
Provides Licensed Data For US Treasury 10-Year Constant Maturities For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query provides Licensed Data for US Treasury 10-Year Constant Maturities
Data Packages
Provides CIQ Legacy IHS Macroecon Mnemonics-to-TimeseriesId Mapping For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query provides CIQ Legacy IHS Macroecon Mnemonics-to-TimeseriesId mapping
Data Packages
Provides Compustat Mnemonics To ECR TimeseriesId Mapping For North America For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query provides Compustat Mnemonics to ECR TimeseriesId mapping For North America
Data Packages
Returns Licensed Content Which Is Subscribed By The User For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query returns licensed content which is subscribed by the User
Data Packages
Calculates Monthly Average With Daily Frequency Data For US Treasury 10-Year Constant Maturities For ECR Economic Data
Version Date:03/02/2023
The following sample SQL query calculates monthly average with daily frequency data for US treasury 10-Year constant maturities
Data Packages
Provides Compustat Mnemonics To ECR TimeseriesId Mapping For Global Coverage In ECR Economic Data
Version Date:03/02/2023
The following sample SQL query provides Compustat Mnemonics to ECR TimeseriesId mapping For Global Coverage
Data Packages
Retrieves S&P Global (China) Ratings For Issuer In English Language
Version Date:02/13/2023
The following queries retrieve S&P Global (China) Ratings for issuer in English Language
Data Packages
Retrieves S&P Global (China) Ratings For Issue In English Language
Version Date:02/13/2023
The following queries retrieve S&P Global (China) Ratings for issue in English Language
Data Packages
Retrieves S&P Global (China) Ratings For Issuer Chinese Language
Version Date:02/13/2023
The following queries retrieve S&P Global (China) Ratings for issuer in Chinese Language
Data Packages
Returns All Firms In Specific Geographical Region With Assets Greater Than Or Equal To Specific AUM
Version Date:01/17/2023
This following sample query returns all firms in specific geographical region with assets greater than or equal to specific AUM
Data Packages
Returns All Firms For All Contacts With Emails
Version Date:01/17/2023
This following sample query returns all firms for all contacts with emails
Data Packages
Returns All Firms With Specific Investment Allocation Such As ESG And Alternatives
Version Date:01/17/2023
This following sample query returns all firms with specific investment allocation such as ESG and alternatives
Data Packages
Returns All Firms Using A Specific Provider Type Such As Consultant Based On Provider Name
Version Date:01/17/2023
This following sample query returns all firms using a specific provider type such as consultant based on provider name
Data Packages
Returns Annual Broker View Revision Estimates
Version Date:12/27/2022
The following sample SQL query returns annual broker view revision estimates. For more information on annual broker view revision estimates, please refer to CIQ Pro Template here: https://www.capitaliq.com/CIQDotNet/Estimates/CIQ/Revisions.aspx?stateKey=bf75adc66b3d452db4e5d674787d8524&companyid=112350&dataVendorId=1&accountingStandardId=-1
Data Packages
Returns Price to Sales Calculation For Compustat Financials On A Specific Observation Date
Version Date:12/19/2022
The following query returns price to sales calculation for compustat financials on a specific observation date.
Data Packages
Returns All Business Segment Fundamentals For CIQLatestFinancials
Version Date:12/08/2022
The following sample SQL query demonstrates how to view the latest annual business segment financials for International Business Machines Corp. (in the reported currency). Note: This sample query includes data from all Segment Add-On packages and loads into ciqFinCollectionDataLatest table for Snowflake
Data Packages
Returns Options And Warrants Add-On Display Options And Warrants Data
Version Date:11/22/2022
The following sample query provides options and warrants add-on display options and warrants data
Data Packages
Returns HS Code and HS Methodology For Panjiva Data
Version Date:11/22/2022
The following sample query provides HS Code and HS Methodology For Panjiva Data
Data Packages
Returns Options And Warrants Data Using Treasury Method Calculation
Version Date:11/22/2022
The following sample query provides options data using treasury method calculation
Data Packages
Returns Top 10 Percent Of Low Short Interest As Per Shares Outstanding For SP500
Version Date:11/16/2022
The following sample SQL query returns top 10 percent of Low short interest as per shares outstanding for S&P500. Tags: Legacy Offering
Data Packages
Returns Top 10 Percent Of High Utilization For SP500
Version Date:11/16/2022
The following sample SQL query returns top 10 percent of high utilization for S&P500. Tags: Legacy Offering
Data Packages
Returns Top 10 Percent Of Low Utilization For SP500
Version Date:11/16/2022
The following sample SQL query returns top 10 percent of low utilization for S&P500. Tags: Legacy Offering
Data Packages
Returns Sustainable Investment Data For Walmart Inc.
Version Date:11/16/2022
The following sample SQL query returns sustainable Investment Data for Walmart Inc.
Data Packages
Creating A Time Series Of Index Values For The S&P 500
Version Date:11/14/2022
The following sample query creates a time series of index values for the S&P 500.
Data Packages
Available TOPIX Security Identifiers
Version Date:11/14/2022
The following sample query returns the available TOPIX security identifiers.
Data Packages
Returning All The Sector Indices That Make Up The S&P 500
Version Date:11/14/2022
The following sample query returns all the sector indices that make up the S&P 500.
Data Packages
Returning Constituents, Weight In The Index, And Index Divisor As Of A Specific Date
Version Date:11/14/2022
The following sample query returning constituents, weight in the index, and index divisor as of a specific date.
Data Packages
Retrieving Russell ICB Financials Industry Cascade For The Russell 3000 Index
Version Date:11/14/2022
The following sample query is retrieving Russell ICB Financials Industry Cascade for the Russell 3000 Index.
Data Packages
Returning The Weight Of The Constituents In The Energy Sector For The S&P 500
Version Date:11/14/2022
The following sample query returns the weight of the constituents in the Energy Sector for the S&P 500.
Data Packages
Returning Constituents, Float Shares, Weight, And Price For A Specific Index On A Specific Date With From And Thru Dates
Version Date:11/14/2022
The following sample query returns constituents, float shares, weight, and price for a specific index on a specific date with from and thru dates.
Data Packages
Identifying All The Data Items Delivered In The Index Packages
Version Date:11/14/2022
The following sample query identifies all the data items delivered to the index packages.
Data Packages
Current TOPIX 100 INDEX (NEW INDEX SERIES) By Linking
Version Date:11/14/2022
The following sample query returns current TOPIX 100 INDEX (NEW INDEX SERIES) by linking.
Data Packages
Current TOPIX 100 INDEX (NEW INDEX SERIES) By Selecting Attributes
Version Date:11/14/2022
The following sample query returns the current TOPIX 100 INDEX (NEW INDEX SERIES) by selecting attributes.
Data Packages
Creating A List Of The Indices Available In The Current CIQ index Package And Their Associated TradingItemIDs
Version Date:11/14/2022
This following sample query creates a list of the indices available in the current CIQ index package and their associated tradingItemIDs.
Data Packages
Linking From ICAType To ICATypeID To DataItemId
Version Date:11/14/2022
The following sample query is linking from ICAType to ICATypeID to dataItemId.
Data Packages
CiqGvkeyIID Linking For The Current S&P 1200 Constituents
Version Date:11/14/2022
The following sample query returns ciqGvkeyIID linking for the current S&P 1200 constituents.
Data Packages
Obtaining A Constituent List As Of A Particular Date
Version Date:11/14/2022
The following sample query obtains a constituent list as of a particular date
Data Packages
Dividends For The Constituents Of The S&P 500 On The Observation Date
Version Date:11/14/2022
The following sample query returns the dividends for the constituents of the S&P 500 on the observation date.
Data Packages
Other TOPIX Security Identifiers
Version Date:11/14/2022
The following sample query returns other TOPIX security identifiers.
Data Packages
Selecting All Constituents Of The S&P 500 And Their Weights As Of July 14th, 2010
Version Date:11/14/2022
The following sample query selects all constituents of the S&P 500 and their weights as of July 14th, 2010.
Data Packages
Obtaining The Most Current Constituents For The S&P 500 Index
Version Date:11/14/2022
The following sample query obtains the most current constituents for the S&P 500 index.
Data Packages
Returns Ultimateparent Details With Levels Recursively For A Given Company
Version Date:11/06/2022
Returns Ultimateparent Details With Levels Recursively For A Given Company. Tags - Backward Recursion, UltimateParentID, Corporate tree, Corporate Hierarchy, Company Hierarchy,Levels Between Child UltimateParent
Data Packages
Returns Price To Sales Ratio For Each Quarter For Compustat Data
Version Date:10/31/2022
The following sample query provides price to sales ratio for each quarter.
Data Packages
Returns Price To Cash Flow For Compustat Data
Version Date:10/31/2022
The following sample query provides Price to Cash flow for compustat data.
Data Packages
Returns Price To Book Values For Compustat Data
Version Date:10/31/2022
The following sample query provides price to book values for compustat data.
Data Packages
S&P CreditStats Data For US Public Finance for New York In 2022 With CUSIPs From RatingsXpress v4
Version Date:10/26/2022
The following sample queries provides S&P CreditStats Data For US Public Finance Data for New York in 2022 with CUSIPs from RatingsXpress v4
Data Packages
How To Find ArtcilesIDs And Published Scores And Factors For All Sovereigns
Version Date:10/14/2022
The following query shows how to retrieve all articleIds and all published Scores And Factors for all Sovereigns with Article Primary Entity.
Data Packages
How To Find A List Of ArticleIds With Their Primary Entity And Other Associated Data
Version Date:10/14/2022
The following query shows how to retrieve articleIds, the associated entity, and publication dates where the entity is tagged as the primary entity.
Data Packages
How To Find ArtcilesIds And Published Scores And Factors For Corporates
Version Date:10/14/2022
The following query shows how to retrieve all articleIds and all published Scores And Factors for Corporates with Article Primary Entity.
Data Packages
How To Find ArtcilesIDs And Published Scores And Factors For Insurance Companies
Version Date:10/14/2022
The following query shows how to retrieve all articleIds and all published Scores And Factors for Insurance Companies with Article Primary Entity.
Data Packages
Returns Ownership Summary For A Particular Company
Version Date:10/07/2022
The following sample queries provide ownership summary for a particular company
Data Packages
Returns Capital Structure Data For A Particular Company
Version Date:10/07/2022
The following sample query retrieves capital structure data for Apple Inc.For more information about capital structure data, please refer to the CIQ Pro Template here: https://www.capitaliq.spglobal.com/web/client?auth=inherit#company/capitalStructureDetails?ID=4004205
Data Packages
Returns Detailed Ownership Data For A Particular Company
Version Date:10/07/2022
The following sample query provide detailed ownership data for a particular company
Data Packages
Finds Forward Or Historical Estimates On A Specific Observation Date
Version Date:09/23/2022
This sample query finds forward / historical estimates on a specific observation date.
Data Packages
Uses Relative Constant To Limit The Estimate Period To The Forward 3 Periods
Version Date:09/23/2022
This sample query uses relative constant to limit the estimate period to the forward 3 periods.
Data Packages
Finds Consensus Estimates For A Company With Multiple Trading Items
Version Date:09/23/2022
This sample query finds consensus estimates for a company with multiple trading items.
Data Packages
Currency Translation With Estimates
Version Date:09/23/2022
This sample query returns estimates for Sony in USD using currency translation.
Data Packages
Returns Companies That Have 5-day Revisions Changes
Version Date:09/23/2022
This sample query returns companies that have 5-day revisions changes.
Data Packages
Returns Estimates For Reported Forward Five Periods
Version Date:09/22/2022
The following sample query retrieves five forward estimates using relative constant concept for given dataitems such as EBITDA, EBIT, Net Income, DPS, EPS & FCF for a given company.
Data Packages
Returns BETA For S&P500 Index Of A Particular Company Using Compustat
Version Date:09/16/2022
This query calculates BETA 5 year value for S&P500 Index of IBM from Compustat
Data Packages
Net Premiums Earned For All Lines Of Business During The Year 2021 And Period Type Annual
Version Date:09/15/2022
The query below gives the information about the flow data of a company for the fiscal year 2021. (Income Statement data).
Data Packages
Net Total Assets For The Fiscal Year 2021 And Period Type Annual
Version Date:09/15/2022
The query below gives the information about the stock data of a company for the fiscal year 2021. (Balance Sheet data).
Data Packages
Metlife - Rolls Up Into Parent LOB Category, Category, LOB Line Of Business
Version Date:09/15/2022
This sample query rolls up into parent lob category, category, LOB line of business for Metlife.
Data Packages
Direct Premiums Written Data For All Lines Of Business During The Year 2021
Version Date:09/15/2022
The query below gives direct premiums written data for all lines of business during the year 2016 and period type Annual (Flow data and Geo type - State).
Data Packages
Data Packages
Identify ETF Characteristics by Ticker Symbol
Version Date:09/13/2022
This sample query allows you to use an entity's ticker symbol to pull style classification characteristics for an ETF
Data Packages
Identify ETF Relationship
Version Date:09/13/2022
The following is a sample query that pulls the fund distributor, advisor, and sponsor for an ETF.
Data Packages
Identify ETF Managers
Version Date:09/13/2022
This sample query pulls the current professional managers for an ETF.
Data Packages
Identify ETF Characteristics
Version Date:09/13/2022
This sample query that pulls all S&P Global Market Intelligence ETF characteristics for a companyId.
Data Packages
Identify ETF Style Classification Codes
Version Date:09/13/2022
This following sample query that pulls style classification codes and their names for a particular asset class, in this case Commodity.
Data Packages
Identify ETFs Associated With A Specific Asset Category
Version Date:09/13/2022
This sample query pulls all ETFs associated with a specific asset category, in this case, coffee. You can find the appropriate style classification code in the style classification tree
Data Packages
Identify ETF Assets Under Management
Version Date:09/13/2022
This sample query pulls historical Assets Under Management (AUM) for an ETF.
Data Packages
Identify ETF Fees
Version Date:09/13/2022
This sample query pulls a benchmark for an ETF.
Data Packages
Returns The Data For Physical Risk Sensitivity Adjusted Scores
Version Date:08/09/2022
This sample query returns the Data for physical risk sensitivity adjusted scores for S&P 500 companies for year 2022 for eight physical risk indicators.
Data Packages
Returns The Forecast Based Exposure Score Data
Version Date:08/09/2022
This sample query returns the forecast based exposure score data for metric Drought, and for new sensitivity adjusted metrics for expanded forecast horizon of '2080' and 'Medium' scenario level for Ford Motor Company
Data Packages
Compare The Positive To Negative Sentiment Between Analysts And Executives On A Particular Call
Version Date:07/29/2022
This sample query compare the positive to negative sentiment between analysts and executives on a particular call.
Data Packages
Compare The Fog Index On All Available Calls From IBM Since 2013
Version Date:07/29/2022
This sample query compare the fog index on all available calls from IBM since 2013
Data Packages
Returns Portfolio Statistics By Industry Subtype For ALPS Advisers
Version Date:07/26/2022
This sample query returns Portfolio statistics by industry subtype for ALPS Advisers.
Data Packages
Identify The Currency For Market Cap And TEV Figures
Version Date:07/26/2022
This sample query identify the currency for market cap and TEV figures in the ciqMarketCap table.
Data Packages
Returns Portfolio Statistics By Region Subtype For SEI Investments Company
Version Date:07/26/2022
This sample query returns Portfolio statistics by region subtype for SEI Investments Company.
Data Packages
Returns Ownership by Fund
Version Date:07/26/2022
This sample query returns Ownership by Fund \x96 expand the holder (e.g., The Vanguard Group, Inc.) and see how the ownership position is built using underlying funds for a given owner (e.g., Wells Fargo & Company)
Data Packages
Returns The Top 50 Holdings Of Fidelity Contrafund As Of 12/31/2011
Version Date:07/26/2022
This sample query list the top 50 holdings of Fidelity Contrafund as of 12/31/2011
Data Packages
Returns Portfolio Style of IBM Displaying Shares Held, Percent Of Institutional Ownership And Percent Of Shares Outstanding
Version Date:07/26/2022
This sample query returns portfolio style of IBM displaying shares held, percent of institutional ownership and percent of shares outstanding.
Data Packages
Returns Portfolio Turnover For The Fidelity Contrafund.
Version Date:07/26/2022
This sample query returns portfolio turnover for the Fidelity Contrafund.
Data Packages
Identify How The Underlying Funds Are Rolled Up To The Parent Investment Manager And Their Aggregated Funds For A Given Owner
Version Date:07/26/2022
This sample query identify how the underlying funds are rolled up to the parent investment manager and their aggregated funds for a given owner (e.g., Wells Fargo & Company).
Data Packages
Returns Public Float Percent For Bank Of America Identified By Ticker Symbol
Version Date:07/26/2022
This sample query returns public float percent for Bank of America identified by ticker symbol.
Data Packages
Returns Ownership Details With Top Holders Of Oracle Corp.
Version Date:07/26/2022
This sample query returns ownership details with top holders of Oracle Corp. by rank on 12/31/2009, with owner names and owner source, using the ciqOwnCompanyHolding table.
Data Packages
Returns Annual Dividends In December 2009 For German Companies Traded On The Deutsche Boerse
Version Date:07/26/2022
This sample query returns annual dividends in December 2009 for German companies traded on the Deutsche Boerse, from the ciqDividendCache and ciqDividend tables.
Data Packages
Identify Prices For A Range Of Dates Using A CUSIP Identifier
Version Date:07/26/2022
This sample query identify prices for a range of dates using a CUSIP identifier through the ciqSymbol table. This query also pulls data from the ciqPriceDivAdjFactor and ciqPriceEquitySharesOutstanding tables.
Data Packages
Returns Securities Experiencing 5 Different Insiders Who Purchased Shares In The Prior 3 Months But No Sellers As Of 12/31/2010
Version Date:07/26/2022
This sample query returns securities experiencing at least 5 different insiders who had purchased shares in the prior 3 months but no sellers as of 12/31/2010.
Data Packages
Returns Dividend Data For A Specified TradingItemId And Date Range
Version Date:07/26/2022
This sample query returns dividend data for a specified tradingItemId and date range using the ciqDivFrequencyType table.
Data Packages
Returns Historical Public Float Percentage And Number Of Public Float Shares For Apple Inc.
Version Date:07/26/2022
This sample query returns historical Public Float Percentage and Number of Public Float Shares for Apple Inc.
Data Packages
Returns Aggregate Issue-Level Ownership Information For Berkshire Hathaway Class B Shares
Version Date:07/26/2022
This sample query returns aggregate issue-level ownership information for Berkshire Hathaway Class B shares.
Data Packages
List The Current Holdings Of Fidelity Contrafund
Version Date:07/26/2022
This sample query list the current holdings of Fidelity Contrafund (based on most recently available reporting and current prices).
Data Packages
Returns Portfolio Style Of Vanguard Wellington Fund Indicating The Portfolio Value, Growth And Dividend Yield Scores
Version Date:07/26/2022
This sample query returns Portfolio Style of Vanguard Wellington Fund indicating the portfolio value, growth and dividend yield scores.
Data Packages
Identify US Public Companies With Non-Traded Shares Outstanding That Have A Market Cap Of More Than $20 Billion.
Version Date:07/26/2022
This sample query identify US public companies with non-traded shares outstanding that have a market cap of more than $20 billion.
Data Packages
Returns Aggregate Company-Level Ownership Information For Berkshire Hathaway
Version Date:07/26/2022
This sample query returns aggregate company-level ownership information for Berkshire Hathaway.
Data Packages
Returns Portfolio Statistics By Market Cap Subtype For Janus Capital
Version Date:07/26/2022
This sample query returns Portfolio Statistics by market cap subtype for Janus Capital.
Data Packages
Display High/Low Annual Stock Price Value For A Single Company
Version Date:07/21/2022
This sample query display high/low annual stock price value for a single company.
Data Packages
Display Annual Stock Data Items For The Latest Annual Filings For A Single Company
Version Date:07/21/2022
This sample query display annual stock data items for the latest annual filings for a single company.
Data Packages
Display Annual Flow Data Items For Latest Annual Filings For A Single Company
Version Date:07/21/2022
This sample query display annual flow data items for latest annual filings for a single company.
Data Packages
Display All SNL InstitutionIds With Restatements Due To Fiscal Year Changes
Version Date:07/21/2022
This sample query display all SNL institutionIds with restatements due to fiscal year changes.
Data Packages
Link The SNL InstitutionId To The Compustat GVKEY
Version Date:07/21/2022
This sample query link the SNL institutionId to the Compustat GVKEY.
Data Packages
Display Quarterly Total Assets For A Single Company
Version Date:07/21/2022
This sample query display quarterly total assets for a single company.
Data Packages
Display Latest Quarterly Total Assets Value For A Single Company
Version Date:07/21/2022
This sample query display latest quarterly total assets value for a single company.
Data Packages
Display InstitutionIds With Filings In The Last Week, Month, Or Year
Version Date:07/21/2022
This sample query display institutionIds with filings in the last week, month, or year.
Data Packages
Display A Single List For A Particular Company/Period Type
Version Date:07/21/2022
This sample query display a single list for a particular company/period type.
Data Packages
Link The SNL InstitutionId To The S&P Capital IQ CompanyId
Version Date:07/21/2022
This sample query link the SNL institutionId to the S&P Capital IQ companyId.
Data Packages
Returns Toyo Data: Industry-Company Composition
Version Date:07/20/2022
This sample query retrieve the Toyo data: Industry-company composition.
Data Packages
Returns Toyo Data: Main Company Attribute Data
Version Date:07/20/2022
This sample query retrieve the Toyo data: Main company attribute data.
Data Packages
Returns A Company's New Name
Version Date:07/20/2022
This sample query returns the Hewlett-Packard Company\x92s new name.
Data Packages
Returns Competitors Of A Company By Industry
Version Date:07/20/2022
This sample query returns competitors of United Technologies Corp. by Industry.
Data Packages
Returns The M/A Transaction Closings
Version Date:07/20/2022
This sample query returns the M/A Transaction closings where Boeing (BA) is the buyer.
Data Packages
Returns The Global Business Addresses For A Company
Version Date:07/20/2022
This sample query returns the global business addresses for Hewlett-Packard Co.
Data Packages
Returns All Alternate, Native And Search Company Names For A Given Company
Version Date:07/20/2022
This sample query returns all Alternate, Native and Search company names for Sony Corporation.
Data Packages
Returns The Companies That Have Defaulted On Debt
Version Date:07/20/2022
This sample query returns the companies that have defaulted on debt in the last two months.
Data Packages
Identify Auto Parts Companies Headquartered In The U.S. And With An Office In China Or Japan
Version Date:07/20/2022
This sample query Identify auto parts companies headquartered in the U.S. and with an office in China or Japan, including all business descriptions.
Data Packages
Returns U.S. Private Placement Transactions Closed In 2010
Version Date:07/18/2022
The following sample query returns U.S. Private Placement transactions that have closed in 2010 with Financial Institutions as investors (showing company relationships).
Data Packages
Returns Merger/Acquisition Activities Of IBM
Version Date:07/18/2022
The following sample query returns all Merger / Acquisition activities IBM has been involved with as Buyer or Seller in 2010 (showing company relationships).
Data Packages
Returns Transaction History For The Target Company
Version Date:07/18/2022
The following sample query returns all transaction history where Casey\x92s General Stores Inc. is the target, showing their advisors.
Data Packages
Returns Bankruptcies Announced In 2009 Or Later
Version Date:07/18/2022
The following sample query returns all bankruptcies announced in 2009 or later that have since emerged or reorganized (showing company relationships).
Data Packages
Returns MarketCap For Compustat GVKey IID
Version Date:07/02/2022
The following sample query provides historical to latest market cap as well as the currency for a given GVKey.
Data Packages
Returns List Of Property M&A Transactions
Version Date:06/09/2022
The following query generate a list of property M&A transactions for gold >500,000 ounces.
Data Packages
Rank Properties In North America In Development Stage
Version Date:06/09/2022
The following query rank properties that are in \x93Development Stage\x94, in North America that have a copper resource >500,000 tonnes (contained copper).
Data Packages
Returns List Of Properties
Version Date:06/09/2022
The following query returns list of properties based on commodity, total resource, grade & stage.
Data Packages
Returns List Of Metals & Mining Companies For Australia
Version Date:06/09/2022
The following query returns list of metals & mining companies with 2020 gold exploration budget for Australia >US$1M.
Data Packages
Returns All Security Level Identifiers
Version Date:06/07/2022
The following query returns all security level identifiers (CUSIP9, ISIN, SEDOL, CINS) for a private fund.
Data Packages
Returns Security Identifiers For A Company
Version Date:06/07/2022
The following query returns all security identifiers for a particular company.
Data Packages
Returns MSA Impact On Raw ESG Scores
Version Date:05/27/2022
The following SQL query returns MSA impact on raw ESG Scores for McDonald's Corporation for 2021 assessment.
Data Packages
Returns Estimated (Modeled) ESG Score Breakdown
Version Date:05/27/2022
The following SQL query returns estimated (modeled) ESG Score breakdown for NextEra Energy, Inc. for 2021 assessment.
Data Packages
Returns Historical Raw ESG Score Breakdown
Version Date:05/27/2022
The following SQL query returns historical raw ESG Score breakdown for NextEra Energy, Inc. for Last 5 Years.
Data Packages
Returns Estimated Modeled ESG Scores
Version Date:05/27/2022
The following SQL query returns estimated (modeled) ESG Scores for NextEra Energy, Inc. for 2021 Assessment.
Data Packages
Returns Industry Range And Averages Against Historical Raw ESG Score Performance
Version Date:05/27/2022
The following SQL query returns Industry Range and Averages against Historical Raw ESG Score Performance for NextEra Energy, Inc. (Last 5 Years).
Data Packages
Returns MSA Impact Details On Raw ESG Score Breakdown
Version Date:05/27/2022
The following SQL query returns MSA impact details on raw ESG Score breakdown for McDonald's Corporation for 2021 assessment.
Data Packages
Returns Industry Specific Dimension and Criteria Weights Trend For Last 5 Years
Version Date:05/27/2022
The following SQL query returns industry specific dimension and criteria weights trend for last 5 years.
Data Packages
Returns Historical Raw ESG Score Performance
Version Date:05/27/2022
The following SQL query returns historical raw ESG Score performance for NextEra Energy, Inc. for last 5 Years.
Data Packages
Cross Reference Query Linking GVKEY
Version Date:05/24/2022
The following sample query link the SNL institutionId to the Compustat GVKEY.
Data Packages
Display A Sample Of Multiple Restatement Data
Version Date:05/24/2022
The following sample query display a sample of multiple restatement data.
Data Packages
Return A Unique TIC, ISIN, CUSIP And SEDOL
Version Date:05/24/2022
The following sample query return a unique TIC, ISIN, CUSIP and SEDOL that represents the most recent public company for any given GVKEY.
Data Packages
Cross Reference Query Linking CIQ Company
Version Date:05/24/2022
The following sample query link the SNL institutionId to the S&P Capital IQ companyId.
Data Packages
Returns Latest Dividends
Version Date:04/19/2022
The following sample query returns latest dividend details.
Data Packages
Returns Dividend Details
Version Date:04/19/2022
The following sample query returns dividend details.
Data Packages
Returns GDP Growth Forecasts
Version Date:04/19/2022
The following sample query returns GDP Growth Forecasts.
Data Packages
Returns Fiscal Year Payments for a Given Company
Version Date:04/19/2022
The following sample query returns fiscal year payments for a company from the given year.
Data Packages
Returns US Versus China GDP Over Time
Version Date:04/19/2022
The following sample query returns US versus China GDP values.
Data Packages
Returns Long Term Interest Rates
Version Date:04/19/2022
The following sample query returns Long term interest rates.
Data Packages
Returns Cumulative Twelve Quarter R&D Spending With Linear Decay Weighting
Version Date:04/18/2022
The following SQL query returns the R&D Stock Factor where the dataitemid is 100 for R&D Expenses.
Data Packages
Returns YTD Total Return With Reinvested Dividends
Version Date:04/18/2022
The following SQL query returns the YTD total return with reinvested dividends.
Data Packages
Returns The Relative Strength Index
Version Date:04/04/2022
The following SQL query returns the Relative Strength Index for a specific company.
Data Packages
Returns The Instrument Level Details
Version Date:04/04/2022
The following SQL query returns the instrument level CreditPro data item name.
Data Packages
Returns Default And Ratings Transitions Of All Issuers
Version Date:04/04/2022
The following SQL query returns the default and ratings transitions of all issuers.
Data Packages
Returns Default And Ratings Transitions Of All Instrument Issues
Version Date:04/04/2022
The following SQL query returns the default and ratings transitions of all instrument issues.
Data Packages
Returns ESG Focused Financial Data Points
Version Date:02/28/2022
The following sample query returns ESG Focused Financial Data Points for General Electric Company.
Data Packages
Returns All The Details From Platform
Version Date:02/28/2022
The following sample query validates all the details from platform.
Data Packages
Returns Parent And Ultimate Parent Company
Version Date:02/28/2022
The following sample query returns parent and ultimate parent company for 'Valim' with industry id 2900.
Data Packages
Returns Environmental, Financial And Market Data Points
Version Date:02/28/2022
The following sample query returns Environmental, Financial and Market Data points for S&P 500 Electric Utilities Companies for Fiscal Year 2020.
Data Packages
Returns Availability Of Data From Which All Countries Or Regions
Version Date:02/28/2022
The following sample query checks availability of data from which all countries or regions.
Data Packages
Returns In Between Records When Subsidiarycompany Is The Ultimateparentcompany
Version Date:02/28/2022
The following sample query checks if there are any records in between where subsidiarycompany is the ultimateparentcompany.
Data Packages
Returns Annual Report Along With Metadata And Entity Name
Version Date:02/08/2022
The following sample query returns DIA 2017 Annual Report, along with the company name, filing language, source and type.
Data Packages
Returns Operational and Planned Datacenters by Period
Version Date:02/03/2022
The following sample query returns the number of operational and planned datacenters by period
Data Packages
Returns Datacenter Quarterly Power Supply and Usage
Version Date:02/03/2022
The following sample query returns datacenter quarterly power supply and usage.
Data Packages
Returns Datacenter Knowledgebase Regional Dashboard Values
Version Date:02/03/2022
The following sample query returns the datacenter knowledgebase regional dashboard
Data Packages
Returns Operational Datacenters By Country
Version Date:02/03/2022
The following sample query returns the number of operational datacenters by country as of Dec. 31st 2020
Data Packages
Returns Top 10 Total Operational Square Footage Current Market Share
Version Date:02/03/2022
The following sample query returns the top 10 total operational square footage current market share
Data Packages
Returns Global Data Snapshot
Version Date:02/03/2022
The following sample query returns the global view of data center knowledgebase metrics
Data Packages
Returns Ratings By LoanX ID
Version Date:01/20/2022
The following sample SQL query returns the issue level ratings for a LoanX ID from the SP Credit Ratings package in Xpressfeed
Data Packages
Returns Recovery Ratings By CUSIP
Version Date:01/20/2022
The following sample SQL query returns the most recent and previous Recovery Rating using a CUSIP as the identifier in Xpressfeed
Data Packages
Screens Rating Changes
Version Date:01/20/2022
The following sample SQL query returns a list of rating changes for a specific instrument type using the SP Capital IQ packages in Xpressfeed
Data Packages
Returns Ratings Data Using Maturity ID
Version Date:01/19/2022
The following sample SQL query returns ratings data using the MaturityID in Xpressfeed.
Data Packages
Returns Ratings Data Related To Triple Component Rating
Version Date:01/19/2022
The following sample SQL query returns the components of the Triple Component Rating, which is a combination of the long-term rating, Outlook or CreditWatch, and short-term rating
Data Packages
Returns Issuer Credit Rating On A Specific Date
Version Date:01/01/2022
The following sample SQL query returns an issuer credit rating on a specific date in Xpressfeed
Data Packages
Returns GI Entity Ratings Put on a Positive Creditwatch
Version Date:01/01/2022
The following sample SQL query returns all Global Issuer (GI) entity ratings put on a positive CreditWatch.
Data Packages
Returns Rating Data For Securities With An NR Rating
Version Date:01/01/2022
The following sample SQL query returns securities that have multiple rating types where one is NR while the other(s) are actively rated using the SP Capital IQ packages in Xpressfeed
Data Packages
Returns ISINs With Current Unsolicited Ratings
Version Date:01/01/2022
The following sample SQL query returns all ISINs that have a current Unsolicited Rating using the SP Capital IQ packages in Xpressfeed
Data Packages
Returns Underlying Rating For A Credit Program
Version Date:01/01/2022
The following sample SQL query returns entities with an underlying Rating for Credit Program in Xpressfeed.
Data Packages
Returns CP Ratings By CUSIP6
Version Date:01/01/2022
The following sample SQL query returns Commercial Paper (CP) ratings data and Maturity ID (maturityId) using the 6-digit CUSIP (CUSIP6) in Xpressfeed
Data Packages
Returns SecurityId, InstrumentId,EntityId From RatingDataId
Version Date:01/01/2022
The following sample SQL query returns securityId,instrumentId,entitySymbolValue from a ratingDataId in Xpressfeed
Data Packages
Returns Entity Level Ratings
Version Date:01/01/2022
The following sample SQL query returns the current Entity Level Issuer Credit Rating for a company with a non-null QualifierValue using the Capital IQ data tables in Xpressfeed
Data Packages
Returns S&P's and Moodys Ratings For A ISIN
Version Date:01/01/2022
The following sample SQL query returns both the SP Rating and the Moodys Rating for a specific ISIN in Xpressfeed.
Data Packages
Returns Ratings Universe For ISINs
Version Date:01/01/2022
The following sample SQL query returns the SP Global Ratings Sector and Instrument Type for an instrument for a set of ISINs using the Ratings v3 packages in Xpressfeed
Data Packages
Returns Sovereign Credit Ratings By Country Code
Version Date:01/01/2022
The following sample SQL query returns the current and historical sovereign ratings for a country using the country code from the CIQ Rating Country (ciqRatingCountry) table in Xpressfeed
Data Packages
Returns Preliminary Ratings
Version Date:01/01/2022
The following sample SQL query returns the current (ratingStatusIndicator = 1) Foreign Currency Preliminary LT (ratingTypeId = 276) and the Local Currency Preliminary LT (ratingTypeId = 278) ratings using the SP Capital IQ packages
Data Packages
Return IQ_BETA_5YR (Index) For CIQ Indices (S&P 500 Index or S&P/TSX Composite Index)
Version Date:12/16/2021
The following sample query calculate CIQ Indices '5 Year Beta' using input parameters CompanyId,ObservationDate and TradingitemID. Tags - BETA, IQ_BETA_5YR
Data Packages
Return IQ_BETA_1YR Or IQ_BETA_2YR (Index) For CIQ Indices (S&P 500 Index or S&P/TSX Composite Index)
Version Date:12/16/2021
The following sample query calculate CIQ Indices '5 Year Beta' using input parameters CompanyId,ObservationDate,Beta 1YR or 2YR and TradingitemID. Tags - BETA, IQ_BETA_1YR, IQ_BETA_2YR
Data Packages
Return IQ_BETA_1YR Or IQ_BETA_2YR (Index) For MSCI Indices (MSCI Eafe Index or MSCI Emerging Markets Index)
Version Date:12/16/2021
The following sample query calculate MSCI Indices '1 or 2 Year Beta' using input parameters CompanyId,ObservationDate,Beta 1YR or 2YR and TradingitemID. Tags - BETA, IQ_BETA_1YR, IQ_BETA_2YR
Data Packages
Returns Scores And Factors For BANK Score Group With Current Ratings
Version Date:12/02/2021
The following SQL include all Score data points with Score and Value Description as well as rating data including Org Debt Type = ICR, Entity Symbol Value, Entity Name, Rating, Rating Date, Outlook, Outlook Date, CreditWatch, CreditWatchDate.
Data Packages
Returns Scores For BICRA Scores
Version Date:12/02/2021
The following SQL returns scoreObjectSymbolValue, scoreDetailId, scoreObjectTypeId, scoreObjectName, scoreGroup, scoreType, scoreBusinessName, scoreValue, scoreValueDescription & scoreCurrentIndicator.
Data Packages
Returns Scores And Factors For BANK Score Group
Version Date:12/02/2021
The following SQL query returns all Score data points with Score and Value Description for â\x80\x98BANKâ\x80\x99 Score Group.
Data Packages
Returns Scores For Sovereign Scores
Version Date:12/02/2021
The following SQL returns scoreObjectSymbolValue, scoreDetailId, scoreObjectTypeId, scoreObjectName, scoreGroup, scoreType, scoreBusinessName, scoreValue & scoreCurrentIndicator.
Data Packages
Returns All Data Items Within The Balance Sheet
Version Date:12/02/2021
The following SQL query Display all data items within the Balance Sheet - Adjusted template organized by section.
Data Packages
Returns Companies And Fiscal Periods Updated Within A Given Date Range
Version Date:12/02/2021
The following SQL query returns the companies and fiscal period between a given date range.
Data Packages
Returns All Data Items Associated With S&P CreditStats
Version Date:12/02/2021
The following SQL query generates data items associated with each S&P CreditStats Package. The dataItemGroupId corresponding to each package is provided in the commented text.
Data Packages
Identify Investor Exit Details Of Private Equity Buyout Deals
Version Date:11/30/2021
The following sample query returns Investor Exit Details Of Private Equity Buyout Deals
Data Packages
Returns LTM Net Income Values For A Company For All The Calendar Month
Version Date:11/19/2021
The following sample query retrieves LTM Net Income month-end entries for every month of the calendar, filling in the dataItemValue with the latest figure.
Data Packages
Forcast More Than 50 Percent Of High Risk Of Water Stress For Global Branches Of A Company
Version Date:11/17/2021
The following sample query returns global branches for JP Morgan Chase Bank at over 50 percent high risk of Water Stress for forecast year 2030.
Data Packages
Returns Power Plant Sites Of S&P 500 Electric Utility Companies
Version Date:11/17/2021
The following sample query returns Power Plant Sites of S&P 500 Electric Utility companies at medium risk scenario of Wildfire for forecast year 2050.
Data Packages
Returns Business Segment Revenue Along With NAIC, SIC And GICS Classifications For A Specific Period End Date
Version Date:11/11/2021
The following sample query retrieves a specific company's business segment revenue for a specific period end date, along with the primary NAIC, SIC & GICS classification.
Data Packages
Linking Preqin Private Equity Rel Package For Sponsored Fund
Version Date:10/25/2021
The following sample query identifies all the current and prior funds sponsored by BMO Fund Management Limited.
Data Packages
Linking Preqin M&A Deals To CIQ Transactions Offering Packages
Version Date:10/25/2021
The following sample query returns the currencyId, announcedDate, identifierValue, etc by linking preqin M&A deals to CIQ Transactions offering packages.
Data Packages
Linking Preqin Private Equity Rel Package With Preqin Identifier For Fund Investor
Version Date:10/25/2021
The following sample query identifies Current, Prior and cancelled fund investors of Shanghai Liansheng Venture Fund.
Data Packages
Linking Preqin Private Equity Rel Package For Fund Investors
Version Date:10/25/2021
The following sample query identifies Current, Prior and cancelled fund investors of SA Corporate Real Estate Limited.
Data Packages
Linking Preqin Deals To CIQ Transactions Offering Packages
Version Date:10/25/2021
The following sample query returns the currencyId, announcedDate, identifierValue, etc by linking preqin deals to CIQ Transactions offering packages.
Data Packages
Linking Preqin Deals To MI Transactions Rounds Of Funding Package
Version Date:10/25/2021
The following sample query returns the currencyCode, amountOffered, identifierValue, etc by linking preqin deals to MI Transactions Rounds of Funding package.
Data Packages
Linking Preqin Private Equity Rel Package With Preqin Identifier For Sponsored Fund
Version Date:10/25/2021
The following sample query identifies all the current and prior funds sponsored by Yamaguchi Capital.
Data Packages
Returns RXtoV4 LoanX_ID Lookup To Issuer Rating
Version Date:10/01/2021
The following sample query returns the rating and entitylevel data for the given LoanX symbol.
Data Packages
Returns RXtoV4 Instrument GISF Current_Assessment
Version Date:10/01/2021
The following sample query returns the current GISF rating for the Instrument based on Recordupdatedate given by the EntityIssuer and the associated long term and short term assessment view.
Data Packages
Returns RXtoV4 Instrument GISF Current
Version Date:09/30/2021
The following sample query returns the current GISF rating for the Instrument based on Recordupdatedate given by the EntityIssuer and the associated long term view.
Data Packages
Returns RXtoV4 Entity GISF Current_Assessment
Version Date:09/30/2021
The following sample query returns the current GISF Entity rating based on Recordupdatedate and long term and short term assessment view.
Data Packages
Returns RXtoV4 Security GISF Current_Assessment
Version Date:09/30/2021
The following sample query returns the current GISF Assessment Rating for the security based on Recordupdatedate given by the EntityIssuer and the associated ratingtype, maturitydate, currentcytype, etc.
Data Packages
Returns RXtoV4 Entity GISF Current
Version Date:09/29/2021
The following sample query returns the current GISF rating for the Entity based on Recordupdatedate and the associated ratingdate, creditwatchdate, outlookdate, etc.
Data Packages
Returns RXtoV4 Security GISF Current
Version Date:09/23/2021
The following sample query returns the current GISF rating for the security based on Recordupdatedate given by the EntityIssuer and the associated ratingtype, maturitydate, currentcytype, etc.
Data Packages
Returns S&P, Moody's And Fitch Ratings
Version Date:09/23/2021
The following sample query returns S&P, Moody's and Fitch Ratings with issuer number for the specific CompanyID
Data Packages
Returns Entity Level Data With Respective CompanyIDs
Version Date:09/23/2021
The following sample query returns Entity Name with respective CompanyIDs mapped to SIC and NAICS codes
Data Packages
Returns RecordUpdateDate for Entity, Instrument And Security Symbol Values
Version Date:09/23/2021
The following sample query returns RecordUpdateDate for specific Entity, Instrument And Security Symbol Values along with currentratingsymbol
Data Packages
Returns Private Companies With Over 75% Of Their Revenue (As A Percentage Of The Total Revenue) Generated By Activities In Crude Petroleum And Natural Gas Extraction Sector
Version Date:09/22/2021
Returns Private Companies With Over 75% Of Their Revenue (As A Percentage Of The Total Revenue) Generated By Activities In Crude Petroleum And Natural Gas Extraction Sector
Data Packages
Returns Intensity Metrics For Jaguar Land Rover Automotive Plc
Version Date:09/22/2021
Returns Intensity Metrics For Jaguar Land Rover Automotive Plc
Data Packages
Returns Companies That Mentioned Boeing In Their Earnings Calls In The First Calendar Quarter of 2021
Version Date:09/21/2021
The following sample query returns companies that mentioned Boeing in their earnings calls in the first calendar quarter of 2021 unsing Nerd on Transcripts. Confidence scores are limited to > .93 on the latest transcript.
Data Packages
Returns All Companies Mentioned By IBM On Their Call Alongside The Call Text
Version Date:09/21/2021
The following sample query returns all companies mentioned by IBM on their call, alongside the call text using NERD on Transcripts
Data Packages
This Query Returns The Quarterly Estimates That Have Changed In The Last 24 Hours
Version Date:09/07/2021
This query returns the quarterly broker estimates for the upcoming quarter that have changed in the last 24 hours based on observation date.
Data Packages
Counts Unique Trademark IPIDs Grouped By NiceClassID
Version Date:09/07/2021
The following sample query counts unique trademark ipIds and groups them by niceClassID.
Data Packages
Counts Unique Patent IpIds And Groups Them Under Specific Patent Classes
Version Date:09/06/2021
The following sample query counts unique patent ipIds and groups them under patent classes containing a description with the phrase 'Golf'.
Data Packages
Returns Broker Recent Changes
Version Date:09/03/2021
The following query returns the recent changes for the companies by the Brokers.
Data Packages
The Following Sample Request Will Retrieve The Expanded Probability Of Default (EPD) Scores
Version Date:08/30/2021
The following sample request will retrieve the Expanded Probability of Default (EPD) scores for General Motors Holdings LLC for the fiscal year 2019, latest as of July 30, 2021, using the new threshold property.
Data Packages
The Following Sample Request Will Retrieve The Sovereign Risk inclusive Of Probability Of Default Scores In The RiskGauge Model
Version Date:08/30/2021
The following sample request will retrieve the Sovereign Risk inclusive of Probability of Default scores in the RiskGauge model for International Business Machines Corporation (NYSE:IBM) for the months January through August 20, latest as of August 20, 2021.
Data Packages
Returns Unconsolidated And Consolidated Income Statement Data For A Company
Version Date:08/10/2021
The following sample SQL query pulls consolidated and unconsolidated Financials income statement data.
Data Packages
Returns Unconsolidated And Consolidated Income Statement Data For A Company Side By Side
Version Date:08/10/2021
The following sample SQL query pulls consolidated and unconsolidated income statement data side by side
Data Packages
Returns Industry/Verticals That Are Tied To An Asset For Funds, Firms, And Service Providers (Strategies, Geographies, Sources Of Capital, Sub-industries)
Version Date:07/15/2021
The following query shows additional information related to a company in an asset classe(Funds, Firms, and Service Providers). Note: Change the prqDescriptorId to view strategies, geographies, sources of capital,sub-industries (and many more more.) Change the prqFirmId as needed, currently it runs for Marqeta, Inc.
Data Packages
Returns CRM Private Equity Company Profile Module (Bite Size)
Version Date:07/10/2021
The following sample query gives bite size information of a particular company. Note: Change the companyId as needed, currently it runs for Bain Pvt Equity,LP.
Data Packages
Returns CRM General Financials Module
Version Date:07/10/2021
The following sample query shows generic information related to a company financials for the last 5 periods (starting from current date) along with market capitalization. Note: Change the companyId as needed, currently it runs for IBM.
Data Packages
Returns CRM Private Equity Company Profile Module (Industry, Investment Style and Transaction Types)
Version Date:07/10/2021
The following sample query shows industries of interest,investment styles and transaction types of a particular company. Note: Change the companyId as needed, currently it runs for Bain Pvt Equity,LP.
Data Packages
Returns CRM Company Relationship Module (Competitors)
Version Date:07/10/2021
The following sample query returns all current competitors and its headquarters of a parent company along with the total revenue reported and converted to USD of the competitor companies. Note: Change the parent companyId as needed, currently it runs for Apple.
Data Packages
Returns CRM Company Relationship Module (Subsidiaries)
Version Date:07/10/2021
The following sample query returns all current subsidiaries and its headquarters of a parent company along with the total revenue reported and converted to USD of the subsidiary companies. Note: Change the parent companyId as needed, currently it runs for IBM. For current investment change the companyRelTypeId=1
Data Packages
Returns CRM People Profile Module (Board Member)
Version Date:07/10/2021
The following sample query returns all board members related to a company and his/her title and board rank. Note: Change the parent companyId as needed, currently it runs for IBM.
Data Packages
Returns CRM Company Profile Module
Version Date:07/10/2021
The following sample query shows generic information related to a company along with previous day market cap, latest EBITDA and Total Revenue for most recent Fiscal Year. Note: Change the companyId as needed, currently it runs for IBM.
Data Packages
Rolling Sharpe Ratio RFR For A Given Hedge Fund
Version Date:06/30/2021
The following sample query returns the Rolling Sharpe ratio RFR 2% (since inception, 1Y, 2Y, 3Y and 5Y) for a given hedge fund
Data Packages
Rolling Volatility For A Given Hedge Fund
Version Date:06/30/2021
The following sample query returns Rolling volatility (1Y, 2Y, 3Y and 5Y) for a given hedge fund
Data Packages
Obtain Financial Data For A Private Company
Version Date:06/07/2021
This query returns the financial information for Celio España Moda Sa, a private company.
Data Packages
Obtain Consolidated And Non-Consolidated Revenues
Version Date:06/07/2021
This query returns the consolidated revenues where available, otherwise the query generates non-consolidated values.
Data Packages
Identify Data Items Associated With Private Company Financials Packages
Version Date:06/07/2021
This query returns the data items associated with each Private Company Financials package.
Data Packages
Returns The Value Of Restricted Stock Units Granted.
Version Date:05/27/2021
The following sample query returns the value of restricted stock units granted by current S&P500 index constituents in fiscal year 2020.
Data Packages
All Possible GICS Codes And Descriptions Reference Query
Version Date:05/21/2021
The following sample query returns all possible GICS Codes and descriptions. Tag: CoInd
Data Packages
S&P Capital IQ Industry Tree For AT&T
Version Date:05/21/2021
The following sample query returns the S&P Capital IQ industry tree for AT&T. Tag CoInd
Data Packages
GICS Code And Description For Intel Corp
Version Date:05/21/2021
The following sample query returns the GICS code and description for Intel Corp. Tag: CoInd
Data Packages
S&P Capital IQ Industry Classification Reference
Version Date:05/21/2021
The following sample query returns all possible industries in the S&P Capital IQ industry classification. Tag: CoInd
Data Packages
API Corporate Yield Curve Annual Values
Version Date:05/07/2021
This JSON request is using the mnemonic 'IQ_Z_CURVE_ANNUAL_DESC' with GDSPV as a function. This function retrieves an array (a set of values) for the most current availability of content either end of day or intraday. The applicable properties to use with the GDSPV are sector and rating. The output of this metric describes characteristics of the curve itself. The output columns include: 1. Number of Bonds, 2. Number of Credits, 3. Either 'Observed' or 'Derived', 4. Standard Deviation, and 5. Valuation Date.
Data Packages
API JSON Direct (JSON/REST) API Access Method
Version Date:05/07/2021
The above JSON request using mnemonic 'IQ_FULL_CURVE_ANNUAL' with GDSP as a function will retrieve the Sector based yield curve compounded annually. The applicable properties to use along with GDSP function are StartDate and tenor. The max tenor value you can pass is 30Y (30 Year tenor).
Data Packages
API Request Corporate Yield Transparency Data
Version Date:05/07/2021
The above JSON request using mnemonic 'IQ_CURVE_TRANSPARENCY' with GDSHV and applicable properties StartDate, EndDate, Sector and Energy will retrieve: 1.ISIN, 2. DerivedBondPrice, 3. ZSpread, 4. ValuationDate, 5. MaturityDate, and 6. IssuerName.
Data Packages
API Request Corporate Yield Historical Data
Version Date:05/07/2021
The above JSON request using mnemonic 'IQ_DISCOUNT_FACTOR_CURVE' with GDST function will retrieve the historical values for a mnemonic over a range of dates. Using the GDST function, the applicable properties to use are StartDate, EndDate and Frequency.
Data Packages
Returns Annual Report For Non-SEC Filings Company
Version Date:05/04/2021
The following sample query returns Roche Holding AG Company (Non-SEC Filings) 2019 Annual Report.
Data Packages
Return All The Data Items Delivered In The Trucost Climate Change Physical Risk Data Packages
Version Date:04/22/2021
Return All The Data Items Delivered in The Trucost Climate Change Physical Risk Data Packages
Data Packages
Returns Carlyle Group Firm Strategy
Version Date:04/15/2021
The following sample query returns the main strategy for Carlyle Group by joining it with relevant lookup table.
Data Packages
Returns Credit Model Score And Implied PD For A Company.
Version Date:04/07/2021
The following sample query returns CreditModel Score and Implied PD for IBM for a specific period (Q1-2017Y).
Data Packages
Returns PD Fundamentals Index Benchmark Data
Version Date:04/07/2021
The following sample query returns latest Index-based Median Fundamental PD and Implied Score for USA - Oil & Gas
Data Packages
Returns Current PD Values Together With Daily Stock Price
Version Date:04/07/2021
The following sample query returns IBM\x92s current PD values together with its daily stock price.
Data Packages
Returns Non Financial Data
Version Date:04/07/2021
The following sample query returns latest Corporate Industry Risk Score for USA - Oil & Gas. Note: Uncomment the second query to get the latest Country Risk Score and Banking Economic Risk Score for USA.
Data Packages
Returns PD Fundamentals Country Industry Benchmark Data
Version Date:04/07/2021
The following sample query returns latest Country Industry based on the Median Fundamental PD and Implied Score for USA - Oil & Gas
Data Packages
Returns PD Market Signals Country Industry Benchmark Data
Version Date:04/07/2021
The following sample query returns country industry based on the Median Market Signal PD and Implied Score for USA - Oil & Gas
Data Packages
Returns PD Based Market Signal For A Company
Version Date:04/07/2021
The following sample query returns IBMâ\x80\x99s PD-based Market Signal.
Data Packages
Returns Local Scales Data (Score value )
Version Date:04/07/2021
The following sample query returns local score from Global Metric Score value (CATypeId - 101)
Data Packages
Returns Credit Model Country Industry Benchmark Data
Version Date:04/07/2021
The following sample query returns the latest Country Industry based on the Median Credit Model Score and Implied PD for USA - Oil & Gas
Data Packages
Transaction Data Items
Version Date:03/29/2021
The following sample SQL query returns the Transaction Data Items
Data Packages
Risk Factor Section From All Available 10-K Filings For a Company
Version Date:03/29/2021
The following sample query returns risk factor section (Item 1a) from all available 10-K filings for a company.
Data Packages
Returns Institution (Humana, Inc.) 2017 10-K Filing
Version Date:03/29/2021
The following sample query below returns Humana, Inc. 2017 10-K Filing
Data Packages
Returns PE Fund Service Providers And Service Type
Version Date:03/15/2021
The following sample query returns PE Fund service providers and service type
Data Packages
Returns Buyout Or Venture Capital Deals That Carlyle Group Participated As A Seller Or Buyer Since 2015
Version Date:03/15/2021
The following sample query returns buyout/ venture capital deals Carlyle Group participated as a Seller or Buyer since 2015
Data Packages
Returns Funds By Fund Size And Their Fund Managers
Version Date:03/15/2021
The following sample query returns top 10 PE\\VC funds by fund size (millions) and their Fund managers
Data Packages
Returns Funds Time Series, Benchmark Median IRR By NetIRRPct
Version Date:03/15/2021
The following sample query returns top 10 funds time series, benchmark median IRR by netIRRPct
Data Packages
Returns Net Cash Flow For A Fund
Version Date:03/15/2021
The following sample query returns net cash flow for West Street Capital Partners VII
Data Packages
Returns Investors Commitment To PE Funds
Version Date:03/15/2021
The following sample query returns investors commitment to PE funds, committed amount in millions
Data Packages
Returns Mapping Of S&P Institution ID To Preqin Firm ids And Fund Ids
Version Date:03/15/2021
The following sample query returns mapping of S&P institution ID to Preqin Firm id's and fund id's
Data Packages
Returns Statistic Time Series Data For Fund Managers And Investors
Version Date:03/15/2021
The following sample query returns statistic time series data for fund managers and investors
Data Packages
Returns Tonnes CO2e Over 2 Degree Budget
Version Date:03/10/2021
The following sample query returns tonnes CO2e over 2 degree budget and current alignment for S&P 500 companies in decreasing order
Data Packages
Returns Region, Country, and GICS Industry Group
Version Date:03/10/2021
The following sample query returns Region, Country and GICS Industry Group Based Count of Companies for Different Alignment Types
Data Packages
Returns Company Carbon Emission Alignment
Version Date:03/10/2021
The following sample query returns Company Carbon Emission Alignment for Exxon Mobil Corporation
Data Packages
Returns Paris Alignment FTP Data for Sample Companies for 2018
Version Date:03/10/2021
The following sample query returns Paris Alignment FTP data for sample companies for 2018 annual report year
Data Packages
Returns CSA Companies And Their Primary CIQ Industries
Version Date:02/26/2021
The following sample query ties CSA companies to CIQ Primary Industry.Note: Company Full Industry is a separately licensed product.
Data Packages
Returns Companies Having Unpriced Carbon Cost As A Percent Of EBITDA In Excess Of 50 Percent
Version Date:01/18/2021
The following sample query returns S&P 500 companies having unpriced carbon cost as a percent of EBITDA in excess of 50% for forecast year 2040, all scenarios
Data Packages
Returns Total Unpriced Carbon Cost
Version Date:01/18/2021
The following sample query returns total unpriced carbon cost for S&P 500 companies for forecast year 2030, scenario level LOW
Data Packages
Returns Data Items In The Trucost Carbon Earnings At Risk Data Package
Version Date:01/18/2021
The following sample query returns data items in the Trucost Carbon Earnings at Risk data package.
Data Packages
Returns Region And Country Based Count Of Companies With EBIT At Risk For Forecast Year 2025
Version Date:01/18/2021
The following sample query returns region- and country-based count of companies with EBIT at risk for forecast year 2025, scenario level HIGH
Data Packages
Returns EBITDA As Risk For The Electric Utilities Companies
Version Date:01/18/2021
The following sample query returns EBITDA as risk for the S&P 500 electric utilities companies for all forecast years, scenario level HIGH
Data Packages
Reconstructs Carbon Earnings At Risk FTP Data
Version Date:01/18/2021
The following sample query reconstructs Carbon Earnings at Risk FTP data for sample companies for 2019 financial year
Data Packages
Returns Government Issued Govt. Bonds Owned By Berkshire Hathaway
Version Date:01/06/2021
The following sample query returns government issued govt. bonds owned by Berkshire Hathaway and reported in 2018 and 2019
Data Packages
Returns The Information About The Annual Flow Data
Version Date:01/06/2021
The following sample query returns information about the annual flow data of Berkshire Hathaway Direct Insurance Company
Data Packages
Returns Contract Details Of The Northern Natural Gas Company Reported In 2020 With The Interconnect Natural Gas Facility
Version Date:01/06/2021
The following sample query returns Contract Details Of The Northern Natural Gas Company Reported In 2020 With The Interconnect Natural Gas Facility
Data Packages
Returns Comparables For Properties Within Thailand By Commodity, Stage, Mining And Processing Methods
Version Date:01/06/2021
The following sample query returns comparables for properties within Thailand by commodity, stage, mining and processing methods, etc.
Data Packages
Returns All Filings Companies Under The Ultimate Parent Travelers Companies Inc With Disposition
Version Date:01/06/2021
The following sample query returns all filings companies under the ultimate parent travelers companies Inc with disposition as Of 2018 and 2019
Data Packages
Returns Amounts Payable On Assumed Losses And LAE Which Have Been Recognized As Paid By The Ceding Company
Version Date:01/06/2021
The following sample query returns amounts payable on assumed losses and LAE which have been recognized as paid by the ceding company in 2019 where Reinsurer is Berkley insurance company
Data Packages
Returns 7 Day Gas Trading Volume For Chicago Trading Hub
Version Date:01/06/2021
The following sample query returns 7 Day gas trading volume for Chicago trading hub
Data Packages
Returns Yearly Average CO2 Emissions And Gross Generations Of All Powerplants
Version Date:01/06/2021
The following sample query returns yearly average CO2 emissions and gross generations of all powerplants in Texas
Data Packages
Returns All Bonds And Stocks Disposed By New York Life Insurance
Version Date:01/06/2021
The following sample query returns All Bonds And Stocks Disposed By New York Life Insurance since 2018
Data Packages
Returns Companies Under Berkshire Hathaway And Their Distribution Channels, Auditors And Actuaries
Version Date:01/06/2021
The following sample query returns Companies Under Berkshire Hathaway And Their Distribution Channels, Auditors And Actuaries
Data Packages
Returns Receivables Of All Companies
Version Date:01/06/2021
The following sample query returns receivables of all Companies in Texas for the last two fiscal years
Data Packages
Returns Average Subscribers For National Geographics TV Network
Version Date:01/06/2021
The following sample query returns average subscribers for national geographics TV network
Data Packages
Daily Average Temperature, Compared To Climatology Min, Avg, Max Values For A Given Location
Version Date:01/03/2021
The following sample query returns daily average temperature, compared to Climatology min, avg, max values for a given location', "Note First 'from' must be a leap year (366 days)
Data Packages
Total Return Using Market Data
Version Date:12/22/2020
The following sample query returns the total return in descending date order from the SP Capital IQ Market Data for company ID 112350 (IBM). The return period can be adjusted by changing the lookback period in the last line of the script.
Data Packages
API Request Pulls Companies Direct Relationships - Company Intelligence
Version Date:12/17/2020
API request pulls companies direct relationships. To see additional relationships(Example. SGPI's subsidiaries' hierarchy) please extend EndRank to a max level of 8. We recommend to use 1 identifier at a time as the response size for a corporate tree can be very large and may cause the API to time out.
Data Packages
API Request Pulls 1 Year Forward Looking Total Revenue And Earnings - Estimates
Version Date:12/17/2020
This API request pulls 1 year forward looking total revenue and earnings per share using relative period type with integer offset to set fiscal period.
Data Packages
API Request To Return Business Entity Cross Reference Service (BECRS)
Version Date:12/17/2020
API request to request BECRS data points with GDSPV. When requesting identifier mapping mnemonics, please reference active and primary flags
Data Packages
API Request Pulls 2 Years Looking Forward Detailed Contributor And Their Related Revenue Estimates
Version Date:12/17/2020
API Request pulls 2 years looking forward detailed contributor and their related revenue estimate. This request uses relative period type with integer offset to set fiscal period. Relative Ranking: This data set experiences relative ranking. Each field in a relative ranking data set is related. JSON array return object Row[0] of IQ_DATASET_NAME is related to JSON array return object Row[0] of IQ_DATASET_VALUE.
Data Packages
API Request To 1st Request All Unique Key Dev Event Identifiers That Are Related To C2
Version Date:12/15/2020
API request to 1st request all unique key dev event identifiers that are related to C2 - Announced or Completed Transactions for the last year. Then request key development data points for the specified event.
Data Packages
API Request To Return The Top 10 Holders Of The Passed In Identifier
Version Date:12/15/2020
API request to return the top 10 holders of the passed in identifier with the associated holder company name. The ranking is always current ranked by value. As ownership can change over time this output will contain all line item names, ranked by most recent, that we have for the company since it's inclusion into the data set. If historical values are required, please use PeriodType to pull a different year. Once a historical value is pulled the rank returned in the result aray is still current. Therefore, the actual quantitive values like a revenue figure will have no order in the array. The values must be searched for and extracted. If all holders are required, please set EndRank to highest value supported. Relative Ranking: This data set experiences relative ranking. Each field in a relative ranking data set is related. JSON array return object Row[0] of IQ_DATASET_NAME is related to JSON array return object Row[0] of IQ_DATASET_VALUE.
Data Packages
API Request To 1st Map CIQ Id To BECRS Entity Rx Id
Version Date:12/15/2020
API request to 1st map CIQ id to BECRS Entity Rx id, then to request Issuer, local currency long term ratings. Please note, you must extract the primary and active RX id out of BECRS_ENTITY_RX and prefix a RX to the id returned prior to requesting the rating mnemonic.
Data Packages
API Request To Pull Time Series Exchange Rates For The Last Year
Version Date:12/15/2020
API request to pull time series exchange rates for the last year. All data is EOD. Identifiers supported are all ISO Currency Codes combinations.
Data Packages
API Request To 1st Request The Last 10 Unique Transaction Identifiers
Version Date:12/15/2020
API request to 1st request the last 10 unique transaction identifiers then request transaction data points for the specified transaction.
Data Packages
Global Instruments Cross Reference Service (GICRS)
Version Date:12/15/2020
API request to request GICRS data points with GDSPV. When requesting identifier mapping mnemonics, please reference active and primary flags.
Data Packages
API Request Pulls Current Total Revenue And Total Assets
Version Date:12/15/2020
This API request pulls current total revenue and total assets values using relative period type
Data Packages
API Request To Pull Equity Time Series Pricing Data
Version Date:12/15/2020
API request to pull equity time series pricing data. All data is EOD
Data Packages
API Request To Pull Last 10 Fiscal Year End Periods For Total Revenue
Version Date:12/15/2020
API request to pull last 10 fiscal year end periods for total revenue, total assets and Filing Date. This request uses relative period type with an integer offset to control the number of periods returned and aligns perioddate with filing date with the MetaDataTag property.
Data Packages
API Request To Return The Top 10 Professionals Of The Passed In Identifier
Version Date:12/15/2020
API request to return the top 10 Professionals of the passed in identifier with the associated professional title. The ranking is always current ranked by value. No history available. Relative Ranking: This data set experiences relative ranking. Each field in a relative ranking data set is related. JSON array return object Row[0] of IQ_DATASET_NAME is related to JSON array return object Row[0] of IQ_DATASET_VALUE.
Data Packages
API Request To Pull Geographical Segment Revenue
Version Date:12/15/2020
API request to pull Geographical Segment Revenue with associated geographical segment name. As segments can change over time this output will contain all segment names, ranked by most recent, that we have for the company since it's inclusion into the data set. If historical values are required, please use PeriodType to pull a different year. Once a historical value is pulled the rank returned in the result aray is still current. Therefore, the actual quantitive values like a revenue figure will have no order in the array. The values must be searched for and extracted. Relative Ranking: This data set experiences relative ranking. Each field in a relative ranking data set is related. JSON array return object Row[0] of IQ_DATASET_NAME is related to JSON array return object Row[0] of IQ_DATASET_VALUE.
Data Packages
API Request To Pull As-Presented Revenue With Associated Financial Line Item Name
Version Date:12/15/2020
API request to pull as-presented Revenue with associated financial line item name. As line item names can change over time this output will contain all line item names, ranked by most recent, that we have for the company since it's inclusion into the data set. If historical values are required, please use PeriodType to pull a different year. Once a historical value is pulled the rank returned in the result aray is still current. Therefore, the actual quantitive values like a revenue figure will have no order in the array. The values must be searched for and extracted. Relative Ranking: This data set experiences relative ranking. Each field in a relative ranking data set is related. JSON array return object Row[0] of IQ_DATASET_NAME is related to JSON array return object Row[0] of IQ_DATASET_VALUE.
Data Packages
Returns PIT Premium Financials Translated To USD
Version Date:12/04/2020
The following sample SQL query returns PIT Premium Financials Translated To USD using the Premium Financials Package NOTE: To run for full universe, comment out the companyId.
Data Packages
Returns Securities Excluding REITs, Mutual Funds And ETFs
Version Date:12/01/2020
The following sample query returns securities excluding REITs, Mutual Funds, and ETFs using the SP Capital IQ packages in Xpressfeed
Data Packages
Returns CIQ Equities Trading On U.S Exchanges
Version Date:12/01/2020
The following sample query returns all equities trading on a U.S. stock exchange using the SP Capital IQ tables in Xpressfeed
Data Packages
Returns Data Item Names And Definitions
Version Date:12/01/2020
The following sample query returns the SP Capital IQ data item name and definition for the Data Item IDs 4220 - 4233
Data Packages
Returns List Of Groups Containing Specified Data Items
Version Date:12/01/2020
The following sample query returns all of the data groups (packages) that a data item is located in and the SP Capital IQ Excel Plug-In Formula (CIQ Plug-In ID) in Xpressfeed
Data Packages
Returns Currency Name For A Trading Item ID
Version Date:12/01/2020
The following sample query returns the currency name and currency ID for IBM (tradingitemid = 2621697) using the SP Capital IQ packages in Xpressfeed
Data Packages
Returns Primary Industry
Version Date:12/01/2020
The following sample query returns the Primary Industry Classification Simple Industry level (3rd level) for a company using the SP Capital IQ Company Foundation schema in Xpressfeed
Data Packages
Returns CIQ Unquoted Securities
Version Date:12/01/2020
The following sample query returns securities from the S&P Capital IQ population where the exchangeSymbol contains UNQ or where the exchangeName contains Unquoted in Xpressfeed
Data Packages
Returns CIQ Primary Identifiers By Ticker
Version Date:12/01/2020
The following sample query returns the primary identifiers for a company by using the companys ticker symbol using the S&P Capital IQ Base Security and GICRS Identifier packages in Xpressfeed
Data Packages
Returns Securities and Exchange Commission (SEC) Central Index Key (CIK)
Version Date:12/01/2020
The following sample query returns the U.S. Securities and Exchange Commission (SEC) Central Index Key (CIK) for a company from the Capital IQ tables in Xpressfeed
Data Packages
Returns Current Profile For A DeletedObjectID
Version Date:12/01/2020
The following sample query returns the current profile for a deletedObjectID
Data Packages
Returns Number OF Companies By Country And Region
Version Date:12/01/2020
The following sample query returns the number of companies comprising the database population by country and region using the SP Capital IQ tables in Xpressfeed
Data Packages
Returns First Instance Of The Fully Matching HS Code For A Given PanjivaRecordId
Version Date:11/23/2020
The following sample query displays the first instance of the fully matching HS Code for a given panjivaRecordId
Data Packages
Returns Company And Ultimate Parent
Version Date:11/23/2020
The following sample query displays a companys ultimate parent in S&P Capital IQ data
Data Packages
Returns Three Levels Of An HS Code
Version Date:11/23/2020
The following sample query displays all three levels of an HS Code in order to create a full six digit view
Data Packages
Returns Aggregate shipments by port of unlading, HS Code, and consignee
Version Date:11/23/2020
The following sample query displays aggregate shipments by port of unlading, HS Code, and consignee. It displays associated weights and shipment counts
Data Packages
Links Trade Data To Market Intelligence Sector Data
Version Date:11/23/2020
The following sample query links Panjiva trade data to S&P Global Market Intelligence industry sector data
Data Packages
Returns Time Series Of Trade For A Given Country Pair and HS Code
Version Date:11/23/2020
The following sample query returns time series of trade for a given country pair & HS Code
Data Packages
Data In Countries That Do Not Have A Data Source
Version Date:11/23/2020
The following sample query finds data in countries that do not have a data source
Data Packages
Links Panjiva Identifiers To Capital IQ Data
Version Date:11/23/2020
The following sample query links Panjiva identifiers to S&P Capital IQ data. Note: Here TOP 100 are shown for better query execution
Data Packages
Returns All Levels Of HS Code By Category
Version Date:11/23/2020
The following sample query displays all levels of HS Code by category
Data Packages
Returns Magnitude Of Restatements Within 500 Days
Version Date:11/18/2020
The following sample SQL query returns magnitude of restatements of Total Revenues within 500 days of original filings region wise. NOTE: Here it is only done for company, for a larger universe it will take some time to run.
Data Packages
Returns MDS Value, MDS-Z Score and PD Based MDS
Version Date:10/29/2020
The following sample query returns the Market Derived Signal (MDS) value, MDS Z-Score, Probability of Default (PD)-based MDS Value, and PD-based MDS Z-Score for a company using the SP Capital IQ Market Derived Signals and Credit Default Swaps Package in Xpressfeed
Data Packages
Returns Market Derived Signals Data
Version Date:10/29/2020
The following sample query returns market derived signals data for a company using the SP Capital IQ Market Derived Signals and Credit Default Swaps Package in Xpressfeed
Data Packages
Returns Credit Default Swaps 5 Year Mid For A Company
Version Date:10/29/2020
The following sample query returns credit default swaps 5-year mid for a company using the SP Capital IQ Market Derived Signals and Credit Default Swaps Package in Xpressfeed
Data Packages
Returns Credit Default Swaps Data
Version Date:10/29/2020
The following sample query returns credit default swaps data for a company using the SP Capital IQ Market Derived Signals and Credit Default Swaps Package in Xpressfeed
Data Packages
Returns 52 weeks high and low Prices
Version Date:10/27/2020
The following sample query returns the 52-week high price and the 52-weel low price for SBUX (TID:2654392) using the ciqpriceEquity table in Xpressfeed
Data Packages
Returns Pricing By Ticker Symbol
Version Date:10/27/2020
The following sample query returns all pricing data in descending date order from the SP Capital IQ CIQPriceEquity table for the ticker PGF (PowerShares Financial Preferred)
Data Packages
Returns Market Capitalization For Non-U.S Shares
Version Date:10/27/2020
The following sample query returns the market capitalization for the non-U.S. shares when they are the primary issue of stock
Data Packages
Returns Market Capitalization For A Company
Version Date:10/27/2020
The following sample query returns the market capitalization for a company for the most recent period using the SP Capital IQ tables in Xpressfeed
Data Packages
Returns Dividend Adjusted Prices
Version Date:10/27/2020
The following sample query calculates the dividend-adjusted price time-series for IBM using the SP Capital IQ packages in Xpressfeed
Data Packages
Returns Dividend Yield
Version Date:10/27/2020
The following sample query calculates the dividend yield for all primary trading items on January 11, 2011 using the SP Capital IQ tables in Xpressfeed. Note: Because price and the indicated annual dividend may be in different currencies, both are converted to U.S. Dollars (USD) for the calculation
Data Packages
Returns ISCRS Data
Version Date:10/27/2020
The following sample query returns ISCRS (Industry Sector Cross Reference Service) data for IBM in Xpressfeed
Data Packages
Returns List Of Industry IDs
Version Date:10/21/2020
The following sample queryreturns a list of SNL Industry IDs in Xpressfeed
Data Packages
Returns SNL Real Estate Property Reported Summary Data
Version Date:10/21/2020
The following sample query returns the Occupancy Rate percentage for the last five fiscal years using the SNL Real Estate package in Xpressfeed
Data Packages
Returns Annual Flow Data For A Company
Version Date:10/21/2020
The following sample query returns annual flow data for a company using the SNL packages in Xpressfeed. Note: This example uses Cost-to-Income for Deutsche Bank AG
Data Packages
Returns InstituionId From Company Name
Version Date:10/21/2020
The following sample query returns the institutionID from a company name using the SNL package in Xpressfeed
Data Packages
Returns Sector Revenue/Total Revenue Of Different Institutions For The Year 2019
Version Date:10/13/2020
Returns Sector Revenue/Total Revenue Of Different Institutions For The Year 2019
Data Packages
Returns Environmental Data (Numeric) Of American Electric Power Company, Inc. For The Year 2018
Version Date:10/13/2020
Returns Environmental Data (Numeric) Of American Electric Power Company, Inc. For The Year 2018
Data Packages
Returns All The Data Items Delivered In The Trucost Environmental Data Packages
Version Date:10/13/2020
Returns All The Data Items Delivered In The Trucost Environmental Data Packages
Data Packages
Returns Carbon Intensity As Company GHG Emissions Divided By Company Power Generation
Version Date:10/13/2020
Returns Carbon Intensity As Company GHG Emissions Divided By Company Power Generation Where Carbon_Intensity>408
Data Packages
Returns All Company Relationships Recursively
Version Date:09/30/2020
Returns Company Relationships Recursively, currently returning output for IBM, if you want to see for universe, please comment WHERE condition Please read comments for more information Tags - Corporate tree, Corporate Hierarchy, Company Hierarchy
Data Packages
Returns CIQ Identifiers Associated with CompanyIds
Version Date:09/29/2020
The following sample SQL query displays the SP Capital IQ entity Id, name, country, and region, along with the corresponding identifier name and Id in BECRS. It also indicates whether the identifier is flagged as the primary identifier. Note: Top 100000 companies are selected to reduce execution time.
Data Packages
Returns CIQ Activist Investor Data
Version Date:09/29/2020
The following sample query returns the Activist Investor companies for The Clorox Company using the SP Capital IQ Ownership package
Data Packages
Returns Latest Holdings Data For SPDR Sector ETFs
Version Date:09/29/2020
The following sample query returns Latest Holdings Data For SPDR Sector ETFs In Xpressfeed Using CIQ Ownership
Data Packages
Returns Top 20 Shareholders For A Company
Version Date:09/29/2020
The following sample query returns the top 20 shareholders for Microsoft Corporation using the CIQ Ownership package and the CIQ Professionals package in Xpressfeed
Data Packages
Returns Public Companies Ownership Top Holders
Version Date:09/29/2020
The following sample query returns the top holders of a company using the SP Capital IQ Ownership and Base Files packages
Data Packages
Returns Primary Trading Items
Version Date:09/29/2020
The following sample SQL query returns the Primary Trading Items associated with Alphabet Inc. (GOOG) using the Global Instruments Cross Reference Service (GICRS) Foundation tables in Xpressfeed
Data Packages
Returns Company And Ultimate Parent
Version Date:09/29/2020
The following sample SQL query displays the company name, the company\x92s ultimate parent, and the country and region for both using the Business Entity Cross Reference System (BECRS) package in Xpressfeed
Data Packages
Returns Insider Trades
Version Date:09/29/2020
The following sample query returns the insider trading activity for AIG and specifically the individual with last name Dooley in Xpressfeed
Data Packages
Returns Ownership Details For Active Mutual Funds, Excluding Exchange-Traded Funds (ETFs) And Index Funds
Version Date:09/29/2020
The following sample query returns Ownership Details For Active Mutual Funds, Excluding Exchange-Traded Funds (ETFs) And Index Funds, From The S&P Capital IQ Ownership Package
Data Packages
Returns Various Rating Agency Identifiers
Version Date:09/29/2020
The following sample SQL query displays a company and the corresponding SP OrgId, the Fitch OrgId, and the Moody\x92s OrgId associated with that company based on the SP Capital IQ companyId in BECRS
Data Packages
Returns CIQ RGA Securities
Version Date:09/29/2020
The following sample SQL query returns the SP Capital IQ Security ID (securityId) for Repertoire General des Actions (RGA) identifiers using the Global Instruments Cross Reference Service (GICRS) package in Xpressfeed
Data Packages
Returns Market Value Of The Securities Owned By A Specific Holder
Version Date:09/29/2020
The following sample query returns Market Value Of the securities owned by a specific holder, or position, as of a specified period-end date using the S&P Capital IQ Ownership and Base Files packages
Data Packages
Returns CIQ Ownership By Calculated Investment Style
Version Date:09/29/2020
The following sample query returns the ownership by Calculated Investment Style (type of investors) that own stock in Blackrock
Data Packages
Returns SecurityId Associated To CUSIP9
Version Date:09/29/2020
The following sample SQL query displays the SP Capital IQ securityId associated to the CUSIP9 for IBM using the Global Instruments Cross Reference Service (GICRS) package
Data Packages
Returns Latest Geographic Or Business Segments For A Company
Version Date:09/26/2020
This query returns the most recent annual geographic or business segment data in the reported currency for a company from the S&P Capital IQ Fundamental data in Xpressfeed
Data Packages
Latest Fundamentals Coverage (US Primary Listed IPO)
Version Date:09/25/2020
Pulling US Primary Listed IPO from Transactions for given YEAR range and then pulling Fundamentals for those based on another YEAR range. Can set Fundamentals Range - Default is 3 Years pre-IPO and 3 Years Post-IPO. Also running a REPLACE on DataItemName to switch commas with hyphens for CSV exporting. Built for The Capital Group to replace a CIQ screenexcel sequence
Data Packages
Total Company Shares Outstanding On A Specific Date
Version Date:09/25/2020
Calculate company-level, aggregated shares outstanding on a particular historical date, incorporating both traded and non-traded shares outstanding and any relevant conversion factors
Data Packages
Returns Summary Debt Information For A Company
Version Date:09/24/2020
The following sample SQL query demonstrates how to view summary debt information for IBM over a 10-year period. Note: This sample query is for the Capital Structure Add-On delivered through the ciqFinCollectionData table in the Premium Financials Core Package
Data Packages
Primary And Secondary Segment Mapping
Version Date:09/24/2020
This query returns the primary and secondary GICS mapping per segmentId for a company using the S&P Capital IQ files in Xpressfeed
Data Packages
Returns Premium Financial Data Items
Version Date:09/24/2020
The following sample SQL query displays data items associated with each Premium Financials Package. The dataItemGroupId corresponding to each package is listed in the where clause
Data Packages
Returns As-Reported Details For A Company's Debt Capital Structure
Version Date:09/24/2020
The following sample SQL query demonstrates how to view as reported details for IBMs FY 2009 debt capital structure. Note: This query is for the Debt Capital Structure Add-On delivered via a separate package
Data Packages
Returns P/E, P/BV, And TEV For A Company
Version Date:09/24/2020
This query returns the Price-to-Earnings (PE) ratio, Price to Book Value (PBV), and Total Enterprise Value (TEV) for IBM on a daily basis using the S&P Capital IQ Premium Financials packages in Xpressfeed.
Data Packages
Returns Business Segment Revenue Along With NAIC And SIC Classifications For A Specific Period End Date
Version Date:09/24/2020
The following sample query retrieves a specific company's business segment revenue for a specific period end date, along with the primary NAIC classification and primary SIC classification
Data Packages
Time Series For A Single DataItemId
Version Date:09/23/2020
The following demonstrates how to create and execute the necessary MS SQL queries to view a time series for a single data item for a company
Data Packages
Returns The Number Of Companies With Non-Null Revenue For Each Calendar Year By Revenue Bands
Version Date:09/23/2020
The following sample SQL query retrieves the count of CompanyIDs within S&P Capital IQ Latest Financials with non-Null revenue for each Calendar Year and groups them into revenue bands of less than 10 million, between 10 and 50 million, and greater than 50 million. All revenue figures are converted to USD
Data Packages
Returns All CIQ Industry Specific Items For A Company
Version Date:09/23/2020
The following sample SQL query returns the 2017 annual Wireless industry-specific data for Verizon Communications using the S&P Capital IQ Latest Instance Fundamental packages in Xpressfeed
Data Packages
Returns The Total Same Store Sales Growth Percent
Version Date:09/23/2020
This query returns returns the Total Same Store Sales Growth percent using the S&P Capital IQ tables in Xpressfeed Note:Here a specific periodType is taken
Data Packages
Returns CIQ Period Last Market Cap
Version Date:09/23/2020
This query pulls the Period Last Market Cap (dataItemId = 100010) using the S&P Capital IQ files in Xpressfeed for a specific period end date and a specific company
Data Packages
Returns P/E, P/BV, And TEV For A Company Using Latest Financials
Version Date:09/23/2020
This query returns the Price-to-Earnings (P/E) ratio, Price to Book Value (P/BV), and Total Enterprise Value (TEV) for Verizon on a daily basis using the S&P Capital IQ Latest Financials packages in Xpressfeed. Note: The Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values by using either a SET or SELECT statement. Note: Uncomment periodtypeId IN (2) to get quarterly results
Data Packages
Data Items Associated With Each Latest Fundamentals Package
Version Date:09/23/2020
The following sample SQL query identifies the dataitemId and descriptions associated with the latest financials package
Data Packages
Returns Current Board Members
Version Date:09/07/2020
The following sample query returns current board members for IBM
Data Packages
Returns Prior Executives In A Company
Version Date:09/07/2020
The following sample query displays prior executives found at IBM
Data Packages
Returns Trends In CEO Pay Ratio, CEO Annual Compensation, Or Employee Median Salary
Version Date:09/07/2020
The following sample query identifies the trends in CEO pay ratio, CEO annual compensation, or employee median salary for the selected fiscal years (For a given company)
Data Packages
Returns Growth Rate Of A Particular Company CEOs Annual Compensation
Version Date:09/07/2020
The following sample query Returns the growth rate of a particular companys CEOs annual compensation for a two-year period
Data Packages
Returns Companies With An IPO
Version Date:09/07/2020
The following sample query returns top 100 companies with an Initial Public Offering (IPO) using the S&P Capital IQ Key Developments package in Xpressfeed.
Data Packages
Returns Companies With The Highest CEO Pay Ratio ( For A Given Financial Year And GICS Sector)
Version Date:09/07/2020
The following sample query identifies for a given financial year and GICS Sector, the top 10 companies with the highest CEO pay ratio,along with company details (company name)
Data Packages
Returns Companies With The Highest CEO Pay Ratio
Version Date:09/07/2020
The following sample query displays for a given financial year, the top 100 companies with the highest CEO pay ratio, along with company details (company name) and CEO information (name, title, biography) from other S&P Global Capital IQ packages
Data Packages
Returns All Key Developments For A Company
Version Date:09/07/2020
The following sample query returns all of the Key Developments for a company ordered by their announced date using the CIQ Company ID using Key Development package in Xpressfeed.
Data Packages
Returns Key Executives With Highest Annual Cash Compensation
Version Date:09/07/2020
The following sample query returns the key executives with the highest annual cash compensation between 01/01/2010 and 12/31/2010
Data Packages
Returns Aggregate Count Of Mentions Of A Specific Keyword
Version Date:08/31/2020
The following sample query returns aggregate count of mentions of a specific keyword, such as weather for this example, during earnings calls for an index by year using the S&P Capital IQ Transcripts package in Xpressfeed.
Data Packages
Returns Linkage Of Transcripts To Events
Version Date:08/31/2020
The following sample query returns linkage of transcripts to events for a company using the S&P Capital IQ Transcripts package in Xpressfeed.
Data Packages
Returns Aggregate Count Of Distinct Analysts Who Asked A Question During Quarterly Earnings Call
Version Date:08/31/2020
The following sample query returns aggregate count of distinct analysts who asked a question for a companys quarterly earnings call using the S&P Capital IQ Transcripts package in Xpressfeed. (Here for Apple Inc.)
Data Packages
Returns Earning Calls For A Company
Version Date:08/31/2020
The following sample query returns earnings calls for a company using specific keywords using the S&P Capital IQ Transcripts package in Xpressfeed. This example uses earnings calls for Macys / Nordstrom / J.C. Penny using the word weather.
Data Packages
Returns Earning Calls Where An Analyst Asked A Question For An Index Constituent
Version Date:08/31/2020
The following sample query returns earnings calls where an analyst asked a question for an Index Constituent using the S&P Capital IQ Transcripts package in Xpressfeed.
Data Packages
Returns Earning Calls Where CEO Answers Questions Using Specific Keywords For A Company
Version Date:08/31/2020
The following sample query earnings calls where CEO answers questions using specific keywords using the S&P Capital IQ Transcripts package in Xpressfeed. This example uses earnings calls where Tim Cook answered a question for Apple Inc using the word acquisition.
Data Packages
Returns Most Recent Security Identifiers
Version Date:08/25/2020
The following sample query returns the most recent security identifiers for all issues for a company through the latest date
Data Packages
Returns A Annual Change Series For One Item With Data Codes
Version Date:08/25/2020
The following sample query builds an annual change series for annual sales (SALE) for GVKEY 007435 (3M)
Data Packages
Returns Time Series For Quarterly Sales
Version Date:08/25/2020
The following sample query builds a time-series for quarterly sales (SALEQ) for GVKEY 001078 (Abbott Labs) in Xpressfeed.
Data Packages
Returns Time Series Using Observation Dates
Version Date:08/25/2020
The following sample query builds a time series for one item for one company as of a particular observation date
Data Packages
Returns Complete Time Series And A Value For All Pointdate-Datadate Combinations
Version Date:08/25/2020
The following sample query uses data groups in the Compustat Point-in-Time Backtest Package to create a complete time series and return a value for all pointdate-datadate combinations for Sales Quarterly for GVKEY 001487. It effectively creates a rolling 20-quarter history for the item at each pointdate.
Data Packages
Returns First Occurrence Of Fundamental Data In Point In Time (NEW)
Version Date:08/25/2020
The following sample query finds the first occurrence of SALEQ in the PIT database, whether it is preliminary or final, for GVKeys 006066 and 012141 for the 12/31/2008 period
Data Packages
Returns A Quarterly Change Series For One Item With Data Codes
Version Date:08/25/2020
The following sample query builds a quarterly change series for all available dates for quarterly EPS (EPSPXQ) for ICG Group Inc (GVKEY 122536) with data codes. Note: To build a time-series for quarterly sales (SALEQ), use c.item = \'SALEQ\' and add c.valuei AS saleq, c.datacode AS saleq_dc in the select statement
Data Packages
This Query Returns S&P Capital IQ Estimates For Natural Gas Using S&P Capital IQ Estimates Packages
Version Date:08/21/2020
This query returns S&P Capital IQ Estimates for Natural Gas using S&P Capital IQ Estimates packages
Data Packages
This Query Returns S&P Capital IQ Estimates As Of A Specific Observation Date Using The CIQ Estimates Consensus Packages
Version Date:08/21/2020
This query returns S&P Capital IQ Estimates as of a specific observation date using the CIQ Estimates Consensus packages
Data Packages
This Query Returns All S&P Capital IQ Estimate Contributors For The Non-Periodic Recommendation Item, Which Can Be Buy, Outperform, Hold, Underperform, Sell, Or No Opinion
Version Date:08/21/2020
This query returns S&P Capital IQ Estimate contributors for the non-periodic recommendation item ABB Ltd (companyId = 18527) using the S&P Capital IQ, this including the Broker Name and Analyst Name for EPS Normalized (Detailed) for ABB Ltd (companyId = 18527) using the S&P Capital IQ Details Estimates packages
Data Packages
This Query Returns The Estimate Target Price (dataItemId = 100161) AND The Currency That The Data Is Reported In For A Single TradingItemId Using The S&P Capital IQ Estimates Package
Version Date:08/21/2020
This query Returns the Estimate Target Price (dataItemId = 100161) AND the currency that the data is reported in for a single TradingItemId using the S&P Capital IQ Estimates package
Data Packages
This Query Returns S&P Capital IQ Estimate Contributors For Polymet Mining Corp (companyId = 875530) Using The S&P Capital IQ
Version Date:08/21/2020
This query returns S&P Capital IQ Estimate contributors for Polymet Mining Corp (companyId = 875530) using the S&P Capital IQ, this including the Broker Name and Analyst Name For 2014 Fiscalyear EPS Normalized (Detailed) for Polymet Mining Corp (companyId = 875530) using the S&P Capital IQ Details Estimates packages
Data Packages
This Query Returns The Free Cash Flow Historical Estimate Data For Hudson Technologies Inc For Fiscal Years 2016 Through 2018 Using The S&P Capital IQ Consensus Estimates Tables
Version Date:08/21/2020
This query returns the Free Cash Flow historical estimate data for Hudson Technologies Inc for fiscal years 2016 through 2018 using the S&P Capital IQ Consensus Estimates tables
Data Packages
This Query Returns The Most Recent CIQ EPS Normalized (Detailed) Estimates For The 2012 Fiscal Year For IBM Using The S&P Capital IQ Estimates Package
Version Date:08/21/2020
This query returns the most recent CIQ EPS Normalized (Detailed) Estimates for the 2012 fiscal year for IBM using the S&P Capital IQ Estimates package
Data Packages
This Query Returns The Latest S&P Capital IQ Broker Detail Recommendations For A Company Using The CIQ Estimates Packages
Version Date:08/21/2020
This query returns the latest S&P Capital IQ broker detail recommendations for a company using the CIQ Estimates packages
Data Packages
This Query Returns Target Price As Well As Buy, Sell And Hold Recommendations For The Analyst Coverage Using The S&P Capital IQ Estimates Package
Version Date:08/21/2020
This query returns target price as well as buy, sell and hold recommendations of IBM (112350) company for the analyst coverage using the S&P Capital IQ Estimates packages
Data Packages
Datadate New Adjustment Factor Is Applied To Given Company
Version Date:08/20/2020
The following sample returns the datadate that a new adjustment factor is applied for stock splits
Data Packages
Returns Shares Outstanding For A Time Period In Compustat
Version Date:08/20/2020
The following sample query pulls the Common Shares Outstanding - Current (CSHOC) values, include From and To dates (fromDate and toDate), for a company from the Security - Daily Pricing (sec_dprc) table in Xpressfeed
Data Packages
Returns Primary EPS In Compustat
Version Date:08/20/2020
The following sample query returns the earnings and shares used to validate the Compustat values for Primary EPS (EPSPX and EPSPI) and Fully Diluted (EPSFX and EPSFI) in Xpressfeed
Data Packages
Returns Daily Price History
Version Date:08/20/2020
Because there is so much daily history, it is recommended to input a datadate range or the query will take a long time to run. To pull the entire history, remove and sec_dprc.datadate = 12/31/2008 from the query
Data Packages
ESG Scores In Detail (Applicable To Legacy)
Version Date:08/18/2020
This sample query returns ESG Scores in detail for Abbott Laboratories for 2019 assessment year. Note - This is applicable to legacy package.
Data Packages
High Scenario-Based Score For Forecast Year 2030
Version Date:08/18/2020
This sample query returns High scenario-based score for forecast year 2030 for top ten S&P 500 companies with most number of assets
Data Packages
ESG Score Trend (Applicable To Legacy)
Version Date:08/18/2020
This sample query returns the ESG Score trend for Biogen Inc. starting 2013. Note - This is applicable to legacy package.
Data Packages
ESG Score Trend For Companies In An Industry (Applicable To Legacy)
Version Date:08/18/2020
This sample query returns the ESG Score trend for top 10 companies in the Biotechnology Industry starting 2013 Note - This is applicable to legacy package.
Data Packages
Company Energy Mix
Version Date:08/18/2020
This sample query identifies utilities that are poorly positioned in the face of rising carbon prices due to their fossil fuel-heavy energy mix
Data Packages
Companies Impacted By Stranded Assets Due To Proven Or Probable Fossil-Fuel Reserves
Version Date:08/18/2020
This sample query determines which companies own fossil fuel reserves and, therefore, may be holding stranded assets as we transition to a lower-carbon economy
Data Packages
Sector Based Physical Risk Asset Count As A Percentage Of Total For Given Year
Version Date:08/18/2020
This sample query identifies the sector-based physical risk asset count as a percentage of total for year 2018
Data Packages
Companies Most Heavily Exposed To Coal-Related Business Activities
Version Date:08/18/2020
This sample query identifies companies that derive revenues from coal-based activities to isolate portfolio exposure to transition risks
Data Packages
Trend In Carbon On A Sector Or Country Level
Version Date:08/18/2020
This sample query assess companies trend over time of absolute carbon emissions, or carbon intensity on a sector- and/or country-level, to determine which companies are driving their emissions down while still growing revenues
Data Packages
Physical Risk Asset Count For S&P 500 Companies For Given Year
Version Date:08/18/2020
This sample query identifies the physical risk asset count for S&P 500 companies for year 2018
Data Packages
Top 10 Most Sustainable Companies An Industry (Applicable To Legacy)
Version Date:08/18/2020
This sample query returns the top 10 most sustainable companies in the Automobile industry in 2019 assessment. Note - This is applicable to legacy package.
Data Packages
Physical Risk Sensitivity Scores For Companies
Version Date:08/18/2020
This sample query identifies the sensitivity scores for S&P 500 companies for year 2019 for seven physical risk indicators
Data Packages
Company Carbon Footprint
Version Date:08/18/2020
The following sample query compares a company carbon footprint (intensity) within the same GICS industry to assess relative carbon efficiency over the course of a financial year
Data Packages
Returns The GVKEY, IID, GSUBIND, And CUSIP From The Xpressfeed
Version Date:08/09/2020
Returns the GVKEY, IID, GSUBIND, and CUSIP from the Xpressfeed company and security tables for the S&P 500 Index constituents from the S&P Capital IQ Index data tables on 7/9/10
Data Packages
Returns The Constituents Of The S&P Americas BMI Fundamentals (Sector) Index For 1 Day Using The BMI Index Feed In Xpressfeed
Version Date:08/09/2020
Returns the constituents of the S&P Americas BMI Financials (Sector) Index for 1 day using the BMI Index feed in Xpressfeed
Data Packages
Returns S&P 500 Index Constituents By Industry
Version Date:08/09/2020
Returns S&P 500 Index constituents by industry as of a specified date and includes the GVKEY, company name, close divisor, weight, index shares, and share price using the S&P Capital IQ packages in Xpressfeed
Data Packages
Returns The Ticker Symbol, GVKEY, Issue ID, And GICS Sub-Industry Code From The Xpressfeed
Version Date:08/09/2020
Returns the ticker symbol, GVKEY, Issue ID, and GICS Sub-Industry Code from the Xpressfeed company and security tables for the S&P 500 Index constituents into a CIQ Index data query that includes index weight, shares, price, and index price
Data Packages
Returns The IndexID For The Desired Index AndReturns The FromDate And ToDate For The Specified Company In Relation To The IndexID
Version Date:08/09/2020
Find the IndexID for the desired index.Pull the fromDate and toDate for the specified company in relation to the IndexID and to determine if a company is a current or historical constituent of a specific index using the Capital IQ files in Xpressfeed
Data Packages
Returns The Members Of The Euro TOPIX Index
Version Date:08/09/2020
Returns the members of the Euro Topix Index
Data Packages
Returns The Filing Dates For All 10-K And 10-Q Forms Filed With The U.S. Securities And Exchange Commission (SEC) For All Of The Companies
Version Date:08/09/2020
Returns the filing dates for all 10-K and 10-Q forms filed with the U.S. Securities and Exchange Commission (SEC) for all of the companies that are constituents of the S&P 500 Index between specified start and end dates using the CIQ packages In Xpressfeed
Data Packages
Returns The Daily Or Monthly MSCI Index Values Using The S&P Capital IQ Index Data Packages In Xpressfeed
Version Date:08/09/2020
Returns The Daily Or Monthly MSCI Index Values Using The S&P Capital IQ Index Data Packages In Xpressfeed
Data Packages
Returns The Corporate Action Of A Name Change For An Index Constituent Company As Of A Particular Date Using The S&P Global BMI Index Data In Xpressfeed
Version Date:08/09/2020
returns the corporate action of a name change for an index constituent company as of a particular date using the S&P Global BMI Index data in Xpressfeed
Data Packages
Returns A List Of All MSCI Indices In Xpressfeed
Version Date:08/09/2020
This query returns a list of all MSCI Indices in Xpressfeed
Data Packages
Returns Companies With Amended Financial Statements
Version Date:07/01/2020
This query returns all companies that filed an amended 10-K for the fiscal year ending 12/31/2009
Data Packages
Returns Long Term Debt To Common Equity
Version Date:07/01/2020
This query returns the Long-Term Debt to Common Equity ratio for companies on a specific datadate using the Compustat packages in Xpressfeed. Note: This query replicates the Long-Term Debt/Common Equity (DCE) concept in Research Insight
Data Packages
Returns Gross Margin(Annually And Quarterly)
Version Date:07/01/2020
This query calculates Gross Margin on an Annual basis in the Compustat database. Note: Uncomment the second query to get quarterly results
Data Packages
Returns FASB 158 Pro Forma Impact On StockHolders Equity
Version Date:07/01/2020
This query calculates the impact of SFAS 158 on Shareholders Equity for years prior to adoption (assuming a statutory tax rate of 35%)
Data Packages
Returns Level 3 Fair Value Transparency
Version Date:07/01/2020
This query returns quarterly transparency for Level 3 assets and liabilities in Xpressfeed
Data Packages
Returns monthly price to book ratio
Version Date:07/01/2020
The following sample query calculates monthly price to book ratio using daily pricing
Data Packages
Returns Growth Or Value Index Constituents
Version Date:07/01/2020
This query returns the constituents of the SP/Barra 500 Growth as of July 29, 2005
Data Packages
Returns BerryQ Ratio
Version Date:07/01/2020
This query returns the quarterly Berry Ratio for a company using the Compustat packages in Xpressfeed. Note: This query replicates the quarterly Berry Ratio (BERRYQ) concept in Research Insight
Data Packages
Returns Operating Segments For A Company
Version Date:07/01/2020
This query returns all operating segments for ALLIS-CHALMERS ENERGY INC as of 12/31/2007 _ /
Data Packages
Returns Security Detail Information
Version Date:07/01/2020
This query returns selected security detail information for Philippine Telephone
Data Packages
Returns Geographic Segments For A Company
Version Date:07/01/2020
This query returns all geographic segments and sales for each segment for IBM as of December 31, 2016 using Compustat Segment packages in Xpressfeed
Data Packages
Returns Mutual Funds
Version Date:07/01/2020
This query is used to screen Xpressfeed for closed-end funds only, search for SIC code of 6726, Issue Type (TPCI) of 7 (Mutual or investment trust fund), and Net Asset Value (NAVM) is a value
Data Packages
Returns Daily Market Data For A Security
Version Date:07/01/2020
This query provides the daily close price (PRCCD), adjustment factor (AJEXDI), and common shares outstanding (CSHOC) for a security over a specified date range
Data Packages
Returns Security Identifiers For All Issues And All Dates In Snapshot
Version Date:07/01/2020
This query returns the identifiers and the exchanges that were active for each issue during specified times
Data Packages
Returns Annual Fair Value Asset Items
Version Date:07/01/2020
This query returns annual Fair Value Asset Items related to SFAS 157 and Fair Value Changes in Earnings related to SFAS 159
Data Packages
Returns All Changes To An Item Over Time In Compustat Point-In-Time
Version Date:07/01/2020
This query uses tables in the Compustat Point-in-Time Backtest Package to show original values and any subsequent changes to a data item over time. It returns the datadate, pointdate, value and data code for the original and revised instances. The query represents an abbreviated time series in that it does not return all datadates and pointdates for the item: It only returns datadates and pointdates for when there is an original value or a change. Note:This query specifically identifies original values and changes to quarterly sales for GVKEY 001487.The mnemonic and GVKEY can be changed to run for other items and companies
Data Packages
Returns PE, BKVLPS And Price Sales
Version Date:07/01/2020
This query returns Price-to-Earnings ratio (PE), Price-to-Book (Book Value per Share) , and Price-to-Sales (Price/Sales) for the S&P 500 Index in Xpressfeed
Data Packages
Returns Dual Listed Companies With Both US And Non-US Security Listings
Version Date:07/01/2020
This query returns all companies that have both an a U.S. security listing (IID of 01) and a non-U.S. security listing (IID of 01C), meaning they are double-followed Canadian companies
Data Packages
Returns Pro Forma Records
Version Date:07/01/2020
This query finds pro-forma companies using the Compustat database in Xpressfeed
Data Packages
Returns Number Of Companies With Finalized Data By Month
Version Date:07/01/2020
This query returns the number of companies that have finalized data by month
Data Packages
Returns Quarterly IS And BS Balancing Models For Banks
Version Date:07/01/2020
This query returns Quarterly Income Statement (IS) balancing model for banks in Xpressfeed. Note: Uncomment the second query to return the Quarterly Balance Sheet balancing model for banks in Xpressfeed
Data Packages
Returns Company Level Notes
Version Date:07/01/2020
This query returns the company-level notes for a company after a specific data date
Data Packages
Returns Index Constituents and Identifiers
Version Date:07/01/2020
The following sample query returns the constituents of the SP 500 Index as of a specified date and their corresponding identifiers, including Company ID (companyId), Trading Item ID (tradingItemId), and GVKEY.
Data Packages
Returns Companies In A Located State
Version Date:07/01/2020
This query finds companies in Colorado and displays their City, ZIP/Postal Code, and GICS Sub-Industry Code and description
Data Packages
Returns Index Name, GVKEYX, And Ist Date Of Pricing
Version Date:07/01/2020
This query returns the Index Name, GVKEY and the first date that price data was available for the Index
Data Packages
Returns Foreign Sales As A Percentage Of Total Sales
Version Date:07/01/2020
This query returns the sales values for each geographic segment for IBM for fiscal year 2010 as a percentage of total sales in Xpressfeed
Data Packages
Returns IBES Broker Recommendation For A Stock
Version Date:07/01/2020
Query the Xpressfeed database on the data item I/B/E/S Recommendations Consensus (IBRECON). This item is located in the ibwrecom data group. This item is the mean recommendation consensus. It is also helpful to pull in I/B/E/S Number of Recommendations (IBNOREC) from the same table because it gives more meaning to the mean recommendation. The possible recommendations are:1- Strong Buy2- Buy3- Hold4- Underperform5- Sell SQL Query:
Data Packages
Returns Major Index Constituents
Version Date:07/01/2020
For the CURRENT constituents of the major indexes: This example queries the indexcst_his data group to return the current constituents of the S&P 500 Index
Data Packages
Returns Adjusted CSHOQ For A Company Over A Specific Time Period
Version Date:07/01/2020
This querypulls the quarterly common shares outstanding (CSHOQ) on an unadjusted and adjusted basis
Data Packages
Returns ROIC
Version Date:07/01/2020
This query calculates Return on Invested Capital (ROIC) for a company using the Compustat packages in Xpressfeed
Data Packages
Returns Number Of Companies With Fundamental Data Available
Version Date:07/01/2020
This query returns the GVKEYs and the Company Names for U.S. and Canadian companies with fundamental data. Note:To get fundamental data for active companies use: WHERE ( A.costat = A ), To get fundamental data for inactive companies use: WHERE ( A.costat = I ). To get the number of active and inactive Canadian companies with fundamental data available for the 2012 fiscal year use: AND ( b.datadate = 6/30/2012 AND b.datadate = 5/31/2013 )
Data Packages
Returns MIC Data For A Company's Securities
Version Date:07/01/2020
This query returns the Market Identifier Code (MIC) and the Stock Exchange Code (EXCHG) for all of a companys equity listings in Xpressfeed
Data Packages
Returns Companies With More Than Specified Number Of Securities
Version Date:07/01/2020
This query returns all companies that have issued more than 10 securities
Data Packages
Returns When Issued Stocks
Version Date:07/01/2020
This query returns When Issued stocks in Xpressfeed
Data Packages
Returns Companies TSX Venture Exchange
Version Date:07/01/2020
This query returns companies on the TSX Venture Exchange OR the Toronto Stock Exchange (TSX)
Data Packages
Returns Active Companies That Have Filed Bankruptcy
Version Date:07/01/2020
This query finds companies that have pricing in the last year and have a filed bankruptcy flagged with a TL/GL footnote on Total Assets using the Compustat financials in Xpressfeed
Data Packages
Returns Members, Pricing And Market Value For A Specific Date
Version Date:07/01/2020
This query returns the adjusted close price, common shares outstanding current, adjusted common shares outstanding current, ticker symbol, and the market value for members of the STOXX Index on a specific date in Xpressfeed
Data Packages
Returns Monthly Return For A Time Period Using Monthly Pricing
Version Date:07/01/2020
This query returns the 3-Month Total Return for McGraw-Hill Financial (GVKEY: 007163) using monthly pricing from December 13, 2006 to March 31, 2007
Data Packages
Returns Sales Growth For An Index
Version Date:07/01/2020
This query returns the one-year sales growth for the S&P 500 Index as of December 31, 2016 using the Compustat files in Xpressfeed
Data Packages
Returns Compustat Market Data
Version Date:07/01/2020
This query subtract the number of companies with market data that also have an annual descriptor record indicating the availability of fundamental data, and returns the number of companies with market data only
Data Packages
Returns Number Of Companies In Annual Or Monthly Files
Version Date:07/01/2020
This query returns the number of companies in the co_adesind data group
Data Packages
Returns Companies That File Financial Statements Late
Version Date:07/01/2020
The following sample query finds all late quarterly filings for quarter ending in 2010.
Data Packages
Returns Dates
Version Date:07/01/2020
This query used to return a date for a specified period of time back from today. Note: Uncomment the second query to return ate one year earlier than another date, where a.datadate is the specified date and -1 is the relative reference
Data Packages
Returns IS And BS Balancing Models For REITs
Version Date:07/01/2020
This query returns the Income Statement (IS) balancing model for Real Estate Investment Trusts (REITs) in Xpressfeed. Note: Uncomment the second query to get the Balance Sheet (BS) balancing model for REITs in Xpressfeed
Data Packages
Returns Global Economic Data
Version Date:07/01/2020
This query uses the economic indicator tables in Compustat to retrieve forecast and historical Gross Domestic Product indicators for the United States in Xpressfeed. Note: Uncomment the second query which uses the economic indicator reference table in Compustat to retrieve descriptive information about the Gross Domestic Product indicators for the United States in Xpressfeed
Data Packages
Returns Daily Total Return For Multiple Periods
Version Date:07/01/2020
This calculates the Daily Total Returns for IBMs primary issue (GVKEY = 006066, IID = 01) for three time periods:Note: The 1-year return (TRT1Y) is calculated over the period from March 6, 2012 thru March 6, 2013. The 3-year return (TRT3Y) is calculated over the period from March 4, 2010 thru March 6, 2013. The 5-year return (TRT5Y) is calculated over the period from March 4, 2008 thru March 6, 2013
Data Packages
Returns Number Of Observations For A Data Item
Version Date:07/01/2020
This query returns the number of companies that have a value for SALE in the co_afnd2 table in Xpressfeed Note: Uncomment the second query to get the number of securities per DATADATE in the sec_dprc table in Xpressfeed
Data Packages
Returns EXCHANGETIER
Version Date:07/01/2020
This query pulls a list of all of the EXCHGTIER codes and descriptions for each Stock Exchange (EXCHGCD). Note: Uncomment the second query to return all of the companies in the sec_history table that have Stock Exchange Tier (EXCHGTIER) data available
Data Packages
Returns Companies That Adopted IFRS
Version Date:07/01/2020
Companies that have adopted International Financial Reporting Standards (IFRS) can be identified by an AN or AN-combination footnote on the Comparability Status item (COMPTS). This query returns companies that adopted IFRS indicated by an AN or AN-combination footnote in COMPST preceded by a DS footnote
Data Packages
Returns Daily TRFD
Version Date:07/01/2020
This query returns the most recent value for Total Return Factor - Daily (TRFD) using the Compustat database in Xpressfeed. Note:Uncomment the second query to return TRFD for a specific datadate
Data Packages
Returns Open Price For Index Constituents
Version Date:07/01/2020
This query returns the Open Price (PRCOD) for the constituents of the S&P 500 Index for December 1, 2016 in Xpressfeed
Data Packages
Returns Fortune 1000/Fortune 500 Companies By Rank
Version Date:07/01/2020
This query returns the Fortune 1000 companies by rank as of a given year in Xpressfeed. Note: Uncomment the second query to return the Fortune 500 companies by rank as of a given year in Xpressfeed
Data Packages
Returns Quarterly Book Value Per Share
Version Date:07/01/2020
The following sample query calculates Book Value per Share with adjustment factors using the Compustat database in Xpressfeed. NOTE:To calculate a quarterly book value per share: (SEQQ-PSTKQ)/CSHOQ Quarterly Common Shares Outstanding (CSHOQ) should be adjusted by the adjustment factor if looking at historical periods. The calculation is: (SEQQ-PSTKQ)/(CSHOQ*AJEXQ)
Data Packages
Returns Primary Issue Of Stock
Version Date:07/01/2020
This query returns the Primary Issue for a company in the Global database for a specific from and thru date
Data Packages
Returns Companies With Multiple Issues
Version Date:07/01/2020
This query returns all companies with multiple issues of stock
Data Packages
Returns Market Value For Preferred Shares
Version Date:07/01/2020
The following sample query calculates market value of preferred shares.To calculate Market Cap for Preferred Shares: (PRSHOQ + PNRSHOQ) * PRCCD.This query takes the most recent day of pricing for PRCCD.
Data Packages
Returns Berry Ratio
Version Date:07/01/2020
This query returns the Berry Ratio for companies on a specific datadate using the Compustat packages in Xpressfeed. Note: This query replicates the Berry Ratio (BERRY) concept in Research Insight
Data Packages
Returns NVDRs
Version Date:07/01/2020
This query identifies Non-Voting Depositary Receipts (NVDRs) by returning all issues with NVDR in the Security Description (DSCI) in Xpressfeed
Data Packages
Returns Dividend Yield
Version Date:07/01/2020
This query calculates dividend yield for IBM as of December 31, 2007 based on Indicated Annual Dividend Rate - Monthly (DVRATE) and Price-Close Monthly (PRCCM)
Data Packages
Returns GICS For Companies On A Specific Exchange
Version Date:07/01/2020
The following sample query returns the most current GICS codes for all of the companies trading on a specified stock exchange using the Compustat packages in Xpressfeed. Most current GICS for all companies trading on an exchange, in this case AMEX.
Data Packages
Returns Preliminary And Final Updates Over The Last Two Days
Version Date:07/01/2020
This query returns company that have had a final quarterly update over the last two days
Data Packages
Returns Data Item Translated To USD For Non-US Companies
Version Date:07/01/2020
This query returns the Global Industry Classification Standard (GICS) Sector, GICS Description (GICDESC), International Organization for Standardization (ISO) Currency Code (CURCD), Revenue -Total (REVT) displayed in U.S. Dollars (USD), USD Translation Rate, and the 12-month moving Average Exchange Rate (EXRAT12M) for all European companies in Xpressfeed
Data Packages
Returns Financial Services Company
Version Date:07/01/2020
This query returns Total Assets for Aetnas financial services format as of 12/31/2009
Data Packages
Returns Indices With Constituent Markers
Version Date:07/01/2020
These queries return all indices with constituent markers including the start date for when the first constituents are available for each respective index
Data Packages
Returns Non MSCI Indices
Version Date:07/01/2020
This query returns non MSCI indices with constituents available in Xpressfeed
Data Packages
Returns Details With Par Value And Exchange Country
Version Date:07/01/2020
This query returns GVKEYs and IID with a Par Value and the associated Exchange Country
Data Packages
Returns Quarterly Transparency Data For An Item
Version Date:07/01/2020
This query returns the transparency calculations of Cost of Goods Sold - Quarterly (COGSQ) on one datadate using the Compustat Transparency data in Xpressfeed
Data Packages
Returns Annual Transparency Notes For Multiple Items Companies Years
Version Date:07/01/2020
This query returns Compustat annual transparency notes for Net Sales (SALE), Cost of Goods Sold (COGS), Selling, General and Administrative Expenses (XSGA), Depreciation and Amortization (DP), and Special Items (SPI) for IBM (GVKEY 006066), McCormick Co Inc (GVKEY 007146), and S&P Global, Inc.(GVKEY 007163) for any time periods after November 30, 2016 in Xpressfeed
Data Packages
Returns Count Of Data Item Availability
Version Date:07/01/2020
This query counts the number of occurrences of specific data items for Domestic (POPSRC = D) and International (POPSRC + I)companies in each Industry Format (INDFMT) in the Compustat database in Xpressfeed
Data Packages
Returns Debt-To-Equity-Ratio Annual And Quarterly
Version Date:07/01/2020
This query calculates Debt-to-Equity (aka Risk, Gearing or Leverage) ratio annually. Note:Uncomment the second query to return Debt-To-Equity Ratio for quarterly basis
Data Packages
Returns IS And BS Balancing Models For Banks
Version Date:07/01/2020
This query returns the Income Statement (IS) balancing model for banks in Xpressfeed. Note: Uncomment the second query to get the Balance Sheet (BS) balancing model for banks in Xpressfeed
Data Packages
Returns Compustat Common Equity
Version Date:07/01/2020
This query approximates Common Equity - Tangible (CEQT) on a quarterly basis using a particular gvkey and date
Data Packages
Returns Total Return And Price Return In Multiple Currencies
Version Date:07/01/2020
The following sample query returns the Price Return and Total Return values for a company in Local Currency, British Pounds (GBP), U.S. Dollars (USD), and Euros (EUR) for a specified period of time using the Compustat database in Xpressfeed.
Data Packages
Returns Number Of Companies With A Value Of Market Data Item On A Specific Date
Version Date:07/01/2020
This query returns the number of companies on the NYSE that have a value for Trading Volume - Monthly (CSHTRM) value on January 31, 2011
Data Packages
Returns Quarterly Static And Dynamic Transparency Data
Version Date:07/01/2020
This query returns both the static and dynamic quarterly transparency for a GVKEY on a specific datadate
Data Packages
Returns Record Count For A Specified Table For A Specified Date
Version Date:07/01/2020
This query returns the record count for a specified table for a specified time period
Data Packages
Returns Pure Canadian Companies
Version Date:07/01/2020
This query returns pure Canadian companies by searching for companies with IID ending with C and Stock Exchange Code (EXCHG) = 7-10 to represent the Canadian exchanges, which are both from the Security table, and Country of Incorporation (FIC) = CAN (Canada) from the Company table
Data Packages
Returns FIC Changes Using North America Snapshot
Version Date:07/01/2020
This query finds changes to the ISO Country Code - Incorporation (FIC) in the last 20 years using the cscompany table in North America Snapshot
Data Packages
Returns Industrial Format Income Statement, Balance Sheet, And Cash Flow Balancing Models
Version Date:07/01/2020
This query returns the North America Industrial Format (INDFMT = INDL) Income Statement Balancing Model. Uncomment the second query to get the North America Industrial Format (INDFMT = INDL) Balance Sheet Balancing Model. Uncomment the third query to get the North America Industrial Format (INDFMT = INDL) Cash Flow Balancing Model
Data Packages
Joining Semi Annual Income Statement Items With Quarterly Balance Sheet Items For International Companies
Version Date:07/01/2020
This query joins Semi-Annual Sales from the Income Statement items with Quarterly Total Assets from the Balance Sheet items for International companies
Data Packages
Returns NAICS And SIC Codes For A Company Segments
Version Date:07/01/2020
This query returns the Standard Industrial Classification Code - Segment (SICS) and North American Industry Classification Code - Segment (NAICSS) for a companys segments
Data Packages
Returns Total Borrowing Rate
Version Date:07/01/2020
This query returns the Borrowing Rate by dividing Interest Expense by Total Debt multiplied by 100 to return a percentage for IBM for the fiscal-year ending 12/31/2008
Data Packages
Returns NonTrading Active Companies
Version Date:07/01/2020
This query returns all companies that are not actively trading on any exchange, but are still active
Data Packages
Returns Compustat Holidays By Country
Version Date:07/01/2020
This query returns U.S. holidays in Xpressfeed
Data Packages
Returns Companies With Highest Market Cap That Had FY Change
Version Date:07/01/2020
This query returns the companies with the highest market cap that also had a fiscal-year change using the Compustat packages in Xpressfeed
Data Packages
Returns Data Item That Have Never Been Restated In Snapshot
Version Date:07/01/2020
This query returns a true or false based on how many records exist in the Snapshot North America database for COGSQ for IBM:
Data Packages
Returns Customer Names And Sales For A Company
Version Date:07/01/2020
This query returns all customer names and customer sales for Apple as of September 30, 2017 using Compustat Segment data in Xpressfeed
Data Packages
Returns All Changes To A Compustat Item Over Time In Canadian Point In Time
Version Date:07/01/2020
This query query specifically identifies original values and the corresponding changes from the original to restated values for Quarterly Selling, General Administrative expenses for GVKEY 149049:
Data Packages
Linking MIC To Stock Exchange
Version Date:07/01/2020
This This query maps Market Identifier Codes (MIC) to Stock Exchange Codes (EXCHG) in Xpressfeed
Data Packages
Returns Frequency Of Dividends Paid
Version Date:07/01/2020
This query calculates the frequency of dividends paid during a calendar year in Xpressfeed
Data Packages
Returns Limited Partnerships
Version Date:07/01/2020
This query searches for LP as the last 2 letters in the CONM (Company Name) data item from the company data group. Note: Uncomment the second query to find Limited Partnerships by searching for LP in the DSCI (Security Description) data item from the security data group
Data Packages
Returns Semi-Annual Cash Flow
Version Date:07/01/2020
This query calculates semi-annual cash flow from operating activities (OANCFY) for international companies
Data Packages
Returns Companies With Omitted Or Suspended Dividends
Version Date:07/01/2020
This query identifies a large group of companies that have omitted or suspended dividends in September 2008, including Lehman, AIG, Fannie Mae and Freddie Mac
Data Packages
Returns The Most Current Datadate With Quarterly Financials
Version Date:07/01/2020
This query identifies the most current datadate for multiple companies where quarterly financial data is available in Xpressfeed
Data Packages
Returns Foreign Government Sales
Version Date:07/01/2020
This query returns GVKEYs where the Customer Name contains foreign government (GOVFRN)
Data Packages
Returns Compustat Banks
Version Date:07/01/2020
This query returns a list of the banks included in the Xpressfeed database population and removes duplicate names
Data Packages
Returns Population Of Private Companies With Public Debt
Version Date:07/01/2020
This query returns the companies with public debt in the Compustat population in Xpressfeed
Data Packages
Returns The Most Current Operating Income For The Current Constituents Of The S&P 500 Index
Version Date:07/01/2020
This query returns the most recent Operating Income after Depreciation (OIADP) for the current constituents of the S&P 500 Index
Data Packages
Returns Total Debt To Total Assets
Version Date:07/01/2020
This query returns the Total Debt to Total Assets ratio for companies on a specific datadate using the Compustat packages in Xpressfeed. Note: This query replicates the Total Debt/Total Assets (DAT) concept in Research Insight
Data Packages
Returns companies with merger or spin-off
Version Date:07/01/2020
The following sample query finds companies with merger or spin-off NOTE: The following tables can be queried in order to find companies with either mergers or spin-offs in Xpressfeed: For Mergers:table sec_mth item isalrt = PA or PM prior to 2000 or PA after 2000table sec_mthdiv item cheqvm is not null For Spin-offs:table sec_mth item isalrt is null and table sec_mthdiv item cheqvm is not null The data item Comparability Status Code (COMPST and COMPSTQ) can be used for North American Companies to identify those that have had a merger or acquisition during the current year with an AA or an AA-combination code. Uncomment the second query to return the footnote on Sales-Net which can also be used to find acquisitions.
Data Packages
Returns Industrial Income Statement For Korean Companies
Version Date:07/01/2020
This query returns an Industrial format Income Statement for companies from Korea
Data Packages
Returns Changes To Cash Flow Working Capital Changes For FASB 95
Version Date:07/01/2020
This query returns the components of the Working Capital changes on the Cash Flow Statement for a company using the Compustat data in Xpressfeed
Data Packages
Returns Canadian Companies
Version Date:07/01/2020
This query returns Canadian companies by annual datadate
Data Packages
Returns AJEXQ For Current Month
Version Date:07/01/2020
This query In Compustat Xpressfeed, AJEXQ is tied to quarterly fundamental data availability so AJEXQ is not available until the fundamental data for that period is available. You can find more current information in Compustat Xpressfeed utilizing the co_adjfact data group. Co_adjfact is organized with effective from and thru dates rather than specific data periods. Note: Uncomment the second query to return the adjustment factor as of a specific date returning only one row of data
Data Packages
Returns Market Value For Global Companies With Multiple Issues
Version Date:07/01/2020
This query calculates market capitalization for a Global company with multiple issues with fundamental data available
Data Packages
Returns Average Market Value For The Most Four recent Quarters.
Version Date:07/01/2020
The following sample query calculates the average Common Shares Outstanding (CSHOQ) for the most recent four quarters multiplied by the average price close monthly for the most recent four quarters, creating an average Market Value for the most recent four quarters for a single company.
Data Packages
Returns Business Segments For A Company
Version Date:07/01/2020
This query returns the Company Name, GVKEY, Data Date, Segment Name, and Segment Sales for business segments for the entire history of a company in Xpressfeed. Note: Uncomment the second query to get the number of all active segments specified per segment for a company on each available data date using Compustat packages in Xpressfeed
Data Packages
Returns Daily Translation Rates
Version Date:07/01/2020
This query returns the daily exchange rate to translate Hong Kong Dollars (HKD) to U.S. Dollars (USD) since inception
Data Packages
Returns REITs
Version Date:07/01/2020
This query return Real Estate Investment Trust (REIT) companies by searching for companies with a Standard Industrial Classification (SIC) code of 6798 or a Global Industry Classification Standard (GICS) Industry code of 404020 in the company table in Xpressfeed.(Uncomment the second query to get GICS)
Data Packages
Returns Number Of Companies That Went Inactive During A Year
Version Date:07/01/2020
This query counts the number of companies from Popsrc D that went inactive in 2007. Note: Remove co_adesind.popsrc = \'D\' to count he number of companies from the entire global database that went inactive in 2007
Data Packages
Returns Exchangeable Shares
Version Date:07/01/2020
This query returns securities described as Exchangeable Shares in Xpressfeed using the term EXCH in the Security Description (DSCI) data item from the security data group
Data Packages
Returns Active/Inactive Companies
Version Date:07/01/2020
This query returns all active companies in Xpressfeed. Note: Uncomment the second query to get all inactive companies
Data Packages
Returns constituents which have their GICS code changed prior to quarter-end
Version Date:07/01/2020
The following sample query returns constituents of the SP 1500 since June 30, 2015 that have had their Global Industry Classification Standard (GICS) code changed prior to quarter-end in Xpressfeed
Data Packages
Returns Historical Index Constituents Using The Indexcst_his Table
Version Date:07/01/2020
This query returns all the constituents of the S&P 500 (GVKEYX 000003) from March 31, 1964 thru December 31, 1991 in Xpressfeed
Data Packages
Returns Data Availability For A Particular Index
Version Date:07/01/2020
The following sample query returns all the data available for the REIT Index in Xpresfeed
Data Packages
Returns Pension Plan Assets
Version Date:07/01/2020
This query returns the components of Pension Plan Assets and the Total Plan Assets in Xpressfeed
Data Packages
Returns Industrial Balance Sheet For Korean Companies
Version Date:07/01/2020
This query returns an Industrial Balance Sheet for companies from Korea
Data Packages
Returns Compustat Issues Classified As A Special Stock
Version Date:07/01/2020
This query returns all of the data items from the security table for issues of stock classified as Special Stock (TPCI = Q) in Xpressfeed
Data Packages
Returns PRCCD As Of A Specific Date
Version Date:07/01/2020
This query returns Price-Close Daily for IBMs domestic issue for March 18, 2004
Data Packages
Returns Dates That The Constituents Of S&P 500 Change
Version Date:07/01/2020
This query returns the dates that the constituents of the S&P 500 Index change using the Compustat packages in Xpressfeed
Data Packages
Returns Current Ratio
Version Date:07/01/2020
This query returns the current ratio quarterly for IBM for the quarter ended March 31, 2008
Data Packages
Returns IS And BS Balancing Models For Broker Companies
Version Date:07/01/2020
This query returns the Income Statement (IS) balancing model for broker companies in Xpressfeed. Note: Uncomment the second query to get the Balance Sheet (BS) balancing model for broker companies in Xpressfeed
Data Packages
Determining Primary Issues
Version Date:07/01/2020
This query returns the primary issue when more than one issue is listed as primary in the Compustat Company table in Xpressfeed
Data Packages
Returns Price-To-Book-Ratio For ADRs
Version Date:07/01/2020
This formula calculates the price-to-book ratio, also called market-to-book, for American Depository Receipts (ADRs) (PRCCMCSHOC/ADRRC)/CEQQ Note:This query returns the price-to-book ratio for Loreal - ADR in Xpressfeed
Data Packages
Returns Daily Total Return For A Time Period
Version Date:07/01/2020
This query returns the Daily Total Return of one issue for a one-year time period using the 1-year return for S&P Global, Inc. from November 1, 2017 to November 1, 2018 in this example
Data Packages
Returns Date Of Adoption
Version Date:07/01/2020
This query identifies companies who have adopted FASB 132 and returns the date of adoption
Data Packages
Returns Multiple Auditors For Companies
Version Date:07/01/2020
This query returns all international companies and their auditors on a specific datadate
Data Packages
Returns Daily Total Return For An Index
Version Date:07/01/2020
This query calculates the daily total return and daily price return for the S&P 500 Index from the current date, as far back as data is available for Index Value - Total Return - Dividends (PRCCDDIV) and Index Value - Price (PRCCD):
Data Packages
Returns Companies Who Report Cash Flows Using Direct Method Statement
Version Date:07/01/2020
This query returns a line for each company and time period when the company reports a Cash Flow Statement using the Direct Method
Data Packages
Returns Economic Country ISO Description Codes
Version Date:07/01/2020
The economic indicator data does not have its own reference table. In order to access the country names for the ISO codes, link to the r_country table. This query returns a list of country codes
Data Packages
Non-Interest Bearing Current Liabilities
Version Date:07/01/2020
This query calculates total non-interest bearing current liabilities
Data Packages
Returns Companies That Emerged From Bankruptcy
Version Date:07/01/2020
This query identifies quarterly periods that have an AG footnote on Assets-Total - Quarterly (ATQ) in Xpressfeed
Data Packages
Returns Differences In CSHOC
Version Date:07/01/2020
This query determines when Common Shares Outstanding - Current (CSHOC) values change from one day to the next for a company and calculates the difference in those values
Data Packages
Returns Standard Poors Quality Ranking for a CUSIP
Version Date:07/01/2020
The following sample queryreturns the Standard Poors Common Stock Ranking for a CUSIP in Compustat.
Data Packages
Returns Long Term Debt To Shareholders Equity
Version Date:07/01/2020
This query returns the Long-Term Debt to Shareholders Equity for companies on a specific datadate using the Compustat packages in Xpressfeed. Note:This query replicates the Long-Term Debt/Shareholders Equity (DSE) concept in Research Insight
Data Packages
Returns Adjusted Dividends And IID For Specific Datadates
Version Date:07/01/2020
This query provides the daily dividends on an adjusted and unadjusted basis
Data Packages
Returns Number Of Securities Issued Per Company
Version Date:07/01/2020
This query returns the number of securities issued per company
Data Packages
Returns Quarterly Transparency Data For A Company
Version Date:07/01/2020
This query returns transparency data for Cost of Goods Sold Quarterly (COGSQ), Net Sales Quarterly (SALEQ), and Selling, General, and Administrative Expenses Quarterly (XSGAQ) for Wells Fargo Co (WFC) at September 30, 2007 in Xpressfeed
Data Packages
Returns Companies Where CURCD Differs From CURCDQ
Version Date:07/01/2020
This query returns companies where the ISO Currency Code - Annual is different from the ISO Currency Code - Quarterly for the same year
Data Packages
Returns Companies Trading Pink Sheets Or OTC
Version Date:07/01/2020
This query returns all of the companies trading pink sheets or OTC
Data Packages
Returns Companies That Adopted FASB 158
Version Date:07/01/2020
This query returns companies who adopted SFAS 158 by looking for an AC footnote on Pension - Funded Status (PCPPAO_FN) from the aco_pnfnta datagroup
Data Packages
Returns Number Of Companies With Final Annual Updates
Version Date:07/01/2020
This query counts the number of final updates for Y07 fiscal-year domestic industrial companies as of 5/21/08:
Data Packages
Returns Interim Fundamental Data At The Issue Level
Version Date:07/01/2020
This query returns interim fundamental data for Samsung Electronics Co Ltd. in Xpressfeed
Data Packages
Returns Companies With Preferred Stock And Without Common
Version Date:07/01/2020
This query returns companies without common or ordinary stock, but with preferred shares in Xpressfeed
Data Packages
Returns Primary And Secondary SIC Codes For A Company
Version Date:07/01/2020
This query returns the primary and secondary Standard Industrial Classification (SIC) codes for a company in Xpressfeed. Note: Uncomment the second query to return the historical SIC Xpressfeed
Data Packages
Returns Companies With Quarterly Financials
Version Date:07/01/2020
The following sample query returns the number of companies per country that have quarterly or semi-annual financials available using the Compustat database in Xpressfeed.
Data Packages
Entity Level ICR Long Term Local Currency Rating at given Observation Date
Version Date:06/26/2020
The following sample SQL query returns the current Long Term Local currency ICR Rating, Outlook and Credit Watch values as of the given observation date for an Entity. The rating type can be modified using the where clause values.
Data Packages
Returns BETA For A Particular Company(Using CompanyId)
Version Date:06/03/2020
This sample query pulls the BETA for IBM (Current Period) from Xpressfeed. Note: Here the company ID is used to identify the particular company. Beta is only pre-calculated for a company's fiscal period end dates. To calculate a daily Beta, one needs to use the S&P Capital IQ Market Data tables and perform the necessary calculation
Data Packages
Filing Date For CIQ Instance
Version Date:06/03/2020
This query returns records from the S&P Capital IQ Fundamentals with a filing date of Mar-30-2018
Data Packages
Returns Shares Outstanding
Version Date:06/03/2020
This query calculates historical, company-level shares outstanding using the S&P Capital IQ Market Data and Equity Capital Structure packages in Xpressfeed for a particular CompanyId (Here for Apollo Global Management.Inc.)
Data Packages
Returns Last Close Balance Sheet Shares Outstanding For A Company
Version Date:06/03/2020
This query returns the Last Close Balance Sheet Shares Outstanding (Data Item ID #100053) for IBM for fiscal-year 2014 using the S&P Capital IQ Market Data package in Xpressfeed
Data Packages
Returns The Number Of Companies With Geographic And/Or Business Segment Data
Version Date:06/03/2020
This sample query returns the number of companies that have segment data available before and after a specified date. Note: This example uses April 19, 2009 for the date
Data Packages
Returns Latest Annual Fundamental Data
Version Date:06/03/2020
This query returns the most recent(Latest Period Flag=1) annual(periodTypeId=1) fundamental financial data for Teletech Holdings Inc (companyId = 348722) in the Latest Financials package
Data Packages
Returns CIQ Annual Values For Restated Fiscal Year Basis
Version Date:06/03/2020
This query returns the S&P Capital IQ annual financials data for a company restated for the latest fiscal-year change (FiscalChainSeriesId) in Xpressfeed. The fiscal year used are 1994 , 1995 , 1996 , 2008 , 2009
Data Packages
Primary NAICS Codes For Specified Segmentid
Version Date:06/03/2020
This sample query displays North American Industry Classification System (NAICS) codes for the designated segment id using the S&P Capital IQ data tables in Xpressfeed
Data Packages
Returns CIQ Fast Fundamentals Data Item List
Version Date:06/03/2020
This query returns the data items collected and calculated for S&P Capital IQ Fast Financials in Xpressfeed
Data Packages
Returns GAAP Used To Collect Company Information
Version Date:06/03/2020
This query returns the GAAP (Generally Accepted Accounting Principles) that a company uses in their financial reporting for a specific period using the S&P Capital IQ Fundamentals packages in Xpressfeed
Data Packages
Returns Geographic Segment For A Company By Using Segment Id
Version Date:06/03/2020
This sample query returns the geographic segment name for a specified Segment ID using the S&P Capital IQ Fundamental in Xpressfeed. NOTE: For reference Not all records from the segment table have records in the segment classification table
Data Packages
Returns Most Recent EPS Items For A Specific Company
Version Date:06/03/2020
This query pulls in the most recent EPS items for a specific company, period type, and filing type from Xpressfeed. Note:Here IBM is taken as an example and periodType is Annual
Data Packages
Number Of CIQ Private Companies With Revenue
Version Date:06/03/2020
This query screens the S&P Capital IQ Fundamentals database for the number of private companies with Total Revenues available. Please note that this query is specific to the S&P Capital IQ Fundamentals offering via Xpressfeed. There is additional private company financials data in our Private Company Fundamentals offering
Data Packages
Returns CIQ Fundamentals In Reported And Target Currency
Version Date:06/03/2020
This query returns a data item in the reported currency and translated into a target currency using the S&P Capital IQ Premium Financials packages and the v2 Exchange packages in Xpressfeed: NOTE:Displays item from S&P Capital IQ Premium Financials package in reported currency and same item translated to target currency
Data Packages
Quarterly Book Value Per Share
Version Date:06/03/2020
This sample query returns quarterly Book Value Per Share for Analog Devices Inc. using the S&P Capital IQ Fundamentals in Xpressfeed
Data Packages
Returns CIQ Data Item Values For A Single Data Item From Original Filings For A Company
Version Date:06/03/2020
This query returns the data values reported in the original filings for a single data item for a company. Note: Here Sony is the company name and the period type is annual and restatement type is original
Data Packages
Returns Unit Type Name For The Data Items
Version Date:06/03/2020
This query returns the Unit Type Name (unitTypename) for data items using the S&P Capital IQ tables in Xpressfeed
Data Packages
Returns CIQ Fiscal Year Change Period Detail
Version Date:06/03/2020
This query can be used to validate differences for the same periods that may occur when a company has a fiscal-year change with details for Calculated vs. Reported periods and the number of months covered
Data Packages
Returns Annual Historical Fundamentals For Specific Data Items
Version Date:06/03/2020
The following sample query returns specific S&P Capital IQ financial data items by either ticker or company ID. Note: In this sample query, the ticker symbol for Amazon (AMZN) is used. If you wish to query by company ID, you can uncomment c.companyId
Data Packages
Returns The Number Of Companies Filing Annual Or Quarterly Statements
Version Date:06/03/2020
This query compares the number of companies with annual filings to the number of companies with quarterly filings for a specific year by country using the S&P Capital IQ files in Xpressfeed. Note: Comparing the results between countries in the two lists shows you an approximation of countries that have a high percentage of companies that file quarterly reports
Data Packages
Returns Shares Outstanding In The Other Component Section Of The ECS
Version Date:06/03/2020
This query returns the Shares Outstanding in the Other Components section of Equity Capital Structure (ECS) for TerraForm Power in Xpressfeed
Data Packages
Restatement Types For CIQ Premium Fundamentals
Version Date:06/03/2020
This query returns the data values, restatement types, and filing dates of the different sources for Earnings from Continuing Operations (dataItem Id = 7) from the S&P Capital IQ Premium Fundamentals
Data Packages
Returns A List Of Reported Financial Statement Accounting Standards
Version Date:06/03/2020
This query returns a list of reported GAAP names (related to Financial Statement Accounting Standard)
Data Packages
Latest Consolidated Data For A Company
Version Date:06/03/2020
This sample query returns the most recent consolidated annual financial data for RedcapTour Co., Ltd. (exchangeSymbol = KOSE, tickerSymbol = A038390) in Xpressfeed
Data Packages
Returns Total Average Common Equity / Total Average Assets % (Data Item ID #4287)
Version Date:06/03/2020
This query returns Total Average Common Equity / Total Average Assets % (Data Item ID #4287) for four companies in the Financial Services industry sector (Toronto Dominion - GVKEY 23515, Royal Bank of Canada - GVKEY 109809, The Bank Of Nova Scotia - GVKEY 873647, and Canadian Imperial Bank of Commerce - GVKEY 386873) from the S&P Capital IQ tables in Xpressfeed
Data Packages
Returns Reported Currency And Convert To Target Currency Using Latest Financials
Version Date:05/29/2020
The following sample SQL query queries display the currency in which financials were reported and convert the data to a target currency
Data Packages
Returns Basic Income Statements
Version Date:05/29/2020
The following SQL query demonstrates how to create and execute the necessary MS SQL queries to view basic income statement items for a single company as of a specific period end date
Data Packages
Returns Number Of Companies Reporting For A Data Item Annually
Version Date:05/29/2020
The following sample SQL query counts the number of companies that report to a particular dataitem from 1989 to 2019 annually (PeriodTypeId=1)
Data Packages
Returns Order Of Items In A Financial Statement For CIQLatestFinancials
Version Date:05/29/2020
The following SQL query displays the order of Items in an Financial Statement. The description corresponding to the reportingTemplateId is provided within the query
Data Packages
Returns Most Recent Annual Filing Date For A Universe Of Companies As Of An Observation Date
Version Date:05/25/2020
This query takes an observation date, and then for a universe of companies determines the most recent annual filing as of the observation date. Query can be customized for other period types and data items
Data Packages
Returns Basic Balance Sheet Items
Version Date:05/25/2020
The following sample SQL query displays basic balance sheet items for a single company for the most recent four quarterly periods
Data Packages
Returns The Latest Instance For The Current Financial Period For Various Income Statement Items
Version Date:05/25/2020
The following query retrieves the Latest Instance for the Current Financial Period for the specific income statement items for Nestle S.A
Data Packages
Returns The Order Of Items In A Financial Statement For CIQPremiumFinancials
Version Date:05/25/2020
The following sample SQL query displays the order of Items in an Income Statement. The description corresponding to the reportingTemplateId is provided within the query
Data Packages
Point-In-Time Date Progress Showing Quarterly Records
Version Date:05/25/2020
The following sample SQL query uses the Premium Financials Instance Date package to display Apple's filing vs. point-in-time date progression
Data Packages
Returns All Business Segment Fundamentals For A Company
Version Date:05/25/2020
The following sample SQL query demonstrates how to view the latest annual business segment financials for International Business Machines Corp. (in the reported currency). Note: This sample query includes data from all Segment Add-On packages: the Segment Financial Data Add-On package (loads into ciqFinCollectionData table), the Segment Financials Add-On, and the Segment Profiles Add-On
Data Packages
Returns The Sources, Values And Filing Dates
Version Date:05/25/2020
The following sample SQL query displays the sources, values and filing dates for a specific company and data item as of a specific period end date
Data Packages
Returns Latest Annual Fundamentals On Given Date
Version Date:05/25/2020
This sample query returns the latest annual financials data for 500 companies for a filing date on or before the given observation date. Note: The population of 500 companies is generated using a TOP 500 in a select statement
Data Packages
Returns Basic Income Statement Items
Version Date:05/25/2020
The following sample SQL query displays basic income statement items for a single company as of a specific period end date for original and all restatement filings
Data Packages
Returns A Time Series
Version Date:05/25/2020
The following sample query below retrieves one data item, quarterly total revenue, for Abbott Laboratories (Ticker ABT) that is presented in a time series
Data Packages
Returns From And Thru Dates For Each FiscalChainSeriesId Change, Including When The ID Changes Back To A Previous FiscalChainSeriesId (i.e., Morgan Stanley 472898)
Version Date:05/25/2020
The following sample query below retrieves from and thru dates for each fiscalChainSeriesId change, including when the Id changes back to a previous fiscalChainSeriesId (i.e., Morgan Stanley 472898). Note: The FiscalYear value in the Quarterly table is just the year of the periodEndDate and not not perfectly align with all companies
Data Packages
Returns Multiple Instances For One Period
Version Date:05/25/2020
The following sample SQL queries display multiple instances for one period for a single company
Data Packages
Latest Annual Filing For Latest Period
Version Date:05/25/2020
The following sample SQL queries display latest Annual Filing for a company for the current period
Data Packages
Point-In-Time Sample Query Which Returns The Average Lag For US Companies
Version Date:05/25/2020
The following sample SQL query uses the Premium Financials Instance Date package to calculate the average lag for US companies, based on the restatement and form types. The query limits the universe to US, Original 10-Q collection for post 2009 records
Data Packages
Returns Same Day Updates For Income Statement Data
Version Date:05/25/2020
The following sample query pulls all S&P Capital IQ same day income data for the quarter specified. Please note that this query pulls data collected via Fast Financials (CIQ-FF). The Fast Financials data is meant to be there temporarily until our collection analysts have collected the data with all of the information analyzed in order to standardize and finalize the collection instance. The FF data in Xpressfeed is maintained for up to 90 days or until the same instance is collected via the full method, whichever comes first. As such, the calendar year and/or calendar quarter will need to be updated in the query in order to continue to retrieve the relevant data
Data Packages
Latest Instance For Financial Period - Annual Net EPS - Diluted Value
Version Date:05/25/2020
The following sample query below retrieves Latest Instance For Financial Period Annual Net EPS - Diluted value for International Business Machines Corporation (112350)
Data Packages
Returns Company Information By A Different Identifier
Version Date:05/25/2020
The following sample SQL query demonstrates how to use the ciqSymbol table to retrieve company information by a different identifier. The sample query below retrieves company information for Sony Corporation
Data Packages
Returns A Time Series Using Filing Dates
Version Date:05/25/2020
The following example demonstrates how to build a time series using filing dates. The sample query below retrieves one data item, quarterly cost of goods sold, for Anadarko Petroleum Corp (GVKEY 011923) that will be presented in a time series
Data Packages
Number Of Quarterly Instances By Region Using Dynamic Pivot
Version Date:05/25/2020
The following sample query counts the number of quarterly instances by Region using Dynamic Pivot
Data Packages
Returns Reported Currency And Convert To Target Currency
Version Date:05/25/2020
The following sample SQL queries display the currency in which financials were reported and convert the data to a target currency
Data Packages
Returns GICS Classifications For Segments
Version Date:05/25/2020
The following sample SQL query demonstrates how to provide the GICS classifications for each segment associated to a filing date. The sample query below retrieves company information for International Business Machines (companyId 112350). Note: This query uses the GICS package (in the SymbolHelper files) and the S&P Capital IQ Key Documents package
Data Packages
Returns Multiple Instances For One Period(Annual)
Version Date:05/25/2020
The latestFilingForInstanceFlag is used when there are multiple records in the ciqFinInstance table that have the same financialPeriodId and the same filingDate.This would occur, for example, when a company filed its press release and its 10-Q on the same day. The latestFilingForInstanceFlag flag shows you the best instance to use if you are trying to select between these two instances. A flag indicating that this instance is the latest one for the financial period. If there are multiple instances, 1=the latest filing that exists for the financial period and 0= other instances. instanceTypeId=4 (Backward column of a press release) are excluded from consideration if instanceTypeIds of 2 or 3 exist (Original Instance or Encore) for that financial period, as this would be replacing a complete source (e.g., an SEC filing) with an incomplete source (e.g., a press release), To view the latestbest source for a company, always screen for latestForFinancialPeriodFlag=1
Data Packages
CIQ Premium Fundamentals PIVOT
Version Date:05/25/2020
PIVOTING Premium Financials for a few specific items for a set CompanyID , for a set Calendar Year. LatestPeriodFinancialFlag=1
Data Packages
TEV/EBITDA Time Series
Version Date:05/25/2020
Calculates a quarterly time series of TEV/EBITDA by joining pricing date to period end date
Data Packages
Returns The Original Filings For A Single Data Item
Version Date:05/25/2020
The following sample SQL query displays the original filings for a single data item for a given company
Data Packages
Trucost Sector Data
Version Date:05/11/2020
Returns a flattened dataset from the Trucost Data similar to the legacy csv file delivery.
Data Packages
Trucost Environmental Data
Version Date:05/11/2020
Returns a flattened dataset from the Trucost Envronmental Data similar to the legacy csv file delivery.
Data Packages
Trucost Paris Alignment Data
Version Date:05/11/2020
Returns a flattened dataset from the Trucost Paris Alignment Data similar to the legacy csv file delivery.
Data Packages
Returns Current Long Term Rating For A Portfolio Of CUSIPs
Version Date:05/10/2020
The following sample SQL query returns the current long-term rating for a portfolio of Committee on Uniform Security Identification Procedures (CUSIP) numbers from the SP Credit Ratings package in Xpressfeed
Data Packages
Links Program To Security For Ratings
Version Date:05/10/2020
The following sample SQL query links a program to its securities using ratingDataItemId 82 in the spInstrumentLevelData table and using the Ratings v4 packages in Xpressfeed
Data Packages
Returns Long Term And Short Term Ratings For An Entity For The Last 24 Hours
Version Date:05/10/2020
The following sample SQL query returns the entity-level long-term and short-term ratings changes for the last 24 hours, including CreditWatch and Outlook changes
Data Packages
Return All The Data Items Delivered In The Trucost Paris Alignment Data Packages
Version Date:04/22/2020
Return All The Data Items Delivered in The Trucost Paris Alignment Data Packages
Data Packages
Returns Financials
Version Date:01/10/2020
The following sample SQL query returns the financials for a company using the SP Capital IQ Transactions package in Xpressfeed.
Data Packages
Returns Russell ICB Financials Industry Cascade for the Russell 3000 Index
Version Date:01/10/2020
The following sample SQL query returnsRussell ICB Financials Industry Cascade for the Russell 3000 Index
Data Packages
Returns Consideration Details For A Transaction
Version Date:01/10/2020
The following sample SQL query returns the consideration details including Consideration to Shareholders, Offer Per Share, and Total Stock for a specific transaction using the SP Capital IQ Transaction packages in Xpressfeed
Data Packages
Returns Offering Date For Fixed Income Securities
Version Date:01/10/2020
The following sample SQL query returns the offering date for fixed-income offering of corporate bonds closed during 2017 for issuers located in specific countries using the SP Capital IQ Transactions package in Xpressfeed
Data Packages
Returns Tender Offer Transactions With Percent Sought Greater Than Percent Acquired
Version Date:01/10/2020
The following sample SQL query returns MA transactions for tender offers where the percent sought on the announced date is greater than the percent acquired on the final date using the SP Capital IQ tables in Xpressfeed.