Finance & Investment · Risk & Portfolio

Sector Allocation Calculator

List your stocks (or fund exposures) with their sector to see your sector allocation and spot heavy concentration in one industry.

A ready-made version of the Portfolio Weights & Allocation Calculator.

Your inputs

Quick start — try a typical case

Currency

Stocks by Sector

8 rows · you can paste rows from Excel or Google Sheets

Type any group name; rows with the same group are added together.

Your result Live

Total Portfolio Value

₹15,70,000

Financials 37% · IT 25% · Energy 15% · Industrials 10% · Consumer staples 8% · Healthcare 6%

Financials: 36.9% — ₹5,80,000
IT: 24.8% — ₹3,90,000
Energy: 15.3% — ₹2,40,000
Industrials: 9.6% — ₹1,50,000
Consumer staples: 7.6% — ₹1,20,000
Healthcare: 5.7% — ₹90,000
Largest Holding: HDFC Bank: 20.4%
Holdings / Effective Number: 8 / 7.1

Financials · 37%₹5,80,000 (36.9%)
IT · 25%₹3,90,000 (24.8%)
Energy · 15%₹2,40,000 (15.3%)
Industrials · 10%₹1,50,000 (9.6%)
Consumer staples · 8%₹1,20,000 (7.6%)
Healthcare · 6%₹90,000 (5.7%)

Holdings by weight

8 rows

Holding	Group	Value	Weight	Weight within group
HDFC Bank	Financials	₹3,20,000	20.4%	55.2%
ICICI Bank	Financials	₹2,60,000	16.6%	44.8%
Reliance	Energy	₹2,40,000	15.3%	100.0%
Infosys	IT	₹2,10,000	13.4%	53.8%
TCS	IT	₹1,80,000	11.5%	46.2%
Larsen & Toubro	Industrials	₹1,50,000	9.6%	100.0%
ITC	Consumer staples	₹1,20,000	7.6%	100.0%
Sun Pharma	Healthcare	₹90,000	5.7%	100.0%

How this is calculated

Weight = Holding value ÷ Total value · Group allocation = Σ weights in the group

Effective number: 1 ÷ Σ weight² — how many equal-sized holdings the portfolio behaves like

Knowing your real mix is the first step in managing a portfolio: funds and accounts spread across platforms often add up to a very different allocation than intended. Group by asset class to check your equity–debt split, or by sector, market cap or owner for other views.

Assumptions & sources

Values are today's market values; a hybrid fund counted in one group may in reality hold several asset classes.

1CFA Program Curriculum — Quantitative Methods: The Time Value of Money — CFA Institute
2Investor education material — SEBI — Securities and Exchange Board of India

Calculator ID FIN-PORT-WEIGHT-001/sector · version 1.0.0

Common questions

How much in one sector is too much?

Many investors cap any single sector at around 25–30 % of their equity, unless they deliberately want that exposure. Compare with the index — financials are over a third of the Nifty 50.

How do I count funds?

Use the fund's sector breakdown from its factsheet and enter one row per sector with your share of the value.