Revenue (Quarter On Quarter Growth)
Returns the quarter-over-quarter (QoQ) growth, comparing the most recent quarter to the immediately prior quarter.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
Parameters
| Parameter | Description | Example |
|---|---|---|
| Symbol | Stock ticker | "AAPL" |
| Metric | Metric to measure | "revenue" |
Calculation
QoQ Growth = (Current Quarter - Prior Quarter) / Prior Quarter
Notes
- Returns value as a decimal (0.05 = 5%)
- Sequential quarter comparison
- May show seasonality effects
Examples
When to Use
- Track sequential quarterly momentum
- Identify recent trend changes
- Analyze business seasonality
- Short-term performance evaluation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Year-over-year growth | YoYGrowth() |
| YoY quarterly comparison | QuarterlyRevenueGrowthYOY() |
| Long-term CAGR | CAGR functions |
| Annual comparison | Annual growth functions |
Common Issues & FAQ
Q: Why is the value less than 1? A: Growth is returned as a decimal. Multiply by 100 to get percentage (e.g., 0.05 = 5%).
Q: Why might QoQ show decline while YoY shows growth? A: Seasonality - many businesses have strong/weak quarters. QoQ compares sequential quarters, YoY compares same quarters across years.
Q: Should I use QoQ or YoY? A: YoY controls for seasonality. QoQ shows recent momentum. Use both for complete picture.
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?