Now, I want to graph the efficient frontier line - ie, the minimum standard deviation possible at any given expected return level.Disclaimer This workbook and the results it produces do not constitute investment advice. EfficientFrontierPortfolios (Excel 2010) (Version 3 corrects the volatility estimate for FrontierPort4.) The workbook is “flexible” in that it accommodates any number of assets up to 50.To edit this to a curved line, right-click the data series and then select the “Format Data Series” button from the pop-up menu. The line graph is inserted with straight lines corresponding to each data point. Select and highlight the range A1:F2 and then click Insert Line or Area Chart Line.Two asset classes (stocks and bonds for example) can be combined with varying proportions to create an infinite number of portfolios.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |