Portfolio Efficient Frontier Data
Returns data points for the efficient frontier used in Modern Portfolio Theory.
Syntax
=PortfolioEfficientFrontierData()Examples
When to Use
- Portfolio optimization
- Asset allocation research
- Modern Portfolio Theory analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Visual chart | PortfolioEfficientFrontierChart() |
| Simple metrics | Individual ratio functions |
Common Issues & FAQ
What is the efficient frontier?
Set of optimal portfolios offering highest return for each risk level.
Related Formulas
More MarketXLS Portfolio Analytics formulas you can use in the same worksheet:
- Portfolio Efficient Frontier Report
- Positive Period
- Sortino Ratio
- Treynor Ratio
- Value At Risk
- Wealth Index
- AIPortfolio Optimize
- AIPortfolio Predict Returns
See PortfolioEfficientFrontierData 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?