Every day, the NEPSE index gives you one number — up or down. But behind that single number are thousands of individual trades, each one showing exactly which broker bought, which broker sold, how much, and at what price. That record is the floorsheet — and it's one of the most underused tools available to ordinary NEPSE investors, mostly because it looks like a wall of numbers the first time you open it.
This guide breaks the floorsheet down piece by piece: what each column actually means, how to read broker behavior, and how to use it to spot accumulation, distribution, and manipulation — without needing any special software.
1. What a Floorsheet Actually Contains
Open any floorsheet (NEPSE's own site publish it) and you'll see rows like this for a single stock:
| Column | What It Means |
|---|---|
| Contract No. | Unique ID for that specific trade — used for tracing/auditing, not analysis |
| Symbol | The stock ticker, e.g. NABIL, UPPER, SAHAS |
| Buyer Broker | Numeric code of the brokerage that executed the buy order |
| Seller Broker | Numeric code of the brokerage that executed the sell order |
| Quantity | Number of shares transacted in that trade |
| Rate | Price per share for that specific trade |
| Amount | Quantity × Rate — the rupee value of that trade |
That's it structurally — seven fields, repeated thousands of times per day across every traded stock. The skill isn't memorizing the columns. It's learning to read the pattern across many rows.
2. Why Broker Numbers Matter More Than They Look
Every licensed brokerage on NEPSE has a fixed numeric code — Broker 19, Broker 34, Broker 58, and so on. This is the single most powerful piece of information on the floorsheet, because broker activity often reveals who is moving a stock, even though you never see the actual investor's name.
๐ฆ Single broker dominates buying
One broker code shows up repeatedly on the buy side of a stock across many trades. Often interpreted as accumulation — someone (institutional or large retail) is steadily building a position.
๐ค Single broker dominates selling
The reverse pattern — one broker consistently on the sell side suggests distribution, i.e., a large holder unwinding a position.
๐ Same broker, both sides
A broker appearing as both buyer and seller in the same stock repeatedly can indicate circular trading — worth extra scrutiny, especially in thinly traded stocks.
๐ Broad broker spread
Many different brokers on both sides, no concentration. Usually indicates organic retail-driven trading rather than any single large player moving the stock.
3. Reading Price and Volume Together
The floorsheet shows you the actual rate of every individual trade — not just the day's closing price. This lets you see exactly how a stock moved minute-by-minute through the session, which tells a very different story than the single closing number reported in news headlines.
| Pattern | What It Usually Signals |
|---|---|
| Price rising + volume rising | Strong buying pressure; the move has real conviction |
| Price rising + volume falling | Buying pressure weakening; rally may be running out of steam |
| Price falling + volume rising | Strong selling pressure; decline likely to continue |
| Price falling + volume falling | Sellers losing interest; the drop may be temporary |
Worked Example
Imagine the floorsheet for a hypothetical stock "XYZ" shows 40 trades through the day. Broker 17 appears as the buyer in 28 of them, prices climb steadily from Rs. 480 to Rs. 512, and total volume is well above the stock's recent daily average. Read together: one broker is accumulating aggressively, the price is responding positively, and volume confirms genuine demand rather than a single outlier trade. That's a textbook accumulation pattern — though whether it's a good buying opportunity still depends on the company's actual fundamentals.
4. Turnover and Liquidity: What the Totals Tell You
At the bottom of every floorsheet page, you'll see aggregate totals — total quantity traded, total turnover amount, and the average rate for the day. These numbers matter beyond any single stock:
- High turnover stocks are liquid — you can enter and exit positions without drastically moving the price yourself.
- Low turnover stocks are illiquid — even a moderate-sized order can swing the price significantly, and exiting a large position may take several sessions.
- Sudden turnover spikes with no news are a yellow flag — investigate before assuming it's organic interest.
5. Practical Use Cases by Investor Type
⚡ Short-Term Traders
Use floorsheet data to spot momentum and volume breakouts intraday or session-to-session, confirming whether a price move has real backing.
๐ Long-Term Investors
Use floorsheets to confirm whether accumulation is happening in a fundamentally undervalued stock before committing capital.
๐ก️ Risk Managers
Use broker concentration data to avoid entering positions in stocks that show signs of coordinated or manipulated trading.
6. Red Flags to Watch For
7. Common Mistakes Beginners Make
- Only checking top gainers/losers — this misses the detailed flow of who is actually driving the move.
- Ignoring broker codes entirely — overlooking the most information-dense column on the entire sheet.
- Focusing on price alone — volume and turnover are equally important context.
- Chasing floorsheet hype without fundamentals — buying a stock purely because activity looks exciting, without checking whether the underlying business justifies it.
- Treating one day's data as the full picture — broker patterns are far more meaningful when tracked across several sessions, not a single snapshot.
8. Where to Access Floorsheet Data
| Source | What It Offers |
|---|---|
| NEPSE Official Website | The authoritative, raw daily floorsheet — published after market close |
| Sharesansar / Merolagani | Searchable, filterable floorsheet by stock, broker, or date with running totals |
| NepseAlpha / Nepalytix | Visual dashboards, broker concentration summaries, and multi-day broker tracking tools |
Frequently Asked Questions
Where can I find NEPSE's daily floorsheet?
NEPSE publishes the official floorsheet on its own website after each trading session. Third-party platforms like Sharesansar, Merolagani, and NepseAlpha also republish it in more searchable, filterable formats with buyer/seller broker filters built in.
What does it mean if one broker dominates buying in a stock?
It can indicate accumulation by a single institutional or large investor, but it can also indicate coordinated trading. Concentration alone is not proof of manipulation — it's a signal to investigate further, not a conclusion on its own.
Is floorsheet data available in real time during the trading session?
Some third-party platforms offer live or near-live floorsheet feeds during market hours, but the official NEPSE floorsheet is published as a complete record after the session closes.
Can floorsheet analysis alone tell me whether to buy a stock?
No. Floorsheet data shows trading activity and broker behavior, not company fundamentals. It works best as a secondary confirmation tool alongside fundamental analysis (earnings, book value, sector outlook), not as a standalone buy or sell signal.
Final Thoughts
The floorsheet is NEPSE's most transparent — and most underused — data source. It won't tell you whether a company is a good investment, but it will tell you exactly who is trading a stock, how aggressively, and whether the price move behind it has real conviction. Combine it with fundamentals, not as a replacement for them, and it becomes one of the sharpest edges a retail investor in Nepal can build.
This article is for educational purposes only and is not investment advice. Floorsheet patterns described here are illustrative; always verify live data on NEPSE's official site before making any trading decision.
Discussion