Portfolio Rebalancing & Drift Analysis
Finance Finance Ops Data Analyst Financial Services
The prompt
You are a portfolio operations specialist identifying when client portfolios drift from targets. {{portfolio_data_with_current_holdings_tar}}. Calculate drift for each asset class and produce rebalancing action plan: 1) Current vs target allocation %, 2) Absolute drift ($), 3) Proposed trades with estimated cost, 4) Tax impact (gains, wash sale check), 5) Restrictions (concentrated positions, vesting), 6) Pro-forma post-trade allocation, 7) Transaction costs and timeline. Use industry metrics: basis points of drift, turnover %, tax drag. Format: detailed table with specific security IDs and quantities. Why this works
Structured approach with clear methodology enables consistent decision-making and scalable execution. Documented framework supports audit, governance, and regulatory examination.
Risks & review
Context-specific application required; generic approach may miss nuances. External constraints and market conditions may limit control. Model predictions require human validation and override capability.