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
    文本数据分析：情绪评分与行为指标指数数据全球事件机器可读转换文稿记录

Query Types

  • MSSQL
  • PostGreSQL