πŸ“–

FPI/FII Dashboard Insights

Practical guides to understanding foreign portfolio investment data β€” what it means, how to read it, and how to use it in your investment research.

Advertisement

What Is FPI Data and Why Every Indian Investor Should Track It

Foreign portfolio investors move billions of rupees in and out of Indian markets every fortnight. Understanding their behaviour can give retail investors a meaningful edge.

AUC vs Net Investment β€” Two Numbers That Tell Very Different Stories

Most investors only look at net inflow or outflow. But Assets Under Custody tells you something far more important β€” the long-term conviction of foreign money in a sector.

How to Spot Sector Rotation Using FPI Fortnightly Data

Foreign investors do not move uniformly β€” they rotate capital between sectors based on global and domestic macro signals. Here is how to catch that rotation early.

The Heat Map Advantage β€” Reading FPI Sentiment at a Glance

A heat map condenses 20+ sectors into one view. Once you understand what the colours are telling you, it becomes one of the fastest research tools available.

Using FPI Trend Data Alongside Price Action β€” A Practical Framework

FPI data alone does not tell you when to buy or sell. But combined with price action and market breadth, it can significantly improve your timing and conviction.

Advertisement
Beginner Β· FPI Basics

What Is FPI Data and Why Every Indian Investor Should Track It

5 min read Β· January 2025

Who Are FPIs?

Foreign Portfolio Investors (FPIs) β€” also commonly called Foreign Institutional Investors (FIIs) β€” are entities registered outside India that invest in Indian financial markets. They include large global asset managers, hedge funds, sovereign wealth funds, pension funds, and insurance companies from across the world.

Unlike Foreign Direct Investment (FDI), which involves long-term stakes in businesses, FPI is more fluid. FPIs buy and sell listed securities β€” primarily stocks β€” based on their view of India's economic prospects, currency movements, global risk appetite, and sector-specific opportunities.

Why Does FPI Data Matter?

FPIs collectively hold a significant portion of Indian equity markets. When they buy, they bring in foreign capital, strengthen the rupee, and often drive markets upward. When they sell, the reverse happens β€” markets fall and the rupee weakens.

Tracking FPI activity gives you visibility into what some of the world's most sophisticated institutional investors think about India and specific sectors. This information is not a guarantee of future returns, but it is a powerful context signal.

Key insight: When FPI outflows persist across multiple fortnightly periods, it rarely means India is broken β€” it often reflects global factors like US interest rate expectations, dollar strength, or risk-off sentiment. Understanding the context matters as much as the numbers.

What the Fortnightly Reports Cover

FPI investment data for Indian equities is published in fortnightly cycles β€” once around the 15th of each month and once at month-end. Each report covers all major equity sectors and provides three key data points per sector:

  • Gross Purchase β€” total value of equity bought by FPIs in that fortnight
  • Gross Sales β€” total value of equity sold by FPIs in that fortnight
  • Net Investment β€” gross purchase minus gross sales (positive = net buying, negative = net selling)
  • Assets Under Custody (AUC) β€” the total market value of all FPI equity holdings in that sector at the end of the period

How to Start Using This Dashboard

The best starting point is the FPI Sector Dashboard. Select the most recent period from the date picker and look at the Net Investment bar chart β€” this gives you an instant read on which sectors FPIs favoured and which they avoided in that fortnight.

Then check the Heat Map tab for a colour-coded view of the same data. Click any sector tile to jump straight into that sector's historical trend β€” this is where the real insights emerge over time.

Finally, check the FPI Consolidated page for the macro picture β€” total net investment across all sectors combined, and total AUC, both plotted over time. This tells you whether India as a whole is in a phase of FPI accumulation or distribution.

Remember: FPI data is a lagging indicator β€” it tells you what happened in the past fortnight, not what will happen tomorrow. Use it as one input alongside fundamentals, price action, and broader market context.
Intermediate Β· AUC Explained

AUC vs Net Investment β€” Two Numbers That Tell Very Different Stories

6 min read Β· January 2025

The Difference Most Investors Miss

When people discuss FPI data, they almost always focus on net investment β€” the inflow or outflow number for a given period. But this tells you only half the story. The number that reveals long-term conviction is Assets Under Custody (AUC).

Net investment is a flow β€” what changed this fortnight. AUC is a stock β€” the total accumulated position. Understanding the relationship between these two is one of the most useful skills in reading FPI data.

What AUC Actually Measures

AUC is the total market value of all equity holdings that FPIs have custodied in a particular sector at the end of a period. It is not just what they bought this month β€” it is everything they hold, accumulated over years of investment.

Because it reflects market value, AUC can change even without any buying or selling. If a sector rallies 10%, the AUC in that sector rises by roughly 10% even if FPIs did not trade at all. Conversely, a market correction reduces AUC even without any outflows.

Example: Imagine FPIs show a net outflow of β‚Ή2,000 Cr from the IT sector in a fortnight, but the AUC in IT is still β‚Ή8,00,000 Cr and rising. This suggests the selling was minor relative to the overall position β€” possibly just rebalancing, not a structural exit.

