应用Excel求解资产组合投资收益与风险的优化模型

An Optimal Model to Calculate the Income and Risk of Asset Combined Investments with Excel

本文结合资产组合投资收益与风险的优化模型的求解 ,介绍在 Excel中可以利用其内嵌的 VBA进行简单编程 ,即可以实现系列化自动反复规划求解。

This paper introduces simple programming with VBA which is built in Excel. An optimal model of calculating the income and risk of asset combined investments is illustrated. How to realize repeated problem solving and result optimization is also presented.