Shares Outstanding (On Demand)
Returns the total number of shares outstanding for a stock using QuoteMedia's on-demand data service.
What are Shares Outstanding?
Shares outstanding represent all shares of a company's stock that have been issued and are held by investors, including institutional investors and company insiders.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | String | Yes | Stock ticker symbol |
Notes
- This is total shares outstanding, not float
- Used to calculate market cap: Price x Shares Outstanding
- May include restricted shares held by insiders
Syntax
=QM_SharesOutstanding(Symbol)Examples
=QM_SharesOutstanding("AAPL")=QM_SharesOutstanding("MSFT")=QM_SharesOutstanding("TSLA")=QM_SharesOutstanding(A1)/1000000=QM_Last("AAPL")*QM_SharesOutstanding("AAPL")When to Use
- Calculate market capitalization
- Analyze ownership structure
- Per-share metric calculations
- Compare company sizes
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need market cap directly | QM_MarketCap() |
| Need tradeable float | Float-specific functions |
| Need diluted shares | Diluted share functions |
Common Issues & FAQ
Why is this number so large?
Shares outstanding is returned as a full number. Apple has ~15.5 billion shares, returned as 15500000000. Divide by 1e9 for billions.
What's the difference between shares outstanding and float?
Shares outstanding includes ALL shares. Float excludes restricted shares held by insiders and is the number available for public trading.
Does this include stock options/warrants?
This is typically basic shares outstanding. Diluted shares would include potential shares from options, warrants, and convertibles.
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?