china-xlsx-author

china-xlsx-author is a skill for Claude Code from jwangkun/claude-for-financial-services-cn. It costs 77 tokens per session (2,308 once invoked), scanned A, original, Apache-2.0.

A workbook-building workflow for Chinese A-share financial analysis. It creates structured Excel models with historical and forecast income statements, balance sheets, cash flow, valuation, charts, assumptions, and checks.

In plain words
What is it for?
Use it to build company models, valuation analyses, peer comparisons, forecasts, working-capital analysis, sensitivity tables, and financial charts. It can use paid iFind data or the free AkShare alternative.
Why use it?
It reduces the work of assembling financial data and formatting a model consistently for Chinese listed companies. Built-in checks help review whether the model’s statements and calculations balance.

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 Use it to build company models, valuation analyses, peer comparisons, forecasts, working-capital analysis, sensitivity tables, and financial charts. It can use paid iFind data or the free AkShare alternative.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/jwangkun/claude-for-financial-services-cn/china-xlsx-author
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-xlsx-author
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-xlsx-author

README.md
[![agentmods](https://agentmods.dev/badge/skills/jwangkun/claude-for-financial-services-cn/china-xlsx-author/github.svg)](https://agentmods.dev/skills/jwangkun/claude-for-financial-services-cn/china-xlsx-author)
Your own site
<a href="https://agentmods.dev/skills/jwangkun/claude-for-financial-services-cn/china-xlsx-author"><img src="https://agentmods.dev/badge/skills/jwangkun/claude-for-financial-services-cn/china-xlsx-author/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-xlsx-author

Your own site · 80×15
<a href="https://agentmods.dev/skills/jwangkun/claude-for-financial-services-cn/china-xlsx-author"><img src="https://agentmods.dev/badge/skills/jwangkun/claude-for-financial-services-cn/china-xlsx-author.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 77 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 2,308 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.00077 $0.02308
Opus 5 $0.00039 $0.01154
Sonnet 5 $0.00015 $0.00462
Haiku 4.5 $0.00008 $0.00231

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

Security

Grade A, and why

china-xlsx-author 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-xlsx-author/SKILL.md · 257 lines

How it starts

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

china-xlsx-author

Purpose

Create professional A股财务分析Excel模型 — structured workbooks for Chinese equity analysis.

Data Sources

Primary: iFind MCP (Tier-1 付费) / AkShare MCP (Tier-2 免费备选)

get_financials(ticker, "income")     → Income statement data
get_financials(ticker, "balance")    → Balance sheet data
get_financials(ticker, "cashflow")   → Cash flow data
get_quote(ticker)                    → Market data

Secondary Sources

  • 巨潮 — source filings
  • 券商研报 — template references

Workflow

Step 1: Workbook Structure

Standard A-share model structure:

Sheet Content
封面 (Cover) Company, date, version, disclaimer
假设 (Assumptions) All model inputs, drivers
利润表 (Income) Historical + forecast P&L
资产负债表 (Balance Sheet) Historical + forecast BS
现金流量表 (Cash Flow) Historical + forecast CF
营运资本 (Working Capital) WC analysis, assumptions
估值 (Valuation) DCF, comps, sensitivity
图表 (Charts) Key visuals
检查 (Checks) Sum checks, balances

Step 2: Formatting Standards

Chinese financial model formatting:

Element Format
Headers Bold, background color
Inputs Blue font, light blue background
Calculations Black font, no background
Hardcodes (to avoid) Red font
Negative numbers Red font or (XXX)
Percentage % format, 1 decimal
Currency ¥ or 万元
Dates YYYY-MM-DD or YYYY年MM月

Color coding:

蓝色 = 输入 (Inputs)
黑色 = 公式 (Calculations)
红色 = 警告 (Warnings / hardcodes)
绿色 = 链接 (Links)
灰色 = 标签 (Labels)

Step 3: Income Statement Layout

Standard P&L format (CAS):

Item FY2021 FY2022 FY2023 FY2024E FY2025E
营业收入
减: 营业成本
= 毛利
毛利率
减: 税金及附加
减: 销售费用
减: 管理费用
减: 研发费用
减: 财务费用
加: 投资收益
加: 公允价值变动
减: 信用减值损失
减: 资产减值损失
加: 资产处置收益
= 营业利润
加: 营业外收入
减: 营业外支出
= 利润总额
减: 所得税费用
= 净利润
其中: 归母净利润
其中: 扣非净利润
EPS (元/股)

Read the full file on GitHub · 257 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 · 257 lines · 77 tokens per session scan A 43311513236d

Subscribe to this mod's changes

china-xlsx-author 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 77 tokens to every session and 2,308 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.