china-xlsx-author
Create professional Excel workbooks for A-share financial analysis. Adapts the original xlsx-author skill for Chinese financial modeling standards, CAS conventions, and A-share formatting. Triggers on "A股Excel模型", "财务模型制作", "create model China", "build model xlsx", "制作模型", or "Excel model [company]".
How do I install this agent skill?
npx skills add https://github.com/jwangkun/claude-for-financial-services-cn --skill china-xlsx-authorIs this agent skill safe to install?
- Gen Agent Trust Hubpass
This skill provides structured instructions and templates for an AI agent to create professional financial Excel workbooks based on Chinese Accounting Standards (CAS). It contains no executable code, malicious commands, or security risks.
- Socketpass
No alerts
- Snykpass
Risk: LOW · No issues
What does this agent skill do?
china-xlsx-author
Purpose
Create professional A股财务分析Excel模型 — structured workbooks for Chinese equity analysis.
Data Sources
Primary: iFind MCP (Tier-1 付费) / AkShare MCP (Tier-2 免费备选)
get_financials(ticker, "income") → Income statement data
get_financials(ticker, "balance") → Balance sheet data
get_financials(ticker, "cashflow") → Cash flow data
get_quote(ticker) → Market data
Secondary Sources
- 巨潮 — source filings
- 券商研报 — template references
Workflow
Step 1: Workbook Structure
Standard A-share model structure:
| Sheet | Content |
|---|---|
| 封面 (Cover) | Company, date, version, disclaimer |
| 假设 (Assumptions) | All model inputs, drivers |
| 利润表 (Income) | Historical + forecast P&L |
| 资产负债表 (Balance Sheet) | Historical + forecast BS |
| 现金流量表 (Cash Flow) | Historical + forecast CF |
| 营运资本 (Working Capital) | WC analysis, assumptions |
| 估值 (Valuation) | DCF, comps, sensitivity |
| 图表 (Charts) | Key visuals |
| 检查 (Checks) | Sum checks, balances |
Step 2: Formatting Standards
Chinese financial model formatting:
| Element | Format |
|---|---|
| Headers | Bold, background color |
| Inputs | Blue font, light blue background |
| Calculations | Black font, no background |
| Hardcodes (to avoid) | Red font |
| Negative numbers | Red font or (XXX) |
| Percentage | % format, 1 decimal |
| Currency | ¥ or 万元 |
| Dates | YYYY-MM-DD or YYYY年MM月 |
Color coding:
蓝色 = 输入 (Inputs)
黑色 = 公式 (Calculations)
红色 = 警告 (Warnings / hardcodes)
绿色 = 链接 (Links)
灰色 = 标签 (Labels)
Step 3: Income Statement Layout
Standard P&L format (CAS):
| Item | FY2021 | FY2022 | FY2023 | FY2024E | FY2025E |
|---|---|---|---|---|---|
| 营业收入 | |||||
| 减: 营业成本 | |||||
| = 毛利 | |||||
| 毛利率 | |||||
| 减: 税金及附加 | |||||
| 减: 销售费用 | |||||
| 减: 管理费用 | |||||
| 减: 研发费用 | |||||
| 减: 财务费用 | |||||
| 加: 投资收益 | |||||
| 加: 公允价值变动 | |||||
| 减: 信用减值损失 | |||||
| 减: 资产减值损失 | |||||
| 加: 资产处置收益 | |||||
| = 营业利润 | |||||
| 加: 营业外收入 | |||||
| 减: 营业外支出 | |||||
| = 利润总额 | |||||
| 减: 所得税费用 | |||||
| = 净利润 | |||||
| 其中: 归母净利润 | |||||
| 其中: 扣非净利润 | |||||
| EPS (元/股) |
Step 4: Balance Sheet Layout
Standard BS format (CAS):
| Item | FY2021 | FY2022 | FY2023 | FY2024E | FY2025E |
|---|---|---|---|---|---|
| 资产 | |||||
| 货币资金 | |||||
| 交易性金融资产 | |||||
| 应收票据 | |||||
| 应收账款 | |||||
| 预付款项 | |||||
| 存货 | |||||
| 其他流动资产 | |||||
| 流动资产合计 | |||||
| 长期股权投资 | |||||
| 固定资产 | |||||
| 在建工程 | |||||
| 无形资产 | |||||
| 商誉 | |||||
| 其他非流动资产 | |||||
| 非流动资产合计 | |||||
| 资产总计 | |||||
| 负债 | |||||
| 短期借款 | |||||
| 应付票据 | |||||
| 应付账款 | |||||
| 合同负债 | |||||
| 应付职工薪酬 | |||||
| 应交税费 | |||||
| 其他应付款 | |||||
| 流动负债合计 | |||||
| 长期借款 | |||||
| 应付债券 | |||||
| 预计负债 | |||||
| 非流动负债合计 | |||||
| 负债合计 | |||||
| 所有者权益 | |||||
| 股本 | |||||
| 资本公积 | |||||
| 盈余公积 | |||||
| 未分配利润 | |||||
| 归母股东权益 | |||||
| 少数股东权益 | |||||
| 所有者权益合计 | |||||
| 负债及权益总计 |
Step 5: Assumptions Sheet
Key assumptions to centralize:
| Category | Assumption | Value | Source |
|---|---|---|---|
| Revenue growth | FY2024E | X% | |
| Revenue growth | FY2025E | X% | |
| Gross margin | FY2024E | X% | |
| SG&A % of revenue | FY2024E | X% | |
| Tax rate | Effective | X% | |
| D&A | % of PPE | X% | |
| CapEx | % of revenue | X% | |
| NWC | % of revenue | X% | |
| Terminal growth | X% | ||
| WACC | X% |
Step 6: Valuation Sheet
DCF layout:
| Item | Value | Notes |
|---|---|---|
| Enterprise value | ¥XX亿 | |
| Less: Net debt | ¥XX亿 | |
| Equity value | ¥XX亿 | |
| Shares outstanding | XX亿股 | |
| Value per share | ¥XX | |
| Current price | ¥XX | |
| Upside/(Downside) | X% |
Football field:
| Method | Low | Mid | High |
|---|---|---|---|
| P/E | |||
| P/B | |||
| EV/EBITDA | |||
| DCF | |||
| Range | ¥XX | ¥XX | ¥XX |
Step 7: Checks Sheet
Essential checks:
| Check | Formula | Target | Result |
|---|---|---|---|
| BS balances | Assets - L - E | 0 | |
| CF ties | Ending cash - Beg cash - Net CF | 0 | |
| Revenue growth | (Rev - Rev_prev) / Rev_prev | Reasonable | |
| Margin check | GP / Revenue | Reasonable | |
| Debt schedule | ST + LT debt | = Total | |
| Retained earnings | RE beg + NI - Div | = RE end | |
| Depreciation | D&A / PPE | Reasonable |
Step 8: Charts & Presentation
Key charts to include:
| Chart | Purpose |
|---|---|
| Revenue & profit bridge | Historical + forecast |
| Margin trends | Gross, operating, net |
| Valuation multiples | Historical range |
| DCF sensitivity | Tornado chart |
| Peer comparison | Comps scatter plot |
China-Specific Excel Conventions
Unit Standards
| Unit | Usage |
|---|---|
| 元 | Per-share items |
| 万元 | Most financial items |
| 亿元 | Large totals, market cap |
Naming Conventions
| Item | Convention |
|---|---|
| Sheet names | Short, Chinese preferred |
| Cell references | Named ranges for key cells |
| File naming | [Ticker][Company][Date]_v[X] |
Formula Conventions
| Convention | Example |
|---|---|
| Sheet references | '利润表'!B10 |
| Named ranges | Revenue, WACC, Shares |
| Chinese function names | SUM, IF, VLOOKUP |
Quality Checks
Before finalizing:
- All sheets present and linked
- No hardcodes in calculation cells
- Historicals cross-checked
- CAS conventions applied
- BS balances and CF ties
- Valuation reasonable
- Charts update automatically
- All checks green
- Documentation complete
Data Source Mode Switch: Set env var
IFIND_DATA_SOURCE_MODEto control data source preference.
ifind-only(strict): Use iFind only, error if unavailableifind-fallback(default): iFind preferred, fallback to AkShareakshare-only, wind-only (Wind only), wind-fallback (Wind first, fallback to iFind → AkShare): Skip iFind, use AkShare only
How can the creator link this skill?
Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.
<a href="https://skillzs.dev/skills/jwangkun/claude-for-financial-services-cn/china-xlsx-author">View china-xlsx-author on skillZs</a>