Returns Ratings For Securities Using CIQ Company ID

The following sample SQL query returns securities based on the SP Capital IQ company ID (objectId) using the RatingsXpress v4 tables in Xpressfeed

Enhancement Date: 5/10/2020

  • SourceMarket Intelligence
  • Data Packages Required
    S&P Global Participants GI Current DailyS&P Global Ratings Cross Ref GI Current DailyS&P Global Ratings GI Current DailyS&P Global Ratings Reference
  • Associated Datasets
    RatingsXpress®：标准普尔信用评级

Query Types

  • MSSQL
  • PostGreSQL