financial-researching

Fetch financial data, compute panel factors, run PanelOLS, and backtest with backtrader.

Updated Jun 29, 2025
One-click install
npx skills add https://github.com/YHWriteCode/EconRAGent --skill financial-researching
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: financial-researching
Source: https://github.com/YHWriteCode/EconRAGent/tree/main/skills/financial-researching
Command: npx skills add https://github.com/YHWriteCode/EconRAGent --skill financial-researching

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires akshare, pandas, numpy, yfinance, linearmodels, statsmodels, backtrader, and includes scripts (resource) and references (resource) components.

What problem does it solve?

End-to-end pain points in quantitative financial research are eliminated by providing a single, repeatable pipeline that handles data ingestion, cleaning, panel modeling, signal generation, and backtesting so analysts avoid manual wrangling across tools and formats.

Core Features & Use Cases

  • Reliable data ingestion: Fetch A‑share, fund and macro data with AKShare and fall back to yfinance when needed, with retries and column mapping to a unified schema.
  • Standardization & factor engineering: Normalize date/code/price columns, handle missing values, compute rolling factors (momentum, volatility, size) and produce MultiIndex panel datasets for modeling.
  • Panel regression & model selection: Run panel OLS with entity effects, cluster-robust errors, model selection guidance and save regression summaries and coefficients for interpretation.
  • Signal generation & backtesting: Convert significant factor directions into per-date trading signals and run backtests via backtrader with recommended analyzers and performance reports.
  • End-to-end automation: Orchestrated MVP script to execute fetch → prepare panel → run model → generate signals → run backtest and produce persistent CSV/JSON/text outputs for reproducibility.

Quick Start

Run the end-to-end pipeline to fetch A-share data for 000001 and 000002 from 20210101 to 20231231, build panel factors, run a panel regression to extract significant factors, generate trading signals for 000001, and execute a backtest with performance report.

Frequently Asked Questions about financial-researching

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

FAQPage Schema
How do I build an end-to-end quantitative research pipeline from data ingestion to backtesting?

An end-to-end quantitative research pipeline automates data ingestion via AKShare and yfinance, computes panel factors, runs linearmodels PanelOLS regression, and executes backtrader backtests with persistent CSV outputs.

How do I fetch A-share and macro data for panel regression analysis?

Fetching A-share and macro data for panel regression uses AKShare with automatic yfinance fallback, applying retries and column mapping to standardize date, code, and price columns into a unified MultiIndex schema.

Can I run panel regression with entity effects and cluster-robust errors in Python?

Panel regression with entity effects and cluster-robust errors is executed using linearmodels PanelOLS, providing model selection guidance and saving regression summaries and coefficients for factor interpretation.

What's the best way to convert significant regression factors into backtrader trading signals?

Converting significant regression factors into trading signals involves extracting factor directions from panel OLS results, generating per-date signals, and feeding them into backtrader with recommended analyzers for performance reporting.

Does this panel regression and backtesting workflow handle missing values and data standardization?

Panel regression and backtesting workflows handle missing values and standardize schemas by normalizing date, code, and price columns, computing rolling factors like momentum and volatility, and producing clean MultiIndex datasets.

Are there limitations to using AKShare for A-share quantitative data ingestion?

AKShare limitations for A-share data ingestion are mitigated by automatic yfinance fallback with retries, ensuring reliable access to financial data while mapping columns to a standardized unified schema for downstream modeling.