excel-template-contract-fill
CommunityTurn raw futures data into a unified template.
Authorcx-qk
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This skill defines semantic rules to transform raw futures market data from SHFE, DCE, CZCE, and GFEX into a unified contract template and outputs to the 合约数据(整理后)/ directory. It emphasizes rule-based data conversion rather than fixed scripts, enabling AI to adapt to changing input formats and newly listed products.
Core Features & Use Cases
- Semantic field mapping across four exchanges to produce standardized columns: 合约代码, 商品名称, 交割月, 收盘价, 持仓量, 最低保证金, 最低保证金率.
- Robust handling of variable input formats, missing columns, and 新品种 with guidance for dictionary updates.
- Output artifacts include standardized workbooks per exchange and a 缺失原因汇总 report for auditing and improvement.
Quick Start
Place raw data into 原始数据/期货数据/ and 原始数据/合约信息/; then run the reference conversion tool to generate the standardized outputs.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: excel-template-contract-fill Download link: https://github.com/cx-qk/Calendar-Spread-Arbitrage/archive/main.zip#excel-template-contract-fill Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.