Tools for portfolio optimization (Mean-Variance Optimization), asset allocation using the Black-Litterman model , and style analysis.
Specific modules for Employee Stock Options (ESOs) that account for vesting requirements and employee exercise behavior.
The add-in is typically delivered as a setup executable or a compressed file. Finance Add-in for Excel - Overview - Hoadley.net hoadley finance add in for excel.zip
Calculate option prices, "Greeks" (Delta, Gamma, Vega, Theta), implied and historical volatility, and underlying asset probabilities.
Includes functions for Value at Risk (VaR) using full portfolio revaluation or risk factor mapping. Finance Add-in for Excel - Overview - Hoadley
The is a professional-grade analytical engine designed for traders, portfolio managers, and financial analysts who require advanced derivatives and portfolio tools within a spreadsheet environment. Core Capabilities of the Hoadley Finance Add-in
Retrieve streaming quotes and option chains from various sources, such as Yahoo Finance and brokerage APIs. Downloading and Installation Core Capabilities of the Hoadley Finance Add-in Retrieve
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: