report_generation

Name: report_generation
Availability: InStock
Author: xueqingpeng

Generate a weekly equity research report from offline DuckDB data.

11|Updated Mar 14, 2026

Search Tags:#research #mcp #offline #report #duckdb #equity #weekly

Ready to run

npx skills add https://github.com/xueqingpeng/trading-analysis --skill report-generation-xueqingpeng

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: report_generation
Source: https://github.com/xueqingpeng/trading-analysis/tree/main/.claude/skills/report_generation
Command: npx skills add https://github.com/xueqingpeng/trading-analysis --skill report-generation-xueqingpeng

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires duckdb, pandas, numpy, pandas_ta, fastmcp, pydantic, and includes scripts (resource) components.

What problem does it solve?

Automates the production of a standalone weekly equity research report for a single symbol and week-ending date. The report is generated entirely from offline DuckDB data, avoiding external data dependencies.

Core Features & Use Cases

Reads prices, news, filings, and peer benchmarks via the MCP server to assemble a structured weekly report.
Generates a Markdown report plus a run-level JSON summary for tracking.
Supports an offline, reproducible workflow suitable for internal research, backtesting, or archival reporting.

Quick Start

Invoke the MCP server to generate a weekly report for a chosen symbol and week ending date.

Frequently Asked Questions about report_generation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I generate a weekly equity research report from offline DuckDB data?▼

Generate a weekly equity report by reading offline DuckDB data through an MCP server to access prices, news, filings, and peer benchmarks, then output a Markdown report and JSON summary.

Can I use pandas and pandas_ta to build a standalone weekly equity report?▼

Yes, the report generation process uses pandas and pandas_ta dependencies alongside DuckDB to process local data and produce a standalone weekly equity report for a specific symbol and date.

Does this weekly report generation tool require external API calls?▼

No, the weekly report generation tool operates entirely offline and does not call external APIs, relying strictly on local MCP-provided data for a reproducible research workflow.

What is the best way to automate equity report generation for backtesting and archival?▼

The best way to automate equity report generation for backtesting is using an offline MCP server with DuckDB to assemble reproducible Markdown reports and run-level JSON summaries without external dependencies.

What limitations exist when generating weekly equity reports from local DuckDB files?▼

The limitation is that weekly equity report generation supports only a single symbol and a target week ending date per run, operating strictly within the local MCP-provided data environment.