top of page

Let’s Talk About Abs

Public·11 members

Hoadley Finance Add-in For Excel Crack 28

Hoadley Finance Add-in for Excel 28: A Powerful Tool for Derivatives Analysis

If you are looking for a comprehensive, easy-to-use and affordable software package for the analysis of options and other derivatives, you may want to check out the Hoadley Finance Add-in for Excel 28. This add-in lets you build spreadsheets and applications that can perform a wide range of calculations and functions related to option pricing, implied volatility, historical volatility, hedge parameters, probabilities, futures, value at risk, portfolio analysis, asset allocation, company valuation and more. You can also retrieve option chains and quotes from various online sources, including streaming real-time data.

Download File:

The Hoadley Finance Add-in for Excel 28 is the latest version of the add-in developed by Peter Hoadley, a former professor of finance and an expert in derivatives. The add-in has been continuously updated and improved since its first release in 1998. The add-in is compatible with Microsoft Excel (32-bit or 64-bit) running under Microsoft Windows. It is also the calculation engine behind the options analysis and portfolio analysis tools available on the Hoadley website.

Features and Functions of the Hoadley Finance Add-in for Excel 28

The Hoadley Finance Add-in for Excel 28 includes hundreds of functions that can be invoked directly from spreadsheet cells or from VBA modules. The functions are organized into different categories, such as vanilla options, exotic options, interest rate derivatives, employee stock options, historical volatility, correlation, cointegration, probabilities, portfolio insurance, hedging, profitability, futures, variance swaps, copulas and simulation, value at risk, factor models, portfolio analysis, asset allocation, portfolio optimization, company valuation, online data feeds and utilities. Some of the main features and functions of the add-in are:

  • Option pricing and Greeks: The add-in can calculate option prices and Greeks for European and American options on equities, currencies, indices and futures using the Black-Scholes or the Cox-Ross-Rubinstein binomial models. The add-in can handle dividends specified as discrete payments or as a continuous yield. The add-in can also price options with time-varying interest rates using a term structure of interest rates.

  • Implied volatility: The add-in can calculate implied volatility for European and American options using the Newton-Raphson method. The add-in also includes an Implied Volatility Calculator that can retrieve complete option chains from a number of online data providers.

  • Implied values: The add-in can calculate values implied from either an option price or an option delta, such as implied strike, implied spot, implied term, implied volatility and implied risk-free rate. This can be useful for identifying options that meet specific hedging or other requirements.

  • Percent-to-target: The add-in can calculate the percentage change in the price of the underlying that would be required to increase the option price by a specified percentage. For example, the percent-to-double metric shows how much the underlying needs to move for the option to double in value.

  • Exotic options: The add-in can price and analyze various types of exotic options, such as barrier options, binary options, chooser options, compound options, lookback options, shout options and rainbow options.

  • Interest rate derivatives: The add-in can price and analyze interest rate derivatives and convertible bonds using different models, such as Black-Derman-Toy, Ho-Lee, Hull-White and Vasicek.

  • Employee stock options: The add-in can value employee stock options using different methods, such as Black-Scholes with modifications for early exercise, binomial lattice with exercise rules based on empirical studies or user-defined rules, Monte Carlo simulation with exercise rules based on empirical studies or user-defined rules, and finite difference methods.

  • Historical volatility: The add-in can calculate historical volatility using different methods, such as close-to-close, Parkinson, Garman-Klass, Rogers-Satchell, Yang-Zhang, Hodges-Tompkins, Corrado-Miller, Brenner-Subrahmanyam, Barone-Adesi-Whaley, Stein-Stein and Heston-Nandi.

  • Correlation and cointegration: The add-in can calculate correlation and cointegration between two or more time series using different methods, such as Pearson, Spearman, Kendall, Engle-Granger, Johansen and Phillips-Ouliaris.

  • Probabilities: The add-in can calculate various probabilities related to options and other derivatives, such as the probability of the underlying reaching a certain level by a certain date, the probability of the option expiring in-the-money or out-of-the-money, the probability of early exercise for American options, the probability distribution of the option payoff and the probability density function of the option price.

  • Portfolio insurance: The add-in can calculate the optimal number of put options or futures contracts to hedge a portfolio using different methods, such as Black-Scholes delta hedging, binomial delta hedging, minimum variance hedging and Sharpe ratio hedging. The add-in can also calculate the profitability of different portfolio insurance strategies.

  • Futures and variance swaps: The add-in can price and analyze futures contracts and variance swaps using different models, such as Black-76, Black-Scholes with continuous dividends, Cox-Ross-Rubinstein with discrete dividends, Heston stochastic volatility and Hull-White stochastic volatility.

  • Copulas and simulation: The add-in can calibrate copulas using historical data and simulate financial data using different copulas, such as Gaussian, Student-t, Clayton, Gumbel, Frank, Joe, Galambos, Husler-Reiss and Marshall-Olkin. The add-in can also simulate data using different distributions, such as normal, lognormal, uniform, exponential, gamma, beta, chi-square, Student-t and Weibull.

  • Value at risk: The add-in can calculate value at risk (VaR) for a portfolio using different methods, such as historical simulation, parametric VaR, Monte Carlo simulation, delta-normal VaR, delta-gamma VaR, Cornish-Fisher VaR, modified VaR and expected shortfall.

  • Factor models: The add-in can estimate factor models using different methods, such as principal component analysis, factor analysis, regression analysis and Kalman filter. The add-in can also calculate factor exposures, factor returns, factor loadings, factor betas, factor alphas and factor risk premiums.

  • Portfolio analysis: The add-in can perform various portfolio analysis functions, such as calculating portfolio returns, portfolio volatility, portfolio beta, portfolio alpha, portfolio Sharpe ratio, portfolio Treynor ratio, portfolio Jensen's measure, portfolio Sortino ratio and portfolio information ratio.

  • Asset allocation: The add-in can perform various asset allocation functions, such as calculating efficient frontiers, optimal portfolios, capital market lines, capital allocation lines, security market lines and capital asset pricing models. The add-in can also perform mean-variance optimization, mean-CVaR optimization, mean-entropy optimization and Black-Litterman optimization.

  • Portfolio optimization: The add-in can perform various portfolio optimization functions, such as maximizing return for a given level of risk, minimizing risk for a given level of return, maximizing Sharpe ratio, maximizing Sortino ratio, maximizing information ratio, maximizing alpha or minimizing tracking error. The add-in can also handle various constraints on portfolio weights, such as upper and lower bounds, linear equality and inequality constraints, cardinality constraints and turnover constraints.

  • Company valuation: The add-in can perform various company valuation functions, such as calculating free cash flow to equity (FCFE), free cash flow to firm (FCFF), dividend discount model (DDM), residual income model (RIM), economic value added (EVA), market value added (MVA), enterprise value (EV), price-to-earnings ratio (P/E), price-to-book ratio (P/B), price-to-sales ratio (P/S) and price-to-cash flow ratio (P/CF).

  • Online data feeds: The add-in can retrieve online data from various sources, such as Yahoo Finance, Google Finance, MSN Money Central, Quandl and Bloomberg. The add-in can also retrieve streaming real-time data from IQFeed. The add-in can handle different types of data, such as stock prices, option chains, dividends, splits, earnings, fundamentals, economic indicators and exchange rates.

Utilities: The add-in includes various utility functions that can enhance the functionality of Excel or simplify the use of the add-in. For example, the add-in includes functions to convert dates between different formats, to interpolate values from a table or a curve, to solve equations numerically or symbolically, to perform matrix operations or linear algebra calculations and to create charts or I'll continue writing the HTML-article on the topic of "hoadley finance add-in for excel 28". Here is the re


Welcome to the group! You can connect with other members, ge...
bottom of page