Shares Owned (Institutional Ownership)
Returns the number of shares owned by institutional investors such as mutual funds, pension funds, hedge funds, and other large investors.
What Counts as Institutional Ownership?
- Mutual funds
- Pension funds
- Insurance companies
- Hedge funds
- Investment advisors
- Banks and trusts
Why It Matters
| High Institutional Ownership | Low Institutional Ownership |
|---|---|
| Generally more stable | May be more volatile |
| More analyst coverage | Less analyst coverage |
| More liquidity | Less liquidity |
| More scrutiny | Less scrutiny |
Calculate Institutional Ownership Percentage
=SharesOwned("AAPL") / Shares_Outstanding("AAPL")
Examples
=SharesOwned("AAPL")=SharesOwned("MSFT")=SharesOwned("TSLA")=SharesOwned(A1)=SharesOwned("AAPL")/Shares_Outstanding("AAPL")When to Use
- Analyzing institutional interest
- Assessing stock stability
- Identifying institutional favorites
- Smart money tracking
- Understanding ownership structure
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need insider ownership | SharePercentHeldByInsiders() |
| Need total shares | Shares_Outstanding() |
| Need public float | FloatShares() |
| Need ownership percentage | Calculate: SharesOwned() / Shares_Outstanding() |
Common Issues & FAQ
Q: How do I get institutional ownership as a percentage?
A: =SharesOwned("SYMBOL") / Shares_Outstanding("SYMBOL")
Q: Why does institutional ownership change? A: Institutions file 13F forms quarterly, so data updates every quarter. Between filings, the numbers may be estimates.
Q: Is high institutional ownership good or bad? A: Neither inherently. High ownership can indicate:
- Confidence from professional investors
- But also risk of large sell-offs if institutions exit
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?