Projects / 02

Pricing & Hedging Toolkit: Fixed Income and Derivatives

Four Excel models on Bloomberg data: government bonds, yield curve, futures, FRAs and swaps, options and strategies.

Derivatives · Course: Derivatives · 2025/26

Description

Four Excel models built on market data from Bloomberg. They cover pricing of Italian government bonds, yield curve construction, order books and margining on futures, the use of FRAs and interest rate swaps to hedge a bank’s interest rate risk, and option pricing across the main strategies (spreads, straddles, strangles, butterflies, condors), on both simulated and real data.

Skills

Pricing of fixed income instruments and derivatives, term structure construction, interest rate risk hedging, Greeks and payoff analysis.

Tools

Advanced Excel, Bloomberg Terminal.

Models

Clean and dirty price, YTM, bootstrapping and interpolation of the spot and forward curve (Euribor, €STR, IRS), futures cost of carry and arbitrage, FRA and IRS pricing, binomial trees, Black–Scholes and implied volatility, Greeks, put-call parity.

Educational projects. Any results are hypothetical, based on historical or simulated data, and are not indicative of future returns. Nothing on these pages constitutes investment advice or a solicitation to invest.

Next project: Actively Managed Simulated Fund on the S&P 100

Open