QuantsappFaster in the app: live data, alerts, tradingOpen
Log inStart free

FII DII Data · 28 Dec 2017

What foreign (FII) and domestic (DII) institutions bought and sold in the cash market, and how FIIs, DIIs, pros and clients are positioned in futures and options, from NSE’s end-of-day data.

← Previous sessionLatest →
FII net · cash market₹+563 Crnet buyers · bought 5,486, sold 4,923
DII net · cash market₹−774 Crnet sellers · bought 5,562, sold 6,336
FII index futures61,088net long · change +38,574
FII index options2.24 Lnet long · change −1.16 L
Last 5 sessions₹+415 CrFII net · DII +1,510 Cr
NIFTY close10,489.80−0.10% on the day

On 28 Dec 2017, FIIs were net buyers of ₹563 crore in the cash market and DIIs net sellers of ₹774 crore. In index futures FIIs are net long 61,088 contracts, adding 38,574 on the day. NIFTY closed at 10,489.80 (−0.10%).

FII vs DII net flows, last 30 sessions

FII DII · ₹ crore
+1,5740−1,57416 Nov 2017: FII −447 Cr, DII +847 Cr17 Nov 2017: FII +1,277 Cr, DII +1,467 Cr20 Nov 2017: FII −359 Cr, DII +613 Cr21 Nov 2017: FII −727 Cr, DII +826 Cr22 Nov 2017: FII −442 Cr, DII +837 Cr23 Nov 2017: FII +73.2 Cr, DII +222 Cr24 Nov 2017: FII −416 Cr, DII +428 Cr27 Nov 2017: FII −425 Cr, DII +69.4 Cr28 Nov 2017: FII +12.2 Cr, DII −428 Cr29 Nov 2017: FII −859 Cr, DII +771 Cr30 Nov 2017: FII −1,501 Cr, DII +1,203 Cr1 Dec 2017: FII +306 Cr, DII +176 Cr4 Dec 2017: FII −334 Cr, DII +776 Cr5 Dec 2017: FII −1,471 Cr, DII +1,074 Cr6 Dec 2017: FII −1,218 Cr, DII +995 Cr7 Dec 2017: FII −1,076 Cr, DII +927 Cr8 Dec 2017: FII −675 Cr, DII +1,243 Cr11 Dec 2017: FII −186 Cr, DII +109 Cr12 Dec 2017: FII +843 Cr, DII −854 Cr13 Dec 2017: FII −579 Cr, DII −117 Cr14 Dec 2017: FII +232 Cr, DII −374 Cr15 Dec 2017: FII −921 Cr, DII +635 Cr18 Dec 2017: FII −432 Cr, DII +1,077 Cr19 Dec 2017: FII −408 Cr, DII +357 Cr20 Dec 2017: FII −1,505 Cr, DII +146 Cr21 Dec 2017: FII −384 Cr, DII +1,574 Cr22 Dec 2017: FII +108 Cr, DII +372 Cr26 Dec 2017: FII −44.1 Cr, DII +545 Cr27 Dec 2017: FII +172 Cr, DII −207 Cr28 Dec 2017: FII +563 Cr, DII −774 Cr16 Nov28 Dec

FII & DII cash market activity

Gross purchase, gross sales and net value in ₹ crore, provisional, by trading day. NIFTY close and change for context.
FII / FPIDII
DateBuySellNetBuySellNetNIFTY
28 Dec 20175,4864,923+5635,5626,336−77410,489.80 −0.10%
27 Dec 20172,8262,654+1723,0603,267−20710,500.20 −0.24%
26 Dec 20172,0292,073−44.14,4873,943+54510,525.95 +0.20%
22 Dec 20173,6543,546+1083,7833,412+37210,505.45 +0.41%
21 Dec 20174,7535,137−3844,7313,157+1,57410,462.45 −0.07%
20 Dec 20174,7776,282−1,5054,3894,242+14610,470.15 −0.01%
19 Dec 20175,6386,046−4084,2983,941+35710,470.95 +0.64%
18 Dec 20174,2974,729−4324,1003,023+1,07710,404.35 +0.43%
15 Dec 20179,25110,172−9214,8134,177+63510,359.50 +0.81%
14 Dec 20174,9764,744+2323,5353,909−37410,276.10 +0.60%
13 Dec 20175,3365,914−5793,4943,610−11710,215.20 −0.48%
12 Dec 20176,8896,046+8432,6343,487−85410,264.50 −0.79%
11 Dec 20174,8815,067−1863,0982,989+10910,346.40 +0.53%
8 Dec 20176,1246,799−6754,4273,184+1,24310,291.65 +0.87%
7 Dec 20174,4835,559−1,0763,8502,924+92710,202.95 +1.33%
6 Dec 20174,8196,037−1,2183,4162,421+99510,068.65 −0.77%
5 Dec 20173,7285,199−1,4713,3132,238+1,07410,146.70 −0.12%
4 Dec 20173,9894,322−3343,2072,431+77610,159.25 +0.05%
1 Dec 20174,5654,259+3062,3352,159+17610,154.25 −0.76%
30 Nov 201715,96417,465−1,5017,3976,195+1,20310,231.65 −1.25%
29 Nov 20174,6605,520−8593,8063,034+77110,360.70 −0.16%
28 Nov 20174,4394,427+12.23,8904,318−42810,377.55 −0.39%
27 Nov 20174,0884,513−4252,9032,833+69.410,418.50 +0.09%
24 Nov 20174,3274,744−4163,3902,962+42810,409.35 +0.41%
23 Nov 20174,3964,323+73.23,1022,879+22210,366.65 +0.08%
22 Nov 20174,7185,159−4423,4392,602+83710,357.95 +0.06%
21 Nov 20175,9966,723−7274,0733,248+82610,351.90 +0.31%
20 Nov 20174,6995,058−3592,8582,245+61310,320.05 +0.11%
17 Nov 20176,7165,439+1,2774,3782,911+1,46710,308.85 +0.57%
16 Nov 20174,5524,999−4473,1812,334+84710,250.90 +0.95%
15 Nov 20175,2955,676−3813,8953,026+86910,154.35 −0.77%
14 Nov 20178,0525,475+2,5773,2123,213−1.310,233.60 −0.35%
13 Nov 20174,6214,854−2343,6593,928−26910,269.40 −0.63%

