Home > Forum Home > Excel Portfolio Optimization Template > Same output by varying the Target returns Share

Same output by varying the Target returns

Excel Help for Same Output By Varying The Target Returns in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Same Output By Varying The Target Returns

Rate this:
(4/5 from 2 votes)
ConfusedI am getting the same output(returns, risk, sharpe ratio, optimal weights) for various target returns. I am evaluating the portfolio optimization spreadsheet during the trial period. Is there a restriction on how many times I run optimization during evaluation period.

Regards,
SamĀ 
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Happy
Rate this:
(4/5 from 2 votes)
We are likely to get similar results based on the returns and variance of each asset. Using the Sortino ratio accounts for downside deviation below the target return on each asset while the Sharpe ratio uses overall standard deviation.

We can also change weighting constraints to model different scenarios and there no no limits to how many optimizations which can be run.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Same output by varying the Target returns in the