ib-create-consolidated-report
This skill merges multiple IBRK trade exports from a directory into consolidated reports, grouping trades by underlying symbol, strike, date, and position direction. It outputs both markdown and CSV formats with aggregated quantities, proceeds, commissions, and realized P&L.
IB Create Consolidated Report consolidates Interactive Brokers trade CSV files into unified summary reports.
AI-generated summary based on this skill's SKILL.md
Decision gist · record as of 2026-07-20
IB Create Consolidated Report consolidates Interactive Brokers trade CSV files into unified summary reports. This skill merges multiple IBRK trade exports from a directory into consolidated reports, grouping trades by underlying symbol, strike, date, and position direction. It outputs both markdown and CSV formats with aggregated quantities, proceeds, commissions, and realized P&L.
Use it when
- ib-create-consolidated-report processes all trade CSV files in a specified directory.
- ib-create-consolidated-report generates consolidated trade data in both markdown and CSV report formats.
Verify before relying
Read SKILL.md below before installing (2 files). Open directory: indexed for reading, not audited.
Install
staskh/trading_skills/ib-create-consolidated-report · repository language: Python
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
What does ib-create-consolidated-report do?
ib-create-consolidated-report merges multiple IBRK trade exports from a directory into consolidated reports, grouping trades by underlying symbol, strike, date, and position direction. It outputs both markdown and CSV formats with aggregated quantities, proceeds, commissions, and realized P&L.
How do I consolidate interactive brokers trade reports with this skill?
ib-create-consolidated-report processes all trade CSV files in a specified directory, automatically consolidating them into unified summary reports. The skill groups and aggregates trades by symbol, strike, date, and position type, then generates both markdown and CSV output files containing the consolidated data.
What output formats does ib-create-consolidated-report support?
ib-create-consolidated-report generates consolidated trade data in both markdown and CSV report formats. Both outputs include aggregated quantities, proceeds, commissions, and realized P&L information organized by symbol, strike, date, and position direction.
Can ib-create-consolidated-report include unrealized P&L in reports?
Yes, ib-create-consolidated-report can retrieve unrealized P&L directly from the IB gateway and include it in your consolidated output. This provides a complete picture of both realized and unrealized position performance alongside your trade aggregations.
How does ib-create-consolidated-report group and aggregate trades?
ib-create-consolidated-report groups trades by underlying symbol, strike price, date, and position type (long/short). It then aggregates quantities, proceeds, and commissions for each group, calculates realized P&L, and presents the results in organized summary reports for easy analysis.
What license does ib-create-consolidated-report use?
ib-create-consolidated-report is released under the MIT license, allowing free use, modification, and distribution with minimal restrictions.
SKILL.md
Rendered from the published skill. Quoted content, verbatim.
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). Defaults to theIB_PORTenv var when set (--portstill overrides).--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
(truncated - see the full file via the links below)
File tree — 2 files
.claude/skills/ib-create-consolidated-report/SKILL.md
.claude/skills/ib-create-consolidated-report/scripts/consolidate.py
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Consolidate multiple Interactive Brokers trade CSV files into unified summary reports”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Ibkr Api Skill enables programmatic access to Interactive Brokers accounts for portfolio management, real-time market data, and trade execution across multiple account types. Built on the ib_async library with support for Roth IRA, personal brokerage, and business accounts, it handles authentication, enforces IRA trading restrictions, and provides both async TWS API and REST Client Portal integrations.
This skill builds collar strategy reports for PMCC traders facing earnings or volatility spikes. It connects to Interactive Brokers, analyzes your long LEAPS and short calls, models put protection scenarios across gap-up/flat/down outcomes, and recommends optimal strike and duration for tactical hedging.
Analyze roll opportunities for existing short options or identify best covered calls/puts to open against long stock. The skill connects to Interactive Brokers via TWS or IB Gateway, evaluates candidates across multiple expirations, and uses IV-aware strike bands to surface relevant alternatives tailored to market conditions.
Pull trade executions directly from your Interactive Brokers account via live API (recent ~7 days) or FlexReport (full history). Filter by account, symbol, or date range, and get back execution details with per-symbol summaries including commissions and realized P&L.
Ibkr bridges your AI agent to Interactive Brokers through a local Trader Workstation or IB Gateway connection—no cloud keys required. Check positions, place orders, pull quotes and history across stocks, ETFs, forex, and futures on your own machine or networked gateway. Requires TWS/Gateway running and API socket enabled; paper trading available for safe testing.
Trading Alert Scheduler runs a single automated scan each morning before market open, analyzing your watchlist tickers and IBKR positions against regime detection, technical confluence, and options flow to surface high-conviction setups. Position health checks flag expiry risks and margin concerns, while a prioritized digest keeps you informed without intraday distractions.
More skills ib-pmcc-advisor (MIT) · ib-stop-loss (MIT) · ib-trailing-stop (MIT)