Home > Forum Home > Excel Portfolio Optimization Template > expected returns > Multiple options for input data Share

Multiple options for input data

Excel Help for Multiple Options For Input Data in Excel Portfolio Optimization Template


Forum TopicLogin

Multiple Options For Input Data

Rate this:
(3/5 from 1 vote)
HappyFor 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
 
View Full Post

Find relevant Excel templates and add-ins for Multiple options for input data in the