Functional Scope
Trigger Rules (When to Use This Skill)
- The user explicitly raises requests such as "comparable company analysis", "peer comparison", "horizontal comparison of operations + valuation", etc.
- The input contains a single identifiable company name or stock code.
- The goal is to evaluate the industry positioning and competitive position of the target listed company.
- Focus on the differences between the target company and peers in operating, financial, and valuation dimensions.
- Needed for investment target screening, fundamental research and judgment, or value investing reference.
- Involves valuation comparison and outlier judgment in M&A/investment scenarios.
Non-Trigger Rules (When Not to Use This Skill)
- The need focuses on the broad market, sector indices, or overall market sentiment, rather than a single company comparison.
- The core of the question is macro-level analysis such as macro policy, interest rates, liquidity, etc.
- The target company's business model is highly unique and lacks a sample of comparable listed companies.
- The target entity is a private company, or a highly diversified conglomerate that cannot be compared horizontally.
- The need is to discover directions from market mainlines or build a candidate target pool.
- The need includes intraday real-time abnormal movement monitoring or trading alerts.
- The topic is fund screening or bond commentary, which does not fall within the scope of company comparable analysis.
Script Description
1. Data Retrieval Script scripts/get_data.py
- Only responsible for calling the interface and standardizing results
- Does not save raw interface data to local files
- Output fields:
header、section_finance、section_valuation、records
2. Tabulation Script scripts/excel_theme.py
- Based on
get_data.pyoutput generates a themed Excel - Reproduces the target style (dark blue top bar + two-section table)
- Default save path:
miaoxiang/comparable_company_analysis/
Quick Start
Input Query Specification
To query the comparable companies of a listed company, the input query can simply be the name of the listed company, for example, East Money.
1. Data Retrieval Debugging Only
python3 {baseDir}/scripts/get_data.py --query "东方财富"
2. One-Click Excel Visualization Report Generation
python3 {baseDir}/scripts/excel_theme.py --query "东方财富"
Output File Description
| File | Description |
|---|---|
comparable_company_analysis_<ID>.xlsx |
Comparable Company Analysis Visualization Excel Report |
Output Specification
Read the information in the visualization Excel report, and in response to the question and input content, provide an answer that outputs an analysis of the financial and valuation differences between the target company and comparable companies, as well as an explanation of the business reasons and strategic roots behind the differences.
Analysis Example (BYD vs. Great Wall Motors 2018-2022):
- 2018 and 2019: BYD's net profit was significantly lower than that of Great Wall Motors
- 2020: Under the wave of comprehensive development of new energy vehicles, BYD's production and sales of new energy vehicles gradually increased, and its net profit rose significantly and surpassed that of Great Wall Motors
- 2022: With the continuous iterative update of new energy vehicle technology, net profit achieved a qualitative leap, far surpassing that of Great Wall Motors
Frequently Asked Questions
Error: Currently, only A-share listed companies are supported for comparable company analysis
→ Currently, only A-share listed companies are supported; Hong Kong and U.S. stocks, delisted stocks, etc. are not supported. Please try to enter the name of an A-share listed company to meet the input requirements.
Note: Currently, comparable company analysis is supported for only a single listed company.
→ If multiple entities are entered, only the comparable company analysis for the first entity will be returned.
Note: The company lists in the Financial Indicators and Valuation sections may differ.
→ This is because a peer company has not yet disclosed its periodic report for the latest reporting period; in this case, only valuation data is returned for that company.
Note: The statistical fields for different indicators may differ.
→ If there are fewer than 2 valid comparable companies, the statistics are invalid, which will reduce the rigor of the report.
Compliance Statement
- The results are for reference only and do not constitute investment advice.
- When the interface fails, a clear error is returned, and analysis conclusions must not be fabricated.
- The indicator names and order in the output must remain consistent with the fixed column definitions.