Skip to content
Advanced

Best Gemini Prompt for Portfolio Review

Why Gemini?

Gemini excels at processing a list of holdings, calculating exposure percentages, and producing a structured portfolio health report with diversification analysis, risk flags, and rebalancing recommendations.

Prompt Template
Open Gemini
You are a portfolio manager and risk analyst reviewing an investment portfolio.\n\n**Portfolio holdings:**\n{{portfolio_holdings}}\n\n**Total portfolio value:** {{total_value}}\n**Investment goals:** {{goals}}\n**Time horizon:** {{time_horizon}}\n**Risk tolerance:** {{risk_tolerance}}\n\n**Please conduct a full portfolio review:**\n\n**1. Current Allocation**\nBreak down the portfolio by: asset class, sector, geography, and individual position size (% of total).\n\n**2. Concentration Risk**\nIdentify any positions > 10% of portfolio. Flag single-stock risk, sector concentration, or correlation clusters.\n\n**3. Performance Attribution**\nIf return data is provided, identify which positions are driving performance and which are lagging.\n\n**4. Alignment with Goals**\nDoes the current allocation match the stated goals, time horizon, and risk tolerance?\n\n**5. Rebalancing Recommendations**\nSpecific actions: what to trim, what to add, what to exit, and suggested target weights.\n\n**6. Missing Exposures**\nWhat asset classes or sectors are underrepresented given the goals?\n\n**7. Risk Score**\nEstimated portfolio risk level (1–10) with explanation.
Example Output
**Allocation Breakdown:**\n- US Large Cap Tech: 75% (NVDA+AAPL+MSFT+QQQ overlap)\n- Crypto: 10%\n- Cash: 15%\n\n**Concentration Risk:** CRITICAL — 75% in correlated US tech/AI. NVDA alone at 25% is a single-stock risk. QQQ further amplifies existing holdings.\n\n**Goal Alignment:** Aggressive, not moderate. Tech concentration is inappropriate for stated moderate risk tolerance.\n\n**Rebalancing Recommendations:**\n- Trim NVDA to 10% (sell $15K)\n- Trim QQQ to 5% (overlap with existing holdings)\n- Add: International equity ETF (VEA) 10%, Bonds/TLT 10%, Small cap (IWM) 5%\n- Maintain BTC at 10% given 10-year horizon\n\n**Missing Exposures:** International equities, fixed income, commodities, healthcare.\n\n**Risk Score: 8/10** — Extremely concentrated in a single sector despite moderate stated tolerance.

Make it yours

Got your AI output? Make it better.

Paste what Gemini generated into Coda One — free, no signup.

Tips for Better Results
List every position with its percentage or dollar value. Include your actual investment goals and time horizon — vague inputs produce vague reviews. Ask for a target allocation table as a separate deliverable.
Example (filled in)
Holdings: NVDA 25%, AAPL 20%, MSFT 15%, QQQ 15%, BTC 10%, Cash 15%. Total: $100,000. Goals: Long-term growth, some capital preservation. Horizon: 10 years. Risk: Moderate.