How to Add the US 10-Year Treasury Yield in Excel Stocks
Question details
The user wants to retrieve and display the US 10-Year Treasury yield within an Excel spreadsheet using the built-in Stocks data type.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Tracking market data and analyzing financial trends by importing live or delayed bond yields directly into a spreadsheet.
- Observed behavior
- The user needs to know the correct market symbol to pull Treasury yield data, noting that the returned value often reflects the previous day's closing yield.
Ensure you have an active internet connection and are signed into a Microsoft 365 subscription, as the Stocks data type requires these to fetch connected market data.
Use the US10Y Ticker Symbol with the Stocks Data Type
By inputting the correct market symbol and utilizing Excel's native Stocks data type, you can easily pull Treasury yield information into your workbook.
Excel relies on external financial data providers to populate the Stocks data type. For the US 10-Year Treasury Yield, the specific ticker symbol required is US10Y.
Click on an empty cell in your spreadsheet and type 'US10Y' (without the quotation marks).
Select the cell containing your text, navigate to the 'Data' tab on the top ribbon, and click on 'Stocks' within the Data Types group.
Once the cell converts (indicated by a small bank or building icon), click the 'Insert Data' icon that appears to the top right of the cell, and select 'Price' or other relevant fields to populate adjacent cells.
Manage Your Financial Spreadsheets with WPS Office
While the specific Stocks data type is a Microsoft 365 exclusive feature, WPS Office provides a powerful, free alternative for managing all your financial data, importing CSVs, and executing complex market calculations.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the software: Run the installer and follow the straightforward on-screen instructions to complete the setup.
- 3. Open your financial documents: Launch WPS Spreadsheet and seamlessly open your existing .xlsx financial tracking files without losing formatting.
Frequently Asked Questions
Why does my Treasury yield show yesterday's value?
Excel retrieves the Treasury yield similar to how it tracks a stock. Because the finalized yield for the current day isn't officially known until the close of business, the data feed often displays the previous day's closing yield during active trading hours.
What is the correct ticker symbol for the US 10-Year Treasury Yield in Excel?
The correct market symbol to use with the Excel Stocks data type is US10Y.
Can I get historical data for the 10-Year Treasury Yield using Excel?
Yes, if you have Microsoft 365, you can use the STOCKHISTORY function in combination with the US10Y ticker symbol to retrieve past yields over a specified date range.
