Bond Pricing and Analysis Tool

Bonds are one of the most important instruments in finance and one of the least talked about. They fund governments and corporations, anchor institutional portfolios, and sit at the center of how the Federal Reserve moves money through the economy. Yet in most finance courses, bonds get a week of coverage before the syllabus moves on to equities.

After a conversation with an analyst at a well-respected hedge fund who told me that bonds are often considered the more abstract instrument compared to stocks, I realized how much I had been underestimating them.

My goal was simple: build something that forced me to understand bond pricing from the ground up, using real market data, not textbook assumptions.

The tool is built in Python across five modules and pulls live data from two sources: the Federal Reserve Economic Data API (FRED) for treasury yields and macroeconomic indicators, and Yahoo Finance for SPY price history.

On the pricing side, the tool implements the standard discounted cash flow formula for fixed-coupon bonds, interpolating discount rates from the live yield curve using NumPy for maturities where FRED does not publish a direct series. Beyond price, the tool computes Macaulay duration, modified duration, and convexity from the full cash flow schedule, and solves for yield-to-maturity numerically using Brent's method via SciPy.

The visualization layer generates four outputs: a live yield curve, an interactive Plotly bond pricing chart with a coupon rate slider, a decade of historical treasury yield data, and a 2x2 panel correlating treasury yields against unemployment, inflation, and the S&P 500. All macroeconomic series in the correlation panels are normalized to z-scores via scikit-learn's StandardScaler so that variables with very different raw scales can be compared directionally on the same chart.

The hardest piece was sourcing the discount rate correctly. FRED provides yield data only at benchmark maturities, so pricing a bond at any other maturity requires interpolation. Getting that interpolation to behave realistically, particularly when the yield curve is inverted or humped as it was at the time this project was built, took more iteration than expected.

The YTM calculation presented a similar challenge: there is no closed-form solution, so the tool uses Brent's method with a yield bracket of 0.0001 to 10.0. Understanding why that bracket needs to be set that way, and what happens at the boundaries, was a meaningful exercise in numerical methods.

The biggest scoping tradeoff was restricting the project to U.S. Treasury bonds. Corporate and municipal bonds introduce credit risk, liquidity premiums, and issuer-specific factors that would have required a fundamentally different data pipeline and pricing model. Keeping the scope to Treasuries made the analysis cleaner and kept the focus on the macroeconomic dynamics that were the real point of the project.