Corporate Bond Index - BBB
Returns the yield or index value for BBB-rated corporate bonds, representing the lower tier of investment-grade corporate debt.
Data Source
Federal Reserve / ICE BofA indices via FRED.
Usage Notes
- No parameters required
- Returns yield as a percentage
- Data updated daily
- BBB is lowest investment grade (one notch above junk)
Credit Rating Context
| Rating | Quality | Investment Grade |
|---|---|---|
| AAA/AA | High | Yes |
| A | Upper Medium | Yes |
| BBB | Medium | Yes (lowest IG) |
| BB and below | Speculative | No (High Yield/Junk) |
BBB Significance
BBB bonds are important because:
- Largest segment of investment-grade market
- One downgrade away from "junk" status
- Watched closely during economic stress
Syntax
=CorporateBondIndexBBB()Returns
number
BBB-rated corporate bond index value or yield
Examples
BBB corporate bond yield (%)
When to Use
- Tracking lower investment-grade yields
- Credit cycle analysis
- Risk premium monitoring
- Fallen angel risk assessment
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need AA-rated bonds | CorporateBondIndexAA() |
| Need AAA yields | BondYieldAAA() |
| Need BAA yields | BondYieldBAA() |
Common Issues & FAQ
What's the difference between BBB and BAA?
BBB (S&P/Fitch) and Baa (Moody's) are equivalent ratings. Both represent the lowest investment-grade tier.
Why are BBB bonds important?
BBB bonds are the largest segment of investment-grade debt. If downgraded to junk, many funds must sell them, causing price disruption.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- Corporate Profits After Tax
- Crude Oil Prices
- Currency In Circulation
- Dow Jones Industrial Average
- Employees - Goods Producing
- Employees - Government
- Employees - Nonfarm Payroll
- Employees - Private
See CorporateBondIndexBBB used in a complete workbook: Junk Bond ETF Tracker Excel: June 2026 Credit Spread Recession Signal Dashboard
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?