Treynor Ratio
Returns the Treynor ratio, measuring excess return per unit of market (beta) risk.
Syntax
=TreynorRatio()Returns
number
Treynor ratio value
Examples
=TreynorRatio()When to Use
- Market risk-adjusted performance
- Diversified portfolio evaluation
- Manager comparison
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Total risk adjustment | SharpeRatio() |
| Downside risk | SortinoRatio() |
Common Issues & FAQ
When use Treynor vs Sharpe?
Treynor for diversified portfolios; Sharpe for total portfolio.
Excel Templates Using Treynor Ratio
These ready-made MarketXLS templates call TreynorRatio() 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:
- Value At Risk
- Wealth Index
- AIPortfolio Optimize
- AIPortfolio Predict Returns
- Drawdown
- Holdings Gain
- Holdings Gain Percent
- Holdings Gain Percent Real-Time
See TreynorRatio used in a complete workbook: Sharpe Ratio: Complete Guide to Portfolio Risk-Adjusted Returns in Excel
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?