Quantitative Analysis of Stocks

Assembles a quantitative scorecard across a list of tickers: market capitalization, price to earnings, return on capital, return on equity and debt to equity, grouped by sector and industry. The database query formula generates the candidate universe and each metric lands in its own column, so rows can be sorted or ranked on a single factor or a weighted blend. Sector and industry tags earn their place here, because ratios that look extreme in isolation are often ordinary for the group, and the comparison stays one column away.