Home > Forum Home > Excel Portfolio Optimization Template > expected returns Share

Expected returns

Excel Help for Expected Returns in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Expected Returns

Rate this:
(3/5 from 1 vote)
ConfusedI have a vague understanding of the portfolio optimization process, but have always had to input the EXPECTED RETURNS in each of the other solvers that I have worked with in the past.  Does this optimization use EXPECTED RETURNS and if so, how are the expectations calculated?

Separately, would like to have a telephonic conversation with an expert who supports this software.  I am interested in solving for a specific amount of risk as measured by semi variance, rather than a targeted return.  Who do I contact to schedule a call?

thanks
 Posted by on
 
Replies - Displaying 1 to 4 of 4Order Replies By: Most recent | Chronological | Highest Rated
Sad
Rate this:
(3/5 from 1 vote)
On dit merci.
 Leloup
 Posted by on
Applaud
Rate this:
(3/5 from 1 vote)
We have emailed you a new version with the option to use semi-deviation below the target return for testing.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
I'm willing to pay someone in your organization to modify my spreadsheet so that I can solve for semi-variance.  how do I go about this?
 Posted by on
Happy
Rate this:
(3/5 from 1 vote)
For the data input there are several options. 

To use expected returns as before simply enter the required data into the correlation matrix of the CoVar sheet.

To have the returns and correlation calculated for you, enter the historical data into the input sheet (which can then be optionally modified in the Covar sheet before optimization). The input data can be either price/value or percentage returns. The expected returns are calculated as the average return from the input data.

Currently the program has the option to use downside risk and the Sortino ratio only but not semi-deviation with a target threshold.  We can look into adding this if commonly demanded.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for expected returns in the