Returns Aggregate Count Of Mentions Of A Specific Keyword

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.

Enhancement Date: 8/31/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Euronext Constituent HistoryEuronext Index LevelEvents 1 Year Rolling DailyTextual Data Analytics - Transcripts (Core)Transcripts History Span
  • Associated Datasets
    Textual Data Analytics: Sentiment Scores & Behavioral MetricsIndex DataGlobal EventsMachine Readable Transcripts

Query Types

  • MSSQL
  • PostGreSQL