skills.rest
Bennel-Wang
Bennel-WangCOMMUNITY
Explore all skills by this author →
GitHub

mx-data

Fetches financial data from the Sina SDF-API and outputs Excel, JSON, and summaries.

Updated Mar 28, 2026
Search Tags:#automation#api#data#finance#excel#stock
One-click install
npx skills add https://github.com/Bennel-Wang/vibe_quant --skill mx-data-bennel-wang
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mx-data
Source: https://github.com/Bennel-Wang/vibe_quant/tree/main/investment_skills/.github/skills/mx-data
Command: npx skills add https://github.com/Bennel-Wang/vibe_quant --skill mx-data-bennel-wang

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, requests, openpyxl.

What problem does it solve?

简化对东方财富权威数据库的金融数据查询，帮助用户避免基于过时信息作出投资判断。

Core Features & Use Cases

  • 实时行情数据：股票、指数、基金等行情与主力资金流向等关键指标。
  • 财务与基本信息：上市公司及非上市公司的财务指标、股东结构、经营信息等。
  • 关系与经营数据：股东、高管与企业之间的关联关系数据。
  • 输出与保存：结果以 Excel（多 Sheet）、原始 JSON、以及描述文本形式导出，便于后续分析。
  • 安全与使用场景：通过 MX_APIKEY 环境变量进行认证，适用于财经研究、策略开发与报告编制。

Quick Start

设置环境变量 MX_APIKEY，然后直接运行 mx_data.py，输入自然语言查询即可获得多表结果与描述文件。

Frequently Asked Questions about mx-data

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

FAQPage Schema
How do I fetch real-time stock market data and financial statements using Python?▼

Fetch real-time stock market data and financial statements by querying East Money's MX API via Python, which returns structured multi-sheet Excel files, raw JSON, and descriptive summaries for deterministic financial analysis.

What is the best way to export corporate shareholder structure and financial data to Excel?▼

Export corporate shareholder structure and financial data to Excel by querying authoritative finance APIs that output structured multi-sheet workbooks using pandas and openpyxl, enabling immediate downstream analysis and reporting.

Do I need an API key to access East Money financial data for automated queries?▼

Yes, you need an API key to access East Money financial data. You must configure the MX_APIKEY environment variable before running automated queries to authenticate your requests to the MX API.

Can I retrieve historical financial statements and corporate relationship data for unlisted companies?▼

Yes, you can retrieve financial statements and corporate relationship data for both listed and unlisted companies. The API covers financial metrics, shareholder structures, and executive affiliations comprehensively.

Why does my financial data query return outdated or hallucinated information from language models?▼

Financial data queries return outdated information from language models due to static training data. Fetching live data from authoritative APIs like East Money prevents this by injecting real-time market quotes and financial metrics directly into your workflow.

Does the MX API integration support outputting raw JSON alongside Excel files for scripting?▼

Yes, the MX API integration supports outputting raw JSON alongside multi-sheet Excel files and descriptive text. This structured output format enables deterministic scripting and seamless integration into automated financial workflows.

Related Skills

Explore More Finance & Accounting Skills→
cattomgithubcattomgithub

mx-search

Search Chinese financial market data via the East Money MX API.

Community
Intermediate
NigarumOvumNigarumOvum

strategy-generate

Generate, modify, and optimize quantitative trading strategies with automated backtesting.

Community
Advanced
kunwl123456kunwl123456
26

diary-visualizer

Generate visual media prompts from diary entries for AI video and image creation.

Community
Intermediate
huidgehuidge
2

eastmoney-scraper

Fetch East Money index quotes, sector flows, and fund rankings from internal APIs.

Community
Intermediate