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".
Install
/plugin marketplace add jwangkun/claude-for-financial-services-cnThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add jwangkun/claude-for-financial-services-cn --skill china-clean-data-xlsgit 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-xlsPersonal 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 |
Details
- Skill name
china-clean-data-xls- Repository
- jwangkun/claude-for-financial-services-cn
- 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
896jwangkun/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.
China Accrual Schedule
896jwangkun/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]".
China Accrual Schedule
896jwangkun/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]".
China Client Report
896jwangkun/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]".
China Cim Builder
896jwangkun/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]".
China Comps
896jwangkun/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.
Browse the most popular Claude skills, all finance & crypto skills, or write your own with the skills generator.