iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
To find Indian shares that lost money over five years, freeze a dated NSE or BSE universe, use split- and dividend-aware data, calculate each stock’s holding-period return between the same two trading dates, and flag results below 0%. Then compare each loss with a market and sector benchmark and investigate liquidity, volatility, leverage, profitability, earnings stability, and corporate actions.
Define exactly what “negative five-year return” means
A five-year result is not meaningful until its dates, universe and return type are fixed. For an observation date D, set the start to D minus five calendar years and use the nearest valid trading day if either date is a market holiday. Record both actual trading dates in the output.
The primary measure should be the five-year holding-period total return:
Recommended Free Tools
five-year total return = (ending total-return value / starting total-return value) - 1
#1 Best Overall
- Comes with secure packaging
- Easy to read text
- It can be a gift option
Flag a security when the result is less than 0%. A stock moving from ₹100 to ₹80 therefore has a -20% holding-period return before considering whether the series includes dividends.
Do not confuse a holding-period return with CAGR. CAGR annualises the same change:
CAGR = (ending value / starting value)^(1/5) - 1
Both are useful, but label them separately. A vendor’s “five-year return” is unusable until you establish whether it means price return, total return or CAGR.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallTotal return versus price return
A price-only series measures the change in the quoted share price. A total-return series also credits dividends, normally assuming reinvestment according to the index methodology. NSE’s Total Returns Index documentation says the index includes constituent price movements and dividend receipts, records dividends on the ex-date and reinvests them. It advises that an investor should benchmark against the Total Returns Index rather than the price index to measure actual returns relative to the index. The NSE page carrying that guidance was updated on 4 January 2023.
If your data contains only adjusted or unadjusted prices, label the result price return and account for cash dividends in a separate column. Never present a price return as an investor’s complete return.
Freeze the stock universe before downloading data
The list of securities is part of the calculation. Write down the exchange, security series, eligibility rule and as-of date before collecting observations.
Choose the universe
- Exchange: specify NSE or BSE. Do not combine symbols without a documented mapping.
- Security type: define whether you are screening equity shares only and which equity series is eligible.
- Scope: choose an index, a market-cap band, a sector or every eligible listed security.
- History rule: decide whether a company must have five years of listed history, and how to treat a merger or relisting.
- As-of date: freeze membership and save the complete security list used.
A list downloaded today can omit companies that were eligible five years ago but later delisted, merged or fell outside the selected index. That is survivorship bias. If you use today’s constituents, call the result a current-universe screen; it is not a point-in-time list of every company that existed during the period.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Save an audit package
Keep the universe file, the raw downloads, the calculation date, the start and end trading-date convention, and notes about every adjustment. A second person should be able to rebuild the same screen without guessing which constituents or dates you used.
Rank #2
- Ideal for Gifting
- Ideal for a bookworm
- Comes with Proper Binding
Obtain adjusted historical observations
NSE’s reports portal provides historical Total Returns Index observations, per-security price and volume data, corporate-action-adjusted 52-week fields, and old/new symbol and company-name mappings. Use the dataset that matches your chosen universe and retain the original files.
Corporate actions that can break an endpoint comparison
- Stock splits: the number of shares and quoted price change even though economic value may not.
- Bonus issues: additional shares alter the historical price relationship.
- Rights issues: subscription terms and adjustment treatment affect the series.
- Merger or demerger: the predecessor and successor may not represent the same investment.
- Suspension or delisting: a last quoted price may not be a realizable exit value.
- Symbol or name changes: an old ticker can otherwise be mistaken for a different company.
Reconcile these events before calculating. Comparing an unadjusted price from five years ago with an adjusted current price can create a fictitious gain or loss. Use the exchange’s mappings and corporate-action records, and add an explanatory note when an event changes the security’s identity or history.
Use matching trading dates
If D minus five years falls on a holiday, select the nearest valid trading day under a stated rule, such as the last trading day on or before the anniversary. Apply the same convention to every stock and to every benchmark. Do not use one date for shares and another date for the index merely because one series has a quote available.
Calculate and flag the return
- Set
as_of_dateto the date at which the screen is run. - Compute
target_start = as_of_date - 5 years. - Map target_start and as_of_date to the nearest valid trading dates.
- Retrieve the dividend-inclusive starting and ending values for each security.
- Calculate
end_value / start_value - 1. - Set the flag to “Negative” when the result is below 0%; otherwise set it to “Non-negative”.
- Store the source, dates, adjustment convention and return type beside the result.
- Sort from the most negative result to the least negative result.
The same logic can be expressed as:
universe = securities_as_of(as_of_date)
for security in universe:
start = nearest_trading_day(as_of_date - 5 years)
end = nearest_trading_day(as_of_date)
start_value, end_value = dividend_adjusted_values(security, start, end)
five_year_return = end_value / start_value - 1
flag = five_year_return < 0Suggested result columns
| Column | What to store | Why it matters |
|---|---|---|
| Security identifier | Current symbol, company name and exchange | Prevents ambiguity after ticker changes |
| Universe status | Rule and as-of date | Shows whether the screen is current-universe or point-in-time |
| Start and end dates | Actual trading dates used | Makes the window reproducible |
| Start and end values | Total-return values, with source | Exposes the inputs to the formula |
| Five-year total return | Percentage change | Primary negative-return flag |
| Five-year price return | Separate price-only percentage, if available | Prevents mixing price and total returns |
| Benchmark return | Total return over the identical dates | Shows market-relative performance |
| Sector return | Relevant sector-index return | Separates company weakness from sector weakness |
| Liquidity and history | Volume or eligibility measures and minimum history | Identifies difficult-to-trade or short-history results |
| Risk and quality diagnostics | Beta, standard deviation, ROE, debt-to-equity and EPS-growth variability | Provides context without turning the screen into a forecast |
| Corporate-action notes | Splits, bonuses, rights, mergers, suspensions, delistings and symbol mappings | Explains unusual observations |
Compare every loss with a benchmark
A negative result can occur while the broader market falls even more, or while a company-specific problem causes a much larger decline than its peers. Use a benchmark covering the same dates and return definition.
Select the benchmark
For a large-cap NSE universe, Nifty 50 is a natural reference. SEBI Investor describes Nifty 50 as the performance of the 50 largest and most frequently traded NSE companies. For a sector screen, use the relevant sector index; SEBI identifies sector indices as tools for sector comparisons.
Use the benchmark’s total-return version when comparing with a stock’s total return. A price index against a dividend-inclusive stock series is not an even comparison.
Measure absolute and relative underperformance
Keep both figures:
- Absolute stock return: the stock’s five-year total return.
- Relative result: stock total return minus benchmark total return, expressed in percentage points.
A stock can be negative in absolute terms but outperform a benchmark that lost more. Conversely, a stock with a small positive return can still be a major relative laggard in a strongly rising market. The benchmark does not explain the cause; it only establishes the comparison frame.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitchesAdd liquidity, volatility and quality diagnostics
These fields help determine whether a negative return reflects an investable, measurable decline or a fragile observation. They do not predict recovery.
Liquidity and minimum history
Record trading volume or another consistent liquidity measure and whether the security has a complete five-year record. NSE index methodologies use liquidity eligibility and free-float market capitalization in index construction, so a screen that ignores these characteristics can overemphasise thinly traded names or stale prices.
Flag securities with long suspensions, sparse observations or a history shorter than the requested window. Do not silently substitute a listing-date return for a five-year return.
Volatility and beta
NSE defines beta as movement relative to market returns and standard deviation as return variability. Include the look-back period and frequency used by your data provider. A high beta can make a stock fall more than the market in a sell-off; high standard deviation means the path was more variable. Neither statistic tells you whether the business will recover.
Profitability, leverage and earnings stability
For quality context, collect return on equity, debt-to-equity where applicable, and the variability of earnings-per-share growth over the previous five years. NSE’s quality-index methodology uses these concepts. Keep accounting period, consolidated or standalone basis, and any unavailable metric explicit in your notes.
High leverage can amplify an operating decline, while unstable EPS growth can indicate an unreliable earnings base. A strong historical ROE can also be distorted by a small equity base or one-off gains, so read the underlying filings.
Investigate why the stock fell
The screen identifies an outcome, not a diagnosis. Before interpreting a large loss, review company filings and exchange disclosures for:
- promoter or other ownership changes and share pledging;
- auditor qualifications or emphasis-of-matter paragraphs;
- material acquisitions, disposals, demergers or business-line changes;
- debt restructurings, covenant stress or repeated equity issuance;
- regulatory action, trading suspension or delisting proceedings;
- changes in the listed entity, symbol or corporate structure.
Read the event against the same-date sector and market returns. A commodity cycle, policy change or industry downturn may explain a sector-wide decline; a qualified audit, pledge increase or governance event points to company-specific risk. Do not infer causation from the return ranking alone.
Build the screen in a spreadsheet
A spreadsheet is sufficient when the universe is modest and every input is retained. Create one row per security and separate raw-data tabs from calculated fields.
- Import the frozen universe and assign a stable security identifier.
- Import total-return observations and the exchange’s old/new symbol mapping.
- For each row, calculate the target anniversary and map it to the selected trading dates.
- Use lookup formulas to retrieve the first and last total-return values.
- Calculate
=EndValue/StartValue-1and format it as a percentage. - Use
=IF(Return<0,"Negative","Non-negative")for the screen flag. - Add benchmark and sector lookups using the identical dates.
- Sort by return ascending and filter for the negative flag.
- Attach adjustment and filing notes rather than overwriting raw values.
For a repeatable monthly or quarterly process, store each run’s as-of date and universe file instead of replacing the previous result. This lets you distinguish a genuine change in performance from a change in membership or data treatment.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Common mistakes and how to correct them
Using today’s winners and calling the result historical
Problem: delisted or failed companies disappear from a current list.
Correction: label the result current-universe, or obtain point-in-time membership that includes securities eligible on the historical date.
Using unadjusted prices across a split
Problem: the split creates an artificial jump or collapse.
Correction: use a consistently adjusted series and document the event.
Calling price return “investor return”
Problem: cash dividends are omitted.
Correction: use total-return values or show price return and dividends separately.
Mixing trading dates
Problem: one endpoint is a holiday or comes from a different window.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Correction: apply one nearest-trading-day rule to every stock and benchmark.
Best Value
Relying on an unexplained vendor percentage
Problem: the field may be CAGR, price return or total return.
Correction: obtain the endpoint values, reconstruct the calculation and retain the vendor’s definition.
Treating a negative flag as a sell signal
Problem: historical underperformance says nothing certain about future returns.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Correction: use the flag to start due diligence, then assess business quality, valuation, liquidity and risk independently.
How to present the final ranking
Publish the observation date, universe rule, exchange, return definition and adjustment convention above the table. Rank from most negative to least negative, but keep the benchmark, sector return, price return and total return in separate columns. Include a note for every incomplete history, suspension, merger or symbol change.
Do not publish a portfolio-wide count as if it were an official statistic. No official source reviewed for this method publishes a single count of all Indian stocks with negative five-year returns as of 16 October 2026. The number changes with the chosen universe, point-in-time membership, dates and fresh security-level calculations.
What the screen can—and cannot—tell you
- It can identify securities whose defined five-year holding-period return was below zero.
- It can show whether the loss was worse than a market or sector benchmark.
- It can expose data-quality issues caused by corporate actions, symbol changes or incomplete history.
- It can organise further checks on liquidity, volatility, leverage, profitability and earnings stability.
- It cannot forecast a rebound, establish that a company is undervalued, or provide an automatic buy or sell decision.
The most defensible result is therefore a dated, reproducible screen with dividend-inclusive values, transparent endpoint dates and a documented explanation of unusual corporate events.
Free tools Windows power users keep installed
One-click scans. No signup required.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
