Home > Forum Home > Excel Portfolio Optimization Template > Further Clarification Share

Further Clarification

Excel Help for Further Clarification in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Further Clarification

Rate this:
(4/5 from 2 votes)
Confused Hi,
Thanks for your excellent help thus far. I have read your help section and still need a clarification on the Chart for "Efficient Frontier and the Portfolio Set". There are two parabolas in the chart. Is one for the optimized portfolio and the other is for the test or "input" portfolio? The help section was not clear on this.
thanks again,
Michael
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Oops
Rate this:
(3/5 from 3 votes)
The blue curves on the efficient frontier chart map the different weightings of assets between 4 main points: maximum return at the top, minimum return at teh bottom, minimum risk to the left and maximum risk to the right.

The right part of the frontier is often inward curving as a result of the risk reduction on combined correlated assets.

The blue point on the chart represents the risk/return of the current portfolio and the green point is the optimized portfolio based on the strategy selected.
 
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Further Clarification in the