Participant-wise open interest (F&O)

Net long-short contracts, total open interest and the change on the day, by participant and segment. Net value is the FII’s net traded value in ₹ crore. Tap a row with an arrow for the index-wise split.

ParticipantSegmentLong − shortChangeTotal OIChangeNet value (Cr)
FII61,088+38,5741.55 L−74,036₹+1,621
NIFTY–––––
BANKNIFTY–––––
MIDCPNIFTY–––––
FINNIFTY–––––
NIFTYNXT50–––––
NIFTYFPI–––––
Stock Futures−1.51 L−3,0988.88 L−1.53 L₹−1,476
2.24 L−1.16 L5.57 L−7.25 L₹−458
Call Options88,219+5,1622.28 L−2.54 L–
Put Options1.35 L−1.21 L3.29 L−4.71 L–
NIFTY–––––
BANKNIFTY–––––
MIDCPNIFTY–––––
FINNIFTY–––––
NIFTYNXT50–––––
NIFTYFPI–––––
−141+4,1651,285−80,573₹+234
Call Options−61+4,052683−43,166–
Put Options−80+113602−37,407–
Cash Market––––₹+563
ProIndex Futures−24,180−13,04961,536−129–
Stock Futures78,866−1,3872.05 L−83,723–
−20,822+2.92 L5.80 L−4.23 L–
Call Options−4,815+1.45 L2.78 L−1.86 L–
Put Options−16,007+1.47 L3.02 L−2.37 L–
−8,744+53,94979,870−2.16 L–
Call Options−18,043+39,60448,057−1.33 L–
Put Options9,299+14,34531,813−82,861–
ClientIndex Futures−37,270−29,0934.07 L−66,021–
Stock Futures8.09 L−10,17614.29 L−1.74 L–
−3.38 L−1.11 L18.61 L−13.38 L–
Call Options−1.42 L−96,7777.17 L−5.42 L–
Put Options−1.96 L−13,75211.44 L−7.96 L–
8,885−58,1142.19 L−5.21 L–
Call Options18,104−43,6561.45 L−3.38 L–
Put Options−9,219−14,45873,811−1.83 L–
DIIIndex Futures362+3,56856,868−7,158–
Stock Futures−7.37 L+14,6617.87 L−56,209–
1.35 L−65,3451.35 L−65,345–
Call Options58,627−53,71858,627−53,718–
Put Options76,648−11,62776,648−11,627–
0000–
Call Options0000–
Put Options0000–
Cash Market––––₹−774

Source: NSE participant-wise open interest and FII statistics, end of day 28 Dec 2017. Contracts in lakh (L).

Monthly FII & DII flows

MonthFII netDII netNIFTY
Nov 2026+79,303−48,388+8.97%
Oct 2026−45,162+62,220+1.72%
Sep 2026−44,013+76,030−6.37%
Aug 2026−7,533+58,269−0.82%
Jul 2026−5,780+35,099+2.48%
Jun 2026−49,028+85,798+0.48%
May 2026−55,963+82,668−1.45%
Apr 2026−70,135+51,064+7.97%
Mar 2026−1,22,540+1,42,960−11.92%
Feb 2026−6,641+38,423−0.31%
Jan 2026−41,435+69,221−3.35%
Dec 2025−34,350+79,620−0.35%
Nov 2025−17,500+77,084+1.86%
Oct 2025−2,347+52,794+5.26%
Sep 2025−35,301+65,344+0.18%
Aug 2025−46,903+94,829−0.82%
Jul 2025−47,667+60,939−3.29%
Jun 2025+7,489+72,674+2.99%
May 2025+11,773+67,642+1.85%
Apr 2025+2,735+28,228+2.75%
Mar 2025+2,014+37,586+6.67%
Feb 2025−58,988+64,853−5.67%
Jan 2025−87,375+86,592−0.78%
Dec 2024−16,983+34,195−2.05%

