mx-data

Translate Chinese stock market questions into API queries and export Excel, JSON, and description files.

1|1|Updated May 5, 2026
One-click install
npx skills add https://github.com/Ewan-yu/skill-repo --skill mx-data-ewan-yu
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: mx-data
Source: https://github.com/Ewan-yu/skill-repo/tree/main/skills/mx-data
Command: npx skills add https://github.com/Ewan-yu/skill-repo --skill mx-data-ewan-yu

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, requests, openpyxl, lxml.

What problem does it solve?

This Skill solves the problem of getting up-to-date, authoritative Chinese financial and market data without relying on a model’s outdated internal knowledge.

Core Features & Use Cases

  • Natural-language financial data lookup: Query real-time/market, financial fundamentals, and relationship/operational data using plain questions.
  • Authoritative API-backed results: Uses 东方财富妙想 (dfcfs) data endpoints with an API key configured via environment variables.
  • Excel-ready output: Exports multi-sheet Excel plus a human-readable description and saves the raw JSON for follow-up analysis.
  • Use Case: Ask for a specific stock’s “closing auction volume/amount over a date range” and directly obtain an Excel sheet with time-series columns and indicator names.

Quick Start

Ask the assistant: "Get 西部材料(002149.SZ) 的开盘集合竞价成交量、开盘集合竞价成交额、收盘集合竞价成交量、收盘集合竞价成交额、开盘集合竞价成交价 for 2026-05-18 to 2026-05-18 and export the results to Excel."

Frequently Asked Questions about mx-data

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

FAQPage Schema
How do I get Chinese stock market financial data exported to Excel?

To get Chinese stock financial data exported to Excel, this Skill translates natural-language questions into API queries against authoritative endpoints and outputs multi-sheet Excel files alongside raw JSON. It targets market, fundamental, and operational data lookups for Chinese stocks.

What is the best way to query time-series metrics for Chinese stocks using an API?

Querying time-series metrics for Chinese stocks is done by asking natural-language questions translated into API queries against the dfcfs endpoint. It returns structured tables containing time-series columns and indicator names for specified date ranges, directly exportable to Excel.

Do I need an API key to pull fundamentals and shareholder relationship data?

Yes, pulling fundamentals and shareholder relationship data requires the MX_APIKEY configured in your environment variables to authenticate requests to the authoritative dfcfs API endpoint. This key ensures secure access to real-time market and operational data.

Can I use natural language to look up stock analytics and operational data?

Yes, you can use natural language to look up stock analytics and operational data. The system translates plain questions into structured API queries to fetch authoritative data on market conditions, financials, and shareholder relationships without requiring manual query syntax.

What format does the financial data API return besides Excel?

Besides multi-sheet Excel files, the financial data API query returns raw JSON and a human-readable description file. This provides both immediate spreadsheet-ready output for analysis and structured data for downstream programmatic processing.