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")
Syntax
=SharesOwned(Symbol)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
How do I get institutional ownership as a percentage?
=SharesOwned("SYMBOL") / Shares_Outstanding("SYMBOL")
Why does institutional ownership change?
Institutions file 13F forms quarterly, so data updates every quarter. Between filings, the numbers may be estimates.
Is high institutional ownership good or bad?
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?