# Calculate Kappa with Excel

This Excel spreadsheet calculates Kappa, a generalized downside-risk adjusted performance measure.

This Excel spreadsheet calculates Kappa, a generalized downside-risk adjusted performance measure.

This Excel spreadsheet implements a Modified Value at Risk (or MVaR) calculation, which adjusts the standard deviation to account for…

This Excel spreadsheet downloads historical Forex data from the Internet. You can ask for bid, ask and mid rates for…

This Excel spreadsheet calculates Value at Risk through the Monte Carlo simulation of geometrical brownian motion in VBA.

Today I’d like to clarify the concept of Value At Risk. I’ll demonstrate how you can calculate VAR in Excel,…

This Excel spreadsheet helps you calculate the Omega Ratio, a financial benchmark created by Shadwick and Keating in 2002.

This Excel spreadsheet imports historical stock prices from Yahoo Finance (http://finance.yahoo.com).

This Excel spreadsheet calculates the Sortino Ratio for an investment, a measure of risk-adjusted return. Investments that emphasize their Sortino…

This Excel spreadsheet will calculate the optimum investment weights in a portfolio of three stocks by maximizing the Sharpe Ratio…

This Excel spreadsheet implements Markowitz’s mean-variance theory. It optimizes asset allocation by finding the stock distribution that minimizes the standard…