Four Combinations to Watch

The most useful way to use AUC and net investment together is to look at which of these four scenarios applies to a sector:

  • Net inflow + Rising AUC β€” Strongest signal. FPIs are actively buying and market appreciation is compounding their position. Classic accumulation.
  • Net outflow + Rising AUC β€” Mixed signal. FPIs are booking some profits but market appreciation is more than offsetting the selling. Position is still growing despite outflows.
  • Net inflow + Falling AUC β€” Caution. FPIs are trying to buy a falling sector. Could be contrarian conviction or catching a falling knife β€” check the trend duration.
  • Net outflow + Falling AUC β€” Weakest signal. Active selling combined with market depreciation. FPI position is shrinking rapidly. Structural exit in progress.

How to Use This on the Dashboard

On the Overview tab, both the Net Investment chart and the AUC chart are shown side by side for the selected period. Compare them sector by sector and identify which of the four patterns above applies.

For historical context, switch to the Sector Trend tab, select a sector, and look at both trend charts together β€” the net investment trend and the AUC trend. A sector where AUC has been rising steadily for 6–8 periods is one where FPIs have structurally increased exposure, regardless of short-term flow noise.

Intermediate Β· Sector Analysis

How to Spot Sector Rotation Using FPI Fortnightly Data

7 min read Β· February 2025

What Is Sector Rotation?

Sector rotation is the movement of investment capital from one sector of the economy to another. Large institutional investors β€” including FPIs β€” rotate their portfolios based on where they expect the next phase of the economic cycle to reward them most.

For example, during periods of high global inflation, FPIs might reduce exposure to rate-sensitive sectors like Real Estate and increase exposure to commodity-linked sectors like Metals and Energy. When growth expectations recover, they might rotate back into IT, Consumer, and Financials.

Because FPIs collectively manage enormous pools of capital, their rotations move markets. Identifying a rotation early β€” even one fortnight before it becomes obvious β€” can give you a meaningful advantage.

Signals of an Early Rotation

Sector rotation rarely happens overnight. It typically shows up in FPI data as a gradual pattern across 2–3 fortnightly periods before it becomes obvious in price action. Here is what to look for:

  • Consistent net outflows from a previously strong sector β€” if a sector that was receiving steady inflows suddenly shows two consecutive fortnights of net selling, investigate further.
  • Falling AUC in a rising market β€” if a sector's AUC is declining even as the broader market is going up, it means FPIs are actively reducing exposure faster than market appreciation can compensate.
  • Rising net inflows in a previously ignored sector β€” sudden interest in a sector that had been neutral for many periods is worth examining.
  • Divergence between two correlated sectors β€” if Financials is seeing inflows while IT is seeing outflows simultaneously, it may signal a growth-to-value rotation.

How to Track This on the Dashboard

The most effective tool for spotting rotation is the Heat Map. Compare the heat map across two or three recent periods using the date picker. Sectors that were green turning red β€” or vice versa β€” over consecutive periods are your rotation candidates.

Once you identify a candidate, click the heat map tile to jump to the Sector Trend tab for that sector. The net investment trend chart will show you exactly how many consecutive periods the change has persisted β€” one period could be noise, three consecutive periods is a signal.

Also check the Consolidated page to see whether the total net investment across all sectors is positive or negative during this period. A rotation happening during a phase of overall FPI outflows is more significant than one happening during broad-based inflows.

Practical tip: Sector rotation signals are most reliable when they persist across at least 2–3 consecutive fortnightly periods AND are accompanied by a change in AUC direction. A single period of unusual net flow is often just portfolio rebalancing noise.

Common Rotation Patterns in Indian Markets

Over recent years, some rotation patterns have recurred regularly in FPI data for Indian equities. These are not rules but historical tendencies worth being aware of:

  • During global risk-off phases (rising US rates, dollar strengthening), FPIs tend to reduce India exposure broadly β€” with IT, Consumer Discretionary and Real Estate often seeing the sharpest outflows.
  • During India-specific growth optimism phases, Financial Services, Capital Goods and Infrastructure tend to attract disproportionate FPI interest.
  • Defensive sectors like FMCG and Pharmaceuticals tend to see relatively stable or mildly positive FPI flows even during periods of broader selling β€” FPIs treat them as safe harbours within India.
Intermediate Β· Reading Charts

The Heat Map Advantage β€” Reading FPI Sentiment at a Glance

5 min read Β· February 2025

Why a Heat Map Works Better Than a Bar Chart for Sentiment

Bar charts are excellent for comparing exact values β€” you can see that Financials received β‚Ή8,200 Cr while IT received β‚Ή3,400 Cr. But when your goal is to quickly read the overall mood across 20+ sectors, your eye has to do too much work scanning bars of different lengths.

A heat map replaces precision with pattern recognition. Colour communicates faster than height. A deep green tile and a deep red tile are immediately distinguishable β€” no axis reading required. This makes the heat map the fastest way to answer the question: where is foreign money going and where is it leaving?

How to Read the Colours

