Trade Skills - Data Source Router

Router skill for managing access to multiple financial data sources. Provides a comprehensive mapping of data types to available data skills.

Function

Purpose: Route users to the appropriate data skill based on their data requirements.

How it works:

1. Verify Dependencies - Check if required skills are installed (akshare-data, tianqin-data)
2. Auto-Install Missing Skills - Install any missing dependencies automatically
3. User requests specific financial data
4. Identify data type and asset class from request
5. Route to corresponding data skill (see Data Resources Table below)
6. User invokes the routed skill with appropriate parameters

---

Dependency Management

Required Skills:

• akshare-data - For stocks, bonds, funds, macroeconomic data
• tianqin-data - For China futures market data

Auto-Installation Process

IMPORTANT: Before routing any user request, verify dependencies are installed.

# Check for dependencies in all supported directories
for skill in akshare-data tianqin-data; do
  if [[ ! -d ~/.claude/skills/$skill ]] && \
     [[ ! -d ~/.agents/skills/$skill ]] && \
     [[ ! -d ~/.cline/skills/$skill ]]; then
    echo "Missing: $skill - Installing..."
    npx skills add https://github.com/PPsteven/skills --yes --global
    break  # Install once adds all skills
  fi
done

Verification Checklist:

• Check ~/.claude/skills/ (Claude Code)
• Check ~/.agents/skills/ (Codex)
• Check ~/.cline/skills/ (Cline)
• If any dependency missing, run: npx skills add https://github.com/PPsteven/skills --yes --global
• Verify installation: ls ~/.claude/skills/{akshare-data,tianqin-data}

Installation command:

# This installs all skills from the repository globally
npx skills add https://github.com/PPsteven/skills --yes --global

Post-Installation Verification:

# Verify both dependencies are available
test -d ~/.claude/skills/akshare-data && echo "✅ akshare-data" || echo "❌ akshare-data missing"
test -d ~/.claude/skills/tianqin-data && echo "✅ tianqin-data" || echo "❌ tianqin-data missing"

---

Data Resources Table

Complete mapping of data types to data skills and APIs.

Data Source 1: akshare-data

AKShare provides comprehensive Chinese financial market data.

Data Type	Data Category	APIs	Use Case
Stocks	Equities	stock_zh_a_hist, stock_zh_a_daily	Historical daily prices, technical analysis
Stock Indices	Indices	index_zh_a_hist, index_zh_a_daily	Index performance, components
Bonds	Fixed Income	bond data APIs	Yields, credit spreads, maturity
Interest Rates	Fixed Income	interest rate APIs	LPR, deposit/loan rates, yield curves
Mutual Funds	Funds	fund_public APIs	Fund data, ratings, performance
Hedge Funds	Funds	fund_private APIs	Private fund data
Commodities	Derivatives	futures APIs, spot APIs	Commodity futures, spot prices
Options	Derivatives	option APIs	Options contracts, Greeks
Forex	FX & International	fx_rate APIs	Currency pairs, exchange rates
Hong Kong Stocks	FX & International	hk_stock APIs	Hong Kong market data
GDP	Macroeconomic	macro_china_gdp	Economic growth
CPI/PPI	Macroeconomic	macro_china_cpi	Inflation, price indices
Production	Macroeconomic	macro_china_industrial	Industrial production
Energy	Macroeconomic	energy APIs	Oil, coal, natural gas
Technical Indicators	Tools	tool APIs	Moving averages, RSI, MACD
Bank Data	Specialized	bank_* APIs	Regulatory data, penalties

Skill Reference: akshare-data

---

Data Source 2: tianqin-data

Tianqin (天勤) provides China futures real-time and historical data via EasyFut API.

Data Type	Data Category	APIs	Use Case
Real-Time Quotes	Futures	quote	Current prices, five-level order book
Daily High/Low	Futures	quote	Daily price limits, day's range
K-Line 1m	Futures	klines --duration 60	1-minute candles for intraday trading
K-Line 5m	Futures	klines --duration 300	5-minute candles for short-term analysis
K-Line 15m	Futures	klines --duration 900	15-minute candles
K-Line 1h	Futures	klines --duration 3600	Hourly candles for day trading
K-Line 1d	Futures	klines --duration 86400	Daily candles for swing trading
K-Line 1w	Futures	klines --duration 604800	Weekly candles for trend analysis
Tick Data	Futures	ticks	Granular transaction records
Open Interest	Futures	quote	Current open interest

Supported Exchanges & Contracts:

• SHFE (Shanghai): Rebar (rb), Copper (cu), Aluminum (al), Rubber (ru)
• CFFEX (China Financial Futures): CSI 300 (IF), CSI 500 (IC), Shanghai 50 (IH)
• DCE (Dalian): Soybeans (a), Soybean Meal (m), Soybean Oil (y), Plastics (l)

Skill Reference: tianqin-data

---

Quick Decision Tree

Need Chinese stocks or stock indices? → Use akshare-data - stock_zh_a_hist

Need Chinese bonds or interest rates? → Use akshare-data - bond APIs, interest rate APIs

Need Chinese funds? → Use akshare-data - fund_public or fund_private APIs

Need macroeconomic indicators (GDP, CPI, etc.)? → Use akshare-data - macro_china_* APIs

Need China futures real-time quotes? → Use tianqin-data - quote command

Need China futures K-lines for technical analysis? → Use tianqin-data - klines command with --duration parameter

Need China futures tick-level data? → Use tianqin-data - ticks command

---

Usage Pattern

1. Identify data requirement from user request
2. Locate data type in Data Resources Table above
3. Note the skill name and API to use
4. Invoke the skill with appropriate parameters
5. Return results to user

Example: User wants "daily prices for stock 000001"

• Step 1: Identified as Chinese stock data
• Step 2: Found in akshare-data table → stock_zh_a_hist API
• Step 3: Invoke akshare-data skill
• Step 4: Command: python3 scripts/akshare_cli.py stock_zh_a_hist --symbol 000001 --start_date 20240101 --end_date 20240131

---

Scripts & Utilities

trade-skills provides utility scripts for futures market operations.

1. Trading Hours Check

Check if a futures contract is currently in trading hours:

Command:

python3 scripts/trade_utils.py is-trading <EXCHANGE>.<SYMBOL>

Examples:

# Check if rebar is trading now
python3 scripts/trade_utils.py is-trading SHFE.rb2601

# Output:
# {
#   "trading": true,
#   "session": "day",
#   "symbol": "SHFE.rb2601"
# }

Notes:

• Uses China Standard Time (Asia/Shanghai)
• Handles cross-midnight night sessions (e.g., 21:00-01:00)
• Returns session: null when market is closed

---

2. Dominant Contract Query

Get the dominant (main) contract for a futures variety:

Command:

python3 scripts/trade_utils.py dominant-contract <VARIETY>

Examples:

# Get dominant contract for rebar
python3 scripts/trade_utils.py dominant-contract rb

# Output:
# {
#   "symbol": "rb",
#   "dominant": "rb2505",
#   "exchange": "SHFE"
# }

First-time setup:

# Initialize dominant contracts database
python3 scripts/trade_utils.py update-dominant

---

3. Update Dominant Contracts

Update the dominant contracts database by querying real-time market data:

Command:

# Update all varieties (recommended weekly)
python3 scripts/trade_utils.py update-dominant

# Update specific varieties only
python3 scripts/trade_utils.py update-dominant --varieties rb,cu,al,au

Output:

{
  "updated": 32,
  "failed": 0,
  "timestamp": "2026-03-03T15:30:45"
}

Requirements:

• Requires tianqin-data skill installed
• Requires TQ_API_KEY environment variable set
• Takes approximately 60 seconds for full update

Maintenance:

• Run weekly to keep dominant contracts up-to-date
• Dominant contracts change as trading months approach expiry

---

Configuration Files

Scripts use local JSON files for configuration:

• scripts/data/trading_hours.json - Trading hours for all varieties (static)
• scripts/data/dominant_contracts.json - Current dominant contracts (updated via command)

Regenerate trading hours config:

python3 scripts/generate_trading_hours.py

---

Troubleshooting

"Variety not found" Error

If you see: Variety 'rb' not found. Run 'update-dominant' command first.

Solution: Initialize the dominant contracts database:

python3 scripts/trade_utils.py update-dominant --varieties rb

"Invalid symbol format" Error

If you see: Invalid symbol format: rb2601

Solution: Use full exchange prefix format:

# Wrong: python3 scripts/trade_utils.py is-trading rb2601
# Right:
python3 scripts/trade_utils.py is-trading SHFE.rb2601

Update-Dominant Fails

If API calls fail, check:

1. TQ_API_KEY environment variable:

   echo $TQ_API_KEY
   

2. tianqin-data skill installed:

   ls -la ~/.claude/skills/tianqin-data
   

3. Test API connection:

   python3 ../tianqin-data/scripts/tq_cli.py quote SHFE.rb2601