Skip to main content
Glama

IB Analytics MCP Server

by knishioka

IB Analytics

Interactive Brokers portfolio analytics library with multi-account support.

Features

  • šŸ“Š Multi-Account Support: Analyze multiple IB accounts simultaneously

  • šŸ”„ Flex Query API Integration: Automated data fetching via IB Flex Query API v3

  • šŸ“ˆ Comprehensive Analysis: Performance, tax, cost, risk, and bond analytics

  • šŸŽÆ Type-Safe: Built with Pydantic v2 for robust data validation

  • ⚔ Async Support: Parallel data fetching for multiple accounts

  • šŸ“„ Rich Reports: Console, HTML, and optional PDF reporting

Installation

# Install with pip pip install -e . # Install with MCP server support pip install -e ".[mcp]" # Install with development dependencies pip install -e ".[dev]" # Install with visualization support pip install -e ".[visualization]" # Install all optional dependencies pip install -e ".[dev,mcp,visualization,reporting]"

Quick Start

1. Configuration

Create a .env file with your IB Flex Query credentials:

# Single account QUERY_ID=1304912 TOKEN=186998807615517163459091 # Multiple accounts (optional) ACCOUNT_1_QUERY_ID=1304912 ACCOUNT_1_TOKEN=186998807615517163459091 ACCOUNT_2_QUERY_ID=1234567 ACCOUNT_2_TOKEN=987654321987654321

2. Fetch Data

# Fetch data for single account ib-sec-fetch --start-date 2025-01-01 --end-date 2025-10-05 # Fetch data for multiple accounts ib-sec-fetch --multi-account --start-date 2025-01-01 --end-date 2025-10-05

3. Run Analysis

# Run comprehensive analysis ib-sec-analyze --account U16231259 # Run specific analyzer ib-sec-analyze --account U16231259 --analyzer performance # Analyze all accounts ib-sec-analyze --all-accounts

4. Generate Reports

# Console report ib-sec-report --account U16231259 --format console # HTML report with charts ib-sec-report --account U16231259 --format html --output report.html

Programmatic Usage

from ib_sec_mcp import FlexQueryClient, Portfolio from ib_sec_mcp.analyzers import PerformanceAnalyzer, TaxAnalyzer from datetime import date # Initialize client client = FlexQueryClient(query_id="1304912", token="your_token") # Fetch data data = client.fetch_statement( start_date=date(2025, 1, 1), end_date=date(2025, 10, 5) ) # Create portfolio portfolio = Portfolio.from_flex_data(data) # Run analysis perf_analyzer = PerformanceAnalyzer(portfolio) results = perf_analyzer.analyze() # Generate report from ib_sec_mcp.reports import ConsoleReport report = ConsoleReport(results) report.render()

Project Structure

ib-sec/ ā”œā”€ā”€ ib_sec_mcp/ # Main library │ ā”œā”€ā”€ api/ # Flex Query API client │ ā”œā”€ā”€ core/ # Core business logic │ ā”œā”€ā”€ models/ # Pydantic data models │ ā”œā”€ā”€ analyzers/ # Analysis modules │ ā”œā”€ā”€ reports/ # Report generators │ └── utils/ # Utilities ā”œā”€ā”€ scripts/ # CLI scripts ā”œā”€ā”€ tests/ # Test suite ā”œā”€ā”€ data/ # Data directory │ ā”œā”€ā”€ raw/ # Raw CSV/XML data │ └── processed/ # Processed data └── legacy/ # Legacy scripts

Available Analyzers

  • PerformanceAnalyzer: Overall trading performance metrics

  • TaxAnalyzer: Tax liability calculations (OID, capital gains)

  • CostAnalyzer: Commission and cost efficiency analysis

  • RiskAnalyzer: Interest rate and market risk scenarios

  • BondAnalyzer: Bond-specific analytics (YTM, duration, etc.)

MCP Server Integration

IB Analytics provides a Model Context Protocol (MCP) server for integration with Claude Desktop and other MCP clients.

Quick Start

# Install with MCP support pip install -e ".[mcp]" # Run MCP server ib-sec-mcp

Features

  • 7 Tools: Fetch IB data, run performance/cost/bond/tax/risk analysis, get portfolio summary

  • 6 Resources: Access portfolio data, account info, trades, and positions via URI patterns

  • 5 Prompts: Pre-configured analysis templates for common workflows

Claude Desktop Setup

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

{ "mcpServers": { "ib-sec-mcp": { "command": "/path/to/venv/bin/python", "args": ["-m", "ib_sec_mcp.mcp.server"], "env": { "QUERY_ID": "your_query_id", "TOKEN": "your_token" } } } }

See .claude/CLAUDE.md for detailed MCP documentation.

Development

# Install development dependencies pip install -e ".[dev]" # Run tests pytest # Run tests with coverage pytest --cov=ib_sec_mcp --cov-report=html # Code formatting black ib_sec_mcp tests # Linting ruff check ib_sec_mcp tests # Type checking mypy ib_sec_mcp

Requirements

  • Python 3.9+

  • Interactive Brokers account with Flex Query access

Dependencies

  • requests (2.32.5+): HTTP client for API calls

  • pandas (2.2.3+): Data analysis and manipulation

  • pydantic (2.10.0+): Data validation and settings management

  • httpx (0.27.0+): Async HTTP client for parallel requests

  • rich (13.7.0+): Beautiful console output

  • typer (0.12.0+): CLI framework

License

MIT

Author

Kenichiro Nishioka

Support

For issues and questions, please check the IB Flex Query documentation.

-
security - not tested
F
license - not found
-
quality - not tested

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

Enables comprehensive analysis of Interactive Brokers portfolios through automated data fetching and multi-dimensional analytics. Provides performance, tax, cost, risk, and bond analysis across multiple accounts with rich reporting capabilities.

  1. Features
    1. Installation
      1. Quick Start
        1. 1. Configuration
        2. 2. Fetch Data
        3. 3. Run Analysis
        4. 4. Generate Reports
      2. Programmatic Usage
        1. Project Structure
          1. Available Analyzers
            1. MCP Server Integration
              1. Quick Start
              2. Features
              3. Claude Desktop Setup
            2. Development
              1. Requirements
                1. Dependencies
                  1. License
                    1. Author
                      1. Support

                        MCP directory API

                        We provide all the information about MCP servers via our MCP API.

                        curl -X GET 'https://glama.ai/api/mcp/v1/servers/knishioka/ib-sec-mcp'

                        If you have feedback or need assistance with the MCP directory API, please join our Discord server