Returns P/E Ratio For SP 500 As Per An Observation Date Using CIQ

This query returns the Price-to-Earnings (PE) ratio for S&P 500 on an observation date using the S&P Capital IQ Premium Financials packages in Xpressfeed. Note: The Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values by using either a SET or SELECT statement.

Enhancement Date: 9/18/2024

  • SourceMarket Intelligence
  • Data Packages Required
    Finl Premium CoreFinl Premium StatementFTSE Index LevelRussell Global Constituent HistoryPrices Intraday Recent HistoryBase SecurityBase CompanyBase Exchange Rates
  • Associated Datasets
    S&P Capital IQ Financials

Query Types

  • MSSQL