> For the complete documentation index, see [llms.txt](https://www.bfm-unity.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.bfm-unity.org/invest-method/group-1/ma-ke-wei-zi-li-lun-shi-cao.md).

# 马科维兹理论 实操

​[马科维茨理论的实际运用](https://www.ixueshu.com/document/6e09572fe1bc8330318947a18e7f9386.html)

​​[基于马科维茨理论的最优证券组合分析](https://www.ixueshu.com/document/a0b4238794c16299a29a486088c5dcf5318947a18e7f9386.html)

​​[\[资金管理\]](https://bbs.pinggu.org/forum.php?mod=forumdisplay\&fid=2166\&filter=typeid\&typeid=5005) 

[使用EXCEL画出马克维茨有效前沿的步骤说明](https://bbs.pinggu.org/thread-5249148-1-1.html)

​​[EXCEL动态规划求解](https://zhuanlan.zhihu.com/p/61531510)​​

[Excel 公式CORREL算出相关系数](https://blog.csdn.net/qq_40875849/article/details/83053355)​

​[如何利用Excel做协方差与相关系数分析？](https://zhuanlan.zhihu.com/p/49592468)​