skills.rest
xueqingpeng
xueqingpengCOMMUNITY
Explore all skills by this author →
GitHub

report_generation

Generate a weekly equity research report from offline DuckDB data.

11|Updated Mar 14, 2026
Search Tags:#research#mcp#offline#report#duckdb#equity#weekly
One-click install
npx skills add https://github.com/xueqingpeng/trading-analysis --skill report-generation-xueqingpeng
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
CYP0630CYP0630

trading

Decide BUY, SELL, or HOLD for a symbol and date using DuckDB data.

Community
Advanced
xueqingpengxueqingpeng
11

report_evaluation

Recompute ground-truth metrics from offline DuckDB data for weekly report evaluations.

Community
Advanced
TeiNamTeiNam
12

python-data-analysis

Automate Python data analysis workflows with pandas, polars, and duckdb.

Community
Advanced
LogicPyLogicPy
8

finance

Provides real-time and historical financial data for market analysis and research.

Community
Advanced