← 返回 Skills 市场
daveglaser0823

Ach Volume Estimator

作者 Daveglaser0823 · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ⚠ suspicious
102
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install ach-volume-estimator
功能描述
Estimate Dwolla's end-of-month ACH transaction volume from daily KPI emails. Use when processing ACH KPI emails, when Dave asks about monthly volume projecti...
使用说明 (SKILL.md)

ACH Monthly Volume Estimator

Workflow

  1. Fetch the ACH KPI email:

    gog gmail messages search "subject:ACH KPIs" --account [email protected] --max 1 --json

  2. Download the PDF attachment (contains all charts and data):

    # Get message details with attachment IDs
gog gmail get \x3CMESSAGE_ID> --account [email protected] --json
# Find the attachment named "ACH KPIs.pdf" (mimeType: application/pdf)
# Download it:
gog gmail attachment \x3CMESSAGE_ID> \x3CATTACHMENT_ID> --account [email protected] --out ~/clawd/work/ach-kpis-latest.pdf

  3. Extract data from the PDF. The PDF contains Tableau dashboard exports with:

    • ACH Transactions chart: MoM bar chart with monthly totals, per-BD averages, 5/20/60-day comparisons
    • Client Growth charts (10K and 5K thresholds)
    • Top 60 Clients tables (60-day and 20-day comparisons)

    Key numbers to extract:

    • Current month transaction total (partial, from MoM bar chart)
    • Business days elapsed (derive from date range in "Prev. 20 Days" row or count from month start to report date)
    • YTD avg transactions per business day
    • SPLY monthly total for comparison

  4. Run the estimator:

    python3 ~/clawd/skills/ach-volume-estimator/scripts/estimate.py \
  --transactions \x3CMTD_TOTAL> --bds-elapsed \x3CBDS_SO_FAR> [--month YYYY-MM]

    Or if you already have per-BD rate:

    python3 ~/clawd/skills/ach-volume-estimator/scripts/estimate.py \
  --per-bd \x3CRATE> [--month YYYY-MM]

    Add --json for structured output.

  5. Compare to benchmarks:

    • Jan 2026 actual: 6.12M (20 BDs, 305K/BD)
    • Dec 2025 actual: 6.41M (22 BDs, 291K/BD)
    • SPLY from the PDF MoM chart

  6. Generate the visual dashboard:

    ~/clawd/scripts/ach-dashboard-gen

    This reads ~/clawd/work/ach-reports/latest-ach-data.json (or falls back to the latest markdown report) and writes ~/clawd/work/ach-reports/dashboard.html. View at: http://192.168.1.60:3013/html/work/ach-reports/dashboard.html TV mode: http://192.168.1.60:3013/html/work/ach-reports/dashboard.html?tv=1

  7. Deliver: Include estimate in the ACH KPI summary sent to Dave. Include the dashboard URL.

Output Format

One-liner: 2026-02 estimate: 5.81M txns | (19 BDs, 12 elapsed, 7 remaining) | 306,000/BD | (3,672,000 so far)

Business Day Calendar

Script uses US Federal Reserve bank holiday calendar (2025-2027 hardcoded). Excludes weekends and all Fed holidays (New Year's, MLK, Presidents' Day, Memorial Day, Juneteenth, Independence Day, Labor Day, Columbus Day, Veterans Day, Thanksgiving, Christmas).

Integration

Wire into the existing "Daily ACH KPIs summary to Dave" cron (9:30 AM ET weekdays). After extracting email data, run the estimator and append the monthly projection to Dave's summary.

安全使用建议
This skill appears to implement what its name says, but the SKILL.md and included scripts assume access to resources that are not declared in the manifest: a specific Gmail account (via a 'gog gmail' CLI), local files under ~/clawd (including revenue_calibration.json and the dashboard HTML), and a local dashboard service at 192.168.1.60. Before installing or enabling this skill: 1) verify you trust the skill author and inspect the provided scripts locally (they are included) to confirm there is no hidden exfiltration; 2) be aware you must already have a Gmail CLI configured (or provide credentials)—do not use your primary account; use a least-privileged account or service account; 3) ensure you understand where files will be read/written (~/clawd) and that calibration files may contain sensitive financial data; 4) because there is no install step declared, confirm how/where the scripts will be installed and that they run in a controlled environment (VM/container) if you are unsure; 5) if you plan to allow autonomous invocation, consider restricting it until you confirm the skill's behavior and necessary credentials. If any of the above is unexpected, treat the skill as not ready for production use.
功能分析
Type: OpenClaw Skill Name: ach-volume-estimator Version: 1.0.0 The ach-volume-estimator skill bundle is a specialized financial forecasting tool designed to process ACH KPI emails and generate volume and revenue projections. The scripts (estimate.py, revenue_forecast.py) implement sophisticated statistical models, including seasonal decomposition and trend analysis, and fetch legitimate economic data from the Federal Reserve (FRED). While the workflow involves high-privilege actions like searching a specific Gmail account ([email protected]) and modifying a local dashboard (update_dashboard.py), these behaviors are transparently documented and strictly aligned with the stated business purpose. No indicators of malicious intent, such as data exfiltration or unauthorized remote execution, were found.
能力评估
⚠ Purpose & Capability
Name/description describe an ACH volume estimator and the included Python forecasting/revenue scripts are consistent with that. However, the SKILL.md explicitly instructs use of a Gmail CLI against [email protected], reading/writing files under ~/clawd, and invoking a local dashboard generator and internal IP (192.168.1.60). The manifest declares no required env vars, binaries, or install steps; that is inconsistent with what the skill actually requires to run.
⚠ Instruction Scope
Runtime instructions tell the agent to fetch an email (specific account), download a PDF attachment, extract numbers, run local Python scripts, and publish to a local dashboard. These steps read and write files in the user's home (~/clawd/work, revenue_calibration.json), rely on an external Gmail CLI ('gog gmail') and a local dashboard service, and would require credentials/config already present. The instructions do not request or document those credentials or tools.
⚠ Install Mechanism
No install spec is provided (instruction-only), yet the package includes multiple Python scripts and the SKILL.md expects them to exist at specific paths (~/clawd/skills/ach-volume-estimator/scripts/ and ~/clawd/scripts/ach-dashboard-gen). This is an incoherence: either the skill must install those files or the instructions should not assume they are present. Lack of an install step means a user could be misled about how these files arrive on disk.
⚠ Credentials
The skill does not declare any required environment variables or credentials, but the workflow needs access to a Gmail account ([email protected]) via a CLI (implying OAuth tokens or local config), and reads/writes sensitive local files (~/clawd/work/*, revenue_calibration.json). It also references an internal IP dashboard. Requesting none of these in the manifest is disproportionate and obscures the actual privileges needed.
✓ Persistence & Privilege
The skill is not marked always:true and does not request system-wide configuration changes. It will run Python scripts and read/write files in the user's ~/clawd area, which is expected for this tool. Note: the skill can be invoked autonomously (platform default); combined with the undeclared credential/file access above, that increases risk and should be considered by the user.
如何使用
  1. 确保已安装 OpenClaw（本地或 Docker 部署）
  2. 在对话框中输入安装命令：/install ach-volume-estimator
  3. 安装完成后，直接呼叫该 Skill 的名称或使用 /ach-volume-estimator 触发
  4. 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.0
- Initial release of the ACH volume estimator skill. - Estimates Dwolla’s monthly ACH transaction volume using metrics from daily KPI emails and PDF attachments. - Calculates per-business-day rates and projects end-of-month totals using US Federal Reserve holiday calendar. - Provides concise, one-line estimates and integrates with ACH KPI summary reports and dashboard generation workflow.
元数据
Slug ach-volume-estimator
版本 1.0.0
许可证 MIT-0
累计安装 0
当前安装数 0
历史版本数 1
常见问题

Ach Volume Estimator 是什么？

Estimate Dwolla's end-of-month ACH transaction volume from daily KPI emails. Use when processing ACH KPI emails, when Dave asks about monthly volume projecti... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 102 次。

如何安装 Ach Volume Estimator？

在 OpenClaw 或 Claude Code 对话框中运行命令「/install ach-volume-estimator」即可一键安装，无需额外配置。

Ach Volume Estimator 是免费的吗？

是的，Ach Volume Estimator 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。

Ach Volume Estimator 支持哪些平台？

Ach Volume Estimator 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。

谁开发了 Ach Volume Estimator？

由 Daveglaser0823（@daveglaser0823）开发并维护，当前版本 v1.0.0。

推荐 Skills
self-improving agent
Captures learnings, errors, and corrections to enable continuous improvement. Use when: (1) A command or operation fails unexpectedly, (2) User corrects Clau...
⬇ 463283 · by pskoett
Skill Vetter
Security-first skill vetting for AI agents. Use before installing any skill from ClawdHub, GitHub, or other sources. Checks for red flags, permission scope, and suspicious patterns.
⬇ 259410 · by spclaudehome
Polymarket
Query Polymarket prediction markets. Check odds, find trending markets, search events, track price movements.
⬇ 232503 · by joelchance
Self-Improving + Proactive Agent
Self-reflection + Self-criticism + Self-learning + Self-organizing memory. Agent evaluates its own work, catches mistakes, and improves permanently. Use when...
⬇ 200423 · by ivangdavila
Github
Interact with GitHub using the `gh` CLI. Use `gh issue`, `gh pr`, `gh run`, and `gh api` for issues, PRs, CI runs, and advanced queries.
⬇ 191115 · by steipete
ontology
Typed knowledge graph for structured agent memory and composable skills. Use when creating/querying entities (Person, Project, Task, Event, Document), linkin...
⬇ 190156 · by oswalpalash

💬 留言讨论