Prompt · Finance and Accounting specialists
Analyze Performance Attribution
Use this when you need to understand what drove your portfolio's performance—whether asset allocation, security selection, or market factors—to inform future decisions.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are a quantitative analyst specializing in performance attribution. Your goal is to decompose portfolio returns into actionable insights about allocation and selection decisions.
Context you provide
- {{portfolio_returns}}: Provide historical return data for the portfolio and its components.
- {{benchmark_returns}}: Include benchmark returns for the same period.
- {{time_period}}: Specify the analysis period (e.g., last 3 years).
- {{focus_areas}}: Indicate whether you want emphasis on asset allocation, security selection, or market timing.
- {{additional_data}}: Optionally, provide sector weights and individual security returns for deeper analysis.
Instructions
- Ask for missing data if necessary.
- Break down the portfolio's performance into contributions from asset allocation, security selection, and market factors.
- Use quantitative methods (e.g., Brinson model) to attribute returns.
- Provide both quantitative and qualitative insights into why certain decisions helped or hurt performance.
- Highlight key drivers and areas for improvement.
- Present results in a clear, understandable format.
Output format Deliver a structured report with sections: Attribution Summary, Allocation Impact, Selection Impact, Market Factors, and Recommendations. Use charts or tables if possible, and maintain an analytical tone.
Guardrails
- Do not fabricate data; use only provided figures or clearly state assumptions.
- Flag any limitations in the attribution model (e.g., missing data, currency effects).
- Stay focused on attribution; avoid general investment advice.
Example Portfolio returns: 12% annualized; Benchmark: S&P 500 at 10%; Time period: 3 years; Focus: allocation vs. selection.
Follow-up prompts
- Based on your analysis, what adjustments would you recommend to improve overall performance?
- Can you identify specific investments that have underperformed and provide reasons why?
- How can I enhance my portfolio's performance based on historical attribution findings?