Portfolio Optimization

Portfolio Optimisation

The Portfolio Optimization with MarketXLS calculates the optimal capital weightings for a basket of investments that gives the highest return for the least risk. The MarketXLS add-in enables it to be applied to either financial instrument or business portfolios. The ability to apply optimization analysis to a portfolio represents an excellent framework for driving capital …

Read morePortfolio Optimization

Efficient Frontier using Excel (with MarketXLS)

Efficient Frontier

The Efficient frontier using excel is one of the most important financial tools that help an investor compose an investment portfolio with the maximum returns and minimum amount of risk. This article will discuss what it is, how it is then calculated, and how MarketXLS calculates it of your Portfolio. Contents: What is Efficient frontier …

Read moreEfficient Frontier using Excel (with MarketXLS)