Home > Forum Home > Excel Portfolio Optimization Template > Assets other than stocks in portfolio > Non-return asset types Share

Non-return asset types

Excel Help for Non-return Asset Types in Excel Portfolio Optimization Template

Forum TopicLogin

Non-return Asset Types

Rate this:
(4/5 from 2 votes)
Confused The input data can be either all return based or all price based.  When we have a mix of return and price data we can convert the price data to returns in a separate spreadsheet by using a simple formula: (end price-start price)/start price.  The resulting return data can then be used in the input data along with the other returns.

If we do not have any return or price data for assets that we want to include in optimization, we can also use proxies.  In this case we need to find publicly traded securities which may include indices or ETFs that best reflect the industry or type of investment asset that we require a weighting for in the portfolio.
 Excel Business Forums Administrator
 Posted by on
View Full Post

Find relevant Excel templates and add-ins for Non-return asset types in the