skills.rest
tankygranny05
tankygranny05COMMUNITY
Explore all skills by this author →
GitHub

db23-excel-split

Split multi-day Excel files into single-day files by trading dates.

2|Updated Jan 30, 2026
Search Tags:#validation#data pipeline#split#excel#trading data#db23
One-click install
npx skills add https://github.com/tankygranny05/agent-box --skill db23-excel-split
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db23-excel-split
Source: https://github.com/tankygranny05/agent-box/tree/main/agent-box/seed/codex-skills/db23-excel-split
Command: npx skills add https://github.com/tankygranny05/agent-box --skill db23-excel-split

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the process of splitting large, multi-day Excel files into smaller, single-day files required by the db23 trading data pipeline, ensuring data integrity and compatibility.

Core Features & Use Cases

  • Splitting Logic: Divides Excel workbooks based on the ORDER_DATE and PT_DATE columns.
  • Data Validation: Enforces strict requirements for sheet names, column headers, and data types.
  • Use Case: Prepare daily trading data from a consolidated weekly or monthly Excel report for ingestion into a structured database.

Quick Start

Split the Excel file located at /home/ubuntu/Downloads/multi-day/YOUR_FILE.xlsx into single-day files in the /home/ubuntu/Downloads directory.

Frequently Asked Questions about db23-excel-split

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

FAQPage Schema
How do I split a multi-day Excel file into single-day files?▼

Splitting multi-day Excel files involves dividing workbooks based on trading dates in the ORDER_DATE and PT_DATE columns, creating individual single-day files for database ingestion.

How does Excel data validation work for trading data pipelines?▼

Excel data validation for trading pipelines enforces strict requirements for sheet names, column headers, and data formats according to predefined requirements to ensure data integrity before processing.

Can I use this to prepare daily trading data from a consolidated monthly Excel report?▼

You can prepare daily trading data from a consolidated weekly or monthly Excel report by splitting the workbook based on trading dates to produce single-day files required by the db23 pipeline.

What are the requirements for splitting Excel files with ORDER_DATE and PT_DATE columns?▼

Splitting Excel files with ORDER_DATE and PT_DATE columns requires predefined sheet names, specific column structures, and strict data formats to validate trading data before generating single-day outputs.

What happens if my Excel sheet names or column structure does not match validation requirements?▼

If Excel sheet names or column structures do not match predefined requirements, the data validation fails to prevent incompatible trading data from entering the pipeline, halting the file splitting process.

Related Skills

Explore More Data & Analytics Skills→
MichaelYang-lyxMichaelYang-lyx
110

excel-sheet-filter-export

Filter multi-sheet Excel records and export results to a new file.

Community
Intermediate
woonetworkwoonetwork

WOOFi Pro Perps Volume Skill

Retrieve daily WOOFi Pro perpetual trading volume from the Orderly Network API.

Official
Basic
tankygranny05tankygranny05
2

db23-pipeline

Execute a 6-step data ingestion pipeline for Vietnamese stock market Excel files.

Community
Advanced
aiyinluyaaiyinluya
2

category-filtering-and-difficulty-analysis

Analyzes Excel categories and computes multidimensional difficulty scores from text signals.

Community
Intermediate