china-clean-data-xls

Normalize A-share financial statements to CAS-aligned, unit-consistent data.

705|115|Updated Jun 7, 2026
One-click install
npx skills add https://github.com/jwangkun/claude-for-financial-services-cn --skill china-clean-data-xls
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: china-clean-data-xls
Source: https://github.com/jwangkun/claude-for-financial-services-cn/tree/main/vertical-plugins/china-finance/skills/china-clean-data-xls
Command: npx skills add https://github.com/jwangkun/claude-for-financial-services-cn --skill china-clean-data-xls

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Clean and normalize A-share financial data for modeling, removing inconsistencies across periods, units, and CAS classifications to enable accurate analysis.

Core Features & Use Cases

  • Normalize units (e.g., 千元 to 万元) and align dates to consistent period ends.
  • Map CAS line items to standard equivalents (revenue, COGS, tax, etc.) and produce a CAS-consistent dataset.
  • Use Case: Prepare 3-5 years of Chinese financial statements for a DCF model or equity screening.

Quick Start

Normalize the latest 3-5 years of A-share financial statements into CAS-aligned, unit-consistent data for modeling.

Frequently Asked Questions about china-clean-data-xls

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I normalize A-share financial statements for DCF modeling?

To normalize A-share financial statements for DCF modeling, you need to align CAS line items, standardize units to 万元, and handle restatements across 3-5 annual periods to ensure consistent data inputs.

What is the best way to clean raw Chinese financial data for equity screening?

The best way to clean raw Chinese financial data for equity screening is to map CAS classifications to standard equivalents and apply unit normalization across balance sheets, income statements, and cash flow statements.

Does this data normalization process handle unit conversion from 千元 to 万元?

Yes, the data normalization process handles unit conversion from 千元 to 万元 to ensure all financial statement figures are consistently scaled for accurate modeling and analysis.

How do I map CAS line items to standard financial categories for balance sheets?

You map CAS line items by aligning raw A-share balance sheet entries to standard equivalents like revenue, COGS, and tax, producing a CAS-consistent dataset ready for financial modeling.

Can I use this to prepare 5 years of cash flow statements with restatements?

Yes, you can prepare 3-5 years of cash flow statements, as the process specifically handles restatements and non-recurring items to deliver accurate, period-aligned financial data.

Why does my A-share financial data show inconsistencies across annual periods?

A-share financial data shows inconsistencies across annual periods due to varying units, misaligned period end dates, and unhandled restatements, which require CAS mapping and unit standardization to resolve.