China Clean Data Xls

Clean and normalize A-share financial data for modeling. Adapts the original clean-data-xls skill for Chinese financial statements, CAS conventions, and A-share data formats. Triggers on "A股数据清洗", "财务数据清洗", "clean financial data China", "数据清洗", or "normalize financial statements".

896 stars 143 forksFinance & Crypto 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-clean-data-xls
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-clean-data-xls ~/.claude/skills/china-clean-data-xls

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-clean-data-xls

## Purpose

Clean and normalize **A股财务数据** — prepare raw financial data from 巨潮 filings for modeling and analysis.

## Data Sources

### Tier 0 — 万得 Wind(最全面付费数据)
- 覆盖:A股/港美股/基金/指数/债券/宏观/研报/分析(44个工具)
- MCP 服务:`wind-mcp`(需 `WIND_API_KEY` 密钥,以 `ak_` 开头)
- 优势:全市场覆盖面最广、数据最全面、包含研报和量化分析
- 密钥申请:https://aifinmarket.wind.com.cn/#/home

### Tier 1 — 同花顺 iFind(付费精确数据)/ AkShare MCP(Tier-2 免费备选)

```python
get_financials(ticker, "income")     → Raw income statement
get_financials(ticker, "balance")    → Raw balance sheet
get_financials(ticker, "cashflow")   → Raw cash flow statement
```

### Secondary Sources
- 巨潮 — original filings (PDF/HTML)
- 审计报告 — audited figures

## Workflow

### Step 1: Data Extraction

**Extract from source documents:**

| Document | Key Data | Format |
|----------|----------|--------|
| 资产负债表 | Assets, liabilities, equity | 千元 |
| 利润表 | Revenue, expenses, profit | 千元 |
| 现金流量表 | Operating, investing, financing CF | 千元 |
| 报表附注 | Detail breakdowns | Text/number |
| 审计报告 | Audit opinion, adjustments | Text |

**Extraction checklist:**
- [ ] All periods extracted (typically 3-5 years)
- [ ] Quarterly data if needed
- [ ] Prior year comparatives
- [ ] Notes and footnotes captured

### Step 2: Normalize Units

**Unit standardization:**

| Issue | Solution |
|-------|----------|
| 千元 vs 万元 vs 元 | Standardize to 万元 |
| Different report dates | Align to same period-end |
| Segment data | Map to consistent segments |
| Currency | All CNY |
Read the full skill on GitHub

Details

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

FAQ

What does the China Clean Data Xls skill do?

Clean and normalize A-share financial data for modeling. Adapts the original clean-data-xls skill for Chinese financial statements, CAS conventions, and A-share data formats. Triggers on "A股数据清洗", "财务数据清洗", "clean financial data China", "数据清洗", or "normalize financial statements".

How do I install the China Clean Data Xls 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 Clean Data Xls 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

China Client Report

896

jwangkun/claude-for-financial-services-cn

Generate client-facing performance reports for Chinese wealth management clients. Adapted from the original client-report skill for A-share portfolios, Chinese regulatory requirements, and local reporting conventions. Triggers on "A股客户报告", "客户持仓报告", "client report China", "wealth report A-share", "客户业绩报告", or "portfolio report for [client]".

Finance & Crypto143

China Cim Builder

896

jwangkun/claude-for-financial-services-cn

Structure and draft Confidential Information Memorandums (CIMs) for A-share sell-side M&A processes. Organizes company information into professional, investor-ready documents with Chinese market context. Triggers on "A股CIM", "保密信息备忘录", "CIM China", "confidential memorandum A-share", or "offering memorandum [company]".

Finance & Crypto143

China Comps

896

jwangkun/claude-for-financial-services-cn

Comparable company analysis for A-share stocks. Uses AkShare MCP to build peer groups, pull financial data, compute valuation multiples (PE, PB, PS), and assess relative value within a Chinese industry sector.

Finance & Crypto143

Browse the most popular Claude skills, all finance & crypto skills, or write your own with the skills generator.