Bonds Function

BONDS() Description

The BONDS() function is designed to automatically obtain historical data on government bonds directly from the Yahoo Finance website (finance.yahoo.com) using the specified symbol (for example, TYX - 30-year bonds, TNX - 10-year bonds).

This function allows you to receive data on the yield and quotes of treasury bonds directly in the Excel (LibreOffice Calc) table, 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"). It can also accept a range of values.
• [Date]: (Optional) Date of data retrieval. By default, today's date is used.
• [Indicator]: (Optional) Indicator ("open", "high", "low", "close", "adjclose", "volume"). By default, the closing price "close" is used. It can also accept a range of values.

Usage Example

Example 1

The BONDS() function allows you to easily 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 the 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 Yahoo Finance website:

How It Works?

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

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

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

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

Download Extension

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

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