skills.rest
jwangkun
jwangkunCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

china-xlsx-author

Build CAS-conforming A-share financial models in Excel workbooks.

705|115|Updated Jun 7, 2026
Search Tags:#excel#xlsx#data-integration#financial-analysis#financial-model#a-share#cas
One-click install
npx skills add https://github.com/jwangkun/claude-for-financial-services-cn --skill china-xlsx-author
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: china-xlsx-author
Source: https://github.com/jwangkun/claude-for-financial-services-cn/tree/main/vertical-plugins/china-finance/skills/china-xlsx-author
Command: npx skills add https://github.com/jwangkun/claude-for-financial-services-cn --skill china-xlsx-author

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Create professional A-share Excel workbooks that adhere to CAS conventions, enabling accurate, repeatable Chinese equity modelling.

Core Features & Use Cases

  • Standard workbook structure including Cover, Assumptions, P&L, Balance Sheet, Cash Flow, Working Capital, Valuation, Charts, and Checks.
  • Formatting standards for Chinese financial models: inputs in blue, calculations in black, hardcodes in red, currency in yuan, dates in CAS style.
  • Use Case: Build an end-to-end A-share financial model for a company and produce a ready-to-share Excel workbook for internal review, investor deck, or IPO filings.

Quick Start

Create an A-share Excel model following the CAS-aligned workbook structure.

Frequently Asked Questions about china-xlsx-author

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

FAQPage Schema
How do I build an A-share financial model in Excel that conforms to CAS conventions?▼

Build A-share financial models in Excel with standardized workbooks covering P&L, balance sheets, and cash flows to ensure CAS compliance, accurate calculations, and repeatable Chinese equity analysis.

What is the standard workbook structure for Chinese equity financial analysis?▼

A standard Chinese equity financial analysis workbook includes Cover, Assumptions, P&L, Balance Sheet, Cash Flow, Working Capital, Valuation, Charts, and Checks sheets to produce consistent, auditable models.

How do I apply CAS formatting rules to an Excel financial model?▼

Apply CAS formatting rules by using blue for inputs, black for calculations, red for hardcodes, yuan for currency, and CAS-style dates to maintain auditable A-share financial models.

Can I use free data sources to create an A-share Excel model?▼

Yes, you can use free AkShare MCP data or premium iFind MCP data, supplemented by Juchao filings and broker templates, to populate income statements, cash flows, and valuations in your workbook.

What's the best way to automate A-share financial modeling for IPO filings?▼

Automate A-share financial modeling for IPO filings by applying data-driven automation and standardized formatting rules to generate ready-to-share Excel workbooks for internal review and investor decks.

Does this A-share modeling approach support valuation and working capital analysis?▼

Yes, the A-share modeling approach supports valuation and working capital analysis by integrating dedicated sheets within the workbook to calculate equity value and assess operational liquidity.

Related Skills

Explore More Finance & Accounting Skills→
jwangkunjwangkun
705

china-pptx-author

Generate A-share investment PPTX decks from live market data via iFind and AkShare MCP.

Community
Intermediate
jwangkunjwangkun
705

china-roll-forward

Update A-share financial models with CAS adjustments and iFind or AkShare data.

Community
Advanced
dgkngkdgkngk

3-statements

Populates financial statement templates and validates cross-statement consistency for accurate reporting.

Community
Advanced
rezosndrezosnd

excel-generator

Generate styled Excel workbooks with formulas, charts, and data validation.

Community
Intermediate