Inter Sector Analysis

Comparing one sector against another is the job of this sheet, which collects return on equity, trailing price to earnings and dividend yield for names grouped by sector and sets them beside seven day, one month and one year price returns.

Reading valuation and profitability next to recent performance shows where the market has already repriced a sector and where it has not. Add or replace tickers in the input column and every metric refills through MarketXLS formulas, so the picture can be rebuilt for whichever groups you follow.