IB Analytics MCP Server

#!/usr/bin/env python3 """ Comprehensive Portfolio Summary Report Executive summary of all analyses conducted """ from datetime import datetime def generate_comprehensive_report(): """Generate comprehensive summary report""" print("=" * 80) print("COMPREHENSIVE PORTFOLIO ANALYSIS REPORT") print("Interactive Brokers - 2025 Trading Performance") print("=" * 80) print() print(f"Report Generated: {datetime.now().strftime('%B %d, %Y at %I:%M %p')}") print(f"Analysis Period: January 1, 2025 - October 5, 2025") print(f"Account Holder: [Your Name]") print(f"Account ID: UXXXXXXXX") print() print("=" * 80) print("EXECUTIVE SUMMARY") print("=" * 80) print() print("PORTFOLIO SNAPSHOT") print("-" * 80) print(f"Total Portfolio Value: $43,151.62") print(f" Cash: $18,500.66") print(f" Positions: $24,650.96") print() print(f"Total Invested Capital: $269,814.32") print(f"Capital Withdrawn: $231,640.00") print(f"Current Net Investment: $38,174.32") print() print(f"Total Realized P&L: $3,672.05") print(f"Unrealized P&L: $1,193.96") print(f"Total P&L (Net): $4,866.01") print(f"Overall ROI: 1.80%") print() print("CURRENT HOLDINGS") print("-" * 80) print(f"Position: US Treasury STRIP 0% 11/15/2040") print(f"Quantity: 50,000 (face value)") print(f"Value: $24,650.96") print(f"Cost Basis: $23,457.00") print(f"Unrealized: $1,193.96 (+5.09%)") print(f"Maturity: November 15, 2040 (15.1 years)") print(f"Yield: 5.136% annually") print() print("=" * 80) print("SECTION 1: TRADING PERFORMANCE ANALYSIS") print("=" * 80) print() print("OVERALL TRADING METRICS") print("-" * 80) print(f"Total Trades: 16") print(f"Trading Period: January 13 - July 10, 2025 (178 days)") print(f"Trading Frequency: 0.07 trades/day (conservative)") print() print(f"Buy Trades: 10") print(f"Sell Trades: 6") print(f"Net Position Change: Fully closed (all positions squared)") print() print("PROFITABILITY METRICS") print("-" * 80) print(f"Total Realized P&L: $3,672.05") print(f"Total Commissions: $21.95") print(f"Net P&L: $3,650.10") print(f"Return on Capital: 1.80%") print() print(f"Gross Sales: $146,361.45") print(f"Gross Purchases: $166,124.45") print(f"Total Trading Volume: $312,485.90") print() print("=" * 80) print("SECTION 2: VOO (S&P 500 ETF) TRADING ANALYSIS") print("=" * 80) print() print("PERFORMANCE RATING: 🟢 EXCELLENT") print("-" * 80) print() print("KEY METRICS") print("-" * 80) print(f"Total VOO Trades: 13") print(f"Shares Traded: 122 bought, 122 sold (net 0)") print(f"Realized P&L: $2,164.05") print(f"Win Rate: 80% (4 wins, 1 loss)") print(f"Profit Factor: 88.70 ⭐⭐⭐") print(f"Risk/Reward Ratio: 22.17:1") print() print("TRADING EFFICIENCY") print("-" * 80) print(f"Average Buy Price: $535.86") print(f"Average Sell Price: $553.65") print(f"Price Appreciation: +3.32%") print() print(f"Average Win: $547.18") print(f"Average Loss: -$24.68") print(f"Largest Win: $2,010.19 (July 10)") print(f"Largest Loss: -$24.68 (January 14)") print() print("ASSESSMENT") print("-" * 80) print("✓ Outstanding win rate (80%)") print("✓ Exceptional profit factor (88.70)") print("✓ Excellent risk management (losses minimized)") print("✓ Strong discipline (conservative frequency)") print("✓ Successful strategy - continue current approach") print() print("=" * 80) print("SECTION 3: BOND TRADING ANALYSIS") print("=" * 80) print() print("COMPLETED TRADES") print("-" * 80) print(f"Security: US Treasury STRIP 0% 11/15/30") print(f"Purchase Date: January 30, 2025") print(f"Purchase Price: $77,298 (100,000 face value)") print(f"Sale Date: May 22, 2025") print(f"Sale Price: $78,816") print(f"Holding Period: 112 days") print(f"Realized P&L: $1,508.00 (+1.96%)") print(f"Commissions: $10.00") print(f"Net Profit: $1,498.00") print() print("CURRENT HOLDINGS") print("-" * 80) print(f"Security: US Treasury STRIP 0% 11/15/40") print(f"Purchase Date: July 10, 2025") print(f"Purchase Price: $23,457 (50,000 face value)") print(f"Current Value: $24,650.96") print(f"Unrealized P&L: $1,193.96 (+5.09%)") print(f"Days Held: 87 days") print() print("BOND STRATEGY ASSESSMENT") print("-" * 80) print("✓ Successfully identified profitable entry/exit for 30-year STRIP") print("✓ Currently holding 40-year STRIP with solid unrealized gain") print("✓ Zero-coupon bonds providing steady appreciation") print("✓ Long-term hold strategy appropriate for maturity profile") print() print("=" * 80) print("SECTION 4: MONTHLY PERFORMANCE TRACKING") print("=" * 80) print() print("MONTH-BY-MONTH RESULTS") print("-" * 80) print(f"{'Month':<15} {'Trades':<8} {'Net P&L':<15} {'Cumulative P&L':<15}") print("-" * 80) print(f"{'January 2025':<15} {'12':<8} {'$143.93':<15} {'$143.93':<15}") print(f"{'February 2025':<15} {'1':<8} {'-$1.00':<15} {'$142.93':<15}") print(f"{'May 2025':<15} {'1':<8} {'$1,503.00':<15} {'$1,645.93':<15}") print(f"{'July 2025':<15} {'2':<8} {'$2,004.17':<15} {'$3,650.10':<15}") print() print("CONSISTENCY METRICS") print("-" * 80) print(f"Profitable Months: 3 out of 4 (75%)") print(f"Best Month: July 2025 ($2,004.17)") print(f"Worst Month: February 2025 (-$1.00)") print(f"Average P&L/Month: $912.53") print() print("TREND ANALYSIS") print("-" * 80) print("📈 POSITIVE TREND: Performance improving over time") print("✓ Excellent consistency (75% profitable months)") print("✓ Conservative trading frequency (4 trades/month avg)") print("⚠ Concentration: July accounts for 55% of total profits") print() print("=" * 80) print("SECTION 5: COST EFFICIENCY ANALYSIS") print("=" * 80) print() print("RATING: 🟢 EXCELLENT") print("-" * 80) print() print("COMMISSION ANALYSIS") print("-" * 80) print(f"Total Commissions Paid: $21.95") print(f"Total Trading Volume: $312,485.90") print(f"Overall Commission Rate: 0.0070%") print(f"Average Commission/Trade: $1.37") print() print("COST BREAKDOWN") print("-" * 80) print(f"VOO Commissions: $6.95 (13 trades, 0.0052% rate)") print(f"Bond Commissions: $15.00 (3 trades, 0.0084% rate)") print() print("EFFICIENCY RATING") print("-" * 80) print(f"Industry Benchmark: 0.002% - 0.01% (discount brokers)") print(f"Your Rate: 0.0070%") print(f"Performance: ✓ BEATING discount broker benchmarks") print() print(f"Impact on Profitability: 0.60% of total P&L") print(f"Assessment: Minimal cost drag - excellent efficiency") print() print("OPTIMIZATION OPPORTUNITIES") print("-" * 80) print("• Consider IBKR Lite for $0 stock/ETF commissions (~$7/year savings)") print("• Batch smaller trades when possible (6 trades under $5K)") print("• Current practices are already excellent - minor tweaks only") print() print("=" * 80) print("SECTION 6: TAX ANALYSIS (PHANTOM INCOME)") print("=" * 80) print() print("ZERO-COUPON BOND TAX TREATMENT") print("-" * 80) print(f"Current Holdings: US Treasury STRIP 0% 11/15/40") print(f"Face Value: $50,000") print(f"Purchase Price: $23,457") print(f"Maturity Date: November 15, 2040") print() print("2025 TAX IMPACT") print("-" * 80) print(f"Holding Period in 2025: July 10 - December 31 (175 days)") print(f"Phantom Interest Income: $560.70") print(f"Estimated Tax (30% rate): $168.21") print() print("⚠️ This $560.70 must be reported as taxable interest income") print(" even though NO CASH is received until maturity in 2040.") print() print("15-YEAR TAX PROJECTION") print("-" * 80) print(f"Total Phantom Income: $26,543 (over life of bond)") print(f"Estimated Total Tax (30%): $7,962.90") print() print(f"Pre-Tax Yield: 5.136%") print(f"After-Tax Yield (estimated): 3.768%") print(f"Tax Impact: -1.368% annually") print() print("TAX STATUS - MALAYSIA RESIDENT") print("-" * 80) print("LIKELY TAX TREATMENT:") print("✓ US: Treasury interest typically EXEMPT for non-residents") print("✓ Malaysia: Foreign income generally NOT TAXED") print("✓ Treaty: US-Malaysia treaty provides double-tax relief") print() print("EXPECTED OUTCOME:") print("→ Likely $0 tax burden in both jurisdictions") print("→ Form W-8BEN required for treaty benefits") print("→ Professional tax advice STRONGLY recommended") print() print("=" * 80) print("SECTION 7: RISK ANALYSIS - INTEREST RATE SCENARIOS") print("=" * 80) print() print("CURRENT BOND POSITION RISK PROFILE") print("-" * 80) print(f"Current Price: $24,650.96") print(f"Unrealized Gain: $1,193.96") print(f"Duration: ~15.1 years") print(f"Rate Sensitivity: ~15.1% price change per 1% rate move") print() print("SCENARIO OUTCOMES") print("-" * 80) print(f"{'Scenario':<25} {'Rate Change':<15} {'New Price':<15} {'Total P&L':<15}") print("-" * 80) print(f"{'Best Case (Rate -3%)':<25} {'-3.0%':<15} {'$38,237':<15} {'+$14,780':<15}") print(f"{'Good Case (Rate -1%)':<25} {'-1.0%':<15} {'$28,495':<15} {'+$5,038':<15}") print(f"{'Base Case (No Change)':<25} {'0.0%':<15} {'$24,651':<15} {'+$1,194':<15}") print(f"{'Moderate Risk (+1%)':<25} {'+1.0%':<15} {'$21,355':<15} {'-$2,102':<15}") print(f"{'Worst Case (Rate +3%)':<25} {'+3.0%':<15} {'$16,091':<15} {'-$7,366':<15}") print() print("PROBABILITY-WEIGHTED ANALYSIS") print("-" * 80) print(f"Expected Value: $23,176 (slight decline)") print(f"Best Case Upside: +$13,586 (+55%)") print(f"Worst Case Downside: -$8,560 (-35%)") print(f"Risk/Reward Ratio: 1.59:1") print() print("OUTCOME PROBABILITIES (Based on scenarios)") print("-" * 80) print(f"Net Loss Scenarios: 65% (4 scenarios)") print(f"Small Gain ($0-2K): 10% (1 scenario)") print(f"Large Gain (>$2K): 25% (4 scenarios)") print() print("RISK ASSESSMENT") print("-" * 80) print("⚠️ Significant interest rate risk due to long duration") print("⚠️ Probability-weighted outcome slightly negative") print("✓ Strong upside potential if rates decline") print("⚠️ Potential losses if rates rise significantly") print() print("RECOMMENDATIONS BY RISK PROFILE") print("-" * 80) print("Conservative: Consider selling or partial sale (50%)") print("Moderate: Hold if comfortable with volatility") print("Aggressive: Hold or buy more if rates expected to fall") print() print("=" * 80) print("SECTION 8: STRATEGIC RECOMMENDATIONS") print("=" * 80) print() print("STRENGTHS TO MAINTAIN") print("-" * 80) print("1. ✓ Excellent trading discipline (80% win rate on VOO)") print("2. ✓ Superior cost management (0.0070% commission rate)") print("3. ✓ Strong risk management (small losses, large winners)") print("4. ✓ Conservative trading frequency (quality over quantity)") print("5. ✓ Profitable bond timing (successful 30-year STRIP trade)") print() print("AREAS FOR IMPROVEMENT") print("-" * 80) print("1. ⚠️ Single-month concentration (July = 55% of profits)") print(" → Develop more consistent monthly returns") print() print("2. ⚠️ Interest rate risk exposure (15-year duration)") print(" → Consider diversifying with shorter-term bonds") print(" → Or accept volatility for hold-to-maturity strategy") print() print("3. ⚠️ Commission optimization available") print(" → IBKR Lite could save $7-10/year on stock trades") print() print("IMMEDIATE ACTION ITEMS") print("-" * 80) print("1. ✓ Submit/verify Form W-8BEN for US tax treaty benefits") print("2. ✓ Consult tax advisor (US non-resident + Malaysia resident)") print("3. ⚠️ Monitor Federal Reserve policy for interest rate outlook") print("4. ⚠️ Decide on bond strategy: hold to maturity vs. active management") print("5. ✓ Consider IBKR Lite account for zero-commission stock trading") print() print("LONG-TERM STRATEGIC CONSIDERATIONS") print("-" * 80) print("1. BOND LADDER: Build 5/10/15/20-year maturity ladder") print(" → Reduces interest rate risk") print(" → Provides regular cash flows") print() print("2. PORTFOLIO DIVERSIFICATION:") print(" → Current: 100% bonds (conservative)") print(" → Consider: 60/40 or 70/30 stock/bond mix") print(" → Utilize proven VOO trading skills") print() print("3. RISK MANAGEMENT:") print(" → Set stop-loss rules for future trades") print(" → Define maximum position sizes") print(" → Document trading plan and rules") print() print("=" * 80) print("SECTION 9: PERFORMANCE SCORECARD") print("=" * 80) print() print(f"{'Metric':<35} {'Rating':<15} {'Score':<10}") print("-" * 80) print(f"{'Trading Profitability':<35} {'🟢 Excellent':<15} {'9/10':<10}") print(f"{'Win Rate Consistency':<35} {'🟢 Excellent':<15} {'9/10':<10}") print(f"{'Risk Management':<35} {'🟢 Excellent':<15} {'9/10':<10}") print(f"{'Cost Efficiency':<35} {'🟢 Excellent':<15} {'10/10':<10}") print(f"{'Trading Discipline':<35} {'🟢 Excellent':<15} {'9/10':<10}") print(f"{'Monthly Consistency':<35} {'🟢 Good':<15} {'7/10':<10}") print(f"{'Portfolio Diversification':<35} {'🟡 Fair':<15} {'5/10':<10}") print(f"{'Interest Rate Risk Mgmt':<35} {'🟡 Fair':<15} {'6/10':<10}") print(f"{'Tax Optimization':<35} {'🟡 Moderate':<15} {'6/10':<10}") print(f"{'Documentation/Planning':<35} {'🟡 Moderate':<15} {'6/10':<10}") print() print(f"{'OVERALL PERFORMANCE':<35} {'🟢 EXCELLENT':<15} {'7.6/10':<10}") print() print("=" * 80) print("SECTION 10: COMPARISON WITH BENCHMARKS") print("=" * 80) print() print("YOUR PERFORMANCE vs S&P 500 (Approximate)") print("-" * 80) print(f"Your YTD Return: 1.80% (net of withdrawals)") print(f"S&P 500 YTD (2025 est): ~8-12% (market dependent)") print() print("Note: Direct comparison difficult due to large capital withdrawal") print(" ($231,640 withdrawn from original $269,814 investment)") print() print("ADJUSTED PERFORMANCE METRICS") print("-" * 80) print(f"Realized Gains: $3,672.05") print(f"Unrealized Gains: $1,193.96") print(f"Total Gains: $4,866.01") print(f"Current Portfolio: $43,151.62") print() print("If capital had not been withdrawn:") print(f"Estimated Portfolio Value: ~$274,680") print(f"Estimated ROI: ~1.80%") print() print("=" * 80) print("CONCLUSION & FINAL ASSESSMENT") print("=" * 80) print() print("OVERALL RATING: 🟢 EXCELLENT (7.6/10)") print() print("KEY ACHIEVEMENTS:") print("-" * 80) print("✓ Outstanding VOO trading performance (80% win rate, 88.7 profit factor)") print("✓ Exceptional cost management (0.0070% commission rate)") print("✓ Strong risk-adjusted returns with minimal losses") print("✓ Disciplined, conservative trading approach") print("✓ Successful bond trading with profitable exits") print() print("AREAS REQUIRING ATTENTION:") print("-" * 80) print("⚠️ Interest rate risk concentration (15-year duration)") print("⚠️ Single-month profit concentration (July = 55%)") print("⚠️ Tax planning clarity needed (Phantom Income)") print("⚠️ Portfolio diversification opportunity") print() print("STRATEGIC OUTLOOK:") print("-" * 80) print("Your trading demonstrates exceptional skill and discipline.") print("The main risks are:") print(" 1. Interest rate volatility on long-duration bond") print(" 2. Lack of diversification (100% bonds currently)") print() print("Recommendations:") print(" 1. Define clear strategy for 40-year STRIP (hold vs. trade)") print(" 2. Monitor Fed policy closely for rate outlook") print(" 3. Consider gradual portfolio diversification") print(" 4. Leverage proven VOO trading skills") print(" 5. Maintain excellent cost and risk discipline") print() print("=" * 80) print("APPENDIX: DATA SOURCES & METHODOLOGY") print("=" * 80) print() print("DATA SOURCES") print("-" * 80) print("• Interactive Brokers Flex Query API") print("• Period: January 1, 2025 - October 5, 2025") print("• Total Transactions: 16 trades") print("• Account Statements: Cash summary, positions, trades") print() print("ANALYSIS METHODOLOGY") print("-" * 80) print("1. Trade-by-trade performance analysis") print("2. Statistical metrics (win rate, profit factor, risk/reward)") print("3. Cost efficiency benchmarking") print("4. Tax obligation modeling (Phantom Income)") print("5. Interest rate scenario analysis (9 scenarios)") print("6. Monthly performance tracking and trend analysis") print() print("ASSUMPTIONS & LIMITATIONS") print("-" * 80) print("• Tax rate: 30% (illustrative; actual may be 0% for non-residents)") print("• Interest rate probabilities: Based on historical patterns") print("• S&P 500 comparison: Approximate 2025 performance") print("• All figures in USD") print("• Market data as of October 5, 2025") print() print("=" * 80) print("END OF COMPREHENSIVE REPORT") print("=" * 80) print() print("For questions or further analysis, please consult:") print("• Financial advisor for investment strategy") print("• Tax professional for US/Malaysia tax obligations") print("• Interactive Brokers support for account-specific questions") print() print("Report generated by IB Securities Analysis Suite") print(f"© 2025 | Generated: {datetime.now().strftime('%Y-%m-%d %H:%M:%S')}") print("=" * 80) def main(): generate_comprehensive_report() if __name__ == '__main__': main()