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
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
Q: Why is this number so large? A: Shares outstanding is returned as a full number. Apple has ~15.5 billion shares, returned as 15500000000. Divide by 1e9 for billions.
Q: What's the difference between shares outstanding and float? A: Shares outstanding includes ALL shares. Float excludes restricted shares held by insiders and is the number available for public trading.
Q: Does this include stock options/warrants? A: 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