Returns Counter For An Upgrade Or Downgrade In Value For Estimates And Revisions

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.

Enhancement Date: 8/24/2023

  • SourceMarket Intelligence
  • Data Packages Required
    CIQ Estimate Detail DailyCIQ Estimate Core DailyBase Equity Security
  • Associated Datasets
    S&P Capital IQ 预估

Query Types

  • MSSQL