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]".

896 stars 143 forksDocuments & Office Files Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add jwangkun/claude-for-financial-services-cn

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add jwangkun/claude-for-financial-services-cn --skill china-xlsx-author
Manual install
git clone --depth 1 https://github.com/jwangkun/claude-for-financial-services-cn.git /tmp/claude-for-financial-services-cn
mkdir -p ~/.claude/skills
cp -r /tmp/claude-for-financial-services-cn/agent-plugins/china-earnings-reviewer/skills/china-xlsx-author ~/.claude/skills/china-xlsx-author

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# 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 免费备选)

```python
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:**
Read the full skill on GitHub

Details

Skill name
china-xlsx-author
Path
agent-plugins/china-earnings-reviewer/skills/china-xlsx-author/SKILL.md
License
Apache-2.0
Repo updated
14 September 2026

FAQ

What does the China XLSX Author skill do?

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 the China XLSX Author skill?

Claude Code plugin: /plugin marketplace add jwangkun/claude-for-financial-services-cn. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is China XLSX Author popular?

It lives in jwangkun/claude-for-financial-services-cn, which has 896 GitHub stars and 143 forks.

Related skills

China 3 Statement Model

896

jwangkun/claude-for-financial-services-cn

Three-statement financial model for A-share stocks. Adapts the standard 3-statement-model methodology for Chinese accounting standards (CAS), Chinese GAAP differences, and AkShare-sourced financials. Use instead of the original 3-statement-model skill when building integrated IS/BS/CF models for Chinese listed companies.

AI, LLMs & Agents143

China Accrual Schedule

896

jwangkun/claude-for-financial-services-cn

Build accrual schedules for A-share fund administration. Tracks revenue recognition, expense accruals, and working capital timing for fund accounting. Adapted from the original accrual-schedule skill for fund accounting standards. Triggers on "基金应计项目", "应计计提基金", "accrual schedule fund", "NAV accruals", or "accruals [fund]".

Finance & Crypto143

China Accrual Schedule

896

jwangkun/claude-for-financial-services-cn

Build accrual schedules for A-share companies tracking revenue recognition, expense accruals, and working capital timing. Adapted from the original accrual-schedule skill for CAS accounting and Chinese business practices. Triggers on "A股应计项目", "应计计提", "accrual schedule China", "应计账款分析", or "working capital accruals [company]".

Finance & Crypto143

Find Session

330

fleurytian/awesome-claude-skills

Identify a specific Claude Code conversation by its UUID and optionally pin it as a shell function for one-word resume. Use when "claude --continue" picks the wrong session, or when the user wants to reliably resume a specific past conversation across reboots.

Documents & Office Files53

China Strip Profile

896

jwangkun/claude-for-financial-services-cn

Create one-page company profile slides (strip profiles) for A-share targets in pitch books and deal materials. Adapted from the original strip-profile skill for Chinese companies, A-share market data, and Chinese business terminology. Triggers on "A股公司简介", "公司概况", "strip profile China", "one-pager A-share", or "target profile for [company]".

Documents & Office Files143

Pitch Deck

473

ailabs-393/ai-labs-claude-skills

Generate professional PowerPoint pitch decks for startups and businesses. Use this skill when users request help creating investor pitch decks, sales presentations, or business pitch presentations. The skill follows standard 10-slide pitch deck structure and includes best practices for content and design.

Documents & Office Files117

Browse the most popular Claude skills, all documents & office files skills, or write your own with the skills generator.