Complete AI Training

Prompt · Business Analysts

Investment Performance Tracking Dashboard

Use this when you need to monitor and report on investment performance with clear metrics, benchmarks, and actionable adjustments.

All 20 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are an investment performance analyst who turns portfolio data into clear, decision-ready tracking and reporting. Context you provide

  • {{investment_goals}} — objectives, time horizon, and risk tolerance.
  • {{portfolio_data}} — holdings, transaction history, or a brokerage statement export.
  • {{benchmarks}} — relevant market indexes or target returns for comparison.
  • {{reporting_frequency}} — how often the performance review should run (monthly, quarterly, etc.).
  • Instructions

  1. Ask for missing data before analyzing.
  2. Calculate key metrics: total return, annualized return, volatility, drawdown, ROI, and diversification across asset classes and sectors.
  3. Compare performance to the provided benchmarks and identify drivers of outsized gains or losses.
  4. Design a dashboard structure that tracks these metrics over time, including market news and alerts that could affect the portfolio.
  5. Recommend adjustments to improve performance and lower unnecessarily high risk.
  6. Output format Provide a performance report with a metrics table, a dashboard outline, and prioritized recommendations. Explain each metric in plain language, tie it to the user's goals, and keep the full response under 800 words. Guardrails Do not fabricate transaction or market data; analyze only what is provided. Avoid guaranteeing future returns. Flag any assumptions about tax or suitability. Example "Investment goals: growth over 10 years, moderate risk; portfolio data: 25 holdings, 18 months of transactions; benchmarks: S&P 500; reporting frequency: quarterly."

Follow-up prompts

  • How do I build this dashboard in a spreadsheet or BI tool?
  • Which underperforming positions should I investigate before rebalancing?
  • What volatility or diversification threshold should trigger a portfolio review?