节点文献
应用Excel求解资产组合投资收益与风险的优化模型
An Optimal Model to Calculate the Income and Risk of Asset Combined Investments with Excel
【摘要】 本文结合资产组合投资收益与风险的优化模型的求解 ,介绍在 Excel中可以利用其内嵌的 VBA进行简单编程 ,即可以实现系列化自动反复规划求解、保存优化结果的一些程序化方法和技巧
【Abstract】 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.
【关键词】 组合投资;
收益与风险;
规划求解;
程序化;
【Key words】 Combined Investment income and risk plan and solve programming;
【Key words】 Combined Investment income and risk plan and solve programming;
- 【文献出处】 微型电脑应用 ,Microcomputth Applications , 编辑部邮箱 ,2001年06期
- 【分类号】TP317.3
- 【被引频次】2
- 【下载频次】691