Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Understanding Yield Curve (Trading Strategy & Yield Curve Control)

Written by Rishav Khaitan on 
Wed Jul 14 2021
 about MarketXLS
Understanding Yield Curve (Trading Strategy & Yield Curve Control) - MarketXLS
Boost your market advantage with MarketXLS. Real-time, enterprise-grade data. Book a demo or subscribe now!
Understanding Yield Curve (Trading Strategy & Yield Curve Control) - MarketXLS

Yield to maturity (YTM) is the effective rate of return that fixed-income securities earn if held to maturity. It depends on the issue price & coupon rate of the securities. A Yield Curve is formed by plotting the YTM of bills/notes/bonds across different maturity periods. It can be for both:

  1. Treasury Instruments 
  2. Specified Credit Rating Corporate Bond

However, it is important to note that the yield curve is different from the term structure (spot rates), which is calculated using the bootstrapping method (discussion for some time later).

The shape of a yield curve can be of three types:

  • Positively sloped (Normal)- Normally, yield curves are positively sloped where the yield for shorter maturity is less than that for longer maturities. The premium on longer maturities exists due to larger uncertainty over the longer time period, which is termed as Liquidity Premium Theory. This is when people expect the short-term interest rates to rise over the period.
  • Flat – The fed rates largely influence the shorter maturity side of the graph. So, if the Federal Reserve increases the short-term rates or the buy traffic in the longer-term maturities increases, the slope of the curve reduces. This phenomenon is called flattening of the curve.
  • Negative Sloped (Inverted)- Further push on short-term rates by the Federal Reserve and higher traffic on long-term maturity leads to a negative slope which is called an inverted yield curve

A prolonged inversion of the treasury yield curve for months has been argued to be a leading indicator of upcoming recession within the next 1-1.5 years in the US market for the last 50 years. The graph below shows the spread between 3-month and 10-year treasury yields.

In the above picture, the white circles highlight the phases when the discussed spread is negative and the red region highlights the following periods of recession.

The movement in the yield curve can be of 3 different natures:

  • Level (Parallel Shift) – When there is an almost equal increase/decrease in the yield across various maturity periods, the yield curve shifts parallelly.
  • Slope (Steepening or Flattening) – When there is an unequal change in the yield curve across maturity periods.
  • Curvature- When the short-term & long-term yields change with a greater magnitude than that of the mid-term. 

The curvature of a yield curve is measured by butterfly spread.

Butterfly Spread = [2x Medium (10 yr) Term Yield] – Short (2 yr) Term Yield – Long (30 yr) Term Yield

Riding the Yield Curve Strategy

In this strategy, it is assumed that the yield curve is positively sloped and remains constant. Suppose an investor needs to invest in bonds for, say, 3 years. Instead of buying a bond of 3 years maturity, one would buy 10 years maturity.

So, after 3 years, the remaining maturity of the bond will be 7 years, and the yield will be at 4.9%, i.e., lesser than 5.5%. As we know, rates of interest and bond prices are inversely related, there will be capital appreciation in the price of the 10-year bond, and thus the investor will earn more than the initial 4.4% in case of buying a 3-year bond.

However, the downside to this strategy is that by buying 10 yr bond instead of 3yr bond, the duration of the portfolio increases, which makes it more sensitive to interest rate changes.

Yield Curve Control

When the bond yields are set by the central bank in the form of an unconventional monetary policy, it is called Yield Curve Control. The Fed targets an interest rate at a specific maturity by buying the necessary quantity of debt and pegs the yield at the decided level. It is different from quantitative easing, where the target is not a specific interest rate but a specific quantity of bonds.

In 2016, the Bank of Japan pegged the yield of the 10-year Japanese Government Bonds at 0% with a fluctuation band of 10 basis points. The band was widened to 20 basis points in 2018.

The Bottom Line

The current outstanding value of the fixed income instruments issued by the Govt as well as private bodies in the United States market is valued at ~$50 trillion as of Dec’2020. In the last 12 months, more than $800 billion worth of instruments has been issued every month. The yield curve is one of the most important aspects of fixed income instruments and is also widely used in inferring the direction of the economy.


All trademarks referenced are the property of their respective owners. Other trademarks and trade names may be used in this document to refer to either the entity claiming the marks and names or their products. MarketXLS disclaims any proprietary interest in trademarks and trade names other than its own, or affiliation with the trademark owners.
None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person. The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein. The article is written for helping users collect the required information from various sources deemed to be an authority in their content. The trademarks if any are the property of their owners and no representations are made.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu


I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.


Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord