excel-template-contract-fill

To normalize raw futures data, semantic field mapping is applied to extract and standardize columns like contract code, commodity name, and closing price from SHFE, DCE, CZCE, and GFEX into a unified Excel template.

Handling missing columns and new futures products requires rule-based semantic conversion that adapts to variable input formats, ensuring robust numeric parsing and generating a missing data log for auditing.

Semantic field mapping works by applying rule-based logic to identify and extract exchange-specific fields, transforming variable raw input formats into standardized columns like delivery month, open interest, and minimum margin.

Yes, this data normalization approach supports newly listed futures contracts by using adaptive semantic rules rather than fixed scripts, allowing it to process format variations across SHFE, DCE, CZCE, and GFEX.

Standardized futures contract outputs and missing data logs are saved directly into the 合约数据(整理后)/ directory, providing unified workbooks per exchange alongside a missing reason summary report.

Futures data transformation may fail when raw exchange formats change if using fixed scripts; this approach uses semantic rules to adapt to format variations and outputs a missing data log to diagnose parsing errors.