Returns Average Market Value For The Most Four Recent Quarters

The following sample query calculates the average Common Shares Outstanding (CSHOQ) for the most recent four quarters multiplied by the average price close monthly for the most recent four quarters, creating an average Market Value for the most recent four quarters for a single company.

Enhancement Date: 7/1/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Core
  • Associated Datasets
    Compustat® 财务数据

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake