An automated PowerPoint report generator that updates a single-page dashboard template with structured daily financial market data.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install generate-ppt-report
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install generate-ppt-report using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Daily Financial PPT Report Generator?
The Daily Financial PPT Report Generator is a specialized automation tool designed to transform raw financial, policy, and enterprise data into polished, single-slide executive dashboards. Built to leverage the automation benefits of Openclaw Skills, this solution eliminates the tedious manual labor of copying and pasting daily market movements, regional policy changes, and corporate event brief records. By executing directly within your analytical pipeline, it ensures leadership always receives consistent, visually clean, and timely market intelligence.
Rather than rebuilding a presentation deck from scratch, this skill works directly with an existing PowerPoint template (located at E:\daily\cankao\M2.pptx). It targets the underlying slide structure using precise Shape ID coordinates, modifying only the textual content inside designated containers while perfectly preserving the custom layout, font sizes, margins, brand colors, and styling rules. This methodology provides a bulletproof way to inject programmatic updates into client-ready presentation templates using Openclaw Skills.
Daily Financial PPT Report Generator Use Cases
- Automating Financial Newsletters: Dynamically updating a daily market brief dashboard to distribute to trading desks or executive boards first thing in the morning.
- Scheduled Pipeline Reports: Acting as the final step in an AI-driven market research pipeline that automatically scrapes, summarizes, and visually formats the day's financial highlights.
- Client Presentations: Creating uniform, mistake-free daily market overviews without manual data entry errors, keeping layout aspects perfectly locked.
- Executive Dashboard Compilation: Transforming raw JSON datasets into visual, easily-readable PowerPoint summary blocks for quick administrative review.
How Daily Financial PPT Report Generator Works
- Data Gathering: The workflow begins by retrieving parsed financial details, policy bulletins, and corporate updates structured inside
market_data.json. - Template Loading: The script reads the baseline single-slide PowerPoint dashboard (
E:\daily\cankao\M2.pptx) utilizingpython-pptxto locate individual visual layers. - Coordinate Filtering: It locates specific target text boxes by filtering shapes according to their preset
shape.shape_idproperties (such as Shape 6 for global markets, Shape 15 for policy, and Shape 23 for corporate dynamics). - Formatting & Truncating: Data is structured according to strict character limits (e.g., truncating policy descriptions at 120 characters, or formatting corporate actions as
Company Name: Event Briefunder 80 characters) to ensure visual boundaries are never broken. - Text Modification: It writes the processed strings into the template placeholders without altering any underlying CSS-like styles, fonts, or colors.
- Export & Archive: The finalized presentation is saved in a date-stamped file path (e.g.,
E:\daily\{YYYY-MM-DD}\金融市场简报_{YYYYMMDD}.pptx) for archiving and immediate distribution.
Daily Financial PPT Report Generator Setup
Prerequisites
Make sure python-pptx is installed in your python runtime environment:
pip install python-pptx
Configuration
Ensure your file paths and workspace configuration are properly set up inside workspace-yoyo/config.py:
- Template Path: Ensure your master template exists at
E:\daily\cankao\M2.pptx. - Data Source: Place your processed financial facts in
market_data.jsoninside your execution directory.
Manual Execution
To manually trigger the PowerPoint generation script outside of an automated pipeline, run:
python scripts/generate_ppt.py
Daily Financial PPT Report Generator Data Schema & Taxonomy
PowerPoint Shape-to-Data Mapping Schema
This skill routes structured data directly from market_data.json to specific text shape indices on the master presentation slide:
| Shape ID | Content Module | Content Strategy & Parsing Rules | Data Source in JSON |
|---|---|---|---|
| Shape 5 | Slide Header | Static title set to "每日环球市场速览" | Static string config |
| Shape 6 | Market Performance | Compiles US indexes, 10-year Treasury yields, USD index, China A-shares, HK Hang Seng, and Spot/Futures Gold prices | 市场表现 array |
| Shape 15 | Regional Policies | Retrieves the first policy dynamic for US, EU, and China, truncated strictly at 120 characters | 政策动态 array |
| Shape 23 | Corporate Actions | Merges company name and event descriptions, capped strictly at 80 characters | 企业动态 array |
| Shape 18 | Disclaimer Footer | Static regulatory indicator set to "内部资料，切勿随意转发" | Static string config |
Critical Categorization & Data Integrity Rules
- Policy Boundaries: Only government or official regulatory mandates (regulations, legislative actions, investigations) are mapped into Shape 15. Commercial entities must never appear here.
- Enterprise Boundaries: Only corporate operations, financial statements, leadership transitions, and M&A activities are mapped into Shape 23. Government activities must never appear here.
- Consistent Number Formatting: Financial rates and points are written in structured shorthand matching standard reporting formats (e.g.,
道指涨0.13%报49230.71点or10年期美债收益率报4.25%).
Daily Financial PPT Report Generator Advanced Features
- Precise Shape-ID Targeting: Avoids unreliable template parsing by mapping directly to individual PowerPoint elements (
shape.shape_id), securing pixel-perfect dashboard edits. - Visual Layout Lockdown: Operates strictly on a text-replacement level, guaranteeing that color-coding, padding, structural boundaries, and typography settings remain unbothered.
- Downstream Agent Integration: Ideal for complex multi-agent workflows using Openclaw Skills, allowing scraping agents to easily pass structured variables to this layout script.
- Automated Directory Provisioning: Programmatically generates organized, date-stamped directory structures to maintain clear historical archive records of daily slide briefs.
SKILL.md
Loading
Related Openclaw Skills
Generate Word Report
Automatically compile raw financial market JSON data into professionally styled, structured Word reports without template dependencies.
Market Data Checker
An automated financial validation engine executing 10-tier quality checks, error recovery, and instant SMTP alerting on market data files.
Tile Mason Knowledge Q&A
An expert AI masonry and tiling assistant providing specialized knowledge routing, precise cost estimation via dedicated scripts, and comprehensive reference material lookup.
Send Email To
An automated email notification and reporting skill designed to read structured market data, discover localized Office files, and transmit them via secured SMTP with compliant Chinese file attachment encoding.
Self-Improvement Skill for Coding Agents
An AI coding agent skill designed to log development corrections, errors, and feature requests to local Markdown files, enabling continuous agent self-improvement and project memory promotion.
Grok Image Generation
A local CLI tool and automation wrapper to generate, edit, and composite images using the xAI Grok Imagine API.
Featured*
