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