🤖 Free AI Tool CSV Import Updated May 2026 Educational Only

Portfolio Analyzer

Add your holdings and get a plain English educational breakdown of your portfolio structure, diversification, risk exposure and concentration.

↓ Analyze my portfolio See sample outputs

Part of the StockEducation tool library built for clearer investor learning.

Dr. Charles Lo
Author
Part-Time Educator at the University of Sydney · Formerly at Charles Sturt University · Now at Wentworth Institute
🔗 LinkedIn
📅 Last reviewed
19 May 2026
Quarterly refresh
🤖 AI Model
GPT
Knowledge to recent
✓ Free · Educational
No financial advice
Quick Answer

How do I check whether my portfolio is too concentrated?

A portfolio can own many positions and still depend heavily on one stock, sector or theme. Check concentration by grouping holdings by sector and measuring each position as a share of the total. Then look at how much the largest few positions control together. The free StockEducation AI Portfolio Learning Tracker accepts manual entries or a CSV file and reports position weights, sector exposure, concentration measures and the overall mix. It cannot see your income, taxes, other assets or ability to bear losses. Use the result to decide what deserves a closer review, not as an order to trade.

Reviewed by Charles Lo — Head of Education Last reviewed
⚠ AI can make mistakes AI output may contain errors. It can miss recent price moves after its training cutoff, oversimplify correlation across holdings, may not know about events after its training cutoff, and can occasionally invent details that sound real but are not. Always check important facts against the original source before acting on what the AI says.
↓ PORTFOLIO ANALYZER ↓
↓ Portfolio Analyzer ↓
Portfolio Analyzer
FREE · NO SIGN-UP

Add Your Holdings

Step 1
Fill Ticker, Qty and Cost, then press Enter or click Add Holding.
CSV format: ticker,quantity,cost_basis,current_price,sector — extra columns are ignored.

Free Daily Uses · CSV Import · Educational Portfolio Review

AI Portfolio Analysis
Your portfolio breakdown appears here.

Can I trust this AI analysis?

Use it to organise your thinking, not to make the decision.

This output is generated by AI from OpenAI and Perplexity. It is good at structuring information and explaining what a figure means. It can be wrong about facts, out of date, or confidently invent things that are not true.

It knows nothing about your finances, goals or tax position. Everyone who enters the same information gets the same output.

Before you act on anything here, check it against the company's own filings on SEC EDGAR. This is not a recommendation to buy or sell.

Educational content only. Not financial, investment, legal or tax advice. This tool is for learning purposes only. Always speak with a licensed professional before making investment decisions.

The Portfolio Analyzer is a free educational tool that helps investors review holdings, diversification, sector exposure, concentration risk and portfolio structure in plain English.

📊
What it analyzes: Holdings, position size, sector exposure, concentration, cost basis, portfolio mix and risk themes based on the data you enter.
How investors use it: As a learning starting point to understand whether a portfolio is concentrated, diversified, sector heavy or worth reviewing more deeply.
Main limitation: Educational only it does not know your personal goals, income, tax position, risk tolerance or full financial situation.
The Portfolio Analyzer turns your holdings into a plain English diversification and risk read. Add positions manually or import a CSV. The AI returns sector exposure, concentration risk, position sizing observations and structural diversification gaps. Use it for periodic review, not personalized investment advice.
💾
Save analysis
Email or copy the breakdown
🎓
Learn diversification
Free course: portfolio construction
🥧
Try Allocation Calculator
Suggested stocks/bonds/cash mix

Three steps to use it

1

Add your holdings

Enter ticker, quantity, cost basis, current price and sector for each position. Add as many as you need. Or import a CSV to skip manual entry.

2

Add an optional question

Leave blank for a full diversification summary. Or ask focused questions like “which sectors am I overexposed to?” for a targeted answer.

3

Read structure and concentration

The AI returns sector exposure, top holding concentration, diversification observations and structural gaps. Use the output to plan rebalances, not as trade signals.

Walkthrough chapters

A four-chapter written walkthrough of adding holdings, importing CSVs, and reading the diversification output.

  1. Chapter 1 · 0:00 · Adding holdings manually
  2. Chapter 2 · 1:00 · Importing from CSV
  3. Chapter 3 · 2:15 · Reading sector exposure
  4. Chapter 4 · 3:15 · Understanding concentration risk

Written walkthrough · video version coming soon.

Why use it

Why investors use it

Specific outcomes for portfolio review.

1

See concentration you missed

Most retail portfolios are more concentrated than they look. The AI surfaces top holding %, sector weight, and overlap across funds.

2

Same framework every review

Consistent diversification, concentration, sector tilts read every time. Track changes over time as you rebalance.

3

Privacy preserving

Holdings stay in your session. We do not store, log or share them. Re enter at each review.

Sample output

★ Sample · Not Live AI Output

