← 返回 Skills 市场
Excel Finance
作者
alsoforever
· GitHub ↗
· v1.0.0
· MIT-0
450
总下载
0
收藏
2
当前安装
1
版本数
在 OpenClaw 中安装
/install excel-finance
功能描述
Excel 财务模型技能 - Excel 财务模型模板、自动化报表生成
使用说明 (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
状态： ✅ 完成
安全使用建议
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.
功能分析
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.
能力评估
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.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install excel-finance - 安装完成后，直接呼叫该 Skill 的名称或使用
/excel-finance触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.0
excel-finance 1.0.0 初始发布
- 提供多种 Excel 财务模型模板，如三表模型、DCF 估值、预算及盈利预测
- 支持自动化生成财务报表（资产负债表、利润表、现金流量表等）
- 包含敏感性分析与各类财务分析报表模板
- 提供详细使用方法和参考文档
- 适用于财务建模、数据分析与报表自动化需求
元数据
常见问题
Excel Finance 是什么？
Excel 财务模型技能 - Excel 财务模型模板、自动化报表生成. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 450 次。
如何安装 Excel Finance？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install excel-finance」即可一键安装，无需额外配置。
Excel Finance 是免费的吗？
是的，Excel Finance 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
Excel Finance 支持哪些平台？
Excel Finance 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Excel Finance？
由 alsoforever（@alsoforever）开发并维护，当前版本 v1.0.0。
推荐 Skills