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.
