Does it support industry-specific metrics?

Absolutely. It includes specialized indicators for various A-share sectors, such as net interest margins for banks, R&D ratios for tech, and contract liabilities for consumer goods.

Can it generate the final report in Excel format?

Yes, it is specifically designed to output structured Excel data with professional formatting, formulas (avoiding hard-coding), and clear statistical blocks.

How many companies can I compare at once?

While it can handle multiple companies, it is best used for a peer group of 5-15 companies to ensure analysis depth and clarity in the statistical benchmarking section.

What data sources does this skill use?

The skill prioritizes the cn-financial-mcp data source for institutional-grade accuracy. If unavailable, it falls back to official sources like Juchao Information and stock exchange announcements.

Is this skill suitable for international stocks?

Currently, this skill is optimized for the China A-share market, utilizing local industry standards (Shenwan) and specific accounting metrics like 'net profit after non-recurring items'.

A-Share Comps Analysis

Name: A-Share Comps Analysis
Author: ccq1

byccq1

•

数据科学与机器学习

Generates institutional-grade financial peer comparison tables for China A-share companies in Excel format.

This skill empowers Claude to perform professional-level valuation and operational benchmarking for A-share listed companies. By integrating with MCP data sources, it retrieves real-time quotes, financial indicators (ROE, margins), and valuation metrics (PE, PB, PS) to build structured Excel reports. It automates the calculation of statistical benchmarks like medians and quartiles, providing a robust framework for investment research, M&A analysis, and industry-wide performance tracking. It is specifically designed to handle the nuances of the Chinese market, including Shenwan industry classifications and 'net profit excluding non-recurring gains/losses'.

主要功能

01Industry-specific indicator customization for sectors like Banking, Tech, and Consumer

02Comprehensive valuation metrics including PE-TTM, PB, PS, and EV/EBITDA

0315 GitHub stars

04Automated financial data retrieval via cn-financial-mcp integration

05Statistical benchmarking (Max, Min, Median, 25th/75th Percentiles)

06Standardized Excel output with professional formatting and embedded formulas

使用场景

01M&A due diligence and target company benchmarking for investment banking

02Equity research and valuation reports for A-share listed companies

03Competitive analysis and industry landscape mapping for corporate strategy

主要功能

01Industry-specific indicator customization for sectors like Banking, Tech, and Consumer

02Comprehensive valuation metrics including PE-TTM, PB, PS, and EV/EBITDA

0315 GitHub stars

04Automated financial data retrieval via cn-financial-mcp integration

05Statistical benchmarking (Max, Min, Median, 25th/75th Percentiles)

06Standardized Excel output with professional formatting and embedded formulas

使用场景

01M&A due diligence and target company benchmarking for investment banking

02Equity research and valuation reports for A-share listed companies

03Competitive analysis and industry landscape mapping for corporate strategy