china-clean-data-xls

china-clean-data-xls is a skill for Claude Code from jwangkun/claude-for-financial-services-cn. It costs 74 tokens per session (2,103 once invoked), scanned A, original, Apache-2.0.

A data-cleaning guide for Chinese A-share company financial statements, including figures from balance sheets, income statements and cash-flow statements. It adapts the data to Chinese accounting rules and common market formats.

In plain words
What is it for?
It helps extract several years of financial figures, quarterly data, comparative periods, notes and audit information from Chinese company filings, then prepare them for modeling and analysis.
Why use it?
Raw filings often use inconsistent labels, units and reporting periods, which makes companies difficult to compare or use in financial models. This helps organize those differences before analysis.

Skill for Claude Code

Written for Claude Code: shipped in a Claude Code plugin.

Part of the china-earnings-reviewer plugin — 31 skills, 1 agent shipped together

Good fit It helps extract several years of financial figures, quarterly data, comparative periods, notes and audit information from Chinese company filings, then prepare them for modeling and analysis.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/jwangkun/claude-for-financial-services-cn/china-clean-data-xls
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add jwangkun/claude-for-financial-services-cn --skill china-clean-data-xls
Clone the repo
git clone --depth 1 https://github.com/jwangkun/claude-for-financial-services-cn

Made for: Claude Code.

Or install china-earnings-reviewer, the plugin that ships this one along with the rest of its 31 skills, 1 agent.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for china-clean-data-xls

README.md
[![agentmods](https://agentmods.dev/badge/skills/jwangkun/claude-for-financial-services-cn/china-clean-data-xls/github.svg)](https://agentmods.dev/skills/jwangkun/claude-for-financial-services-cn/china-clean-data-xls)
Your own site
<a href="https://agentmods.dev/skills/jwangkun/claude-for-financial-services-cn/china-clean-data-xls"><img src="https://agentmods.dev/badge/skills/jwangkun/claude-for-financial-services-cn/china-clean-data-xls/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for china-clean-data-xls

Your own site · 80×15
<a href="https://agentmods.dev/skills/jwangkun/claude-for-financial-services-cn/china-clean-data-xls"><img src="https://agentmods.dev/badge/skills/jwangkun/claude-for-financial-services-cn/china-clean-data-xls.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 74 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 2,103 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe. Third-party audits
  • NVIDIA SkillSpector pass 7 Sept 2026
How audits are shown
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00074 $0.02103
Opus 5 $0.00037 $0.01052
Sonnet 5 $0.00015 $0.00421
Haiku 4.5 $0.00007 $0.00210

Measured 13d ago against content hash 433a19c82ea6, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-12, from the pricing page.

Security

Grade A, and why

china-clean-data-xls scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 13d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

agent-plugins/china-earnings-reviewer/skills/china-clean-data-xls/SKILL.md · 238 lines

How it starts

The opening of the file, as written. The whole thing — 238 lines — stays where its author put it; the contents beside it link to each section on GitHub.

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

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

Unit conversion:

From 千元: divide by 10 → 万元
From 元: divide by 10,000 → 万元
From 亿元: multiply by 10,000 → 万元

Step 3: Handle CAS-Specific Items

CAS vs IFRS mapping:

CAS Line Item Equivalent Notes
营业收入 Revenue Net of VAT
营业成本 COGS Includes VAT
税金及附加 Tax & surcharges 城建税, 教育费附加
销售费用 SG&A (selling)
管理费用 G&A
研发费用 R&D Separated from G&A in new CAS
财务费用 Interest & finance costs
投资收益 Investment income Including 联营/合营
公允价值变动 Fair value change
信用减值损失 Credit impairment New CAS 22
资产减值损失 Asset impairment
资产处置收益 Asset disposal
营业外收入 Non-operating income Including 政府补助
营业外支出 Non-operating expense
所得税费用 Income tax
净利润 Net income
归母净利润 Net income to parent Key metric
扣非净利润 Non-GAAP net income

Read the full file on GitHub · 238 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 13d ago First seen · 238 lines · 74 tokens per session scan A 433a19c82ea6

Subscribe to this mod's changes

china-clean-data-xls is a skill published in the GitHub repository jwangkun/claude-for-financial-services-cn (744 stars, last pushed 3mo ago), licensed Apache-2.0. It adds 74 tokens to every session and 2,103 once invoked, about $0.0004 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

fs-creative-voltage

OpenDesign's seed pitch: the open, local alternative to closed AI design — why now, the wedge, and the ask. Built as a decision-grade fundraising pitch deck for pre-seed & seed VCs.

nexu-io/open-design · 49 tokens

ml-strategy

Machine-learning predictive strategy based on sklearn walk-forward training, feature engineering, and signal generation. Suitable for any OHLCV data.

HKUDS/Vibe-Trading · 30 tokens

ai-readiness

Scan the portfolio for the highest-leverage AI opportunities and rank where to deploy operating-partner time. Ingests quarterly updates and financials across multiple portfolio companies, identifies quick wins at each, and stacks them into a single ranked action list. Use during quarterly portfolio reviews, annual…

anthropics/financial-services · 112 tokens

merger-model

Build accretion/dilution analysis for M&A transactions. Models pro forma EPS impact, synergy sensitivities, and purchase price allocation. Use when evaluating a potential acquisition, preparing merger consequences analysis for a pitch, or advising on deal terms. Triggers on "merger model", "accretion dilution", "M&A…

anthropics/financial-services · 87 tokens

technical-basic

Core technical indicator collection (trend EMA/ADX + mean-reversion BB/RSI + volume-price OBV/volume ratio), generates a composite signal via three-dimensional voting. Pure pandas implementation for any OHLCV data.

HKUDS/Vibe-Trading · 48 tokens

qveris

Paid capability marketplace for global multi-asset data; use it when free Vibe-Trading sources lack coverage, depth, or provider quality, and keep free sources as the default for routine OHLCV.

HKUDS/Vibe-Trading · 45 tokens