Excel Models
The Greek Letters
๐ As we saw, Delta Hedging is a very effective tool for hedging the risk of a sold option.
โ๏ธ When a portfolio becomes Delta Neutral, changes in the underlying assetโs price no longer affect profitability.
๐ We also saw that the optionโs delta changes with the underlying asset price, so hedging requires periodic portfolio rebalancing (Dynamic Hedging).
โ However, Delta Hedging alone is not sufficient for complete risk protection, and in practice, other โGreek lettersโ are also monitored, which play their roles in the relationship between the stock and the option.
๐ It is important to understand that if delta hedging is effective only for a single type of option, when we consider other Greeks here, we are talking about an options portfolio that depends on a single underlying asset.
๐ผ Options dependent on a single asset can vary by strike price, maturity, type (Put/Call), and quantity. The portfolio may also include futures…
๐ Below, the Greeks are discussed in general, and at the end, formulas and an Excel file are provided as an example from the source*.
Gamma (ฮ) โ measures the curvature of the relationship.
๐ It is a second-order derivative that affects the sensitivity of the option price when the underlying price moves in a wide range.
๐น (For small changes, delta is usually enough, as the curvature has little impact).
๐ฏ For ideal hedging, the portfolio needs to be both delta and gamma neutral.

THETA (ฮธ) โ is the rate at which the value of an option portfolio changes over time, assuming all other parameters remain constant.
๐ ฮธ does not serve the same hedging purpose as gamma and delta, since in their case there is uncertainty,
โณ theta is simply related to the passage of time.
โ
Nevertheless, it is still considered an important parameter, as it is symmetrically related to gamma.

Vega (V) โ is the rate at which the value of an option portfolio changes due to volatility in the underlying asset.
๐น In other words, the larger the Vega (positive or negative), the more sensitive the portfolio value is to changes in the underlying assetโs price volatility (Sensitivity on Volatility).
Rho (ฯ) โ is the rate at which the value of an option portfolio changes due to interest rate changes.
๐ฐ In other words, it measures how sensitive the portfolio value is to changes in the market interest rate.
How are the parameters managed in practice?
๐น In practice, it is not possible for a portfolio to constantly balance all parameters.
๐ Typically, individual traders manage an options portfolio dependent on a single asset (e.g., a derivatives portfolio linked to the Euro).
๐ป Software automatically calculates the Greek letters and sets limits, which the trader cannot exceed, and/or requires additional authorization.
๐
Delta is balanced on a daily basis.
๐ Other Greeks are mainly monitored, and reactions to them occur less frequently.
Formulas:

๐ Excel โ Greeks โ this file contains examples with formulas for a dividend-free stock and a portfolio of short European calls.
๐ Source: Options, Futures & Other Derivatives, John C. Hull
| Greek | Symbol | Unit | What it Measures | Practical Meaning |
|---|---|---|---|---|
| Delta | ฮ | shares | โV / โS | Value change for $1 move in underlying |
| Gamma | ฮ | shares per $ | โฮ / โS | Change in delta for $1 move |
| Vega | ฮฝ | currency per 1.00 vol | โV / โฯ | Value change for 100% vol change |
| Theta | ฮ | currency per year* | โV / โt | Value lost (or gained) as time passes |
| Rho | ฯ | currency per 1.00 rate | โV / โr | Value change for 100% rate change |