AI Agent Skill-Financial Data Fetcher

Financial Data Fetcher

AI Agent Skill for All-Asset Real-Time Price Retrieval

One skill to fetch them all — A-shares, ETFs, US stocks, cryptocurrency OTC, and bank forex rates. Real-time, programmatic, and AI-assisted.

Overview

This is the ultimate financial data Swiss Army knife for AI coding assistants. It contains battle-tested SOPs (Standard Operating Procedures) for fetching real-time prices across every major asset class. Each SOP includes exact API endpoints, required headers, response field mappings, critical pitfalls (like Yahoo Finance's regularMarketPrice trap), and ready-to-run PowerShell/Python code snippets. No more guessing which API to use or debugging wrong fields — these are production-verified workflows refined through real-world usage.

Asset Classes Covered

A-Shares & ETFs: Real-time prices from EastMoney API (Shanghai & Shenzhen). Includes Gold ETF 518880 example.

US Stocks: Pre-market, regular, and post-market prices via Yahoo Finance v8 API. Critical fix documented: never use meta.regularMarketPrice for real-time data.

Cryptocurrency OTC: USDT/CNY rates from OKX C2C (primary) and Binance P2P (backup). Includes 150th-merchant pricing logic.

Bank Forex: USD and HKD settlement rates from China Merchants Bank API with proper Referer headers.

What's Included

7 comprehensive SOP documents covering:

• financial-data-fetcher.skill.md — Master skill definition with all API rules.

• gold-etf-518880-sop.md — A-share/ETF data via EastMoney.

• us-stock-realtime-sop.md — US stocks with pre/post market handling.

• okx-c2c-usdt-cny-sop.md — Crypto OTC via OKX + Binance.

• cmb-forex-settlement-sop.md — Bank forex rates via CMB.

• hk-ipo-data-update-sop.md — HK IPO data workflow summary.

• skill-framework.md — Bonus: cognitive framework for designing your own AI Agent Skills.

Requirements

• VS Code with GitHub Copilot Chat

• PowerShell 5.1+ (for quick API calls)

• Python 3.7+ with akshare (for HK IPO data)