Below is a sample of the portfolio breakdown the AI returns. Exact percentages vary with your holdings; analyze your own to see real output.

Example Input “5 holdings: AAPL 100 shares @ $150 cost ($210 current), MSFT 50 @ $250 cost ($410), VTI 200 @ $200 cost ($245), JNJ 75 @ $160 cost ($155), NVDA 30 @ $400 cost ($875).”
✓ Positives (Portfolio Structure) High confidence
Total portfolio value: $120,750. Holdings count: 5. Largest position: NVDA at 21.7% of portfolio. Top 3 (NVDA, AAPL, MSFT) = 59% of portfolio. Average position size: $24,150.
Sources cited: Calculated from inputs
Why the AI said this

Portfolio value calculated by summing quantity x current price. Position weights calculated as position value / total value. Top 3 concentration is a standard diversification metric. All math direct from user inputs; high confidence.

⚠ Concerns (Concentration + Sector Risk) High confidence
59% top 3 concentration is high; “concentrated” by most diversification definitions (typically 50%+ in top 3). Heavy tech tilt: NVDA, AAPL, MSFT all tech = 51% of portfolio. JNJ (healthcare) is the only meaningful non tech exposure outside the broad VTI index fund.
Sources cited: Standard diversification thresholds · GICS sector classifications
Why the AI said this

Concentration threshold uses the conventional 50% top 3 cutoff. Sector classification uses GICS. Tech tilt calculated by summing tech holdings. Note that VTI itself contains 25-30% tech in its own composition, increasing effective tech exposure further; AI surfaces this overlap.

→ What to watch next (Diversification Gaps + Rebalance Ideas) Moderate confidence
Missing exposures to: international developed markets, emerging markets, small caps, bonds, real estate, commodities. Consider trimming top 3 if you want to reduce concentration. Adding a global ETF (VXUS, VEU) or bond ETF (BND, AGG) would broaden the structure.
Sources cited: Standard diversification framework
Why the AI said this

Diversification gaps identified by comparing portfolio composition against a balanced multi asset framework. Rebalance ideas are educational suggestions, not recommendations. Confidence moderate because optimal allocation depends on your goals, age, and risk tolerance, which the AI does not know.

Before AI vs after AI

What you see in the raw input vs what the AI surfaces from it.

Before: what you read
5 holdings: AAPL 100, MSFT 50, VTI 200, JNJ 75, NVDA 30 with cost basis and current price for each.

5 stocks with 4 data points each. To analyse diversification properly requires calculating position weights, applying sector classifications, comparing against benchmarks, identifying gaps. Roughly 45 minutes manually with a spreadsheet.
After: what the AI surfaces
What the AI surfaces in 30 seconds: total value, position weights, top 3 concentration, sector exposure, structural gaps, and rebalance ideas. Each section explains its reasoning so you can debate the AI conclusions rather than blindly act on them.

How to check the AI output in 30 seconds

AI output is a starting point, not a conclusion. Use this 3 step check before acting on anything the AI says:

1
Cross check sector classifications
Different providers (GICS, ICB) classify some companies differently. If a tech tilt seems off, verify the classifications.
2
Check ETF overlap manually
VTI plus QQQ plus VOO is heavy tech concentration even though each looks diversified alone. The AI flags this but verify against issuer factsheets.
3
Consider tax and your actual goals
Rebalancing has tax implications. AI suggestions ignore your tax situation and personal goals.

Which AI model powers this tool

AI Model
GPT
Via OpenAI API. Documentation linked in sources.
Knowledge Cutoff
recent
For events after this, verify against current news.
System Prompt
CPA reviewed
Tuned for portfolio diversification and structure analysis.
Prompt Updated
19 May 2026
Reviewed quarterly. Changes logged.

What happens to your input

Your input text is sent to the AI model provider (OpenAI via API) for processing. Your input is sent to the AI provider for processing and is not stored on our servers. The AI provider may briefly process input under their published data policy. See the OpenAI data policy[1].

⚠ Do not paste personal financial information, account numbers, tax file numbers or other sensitive data into this or any AI tool. Holdings remain in your browser session only. Do not include account numbers or any personally identifying account details.

Complete guide

Most retail portfolios drift toward concentration over time. The winners get bigger, the losers get sold, and slowly the portfolio becomes a bet on two or three stocks even though you may have started with twenty.

This tool gives you a periodic structural read. Add your holdings, get a plain English breakdown of position weights, sector exposure, concentration and diversification gaps. It is a checkup, not advice. Use it as input to rebalance decisions you make with your adviser or based on your own research.

How the AI works in this tool

We use the base GPT model with a custom system prompt tuned for portfolio analysis. The prompt calculates position weights, applies sector classifications, identifies concentration thresholds, and surfaces structural gaps. Knowledge cutoff is recent; recent price moves may not be reflected unless you enter current prices.

Common mistakes to avoid

How to read the output

