Hoadley Finance Add In For Excel.zip -

Tools for portfolio optimization (Mean-Variance Optimization), asset allocation using the Black-Litterman model , and style analysis.

Retrieve streaming quotes and option chains from various sources, such as Yahoo Finance and brokerage APIs. Downloading and Installation hoadley finance add in for excel.zip

Calculate option prices, "Greeks" (Delta, Gamma, Vega, Theta), implied and historical volatility, and underlying asset probabilities. asset allocation using the Black-Litterman model

Specific modules for Employee Stock Options (ESOs) that account for vesting requirements and employee exercise behavior. implied and historical volatility

Includes functions for Value at Risk (VaR) using full portfolio revaluation or risk factor mapping.

The add-in provides a massive library of functions that can be invoked directly from Excel cells or through VBA macros. Its primary focus areas include: