Junk Bond ETF Tracker Excel: June 2026 Credit Spread Recession Signal Dashboard

Junk bond ETF tracker excel is what you need if you are trying to gauge credit risk in real time without paying for a Bloomberg terminal. The high yield bond market is one of the cleanest mirrors of corporate default risk, and the spread between BAA corporate yields and 10-year Treasuries has historically led equity drawdowns by months. This guide walks through how to build a working junk bond ETF tracker in Excel using live MarketXLS formulas, then explains the credit spread regimes that matter for portfolio positioning in June 2026.

The post pairs with a downloadable that covers 18 bond ETFs, computes live credit spreads, and includes a risk-tiered allocation builder.

Key Data Table - Current High Yield Snapshot

The table below shows the core junk bond ETF universe by category, expense profile, and current dividend yield. All values in the live template update through MarketXLS.

Sample values shown above reflect representative levels for June 2026. The downloadable template pulls live data through MarketXLS when opened in Excel with the add-in installed.

Why a Junk Bond ETF Tracker Excel Matters Right Now

High yield credit spreads are one of the most watched market indicators among institutional bond investors, and for good reason. The spread between BAA-rated corporate yields and 10-year Treasury yields has historically widened ahead of recessions, and the option-adjusted spread on the broader high yield index tends to blow out before equity bear markets bottom. June 2026 is a particularly interesting moment to be tracking this for several reasons.

First, the Federal Reserve is in a cautious posture as we head into the back half of the year. Effective fed funds sit in the low fours, and the bond market is pricing a slow glide path lower. Second, the labor market has cooled from its 2024 peaks without snapping. Initial claims are trending sideways, JOLTS openings have normalized, and wage growth has settled near 3.5 percent year-over-year. Third, corporate margins for high-yield issuers face pressure from refinancing at higher rates than the post-COVID era. These crosscurrents make a credit spread dashboard an essential part of a portfolio risk monitoring kit.

The point of the junk bond ETF tracker excel template is to put the math in front of you in one place. Instead of clicking through FRED, Yahoo Finance, and a handful of ETF issuer pages, you open one spreadsheet, see live prices on 18 bond ETFs, see live BAA and AAA corporate yields, see live Treasury rates, and watch the computed spreads update in real time.

The Credit Spread - What It Is and Why It Leads

A credit spread is the extra yield investors demand to hold a corporate bond instead of a Treasury bond of the same maturity. Wider spreads mean investors are pricing more default risk. Tighter spreads mean investors are comfortable taking credit risk for less compensation. The simplest version is the BAA-Treasury spread, calculated as Moody's BAA corporate yield minus the 10-year Treasury yield. In MarketXLS that is one line:

=BondYieldBAA("") - TreasuryRate10Y("")

This single number, expressed in basis points, has done more to forecast credit cycles than most economic models. When BAA-Treasury sits below 130 basis points, the market is complacent and carry trades dominate. When it pushes above 300 basis points, you are entering credit stress territory. Above 400 basis points historically coincides with recession or liquidity crisis.

The high yield equivalent uses the ICE BofA US High Yield Index option-adjusted spread, which is not directly priced in MarketXLS, but tracks closely with the relationship between HY ETF prices and Treasury ETF prices. The template uses BAA-Treasury as the cleanest live proxy because it has reliable historical context and is fully formula-driven.

Five Credit Spread Regimes

The template classifies the current spread environment into five regimes. Each regime has historically been associated with a different return profile across asset classes.

Tight - Below 130 basis points

This is the late-cycle, easy-liquidity environment. Volatility is low, carry trades work, and high yield typically delivers steady positive returns. The trap is that tight spreads have very little room to compress further, so the asymmetric payoff favors taking less risk. Historical examples include 2007 before the GFC, late 2018, and most of 2021.

Normal - 130 to 200 basis points

Mid-cycle expansion territory. High yield delivers its expected long-run return of roughly 5 to 7 percent. Defaults are running near long-run averages. This is where most of the 2013 to 2019 period sat.

Elevated - 200 to 280 basis points

A growth scare, a mid-cycle slowdown, or a sector-specific stress event. High yield often delivers a flat to mildly negative total return as price losses offset coupon income. 2015 to 2016 during the oil collapse and the first half of 2022 sit here.

Stress - 280 to 400 basis points

Credit cycle building, default rates accelerating, and spread widening becoming reflexive. High yield experiences double-digit drawdowns. The third quarter of 2008 and the first quarter of 2020 are textbook examples.

Blowout - Above 400 basis points

Recession, liquidity crisis, or systemic credit event. Defaults spike, rated downgrades cascade, and distressed debt becomes its own market. The fourth quarter of 2008 and the March 2020 COVID peak hit this regime.

The point of the regime classifier is not to time the market, it is to keep you honest about the risk premium being offered. When spreads are tight and your portfolio is overweight high yield, you are getting paid less to take on more risk. When spreads are wide and you are scared, the market is paying you more to step in. The template does not tell you what to do, it tells you where you are.

MarketXLS Implementation - The Core Formulas

The entire junk bond ETF tracker is built on a small number of MarketXLS functions. Below are the verified formulas that power the dashboard.

Live Bond ETF Data

=QM_Last("HYG")              Live HYG price
=DividendYield("HYG")        Trailing dividend yield in percent
=FundExpenseRatio("HYG")     ETF expense ratio
=FundTotalAssets("HYG")      Total fund assets
=SimpleMovingAverage("HYG", 50)  50-day SMA
=Beta("HYG")                 Beta versus the broad market
=RSI("HYG")                  14-day Relative Strength Index

Live Corporate Bond Yields

=BondYieldAAA("")            Moody's AAA corporate yield
=BondYieldBAA("")            Moody's BAA corporate yield
=CorporateBondIndexAA("")    ICE BofA AA US Corporate Index
=CorporateBondIndexBBB("")   ICE BofA BBB US Corporate Index

Treasury Yields and Macro

=TreasuryRate3M("")          3-month Treasury yield
=TreasuryRate1Y("")          1-year Treasury yield
=TreasuryRate5Y("")          5-year Treasury yield
=TreasuryRate10Y("")         10-year Treasury yield
=TreasuryInflationProtectedSecurities10Y("")  10Y TIPS yield
=FederalFundsRate("")        Effective federal funds rate
=ConsumerPriceIndex("")      CPI index level

Computed Spreads

The credit spread calculations themselves are just arithmetic on top of the yield series.

BAA Treasury Spread:  =BondYieldBAA("") - TreasuryRate10Y("")
AAA Treasury Spread:  =BondYieldAAA("") - TreasuryRate10Y("")
IG Quality Spread:    =BondYieldBAA("") - BondYieldAAA("")
BBB Spread:           =CorporateBondIndexBBB("") - TreasuryRate10Y("")
Yield Curve 10Y-3M:   =TreasuryRate10Y("") - TreasuryRate3M("")
10Y Breakeven CPI:    =TreasuryRate10Y("") - TreasuryInflationProtectedSecurities10Y("")

That handful of formulas drives every cell in the spreads, recession signal, and macro sheets. Once you have them in place, the entire dashboard updates with one recalculation.

Inside the Template - Sheet by Sheet

The downloadable workbook has six sheets, each focused on a specific lens.

Sheet 1 - How To Use

A short tutorial explaining the purpose, each sheet, and the MarketXLS formulas that drive the workbook. Includes a "Data as of" stamp on the sample version and a live-template banner on the formula version.

Sheet 2 - Main Dashboard

Eighteen ETFs spanning the high yield, investment grade, and Treasury categories. Each row shows ticker, category, live price, dividend yield, expense ratio, total assets, 50-day SMA, and beta. Yellow input cells at the top let you enter portfolio size, risk tolerance on a 1 to 5 scale, a spread alert threshold, and minimum AUM and maximum expense ratio filters.

The category labels are important. They group the ETFs into:

• High Yield Core - HYG, JNK, USHY for broad market exposure
• Short HY 0-5Y - SHYG, SJNK, HYS for lower-duration carry
• Fallen Angels - ANGL, FALN for downgraded investment-grade names
• HY Factor - HYDB for a quality screen on HY
• Broad HY - HYLB for the Xtrackers low-cost wrap
• Senior Loans - BKLN, SRLN for floating-rate, senior secured
• Investment Grade - LQD, VCIT, IGSB as the IG benchmark
• Treasury - TLT, IEF, SHY across the curve

Sheet 3 - Credit Spreads

The yield series and all the computed spreads. This is the engine room of the dashboard. Every value pulls from a MarketXLS function, with the formula text printed alongside so you can audit the math. Cells include BAA-Treasury, AAA-Treasury, BAA-AAA, BBB-Treasury, Fed Funds-Treasury inversion check, and the 10-year breakeven inflation calculation.

Sheet 4 - Recession Signal

The regime map from tight to blowout, with BAA-Treasury range, HY OAS range, macro context, equity tape behavior, credit tape behavior, and historical examples for each regime. A live classifier at the bottom uses nested IF logic to label the current regime based on the live BAA-Treasury spread.

=IF(B<130, "Tight / Complacent",
 IF(B<200, "Normal",
  IF(B<280, "Elevated",
   IF(B<400, "Stress", "Blowout"))))

Sheet 5 - Allocation Builder

A risk-tiered allocation matrix mapping risk tolerance 1 through 5 to suggested weights across high yield, investment grade, Treasury, and cash. INDEX and MATCH formulas pull the right tier based on the input cell. A live calculator then converts percentage allocations into dollar amounts using the portfolio size input.

The tiers are educational. They are not investment advice and do not account for individual circumstances. They simply show how a more conservative bond mix differs from a more aggressive carry-seeking one.

Sheet 6 - Yield Curve and Macro

Live Treasury curve from 3-month to 10-year, plus TIPS yields, fed funds, CPI levels, and crude oil. The curve slope diagnostics include 10Y minus 3M, 10Y minus 5Y, Fed Funds minus 10Y, and the 10Y breakeven inflation calculation. Use this sheet alongside the credit spreads sheet to assess the overall risk environment.

How to Read the Dashboard - A Worked Example

Imagine you open the template on a quiet Wednesday in June 2026 and the live values show:

• HYG price up 0.15 percent on the day, 0.8 percent above its 50-day SMA
• JNK and USHY similar
• LQD flat
• TLT down 0.3 percent
• BondYieldBAA at 6.05 percent
• TreasuryRate10Y at 4.18 percent
• BAA-Treasury spread = 6.05 - 4.18 = 1.87 percent = 187 basis points

The regime classifier returns "Normal" because 187 sits in the 130-200 band. The macro overlay shows the 10Y minus 3M curve at slightly negative, breakeven inflation near 2.2 percent, and fed funds 15 basis points above the 10-year. None of those flash a stress signal on their own.

Now suppose three weeks later you reopen the template and BAA-Treasury has widened to 225 basis points while HY ETF prices have dropped 2 percent across the board. The regime classifier flips to "Elevated" and your allocation builder, set at risk tolerance 4, is still showing a 25 percent HY weight. That is the moment to ask whether your portfolio mix still reflects your conviction. Maybe you trim, maybe you hold, maybe you add. The template does not decide for you. It puts the data in front of you with the math made explicit.

Common Pitfalls When Tracking Junk Bond ETFs

A few warnings from people who have built these dashboards before.

ETF price does not equal index OAS. The price of HYG reflects current yields plus duration risk plus liquidity premium plus any tracking drift from the underlying index. When spreads widen, HY ETF prices fall, but the relationship is not perfectly linear. Use prices for trend, use the BAA-Treasury spread for the cleanest read on credit risk.

Distribution yields lag. DividendYield reports the trailing 12-month distribution divided by current price. After a sharp HY rally, this can understate the forward yield to maturity. After a selloff, it can overstate it. Treat distribution yield as an income-stream indicator, not a forward return estimate.

Senior loans behave differently. BKLN and SRLN are floating rate. When the Fed is cutting, their yields drop with the policy rate. When the Fed is hiking, they benefit. The carry profile is very different from fixed-rate HY ETFs, and the credit quality skew is also different. Do not blend them with fixed-rate HY without thinking through duration and rate sensitivity.

Fallen angels are not the same as broad HY. ANGL and FALN focus on bonds downgraded from investment grade. These tend to have higher average credit quality than the broad HY index, so they typically underperform in HY rallies and outperform in HY selloffs. They are a quality tilt, not a high-beta play.

