Positive Period
Returns the percentage of periods with positive returns.
Syntax
=PositivePeriods()Returns
number
Percentage of positive periods
Examples
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:
- Sortino Ratio
- Treynor Ratio
- Value At Risk
- Wealth Index
- AIPortfolio Optimize
- AIPortfolio Predict Returns
- Drawdown
- Holdings Gain
See PositivePeriods used in a complete workbook: Portfolio Optimization in Excel: Complete Implementation Guide
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?