Agent Skills › staskh/trading_skills › ib-create-consolidated-report

ib-create-consolidated-report

GitHub

用于整合IBKR交易CSV文件，按标的、日期等维度汇总数据并生成Markdown和CSV报告。支持自动探测端口获取未实现盈亏，强制使用纽约时区，输出包含生成时间及延迟字段。

.claude/skills/ib-create-consolidated-report/SKILL.md staskh/trading_skills

触发场景

需要合并多个IBKR交易CSV文件生成期权或股票交易的汇总报表

安装

npx skills add staskh/trading_skills --skill ib-create-consolidated-report -g -y

更多选项

非标准路径

npx skills add https://github.com/staskh/trading_skills/tree/main/.claude/skills/ib-create-consolidated-report -g -y

不安装直接使用

npx skills use staskh/trading_skills@ib-create-consolidated-report

指定 Agent (Claude Code)

npx skills add staskh/trading_skills --skill ib-create-consolidated-report -a claude-code -g -y

安装 repo 全部 skill

npx skills add staskh/trading_skills --all -g -y

预览 repo 内 skill

npx skills add staskh/trading_skills --list

SKILL.md

Frontmatter

{
    "name": "ib-create-consolidated-report",
    "description": "Consolidate IBRK trade CSV files from a directory into a summary report. Groups trades by symbol, underlying, date, strike, buy\/sell, and open\/close. Outputs both markdown and CSV.",
    "dependencies": [
        "trading-skills"
    ]
}

IB Create Consolidated Report

Reads all CSV files from a given directory (excluding subdirectories), consolidates trade data by key fields, and generates both markdown and CSV reports.

Instructions

uv run python scripts/consolidate.py <directory> [--port PORT] [--output-dir OUTPUT_DIR]

Arguments

directory - Path to directory containing IBRK trade CSV files
--port - IB port to fetch unrealized P&L (7497=paper, 7496=live). If not specified, auto-probes both ports (tries 7496 first, then 7497).
--output-dir - Output directory for reports (default: sandbox/)

Consolidation Logic

Groups trades by:

UnderlyingSymbol - The underlying ticker (e.g., GOOG, CAT)
Symbol - Full option symbol
TradeDate - Date of the trade
Strike - Strike price
Put/Call - Option type (C or P)
Buy/Sell - Trade direction
Open/CloseIndicator - Whether opening or closing

Aggregates:

Quantity - Sum of quantities
Proceeds - Sum of proceeds
NetCash - Sum of net cash
IBCommission - Sum of commissions
FifoPnlRealized - Sum of realized P&L

Adds column:

Position - SHORT (Sell+Open), LONG (Buy+Open), CLOSE_SHORT (Buy+Close), CLOSE_LONG (Sell+Close)

Output

Generates two files in the output directory:

consolidated_trades_YYYY-MM-DD_HHMM.md - Markdown report with summary tables
consolidated_trades_YYYY-MM-DD_HHMM.csv - CSV with all consolidated data

Example Usage

# Consolidate trades from IBRK reports directory
uv run python scripts/consolidate.py "C:\Users\avrah\OneDrive\Business\Trading\IBRK reports\2stastrading2025"

# Specify custom output directory
uv run python scripts/consolidate.py "C:\path\to\reports" --output-dir "C:\output"

Timezone

All timestamps and time-based calculations must use the America/New_York timezone. All JSON output must include generated_at (NY time string) and data_delay fields.