MarketXLS

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

Syntax

=QoQGrowth(Symbol, Metric)
Excel Desktop (Windows)

Parameters

symbolstringRequired
metricstringRequired

Returns

number

Quarter-over-quarter growth as a decimal

Examples

=QoQGrowth("AAPL","revenue")
Apple QoQ revenue growth
=QoQGrowth("MSFT","revenue")
Microsoft QoQ revenue growth
=QoQGrowth(A1,B1)
Symbol and metric from cells
=QoQGrowth("AAPL","revenue")*100
Convert to percentage

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

Why is the value less than 1?

Growth is returned as a decimal. Multiply by 100 to get percentage (e.g., 0.05 = 5%).

Why might QoQ show decline while YoY shows growth?

Seasonality - many businesses have strong/weak quarters. QoQ compares sequential quarters, YoY compares same quarters across years.

Should I use QoQ or YoY?

YoY controls for seasonality. QoQ shows recent momentum. Use both for complete picture.

Excel Templates Using Revenue (Quarter On Quarter Growth)

These ready-made MarketXLS templates call QoQGrowth() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Growth formulas you can use in the same worksheet:

See QoQGrowth used in a complete workbook: MarketXLS New Release 9.3.4.5

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Revenue (Quarter On Quarter Growth) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions