Total Return Using Market Data

The following sample query returns the total return in descending date order from the SP Capital IQ Market Data for company ID 112350 (IBM). The return period can be adjusted by changing the lookback period in the last line of the script.

Enhancement Date: 6/16/2026

  • SourceEDI
  • Data Packages Required
    Base Equity SecurityPrices Intraday 1990s
  • Associated Datasets
    市场数据

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake
  • Databricks