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

Value-at-risk VaR using Excel (with MarketXLS)


Value-at-risk using Excel is one of the most important financial tools that help an investor measure the risk of an investment portfolio. This article will discuss what it is, how it is then calculated, how MarketXLS calculates the Value-at-risk of your Portfolio. Value-at-risk is a statistical measure of the riskiness of portfolios of assets. It …

Read moreValue-at-risk VaR using Excel (with MarketXLS)