Building a Watchlist Without the Template

If you prefer to build your own version from scratch, the recipe is straightforward. Open Excel with the MarketXLS add-in installed, set up a column for tickers, then use the formula list above. Within an hour you have a working dashboard. The template is just a head start with sensible defaults, formatting, and pre-built spread calculations.

For a richer build, layer on historical context using QM_GetHistory and chart the BAA-Treasury spread over time alongside the S&P 500 drawdowns. The visual relationship is striking and is one reason credit spreads are taken so seriously by macro investors.

You can also extend the macro sheet with additional MarketXLS series. ConsumerPriceIndex, ConsumerPriceIndexWithoutFoodEnergy, FederalDebt, and FederalSurplusOrDeficit are all available as live functions. Each adds a piece of the macro picture without leaving the spreadsheet. See the MarketXLS feature catalog for the full set of supported functions.

Frequently Asked Questions

What is a junk bond ETF?

A junk bond ETF holds a basket of corporate bonds rated below investment grade, meaning BB+ and lower by S&P or Ba1 and lower by Moody's. These bonds carry higher default risk than investment-grade corporate bonds, which is why they offer higher yields. The largest examples are iShares HYG and SPDR JNK, each with multi-billion dollar AUM and high daily trading volume.

How do I track credit spreads in Excel without a Bloomberg terminal?

Credit spreads are calculated as the difference between a corporate bond yield and a Treasury yield of similar maturity. With MarketXLS you can use =BondYieldBAA("") for the Moody's BAA corporate yield and =TreasuryRate10Y("") for the 10-year Treasury yield, then subtract them. The result is the BAA-Treasury spread in percent. Multiply by 100 to get basis points.

Which junk bond ETFs should I include in a tracker?

A balanced tracker should cover the large-cap HY index trackers (HYG, JNK, USHY), short-duration HY (SHYG, SJNK), fallen angels (ANGL, FALN), and the senior loan complement (BKLN, SRLN). Adding investment-grade benchmarks like LQD and Treasury benchmarks like TLT and IEF gives you the relative-value lens that turns a price screen into a spread tracker.

Are wide credit spreads a buy signal?

Historically, very wide credit spreads have preceded strong forward returns in high yield. The challenge is that spreads can widen further before they tighten, and the path through a stress regime can be brutal. The educational view is that spread regimes describe the risk-reward being offered, not a deterministic timing signal. Position sizing matters more than entry timing.

What is the difference between BAA-Treasury and high yield OAS?

BAA-Treasury uses Moody's BAA corporate bond yield, which is the lowest tier of investment grade. High yield OAS uses the ICE BofA US High Yield Index option-adjusted spread, which is broader and more sensitive to default risk. The two tend to move together but high yield OAS has more volatility and bigger blowouts. BAA-Treasury is the more conservative, longer-history version of the indicator.

How often should I refresh the tracker?

For active monitoring, weekly is sufficient for the credit spread reading. Daily makes sense if you are running an active high-yield sleeve or watching for regime changes. The live MarketXLS formulas refresh whenever you open the workbook with the add-in installed, so the work is essentially zero once the template is built.

The Bottom Line

A junk bond ETF tracker excel is one of the highest-leverage dashboards you can build for fixed-income monitoring. It takes a small set of MarketXLS formulas, organizes them around the credit spread that has historically led recessions, and puts the math in front of you in one place. The June 2026 setup is genuinely interesting. Spreads are sitting in the normal range, the Fed is patient, the labor market has cooled without snapping, and high yield ETF prices are grinding higher. None of that means risk is gone. It means the risk is mostly priced in. The point of the dashboard is to be the first to notice when that changes.

Download the templates:

• - Pre-filled with current data
• - Live-updating formulas

To explore more bond market and macro tools, visit MarketXLS for the full set of fixed income and macro functions. If you want to see the dashboard in action with a guided walkthrough, book a demo and we will show how to wire MarketXLS into your existing portfolio model.

This post is for educational purposes only. It is not financial advice, not a recommendation to buy or sell any security, and not a guarantee of future results. Past credit spread behavior does not guarantee future returns. Always consult a qualified financial advisor before making investment decisions.