sector-equity-scoring

name	sector-equity-scoring
scope	langsensei
description	Percentile-based equity scoring methodology — 18 indicators across 6 categories, with sector-adaptive weights and outlier cap rules
version	1.0.0
dependencies	{"skills":["https://github.com/LangSensei/emploke-marketplace/tree/main/skills/eastmoney-data"]}

Sector Equity Scoring Skill

A reusable methodology for building quantitative value-scoring formulas for any A-share sector. Each formula produces a 0-100 composite score per stock, combining valuation, profitability, growth, cash flow, risk, and industry quality indicators via percentile ranking.

When to Use

• Building a new sector scoring formula from scratch
• Reviewing or updating an existing formula
• Comparing scoring approaches across sectors

Core Concepts

18-Indicator System

Every sector formula targets 18 indicators organized into 6 categories:

Category	Standard Indicators	Typical Weight
Valuation (3)	PE-TTM, PB, Dividend Yield	~15-25%
Profitability (5)	ROE, ROA, ROIC, Gross Margin, Net Margin	~25-35%
Growth (2)	Revenue Growth YoY, Net Profit Growth YoY	~10-25%
Cash Flow (3)	Operating CF / Net Profit, FCF Yield, Operating CF / Revenue	~8-15%
Risk (3)	Debt-to-Asset Ratio, Current Ratio, Interest-bearing Debt Ratio	~8-12%
Industry Quality (2)	Gross Margin YoY Change, Quick Ratio	~5-10%

Sector-specific substitutions are allowed. Financial sectors (banking, insurance, securities) replace inapplicable indicators with industry-specific ones (e.g., NPL ratio, provision coverage, net interest margin for banks; combined ratio, investment yield for insurance). The total must still target 18 indicators.

Percentile Ranking Method

Each indicator is scored by ranking all stocks in the sector and converting to a 0-100 percentile:

score_i = percentile within sector (0-100)

For "lower is better" indicators (PE, D/A, etc.):
  score = 100 - percentile

For "higher is better" indicators (ROE, dividend yield, etc.):
  score = percentile

percentile = (rank - 1) / (N_valid - 1) * 100

Tie-breaking: When multiple stocks share the same indicator value, they receive the same rank (standard competition ranking). The next rank is offset by the number of tied stocks (e.g., if two stocks tie at rank 3, the next stock receives rank 5).

Edge case — N_valid = 1: When only one stock has a valid value for an indicator, the percentile formula produces 0/0. In this case, assign a score of 50 (neutral) for that indicator.

The composite score is a weighted sum:

Value_Score = Sum(weight_i * score_i) / Sum(weight_i_participated)

Missing indicators are excluded — the denominator adjusts to only include weights of indicators with valid data.

Scoring Rules

These rules prevent outliers from distorting rankings:

Rule	Description
Growth ±200% cap	Revenue and net profit growth rates are capped at ±200% before ranking. Display the capped value (e.g., 200.0, not the raw 1500%)
ROE/ROIC ≤60% cap	ROE and ROIC values exceeding 60% are capped at 60% before ranking
PE<0 exclusion	Loss-making stocks (negative PE) are excluded from PE ranking entirely (they receive no PE score)
Coverage penalty	If a stock has fewer than 10 valid indicators (out of 18), apply penalty: score *= valid_count / 18
ST/*ST exclusion	All ST and *ST stocks are excluded from the ranking universe
B-share exclusion	B-share stocks (codes starting with 9xxxxx) are excluded

FCF Yield Calculation

FCF_Yield = FCFF_BACK / f20

• FCFF_BACK = Free cash flow to firm (from datacenter-web API: RPT_F10_FINANCE_MAINFINADATA)
• f20 = Total market capitalization (from push2 batch API)
• Do NOT use f116 (circulating market cap) — use total market cap

Weight Design Principles

Weights must sum to 100% and reflect sector economics. Use these guidelines:

Base Template

Category	Default	Range
Valuation	20%	15-35%
Profitability	30%	25-35%
Growth	15%	10-25%
Cash Flow	10%	8-15%
Risk	10%	8-12%
Industry Quality	8%	5-10%

There is no single correct weight allocation — it should be driven by sector characteristics.

Sector Adaptation Rules

Sector Type	Adjustment	Rationale
Consumer staples (food, beverage, household)	Raise Profitability to ~35%, emphasize gross margin	Brand moat drives pricing power
Heavy-asset / PPP sectors (utilities, construction, transportation)	Raise Cash Flow to ~13-15%, raise Risk to ~12%	Capital-intensive, cash flow quality critical
Cyclical sectors (steel, coal, nonferrous, chemicals)	Lower Growth to ~10-12%, raise Valuation to ~25%	Growth is volatile and mean-reverting
Growth sectors (electronics, computer, pharma)	Raise Growth to ~20-25%, lower Valuation to ~15%	Revenue trajectory is the primary value driver
Financial sectors (banking, insurance, securities)	Replace Cash Flow/Risk with industry-specific indicators; Valuation ~30-35%	Standard cash flow metrics don't apply

Indicator-Level Weight Guidance

Within each category, distribute weight based on indicator importance:

• Primary indicator (the most important metric): 40-60% of category weight
• Secondary indicators: 20-30% each
• No single indicator should exceed 15% of total weight (except in financials where PB for banks can be 15%)
• Risk category: keep each indicator at 2-5%, distribute evenly across 3 indicators

Standard Output Format

Every sector formula document follows this structure:

Part 1: Data Audit

• API data sources used (batch API for quotes, datacenter-web for financials)
• Indicator availability table: indicator name, API source, field name, coverage rate, data quality
• List of unavailable indicators (weight = 0%)

Part 2: Weight Table

• One table per category showing: indicator, weight, direction (higher/lower is better), notes
• Weight summary table: category, total weight, core logic explanation
• Weights must sum to exactly 100% (101% with rounding is acceptable)

Part 3: Formula

• The scoring formula (copy the standard percentile formula)
• Scoring rules applied (growth cap, ROE/ROIC cap, PE exclusion, coverage penalty)
• Any sector-specific formula adjustments

Part 4: Ranking Table

• Full ranking table with columns: Rank, Stock Name, Code, Score, and key indicator values
• Include an indicator coverage column (X/18 format showing how many indicators had valid data)
• Data date must be stated
• Total stock count and indicator count

Part 5: Reasonableness Checks

Perform all 7 standard checks:

#	Check	What to Verify
1	Loss-making stocks	All PE<0 stocks should cluster near the bottom of rankings
2	High-score logic	Top-ranked stocks should have strong fundamentals across multiple categories, not just one extreme metric
3	Low-score logic	Bottom-ranked stocks should show clear weaknesses (losses, high debt, declining revenue)
4	Industry leader ranking	Well-known sector leaders should appear in a reasonable range (top quartile, though not necessarily #1)
5	Score distribution	Mean ~49-51, median ~49-52, >70 scores <15% of total, healthy spread
6	Cap validation	Verify that capped values appear correctly in ranking table (200.0 for growth, 60.0 for ROE/ROIC)
7	Sub-industry coverage	Check that the formula doesn't systematically favor one sub-industry over others within the sector

Present checks as a verification table: dimension, expected, actual, conclusion (pass/fail).

Include a Limitations section noting known weaknesses (e.g., YoY vs CAGR, missing indicators, cross-sectional only).

Data Sources

API	Endpoint	Purpose
Batch quote API	push2.eastmoney.com/api/qt/clist/get	Sector stock list + basic indicators (PE, PB, market cap, dividend yield)
Financial data API	datacenter-web.eastmoney.com/api/data/v1/get	Detailed financials per stock (RPT_F10_FINANCE_MAINFINADATA)

Refer to the eastmoney-data skill for API usage details, field mappings, and request patterns.

Reference Formulas

See reference/a-share/ for 32 completed A-share sector formulas (01-banking through 32-conglomerate). These serve as concrete examples of the methodology applied to different sector types.