Bonds Function

BONDS() Description

The BONDS() function is designed for automatic retrieval of historical government bond data directly from the Yahoo Finance website (finance.yahoo.com) by a specified symbol (for example, TYX - 30-year bonds, TNX - 10-year bonds).

This function allows you to get yield and quotation data for treasury bonds directly in the Excel (LibreOffice Calc) spreadsheet, which is important for analyzing macroeconomic indicators and risks.

Main Characteristics of the BONDS Function

Syntax:

=BONDS(Symbol; [Date]; [Indicator])

Parameters:

• Symbol: Bond ticker symbol (for example, "TNX", "IRX"). Can also accept a range of values.
• [Date]: (Optional) Data retrieval date. The default is today's date.
• [Indicator]: (Optional) Indicator ("open", "high", "low", "close", "adjclose", "volume"). The closing price is used by default "close". Can also accept a range of values.

Usage Example

Example 1

The BONDS() function makes it easy to track changes in bond yields. You specify the instrument code, and Excel (Calc) imports the data:

=BONDS(Symbol; Date; Indicator)

We will have the following result:

In this example, the following values are used:

• Symbol: B5:B9 - Range of cells with bond codes (IRX, FVX, TNX, TYX, ZN=F).
• Date: B1 - The date for which data needs to be obtained ("2026-02-10").
• Indicator: C4:H4 - Range of cells with indicators (open, high, low, close, adjclose, volume).

Example 2

In this example, the following values are used:

• Symbol: B1 - Cell containing the bond code ("IRX").
• Date: A5 - Price setting date ("Feb 6, 2026").
• Indicator: G4 - Indicator (trading volume) ("volume").

Corresponding data from the website Yahoo Finance:

How Does It Work?

The BONDS() function can work both in normal mode and as an array function.

To use it as an array, simply enter the function into any cell, specifying the corresponding parameters. After that, you need to press Ctrl+Shift+Enter to enter the array formula, and LO Calc will automatically return a table with data.

To select all cells associated with the array formula, simply select any cell in the array and press Ctrl+/.

If you need to convert an array formula to values - select the entire array and in the Data > Calculate menu select Formula to Value.

When using a date as text, it must first be converted to a real date, for example: DATEVALUE("2026-01-25").

Ready-made templates

You can also use ready-made templates to get historical data, financial indicators, or a company profile.

To do this, go to the menu YLC Utilities > Template > Company screener and select one of the following reports:

• Profile data ("Profile data")
• Financial data ("Financial data")
• Statistical data ("Statistical data")
• Dividend data ("Dividend data")
• Historical data ("Historical data")

Download extension

You can use the function BONDS() by installing the extension YLC Utilities.

After that, this function will be available in all files that will be opened in Excel (LibreOffice Calc).