Market Capitalization (On Demand)
Returns the market capitalization (price x shares outstanding) for a stock using QuoteMedia's on-demand data service.
What is Market Cap?
Market capitalization represents the total market value of a company's outstanding shares. It's calculated as:
Market Cap = Current Stock Price x Shares Outstanding
Market Cap Categories
| Category | Range |
|---|---|
| Mega Cap | > $200 billion |
| Large Cap | $10-200 billion |
| Mid Cap | $2-10 billion |
| Small Cap | $300M-2 billion |
| Micro Cap | $50-300 million |
| Nano Cap | < $50 million |
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | String | Yes | Stock ticker symbol |
Notes
- Value is in dollars
- Updates with stock price changes
- Large numbers may need formatting (e.g., billions)
Examples
=QM_MarketCap("AAPL")=QM_MarketCap("MSFT")=QM_MarketCap("TSLA")=QM_MarketCap(A1)/1000000000=TEXT(QM_MarketCap(A1),"$#,##0,,"B"")When to Use
- Compare company sizes
- Screen stocks by market cap
- Portfolio weighting calculations
- Fundamental analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need shares outstanding | QM_SharesOutstanding() |
| Need enterprise value | Calculate from debt/cash data |
| Need historical market cap | Historical fundamental functions |
Common Issues & FAQ
Q: Why is the value so large? A: Market cap is returned in full dollars. Apple's $2.8 trillion market cap returns as 2800000000000. Use formatting or divide by 1B.
Q: How do I format the result? A: Use Excel formatting:
=QM_MarketCap("AAPL")/1e9for billions=TEXT(QM_MarketCap("AAPL"),"$#,##0,,"B"")for formatted billions
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?