How to read the NEPSE floorsheet (and why it matters).

What the floorsheet is

The NEPSE floorsheet is the official record of every individual trade executed on the exchange during a trading day. Each row contains:

• Symbol: the stock that traded.
• Buyer broker: the broker code that bought.
• Seller broker: the broker code that sold.
• Quantity: number of shares in this single execution.
• Rate / Price: the per-share price the trade executed at.

A busy NEPSE trading day produces thousands of these rows across all listed securities. NEPSE publishes the floorsheet on its official portal page by page, which makes reading a full day by hand impractical.

Why brokers matter

Every NEPSE trade is matched between two licensed brokers. A small number of brokers tend to dominate volume on a given stock on a given day. When the same broker is the buyer on most large trades in a stock, it may be working for one large client or for many smaller ones; the floorsheet shows the broker, not the client. None of this is visible in the daily price chart, and none of it says which way the price will go next.

Three ways to read the floorsheet

1. By stock

Pick a symbol and aggregate the day's floorsheet rows for that symbol. Sum buy quantity and sell quantity by broker. Sort by net flow. The top of the list tells you which brokers were the day's biggest net buyers; the bottom shows the net sellers. If the top broker is, say, +50,000 shares net on a 200,000-share day, one client through one broker drove 25% of the day's volume on the buy side.

2. By broker

Pick a broker and look at every stock they traded across the day. Brokers that specialise, say, mostly trade hydropower, are easy to spot. Brokers that are unusually active in a single stock today versus yesterday stand out. A broker leaderboard sorted by total daily turnover surfaces who's moving the most capital across the exchange.

3. Big-block trades

Sort the day's floorsheet by quantity descending. The biggest single executions, say, any row with a quantity that's 5 to 10x the median trade size for that stock, are often a large investor, though not always. Clusters stand out too: three 5,000-share blocks through the same buyer broker within a few minutes may be one client building a position in pieces, or several unrelated orders. The floorsheet cannot tell you which.

Limits of floorsheet analysis

The floorsheet is not omniscient. A few caveats:

• Broker codes don't reveal client identities. You see that a broker bought, not who the broker bought for. A broker may be working a single large client or hundreds of retail orders bundled together.
• Bilateral floor-trades and odd lots can distort the read. Most platforms exclude obvious special-case trades before computing broker pressure.
• Yesterday's broker is not necessarily today's broker. A single day of strong accumulation can be unwound the next day. Floorsheet analysis is most useful across a window (a week, a month) not a single day.

How Punji handles the floorsheet

Punji's app ingests the entire daily floorsheet and pre-computes three roll-ups: per-stock summaries (broker activity for a single symbol), per-broker summaries (a single broker's day across every stock), and a broker × stock cross-tab. During market hours a live sample of the partial day's trades is shown with a banner indicating data is provisional; off-hours, Punji shows the final settled floorsheet for the latest closed business day. Today's top brokers and the day's biggest broker positions by company are two one-tap views, and any company's broker activity can be read over a day, a week, a month and up to a year. On the web, the NEPSE floorsheet page shows the last 30 days of broker buying and selling for every company, and each stock page, such as NABIL, carries its own broker tables.

Read the NEPSE basics guide if you're new to the market, or the CGT guide for the tax math on any sale.