Futures open interest up more than 3% on a day price rose over 1%. New longs being opened.
from fno where fut_oi_change_pct > 3 and change > 1
Top 500 by turnover
F&O derivatives scanners for NSE
Price tells you what happened. Open interest tells you who is committed to it. Every futures contract is a long and a short who both posted margin, so the direction OI moves alongside price sorts each session into one of four states: long buildup, short buildup, short covering, long unwinding. The four scans at the top of this page are that grid. Around them sit the other positioning reads. The basis is the leveraged market's opinion of the cash price, quoted as a premium or a discount. The put-call ratio marks crowding at its extremes. Futures volume against its own norm is the volume shocker, read from the derivatives desk. Two limits worth stating. Only the roughly 200 stocks with listed futures carry any of this data, which is what `from fno` in each query means, and open interest is counted in contracts summed across expiries because that is the unit NSE publishes. Expiry week bends every number here: OI falls mechanically as contracts settle, and the basis converges to zero by construction.
Open interest up more than 3% into a falling price. Fresh shorts being written.
from fno where fut_oi_change_pct > 3 and change < -1
Top 500 by turnover
Price up while open interest drains away. Shorts buying themselves out.
from fno where fut_oi_change_pct < -3 and change > 1
Top 500 by turnover
Open interest down more than 2% on a softer price. A trend losing its sponsors.
from fno where fut_oi_change_pct < -2 and change < -0.5
Top 500 by turnover
More futures contracts open than on any day in three months.
from fno where fut_oi is highest in 3mo
Top 500 by turnover
The front-month future paying more than half a percent over cash, in a stock above its 50-day average.
from fno where fut_basis_pct > 0.5 and close > sma(50)
Top 500 by turnover
The front-month future trading at least 0.2% under cash. Hedging pressure, or supply the market expects.
from fno where fut_basis_pct < -0.2
Top 500 by turnover
Put-call open interest ratio above 0.8 in a stock above its 50-day. Put writers are paid to defend the strikes below.
from fno where pcr_oi > 0.8 and close > sma(50)
Top 500 by turnover
Put-call open interest ratio under 0.4. Optimism crowded enough to be worth distrusting.
from fno where pcr_oi < 0.4
Top 500 by turnover
Futures volume at 1.5 times its own 20-day average.
from fno where fut_volume > 1.5x avg(fut_volume, 20)
Top 500 by turnover
Put volume above 0.7 times call volume on the session.
from fno where pcr_vol > 0.7
Top 500 by turnover
Common questions
What is a long buildup?
Rising price with rising futures open interest. New contracts are being opened while price advances, so fresh money is committing to the upside. Compare short covering, where price rises because existing shorts are buying back and OI falls.
What does the put-call ratio tell you?
How the option book is positioned. A high PCR means put open interest rivals calls, often put writers collecting premium who then defend the strikes below. A very low PCR means the book is almost all calls, which is crowded optimism with little hedging underneath. Extremes on either side are conditions to notice.
Why is open interest in contracts rather than shares?
Because contracts are what NSE publishes, before and after a lot-size revision. Converting to shares needs the historical lot size of every contract, and that is not knowable for the older data. So the unit here is the exchange's own, and comparisons are made against a stock's own history, where the unit cancels out.