Returns SecurityId Associated To CUSIP9

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

Enhancement Date: 9/29/2020

  • SourceMarket Intelligence
  • Data Packages Required
    GICRS Security Detail Daily
  • Associated Datasets
    世界産業分類基準（GICS®）

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake