Returns Companies With Merger Or Spin-Off

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.

Enhancement Date: 7/1/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Core
  • Associated Datasets
    Compustat® 財務情報

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake