← Back to Skills Marketplace
Excel Finance
by
alsoforever
· GitHub ↗
· v1.0.0
· MIT-0
450
Downloads
0
Stars
2
Active Installs
1
Versions
Install in OpenClaw
/install excel-finance
Description
Excel 财务模型技能 - Excel 财务模型模板、自动化报表生成
README (SKILL.md)
📊 Excel 财务模型技能
Excel 财务模型模板与自动化工具
作者： 滚滚家族 🌪️
版本： 1.0.0
主页： https://aigogoai.com
🎯 技能描述
一个帮助财务人快速创建 Excel 财务模型的工具。
核心功能：
- 📊 Excel 财务模型模板
- 📈 自动化报表生成
- 💰 财务预测模型
- 📉 敏感性分析
- 🎯 图表自动生成
🛠️ 使用方法
1. 创建财务模型
from excel_finance import create_financial_model
# 创建三表模型
model = create_financial_model(
company_name="XX 公司",
forecast_years=5,
output_file="financial_model.xlsx"
)
# 输出：Excel 文件路径
2. 生成财务报表
from excel_finance import generate_reports
# 生成财务报表
reports = generate_reports(
stock_code="600519.SH",
report_types=["balance_sheet", "income_statement", "cash_flow"],
output_file="reports.xlsx"
)
3. 敏感性分析
from excel_finance import sensitivity_analysis
# 敏感性分析
result = sensitivity_analysis(
base_case={"revenue_growth": 0.15, "margin": 0.5},
scenarios={
"bull": {"revenue_growth": 0.20, "margin": 0.55},
"bear": {"revenue_growth": 0.10, "margin": 0.45}
},
output_file="sensitivity.xlsx"
)
📋 模板列表
财务模型模板
| 模板 | 描述 | 适用场景 |
|---|---|---|
| 三表模型 | 资产负债表 + 利润表 + 现金流量表 | 全面财务分析 |
| DCF 估值 | 现金流折现模型 | 股票估值 |
| 预算模型 | 年度预算编制 | 企业预算管理 |
| 盈利预测 | 未来 3-5 年盈利预测 | 投资研究 |
分析报表模板
| 模板 | 描述 | 适用场景 |
|---|---|---|
| 财务比率分析 | 盈利能力/偿债能力/营运能力 | 财务健康诊断 |
| 趋势分析 | 3-5 年财务数据趋势 | 成长性分析 |
| 同业对比 | 同行业多公司对比 | 竞争地位分析 |
| 杜邦分析 | ROE 分解分析 | 盈利能力深度分析 |
📚 参考文档
🌪️ 滚滚的话
"你只管 do it，Excel 模型交给滚滚！"
这个技能是滚滚家族为财务人打造的 Excel 自动化利器， 希望能帮助你更高效地完成财务建模工作！
如有问题或建议，欢迎反馈！
翻滚的地球人，一直在！ 🌪️💚
创建人： 滚滚 6 号（数据分析师）
创建时间： 2026-03-28
状态： ✅ 完成
Usage Guidance
This skill appears to be a lightweight or incomplete implementation rather than a hidden-risk package: it asks only for python/pip and contains a small script that only prints messages and does not actually generate Excel files or perform network calls. Before installing or using it, consider: 1) Do not expect it to produce real spreadsheets — review or run the code in a safe sandbox to verify behavior. 2) The SKILL.md imports 'excel_finance' but the included file is excel_model.py; the package may be misnamed or missing packaging steps — ask the author for a proper distribution or a setup.py/pyproject. 3) Because it doesn't request credentials or perform network I/O, it poses low risk for secret exfiltration, but also likely lacks promised functionality. If you need real Excel output or integration with data sources, obtain a well-packaged library (with tests and explicit dependencies like openpyxl/pandas) or request the full implementation from the publisher.
Capability Analysis
Type: OpenClaw Skill
Name: excel-finance
Version: 1.0.0
The skill bundle is a non-functional or mock implementation of a financial modeling tool. The Python script (scripts/excel_model.py) contains only print statements and lacks any actual logic for Excel file generation or financial analysis, while the SKILL.md provides usage examples for a non-existent 'excel_finance' module. No security risks, malicious intent, or data exfiltration capabilities were found.
Capability Assessment
Purpose & Capability
The skill claims to create Excel models and output files (financial_model.xlsx, reports.xlsx, sensitivity.xlsx). The included Python file (scripts/excel_model.py) only prints progress and messages and does not create or write any Excel files, nor does it import or use libraries for Excel (e.g., openpyxl, pandas). SKILL.md examples import from 'excel_finance' but no module with that name is included — the actual filename is excel_model.py. This is a functional mismatch between claimed capability and shipped artifacts.
Instruction Scope
The SKILL.md examples and instructions are narrowly scoped to creating models, generating reports, and running sensitivity analysis. They do not instruct reading unrelated files, accessing environment variables, contacting external endpoints, or collecting system data. However, the instructions reference a module name ('excel_finance') that is not present in the package, which could cause runtime confusion.
Install Mechanism
No install spec is provided (instruction-only plus a small script). No external downloads, package installs, or archive extraction are present. Required binaries are reasonable (python3, pip).
Credentials
The skill requests no environment variables, no credentials, and no config paths. That is proportionate to the stated purpose. The code does not attempt to read environment variables or access external secrets.
Persistence & Privilege
The skill is not flagged always:true and does not request persistent system-level presence. It does not modify other skills or system settings. Autonomous invocation is allowed (platform default) but there are no additional privileges requested.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install excel-finance - After installation, invoke the skill by name or use
/excel-finance - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
excel-finance 1.0.0 初始发布
- 提供多种 Excel 财务模型模板，如三表模型、DCF 估值、预算及盈利预测
- 支持自动化生成财务报表（资产负债表、利润表、现金流量表等）
- 包含敏感性分析与各类财务分析报表模板
- 提供详细使用方法和参考文档
- 适用于财务建模、数据分析与报表自动化需求
Metadata
Frequently Asked Questions
What is Excel Finance?
Excel 财务模型技能 - Excel 财务模型模板、自动化报表生成. It is an AI Agent Skill for Claude Code / OpenClaw, with 450 downloads so far.
How do I install Excel Finance?
Run "/install excel-finance" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Excel Finance free?
Yes, Excel Finance is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Excel Finance support?
Excel Finance is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Excel Finance?
It is built and maintained by alsoforever (@alsoforever); the current version is v1.0.0.
More Skills