Positive Period

Returns the percentage of periods with positive returns.

Syntax

=PositivePeriods()
Excel Desktop (Windows)

Returns

number

Percentage of positive periods

Examples

=PositivePeriods()

When to Use

  • Consistency analysis
  • Win rate assessment
  • Strategy evaluation

When NOT to Use

Scenario Use Instead
Average return CAGR()
Risk-adjusted SharpeRatio()

Common Issues & FAQ

What period is this based on?

Typically monthly periods.

Excel Templates Using Positive Period

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

Related Formulas

More MarketXLS Portfolio Analytics formulas you can use in the same worksheet:

See PositivePeriods used in a complete workbook: Portfolio Optimization in Excel: Complete Implementation Guide

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
MarketXLS Excel Add-in Tutorial - How to Use Positive Period and Other Financial Formulas
▶
How does MarketXLS work?