This is a trading object shared by a member. You can use this object as well as hundreds of others with QuantShare - Trading Software.
Click on the Like button or on one of the share buttons to share this object and spread the word about QuantShare.
QuantShare is an advanced trading software for stock, forex, futures, ETF and options markets. It is the best and the most complete EOD trading software software and it is FREE (beta version).
The S&P 500 Price to Earnings Ratio is the average PER (Price to Earnings ratio) of the 500 stocks that compose the S&P 500 Index. The P/E ratios are based on trailing 12-month earnings, and they are reported quarterly with one-quarter lag due to reporting.
The Price earnings ratio is simply calculated by dividing the stock price by the earnings per share (the total profits or earnings of a company divided by the number of outstanding shares). Therefore, this value increases when the stock price increases in value or if the earnings per share decrease. You can get the 'Price Earnings Ratio' data for individual stocks by using the following downloader item: Valuation ratios for US stocks. (The item do not download historical PER data, it only gets the last PER value for each stock that trades in the U.S. market).
This item downloads the S&P 500 Price to Earnings Ratio historical data from the 'standardandpoors' website. The content is downloaded as an Excel file, therefore Excel should be installed on your machine in order for this item to work properly. The data is associated with the following symbol: '^SP500_PE'. This symbol is automatically created after the downloading process completes.
