To find Indian shares that lost money over five years, freeze a dated stock universe, collect split- and dividend-aware historical data, use the nearest valid trading days for the start and end dates, calculate each stock’s holding-period total return, and flag every result below 0%. Then compare each flagged stock with a broad or sector benchmark and investigate liquidity, volatility, leverage, profitability, earnings stability, and corporate actions.
The result is a historical screen, not a forecast or an automatic sell signal. The answer changes with the exchange, security universe, observation date, treatment of dividends, and handling of delisted or renamed companies. Record those choices so another investor can reproduce the list.
As an Amazon Associate I earn from qualifying purchases.
What “negative five-year return” actually means
A five-year return compares an investment’s value on two specified dates. Let D be the observation date. The starting observation is normally the trading day nearest to D minus five calendar years; the ending observation is the trading day nearest to D. A stock is flagged when its holding-period return is below zero.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →The basic calculation is:
five-year total return = (ending total-return value / starting total-return value) - 1
#1 Best Overall
- Compact & Portable Design: This Small Excel, Word, PowerPoint, & Windows Cheat Sheet Mouse Pad measures 11.8" x 9.8", offering a portable mouse pad. Its compact size fits in bags or laptop cases, suitable for professionals, students, or travelers.
- Multi-Software Shortcut Guide: Featuring essential shortcut keys for Excel, Word, PowerPoint, & Windows, this small mouse pad provides a quick reference for frequently used shortcuts, offering a reference designed to support workflow efficiency
- Smooth & Precise Surface: The finely-textured surface ensures precise mouse control, allowing for smooth and accurate movement during work or gaming sessions.
- Durable & Non-Slip Design: This Multi-Software Shortcut Mouse Pad features stitched edges to reduce fraying. The non-slip rubber base helps keep it securely in place, and the water-resistant fabric allows for easier maintenance.
- Clear Print Quality: Displays high-resolution printing intended to remain legible through regular use and cleaning
For example, if a dividend-adjusted value rose from 100 to 120, the holding-period return would be 20%. If it fell from 100 to 80, the return would be −20%. Those numbers are only an arithmetic illustration, not a market result.
Use total return when the question is about an investor’s outcome
A price series measures only the change in the quoted share price. A total-return series also includes cash distributions and assumes those distributions are reinvested according to the index methodology. NSE explains that its Total Returns Index includes constituent price movements and dividend receipts, records dividends on the ex-date, and reinvests them.
“An investor in index stocks should benchmark his investments against the Total Returns index instead of the price index to determine the actual returns vis-à-vis the index.” — NSE India, Total Returns Index page, updated 4 January 2023.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
If your data contains only prices, label the result price return. Do not call it total return. You can report dividends separately, but adding an unverified dividend estimate to an adjusted price creates a different and potentially misleading series.
Do not confuse holding-period return with CAGR
A five-year holding-period return answers, “How much did the investment gain or lose over the whole interval?” Compound annual growth rate (CAGR) answers, “What constant annual rate would produce that ending value?” Its formula is (ending value / starting value)^(1/5) - 1 for exactly five years. Both measures have the same positive or negative sign when the dates and values are the same, but their percentages are not interchangeable. Keep separate columns for total return and CAGR if a data vendor reports both.
Freeze the stock universe before downloading data
The universe determines what your screen can find. Write the rules first and save the resulting security list. At minimum, specify:
- Exchange: NSE, BSE, or both. Do not merge listings casually; map the security identifiers and select one authoritative series for each company.
- Security type: equity series and any exclusions such as exchange-traded funds, preference shares, warrants, suspended securities, or newly listed issues.
- Size or membership rule: a market-cap band, a named index, or every eligible listed equity.
- Minimum history: whether a company must have a valid observation near the five-year start date.
- As-of date: the date on which membership and the ending observation are fixed.
A list downloaded today is a current-universe screen. It can omit companies that were eligible five years ago but later delisted, merged, or fell out of an index. That is survivorship bias: the screen studies today’s survivors rather than the investable set known at the starting date. A point-in-time universe, preserved as of the chosen date, is needed for a historical membership study.
Recommended Free Tools
Rank #2
- [MULTIFUNCTIONAL]You'll get 2 pieces computer monitor memo boards that you can stick on the left and right edges of your monitor, and they're the perfect office desk organizers and accessories. Computer monitor side panels desktop organizer are suitable for home work or office,bringing convenience. Desktop memo is used to organize meeting memos, important messages, business cards, planning notes.Paste on the message board to keep track of important things and to-do items to prevent forgetting.
- [🌟HIGHLY QUALITY] The material of computer screen side note holder is transparent acrylic. Durable, simple, stylish, light weight, easy to use, not easy to fall off or break. This cute office supplies for women desk can be used for a long time. This computer desk accessories is waterproof and dirt resistance, and look simple and stylish. The transparent acrylic sticky note holder as cubicle accessories is easy to notice the context of your sticky notes.
- [📋Easy to use] Office must haves cool office gadgets for desk ready to tear, easy to install and remove, not easy to leave traces. You only need to peel off the protective film on the surface of the computer side board memo, wipe off the dust on the edge of the computer monitor, and then stick the desk essentials for women office on the right or left side of the tape, and you're done. A perfect gift for your colleagues, friends or classmates and family members or relatives
- [🏢MULTI-SCENE USE] This desk supplies computer memo board can be applied to home and office, clear your office decor for women, suitable for most computer monitors, screens and cabinets, you can put it where you think, this cute office decor serve as a reminder. Stick on the computer side. It’s a good office gadgets can remind work improve office productivity. Pasted cabinets, dressers, refrigerators, walls, etc as cubicle accessories. To make life more orderly.
- [💌NOTE] The adhesive force of the computer sticky note holder is very strong. It can not be directly pasted on the computer screen. It should pasted on the black edge of the screen. Narrow edge not recommended!!! If you are not satisfied with your purchase, or if the product is damaged or broken in transit, please let us know immediately. We will promptly solve your problem.
Choose the question before choosing the list
These are different questions:
- “Which stocks in today’s NSE large-cap universe have lost money over the past five years?” uses current membership.
- “Which stocks an investor could have selected five years ago subsequently lost money?” requires a point-in-time universe and historical eligibility data.
- “Which current constituents of a named index underperformed?” requires the index’s membership rule and the relevant review dates.
Put the question and universe definition in the screen’s title or methodology note. Otherwise readers cannot tell whether a missing delisted stock is a genuine non-loss or simply absent from the file.
Set the dates consistently
Take the observation date first. Subtract five calendar years, then select the nearest valid trading day for the start. Select the nearest valid trading day for the end as well. If the anniversary falls on a Saturday, Sunday, exchange holiday, or a day with no valid observation, state whether you used the previous trading day, the next trading day, or the nearest day by distance. Apply the same convention to every security.
Do not silently use one stock’s first available date and another stock’s exact anniversary. A shorter interval can make a loss appear smaller, while a longer interval can include a materially different market cycle. Store the actual start and end dates beside every calculated return, not only the intended anniversary.
Collect historical data from authoritative files
NSE’s reports portal exposes several data types useful for this work:
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →- Historical Total Returns Index values.
- Per-security historical price and volume data.
- Corporate-action-adjusted 52-week fields.
- Old and new symbol and company-name mappings.
Download the raw files rather than copying a displayed percentage. Preserve the file name, download date, exchange, security identifier, field definitions, and any adjustment setting. If you use another vendor for security-level total returns, verify exactly what its “adjusted” field includes and whether its five-year figure is a price return, total return, or CAGR.
Keep an evidence trail for every row
Each screened security should retain:
- Company name and exchange identifier.
- Symbol at the start date and current symbol, if different.
- Actual start and end trading dates.
- Starting and ending values.
- Whether the values are price-only or dividend-inclusive.
- Source file name and download date.
- Corporate-action and symbol-mapping notes.
- The calculation formula or spreadsheet cell references.
This evidence trail makes a surprising result auditable. It also prevents a later data refresh from quietly changing the universe or dates.
Reconcile splits, bonuses, rights issues and other corporate actions
Endpoint comparisons fail when the two prices are expressed on different share bases. Before calculating a return, check for:
Rank #3
- Stay Organized with Ease: Our To Do List Notepad provides multiple sections with plenty of space to jot down all of your important tasks.A versatile office supply perfect for daily task management, helping you keep track of everything that needs to be done and prioritize effectively.
- Achieve Your Productivity Goals: Begin each day on a positive note, reminding you of your potential, strength, and the significance of staying focused on your goals. Our Daily Checklist Notepad is the ultimate tool to streamline your daily planning and elevate your productivity. With a clear and concise overview of your tasks, you can effortlessly prioritize what truly matters and make consistent strides towards achieving your goals.
- Reliable and Stylish: Our to do list planner combines functionality with durability. With a transparent PP cover, the inner pages are well-protected from dirt and wear. Additionally, the back cover is crafted with thick paperboard, offering a stable surface for your writing needs. Each notepad includes 52 pages of high-quality, 100gsm paper, which is thick and non-bleeding, resulting in a smooth and enjoyable writing experience.
- Versatile Use: This daily checklist notepad, suitable for teacher supplies and a wide range of applications, proves invaluable in various settings including work, school, and home. Whether you need to organize your daily tasks, plan a project, or create a grocery list, this notepad serves as the ideal tool. Its compact size ensures easy portability, allowing you to conveniently carry it with you throughout your day.
- Perfect Present for Anyone: Our Daily To-Do List Notepad is the perfect present for those who value organization and productivity. With its stylish design and versatility, this office desk accessory is also a practical addition to school supplies. Suitable for students, professionals, and homemakers alike, it helps keep tasks and priorities in check effortlessly.
- Stock splits and bonus issues.
- Rights issues and other changes in the number of shares.
- Mergers, demergers, acquisitions, and scheme-of-arrangement events.
- Suspensions, relistings, and delistings.
- Symbol or company-name changes.
- Special dividends or distributions that may not be represented in an ordinary price field.
Never compare an unadjusted historical price with an adjusted current price. Use a consistently adjusted series, or reconstruct the adjustment using documented corporate-action terms. If a merger replaces one security with another, explain how the predecessor and successor are connected and whether the data series includes the economic value transferred to shareholders.
Windows 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 reinstallOutdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchOld/new symbol and company-name mappings are especially important when a search returns no history under the current ticker. A blank result may be a renamed company, not a newly listed one. If the record cannot be reconciled, exclude it from the calculated screen and mark the reason rather than assigning a zero return.
Calculate the screen in a spreadsheet or script
The calculation itself is simple; the controls around it are what make the result credible. A reproducible workflow is:
- Save the universe: export the eligible securities as of the chosen date and give the file a versioned name.
- Set the observation date: record it in one cell or configuration value.
- Derive the anniversary: calculate the date five years earlier using a calendar-year function, not an assumption that every year has 365 days.
- Select trading dates: map both target dates to the agreed nearest valid observations.
- Load adjusted values: retrieve price-only and, where available, dividend-inclusive values for the same security and dates.
- Calculate return: divide the ending value by the starting value and subtract one.
- Flag losses: set the flag to true only when the return is less than 0%; a value of exactly 0% is not negative.
- Sort: order flagged securities from the most negative return to the least negative.
- Attach diagnostics: add benchmark, sector, liquidity, risk, fundamental, and corporate-action fields before interpreting the result.
A language-neutral version is:
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 < 0In a spreadsheet, keep the date-selection rule explicit. A formula that simply looks up the nearest row can choose a date after the target for one security and before it for another if the data has gaps. Where a security has no observation near the start date, apply your minimum-history rule and report it as unavailable rather than shortening the window silently.
Benchmark every result against the same dates
A negative stock return can reflect a company-specific problem, a weak sector, or a broad market decline. Calculate the benchmark’s total return over the identical actual start and end dates. For a large-cap universe, Nifty 50 is a common reference; SEBI Investor describes it as representing the performance of the 50 largest and most frequently traded NSE companies. For a sector-focused universe, use the relevant sector index as well.
Free tools Windows power users keep installed
One-click scans. No signup required.
Keep two comparisons separate:
- Absolute result: whether the stock’s own five-year total return is below 0%.
- Relative result: how many percentage points the stock lagged or exceeded the benchmark over the same interval.
A stock can lose 8% while a benchmark loses 20%; it has a negative absolute return but positive relative performance. Conversely, a stock can gain 4% while its benchmark gains 35%; it is positive in isolation but a substantial relative laggard.
Add diagnostics before drawing a conclusion
The negative-return flag identifies what deserves investigation. It does not explain the decline or predict recovery. Add the following fields to the results file.
Rank #4
- 【Adjustable & Ergonomic】：This laptop stand can be adjusted to a comfortable height and angle according to your actual needs, letting you fix posture and reduce your neck fatigue, back pain and eye strain. Very comfortable for working in home, office and outdoor.
- 【Sturdy & Protective】 ：Made of sturdy metal, it can support up to 17.6 lbs (8kg) weight on top; With 2 rubber mats on the hook and anti-skid silicone pads on top & bottom, it can secure your laptop in place and maximum protect your device from scratches and sliding. Moreover, smooth edges will never hurt your hands.
- 【Heat Dissipation】 ：The top of the laptop stand is designed with multiple ventilation holes. The open design offers greater ventilation and more airflow to cool your laptop during operation other than it just lays flat on the table.
- 【Portable & Foldable】：The foldable design allows you to easily slip it in your backpack. Ideal for people who travel for business a lot.
- 【Broad Compatibility】：Our desktop book stand is compatible with all laptops from 10-15.6 inches, such as MacBook Air/ Pro, Google Pixelbook, Dell XPS, HP, ASUS, Lenovo ThinkPad, Acer, Chromebook and Microsoft Surface, etc.Be your ideal companion in Home, Office & Outdoor.
Liquidity and minimum history
Record average traded value or volume using a stated look-back period, the number of valid observations, and any periods of suspension. Thin trading can make a closing price stale and can make a nominal loss difficult to transact at. NSE index methodologies use liquidity eligibility and free-float market capitalization in index construction; those concepts are useful checks even when your screen is not an index.
Volatility and beta
Calculate or source return volatility over a stated frequency and period. Beta describes how a security’s returns moved relative to a market return; standard deviation describes the variability of the security’s own returns. A high beta or high standard deviation explains a rougher path, not whether the next five years will be better.
Profitability, leverage and earnings stability
Collect return on equity (ROE), debt-to-equity where applicable, and a measure of earnings-per-share growth variability. NSE’s quality-index methodology uses ROE, debt-to-equity where applicable, and EPS-growth variability over the previous five years. Record the reporting periods and accounting basis so figures from different companies are not treated as directly interchangeable.
Corporate and governance events
Review company filings for promoter or ownership changes, share pledging, auditor qualifications, business-line changes, major fund-raising, related-party events, and restructuring. A price decline may reflect a one-time event, a lasting impairment, or a business that has changed so much that the earlier five-year comparison is no longer economically comparable.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Interpret the screen with a comparison matrix
| Screen field | What to record | How it changes interpretation |
|---|---|---|
| Total return | Dividend-inclusive return, actual start and end dates | Answers whether an investor-like holding-period value fell below zero. |
| Price return | Price-only return in a separate column | Shows the quoted-price change but excludes cash distributions. |
| Benchmark total return | Broad or sector benchmark over identical dates | Separates market or sector weakness from company-specific underperformance. |
| Liquidity | Volume or traded value, look-back period, suspensions | Indicates whether the quoted result may be difficult or costly to trade. |
| Volatility and beta | Method, frequency, and observation window | Describes risk and path variability; it is not a recovery forecast. |
| Leverage and profitability | Debt-to-equity, ROE, and reporting period | Provides business-quality context for the loss. |
| Earnings stability | EPS-growth variability and the five-year period analyzed | Shows whether weak returns coincided with unstable results. |
| Corporate-action notes | Splits, rights, mergers, symbols, pledging, auditor matters | Tests whether the endpoints are comparable and identifies possible causes. |
Read common result patterns correctly
Stock negative, benchmark positive
This is the clearest relative warning: the company destroyed value while the chosen market or sector reference gained. Investigate earnings, balance-sheet stress, governance, dilution, competitive position, and corporate actions before making any decision.
Stock negative, benchmark also negative
The loss may be partly market-wide or sector-wide. Compare the stock’s loss with the benchmark’s loss and then examine beta and volatility. A company can still be a severe relative underperformer during a broad sell-off.
Do these 3 things before closing this tab:
1Fix the driver behind crashes, sound loss and screen glitches2Repair Windows errors before they cause bigger problems3Scan for outdated or missing drivers - takes under a minuteStock positive, benchmark much stronger
This stock should not appear in the negative-return list, but it may still merit a relative-underperformance review. Keep this analysis separate from the below-zero screen so the two questions are not conflated.
Best Value
- Twin-Ball Design : Hiacry gel pen features a double ball conical tip that reduces writing resistance and provides a stable and smooth writing experience. 0.7mm quick drying black ink ensures no jumping, leakage or seepage.
- Quick-Dry Long Lasting Ink：0.7mm black ink can slide effortlessly, dry immediately, & is not easily dirty. It has a high-capacity reservoir (up to 1300 meters), which is very suitable for left-handed & right-handed users.
- Sleek Design for Journaling & Planning: Engineered with a low center of gravity and precision tip for steady ink flow, these journaling pens excel at note-taking, sketching, planning, and more. They combine stylish pens with top-tier performance.
- Rolling Ball Design：The pocket clip with roll ball design can be easily attached to notebook pockets and binders, in addition, the fidget on the pen clip is also a small toy for your daily thinking to relieve stress.
- Comfortable Non-Slip Grip：The ergonomic pen barrel has a soft rubberized coating for a comfortable, non-slip grip, so you won't get fatigued even after long hours of writing.
Large loss with weak liquidity
Check whether sparse trading, stale prices, or long suspensions distort the apparent endpoint. Confirm trades and corporate actions before treating the percentage as economically realizable.
Common screening errors and fixes
- Using today’s list to make a five-year historical claim: label it current-universe, or obtain point-in-time membership and include delisted names where appropriate.
- Calling a price return a total return: use a dividend-inclusive series or label the output price return.
- Mixing dates: use one documented trading-day convention for every security and benchmark.
- Ignoring splits or bonuses: reconcile the share basis before comparing endpoints.
- Missing renamed securities: use old/new symbol and company-name mappings.
- Treating a vendor percentage as self-explanatory: verify whether it is price return, total return, or CAGR.
- Assigning zero to missing data: mark the observation unavailable and explain why it failed the history rule.
- Ranking without a benchmark: report both absolute loss and relative underperformance.
- Interpreting a flag as a sell signal: investigate the business and portfolio context; a historical loss does not guarantee further decline or recovery.
How to publish or share the results responsibly
State the screen’s as-of date, exchange, security type, universe rule, minimum history, date convention, return definition, and data source directly above the results. Keep price return and total return in separate columns. Sort by the total return from most negative to least negative, but retain the benchmark and sector comparisons beside each row.
For every flagged security, preserve the actual start and end dates and a concise explanation of unresolved issues. If a comparable value is not established, write “not stated” and identify the source or reason; never fill the cell with an estimate. A reader should be able to download the same raw observations, apply the same adjustment notes, and reproduce the same flag.
What the screen can—and cannot—tell you
The screen can identify securities whose defined five-year holding-period value fell below zero and can show whether they lagged a relevant benchmark. It can also organize the next research questions: Was the loss caused by the sector, the market, leverage, unstable earnings, poor liquidity, dilution, a corporate action, or a business-model change?
It cannot establish that a stock is cheap, that a turnaround is likely, or that a future five-year return will be negative. Historical screening is a filtering step. Investment decisions require current financial statements, valuation, liquidity, portfolio concentration, tax considerations, and a risk assessment beyond the endpoint calculation.
Why there is no single official count of losing Indian stocks
As of 16 October 2026, no official source publishes one portfolio-wide count of Indian stocks with negative five-year returns. Such a number depends on the chosen exchange, point-in-time universe, listing-history rule, observation date, treatment of dividends, and corporate-action adjustments. A defensible count must be calculated from security-level data under stated rules; it should not be quoted as a universal market statistic.
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.