Yearly FII & DII flows since 2007

YearFII netDII netNIFTY
2026−3,68,927+6,53,364−4.28%
2025−3,06,419+7,88,184+10.46%
2024−3,02,435+5,26,545+8.77%
2023−21,692+1,85,610+20.21%
2022−2,77,868+2,76,555+4.58%
2021−91,626+94,846+24.47%
2020+65,246−35,663+14.21%
2019+39,881+42,257+12.18%
2018−73,212+1,09,662+3.41%
2017 (so far)−44,109+90,738+28.94%
2016−10,582+35,363+3.10%
2015−20,374+67,587−4.75%
2014+67,423−28,557+31.21%
2013+73,040−62,181+6.77%
2012+96,303−53,092+28.43%
2011−34,580+29,802−24.80%
2010+44,053−16,282+18.46%
2009+24,820+26,106+75.43%
2008−1,01,215+72,570−51.88%
2007−351+24,327+55.32%

Unlock 30+ free options tools

Long and short positions of FII, DII, Pro and Client over time, index-wise FII activity, net value and volume - next to open interest, the option chain, max pain and the strategy builder. One free account, no payment.

Used by 17 lakh+ traders · Real-time NSE & BSE · No payment required

Create free account
  • Max pain / option pain
  • Option chain + Greeks
  • Open interest analysis
  • Multi-strike OI chart
  • PCR & Modified PCR
  • Strategy builder
  • FII / DII data
  • IV analysis
  • Futures OI
  • OI buildup
  • Trade with 16 brokers
  • Alerts & triggers
See the Quantsapp terminal in action · free to watch, no sign-up needed

How to read FII DII data

Cash market. Each day FIIs (foreign portfolio investors) and DIIs (mutual funds, insurers, banks and pension funds) report what they bought and sold on the exchanges. The net value is purchases minus sales. Persistent FII selling tends to pressure large caps and the rupee; DII buying, fed by SIP flows, has often absorbed it - which is why the two lines above frequently mirror each other.

Futures and options. NSE also publishes every participant’s long and short open interest. The FII net position in index futures is the most watched number: a large net short signals a bearish or hedged stance, and a sharp change in it shows new bets being placed or old ones covered. Because Pro and Client are the other side of the same contracts, retail clients are often positioned opposite to FIIs.

Learn it on video

Browse the video library →

Frequently asked questions

What is FII DII data?

It is the daily record of what foreign institutional investors (FIIs, also called FPIs) and domestic institutional investors (DIIs: mutual funds, insurers, banks) bought and sold. In the cash market it is published as gross purchase, gross sales and the net value in ₹ crore; in futures and options, NSE publishes each participant’s long and short open interest.

What does FII net buy or net sell mean?

Net value is purchases minus sales. A positive number means FIIs bought more than they sold that day (net buyers); a negative number means they sold more (net sellers). Heavy, sustained FII selling often weighs on the index, while DII buying frequently absorbs it.

What was the FII DII data on 28 Dec 2017?

FIIs bought ₹5,486 crore and sold ₹4,923 crore, a net +563 crore. DIIs bought ₹5,562 crore and sold ₹6,336 crore, a net −774 crore. NIFTY closed at 10,489.80.

What is long-short open interest in participant data?

For each participant, NSE reports how many futures and options contracts they hold long and short. Long minus short is the net position: a negative index-futures number means FIIs hold more short contracts than long, which traders read as a bearish stance. The change shows what was added or cut that day.

Who are Pro and Client in participant-wise OI?

Pro is proprietary trading: brokers and members trading with their own money. Client is everyone trading through a broker, mostly retail. Together with FII and DII they add up to the whole market, so one side’s long is another side’s short.

When is FII DII data updated?

Once a day after the close. Provisional cash-market figures come out in the evening, and NSE’s participant-wise open interest follows after the F&O session. This page shows the latest trading day as soon as it is published, and any earlier day from the date picker.

Cash-market figures are provisional as published after the close. Data is for information only and is not investment advice. Derivatives trading carries substantial risk. Disclaimer

Log in or sign up

Enter your mobile number. New to Quantsapp? The same OTP creates your free account.

+91

Have a password?

By continuing you agree to the Terms of Use and Privacy Policy.