Top 3 concentration is the fastest signal. Above 50% is concentrated; above 70% is essentially a 3 stock portfolio.

Sector tilts matter more than they look. A tech tilt during a tech sell off is the dominant risk regardless of stock count.

Good prompts vs bad prompts

The biggest factor in AI output quality is the input. Three side by side examples.

❌ Bad: too short, vague
“Analyse my portfolio”
Why it fails: No holdings provided. AI cannot analyse what it cannot see.
✓ Good: specific, clear context
“AAPL 100, MSFT 50, VTI 200 with cost basis and current prices”
Why it works: Real holdings with data. AI can calculate weights and analyse structure.
❌ Bad: asks for an opinion
“Should I sell my NVDA?”
Why it fails: Asks for a trade decision. Tool analyses structure, does not give buy/sell advice.
✓ Good: asks for interpretation
“My holdings… Question: NVDA is now my largest position; what does concentration risk look like?”
Why it works: Specific concentration question grounded in your actual portfolio. Useful analysis.
❌ Bad: Just listing tickers without quantities
“I own AAPL MSFT VTI”
Why it fails: Without quantities and prices, the AI cannot calculate position weights or concentration.
✓ Good: Tickers with quantities and prices
“AAPL 100 @ $210, MSFT 50 @ $410, VTI 200 @ $245”
Why it works: Enough data to calculate weights, identify concentration and produce a real analysis.

When to trust the AI vs do your own research

AI is excellent at calculating portfolio structure from inputs. It cannot replace your adviser on tax, goals or rebalance timing.

SituationUse AIOverride with research
Calculating position weights AI fast and consistent
Identifying concentration thresholds Standard framework
Tax implications of rebalancing✗ Tax adviser required
Matching allocation to your goals✗ AI does not know your goals
Sector classification standard GICS is consistent
Predicting which sector will outperform✗ Nobody can do this
ETF overlap calculation✗ AI flags, you verify
Recommending specific replacement ETFs✗ Adviser territory

Frequently asked questions

Is the Portfolio Analyzer free?

Yes. Free to use, no signup required.

What AI model does this use?

GPT via the OpenAI API with a custom prompt tuned for portfolio analysis. Knowledge cutoff is recent.

Are my holdings stored?

No. No input or output is logged or stored on our servers. Holdings remain in your session and are sent to the AI provider only for processing.

Can I import from my broker?

Use CSV import. Most brokers offer holdings export to CSV. Format the columns as ticker, quantity, cost_basis, current_price, sector.

Does it give investment advice?

No. The analyzer surfaces structural observations. For personalized advice, consult a licensed financial adviser.

How often should I run this?

Quarterly is reasonable for most investors. Monthly if you trade actively; annually if you rarely change holdings.

What if my portfolio has 50+ positions?

Still works. CSV import handles large portfolios. AI still surfaces top concentration and sector tilts.

Does it cover international holdings?

Yes. ASX, LSE, HKEX tickers work. Sector classifications follow GICS where available.

Sources, model docs & methodology

The AI used in this tool is GPT via the OpenAI API. Editorial team maintains the prompt and reviews quarterly. Portfolio analysis methodology references standard portfolio theory frameworks.

Regulatory & disclaimer

This AI tool is provided for general educational purposes only. It does not constitute financial product advice. Portfolio observations are structural; they do not factor in your tax situation, personal goals or time horizon. Consult a licensed financial adviser before making rebalance or allocation decisions.

Limitations of this AI tool

Footnotes

  1. OpenAI API documentation and data usage policy. OpenAI privacy policy
  2. GICS (Global Industry Classification Standard) maintained by MSCI and S&P. Used industry wide for sector classification. msci.com
  3. Markowitz, Harry. Portfolio Selection (Journal of Finance, 1952). Foundation paper for Modern Portfolio Theory. jstor.org
  4. Vanguard Research on the diversification benefit of asset class additions to US equity only portfolios. vanguard.com

Ready to review your portfolio?

Add your holdings and get a structural breakdown in 30 seconds. Free, no signup, no storage.

↑ Analyze my portfolio Start the free course

Educational content only. Not financial advice.

Learn how to use this

Use these lessons to understand the investing concepts behind the tool and interpret the results in context.

AI Robot

Ask Our AI Stock
Learning Assistant

Get instant educational answers about
stocks, investing, and StockEducation.com.

Instant Answers Built With Learners

Educational support only. Not personal financial advice. AI responses may contain errors.

Powered by AI ●

The Ultimate Investing Starter Guide

Free Stock Market
Investing Guide

A beginner friendly guide that covers the essential lessons and concepts every new investor should understand.

Subscription Form

Inside You'll Learn

Stocks & How They Work
Valuation Basics
Compound Interest
Index Funds & Diversification
Warren Buffett Principles
AI Stock Research & More
20+ Pages
of Value
Instant
Download
100% Free
No Strings