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.
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?