On the FPI India heat map, tile colour represents the net investment in that sector for the selected period. The intensity of the colour is proportional to the magnitude relative to all other sectors in that period:

  • Deep green β€” large net inflow, this sector received the most FPI buying this period
  • Light green β€” modest net inflow, some buying but not the primary destination
  • Light red β€” modest net outflow, mild selling, could be routine rebalancing
  • Deep red β€” large net outflow, this sector saw the most concentrated FPI selling this period
Important nuance: The colour intensity is relative to the current period's data, not an absolute scale. A light green tile in a period of broad outflows may still represent net selling β€” always check the actual number by clicking through to the sector trend.

The Click-Through Feature

The most powerful feature of the heat map is that every tile is clickable. Clicking any sector takes you directly to that sector's historical trend charts β€” showing you both the net investment trend and the AUC trend across all available fortnightly periods.

This workflow β€” scan the heat map, click the interesting sectors, investigate the trend β€” is the most efficient research path this dashboard offers. What would take you 20 minutes reading through tables takes under 2 minutes with this approach.

What to Do When Everything Is Red

Periods of broad-based FPI selling can make the heat map look alarming β€” most tiles red, a few a deeper shade than others. In these situations, the heat map still gives you useful information:

  • Which sectors are holding up relatively better (lighter red or even green) β€” these may have strong domestic institutional support or fundamental tailwinds
  • Which sectors are being hit hardest β€” deep red tiles in a broad selloff may indicate sectors with structural challenges beyond just FPI sentiment
  • Whether the pattern is uniform or concentrated β€” a broad shallow red is very different from a few deep red tiles surrounded by neutral ones

Also check the Consolidated Net Trend during these periods to see how severe the current phase of selling is relative to previous selloff periods.

Advanced Β· Strategy

Using FPI Trend Data Alongside Price Action β€” A Practical Framework

8 min read Β· March 2025

Why FPI Data Alone Is Not Enough

FPI flow data is valuable context β€” but it is not a trading signal on its own. Foreign investors can be wrong. They can be early. They can be selling for reasons entirely unrelated to the Indian company or sector they are exiting β€” global redemptions, currency hedging requirements, or benchmark rebalancing can all drive flows that have nothing to do with underlying fundamentals.

The most effective use of FPI data is as a confirmation or divergence signal layered on top of other analysis β€” particularly price action and fundamental research.

The Confirmation Framework

A high-conviction setup emerges when FPI data and price action tell the same story. Here is what strong confirmation looks like:

  • Bullish confirmation: A sector is making new highs or breaking out of a base on the price chart AND showing consistent net FPI inflows over 3+ fortnightly periods AND AUC is rising. All three agree β€” conviction is high.
  • Bearish confirmation: A sector is breaking down or underperforming the broader market AND showing consistent FPI net outflows AND AUC is declining. All three agree β€” the weakness has structural support.

The Divergence Framework

Divergences β€” where FPI data and price action disagree β€” are often even more interesting than confirmations:

  • Price up, FPI selling: A sector is rallying in price but FPIs are consistently reducing exposure. This could mean domestic institutions or retail are driving the rally without FPI support β€” a potentially fragile move. Worth watching with caution.
  • Price down, FPI buying: A sector is underperforming or correcting but FPIs are accumulating. This is classic smart money accumulation in a sector that local sentiment has given up on. Historically one of the higher-probability setups.
  • Stable price, rising AUC: Price is not moving much but FPI AUC is growing. This usually means market appreciation within the sector β€” stocks going up quietly without fanfare β€” while new buying is also coming in. Often a precursor to a breakout.
Note: These are frameworks for research and hypothesis formation β€” not mechanical rules. Always combine with your own fundamental analysis and risk management discipline. FPI data is one input, not a complete system.

A Practical Weekly Routine

Here is a simple weekly workflow that takes under 15 minutes and keeps you up to date with FPI developments:

  1. Check the Consolidated Net Trend first β€” is the macro FPI mood positive or negative right now? This sets the context for everything else.
  2. Open the Heat Map for the most recent period β€” scan for any surprising greens or reds relative to your expectations.
  3. Click through to the trend charts for 2–3 sectors that caught your attention β€” has the pattern just started or been building for several periods?
  4. For sectors you already hold or watch, check whether the AUC trend is consistent with your thesis. Rising AUC in a sector you are long is reassuring. Falling AUC warrants a second look at your reasoning.
  5. Note any divergences between FPI data and recent price action in those sectors for further investigation.

What This Dashboard Cannot Tell You

Being honest about limitations makes the data more useful, not less. FPI fortnightly data does not tell you:

  • Which specific stocks within a sector FPIs are buying or selling β€” only the sector aggregate
  • The reason behind any particular flow β€” you have to infer from macro context
  • What FPIs will do next β€” flows can reverse quickly
  • Whether domestic institutions (DIIs) are buying what FPIs are selling, which can offset market impact significantly

Use this data as one lens among several β€” alongside DII data, corporate earnings trends, valuations, and macro indicators β€” for the most complete picture.

Advertisement