发布求助
文献互助 智能选刊 最新文献

Journal of Quantitative Methods最新文献

筛选
英文 中文
Creating Optimal Portfolio and the Efficient Frontier Using Microsoft Excel ® 使用Microsoft Excel®创建最佳投资组合和高效前沿
Journal of Quantitative Methods Pub Date : 2018-08-01 DOI: 10.29145/2018/JQM/020207
Saurav Roychoudhury
{"title":"Creating Optimal Portfolio and the Efficient Frontier Using Microsoft Excel ®","authors":"Saurav Roychoudhury","doi":"10.29145/2018/JQM/020207","DOIUrl":"https://doi.org/10.29145/2018/JQM/020207","url":null,"abstract":"Portfolio managers and investors strive to achieve the best possible trade-off between risk and return, and one of the tools they use is constructing mean-variance efficient portfolios. Finance students learn about optimal portfolios and efficient frontiers, though it is difficult to replicate them unless they have access to sophisticated software. This paper develops a teaching module that uses Microsoft Excel® to create mean-variance portfolios and traces out the efficient frontier using real-world data. In the process, the students learn to determine optimal investment allocations in a portfolio, select the optimum investment portfolio given investor’s objectives and preferences and learn about factors that influence different asset allocations. For multiple assets (N>3), the paper uses Matrix algebra in Excel®. The paper enables students and investors to learn how to construct real-world mean-variance efficient portfolios using Excel®.","PeriodicalId":212366,"journal":{"name":"Journal of Quantitative Methods","volume":"1 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2018-08-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"130634894","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 1
首页 上一页
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整，为了账户安全，请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
现在去查看 取消
×
提示
确定
请完成安全验证×
相关产品
×
本文献相关产品
联系我们：info@booksci.cn Book学术提供免费学术资源搜索服务，方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号：604180095
Book学术官方微信