Options Function

OPTIONS() Description

The OPTIONS() function is designed for automatically obtaining historical data for options directly from the Yahoo Finance website (finance.yahoo.com) by a specified contract symbol (for example, SPY260205P00680000).

This function allows you to obtain prices and other option indicators directly in the Excel (LibreOffice Calc) table, which significantly simplifies the analysis of derivatives and the construction of complex financial models.

Main Characteristics of the OPTIONS Function

Syntax:

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

Parameters:

• Symbol: Full stock symbol of the option contract. Can accept a range of values.
• [Date]: (Optional) Date of receiving data. By default, today's date is used.
• [Indicator]: (Optional) Indicator ("open", "high", "low", "close", "adjclose", "volume"). By default, the closing price "close" is used. Can accept a range of values.

Example of Usage

Example 1

The OPTIONS() function automatically downloads data for a specific contract. You only need to specify the option symbol, and Excel (Calc) imports the data:

=OPTIONS(Symbol; Date; Indicator)

We will have the following result:

In this example, the following values are used:

• Symbol: A5:A9 - Range of cells with option symbols ("SPY2602...","SLB2602...","LQD2603...","XLF2603...","SPY2602...").
• Date: B1 - Date for which the indicators need to be obtained. ("2026-02-05").
• Indicator: B4:G4 - Range of cells with indicators (open, high, low, close, adjclose, volume).

Example 2

In this example, the following values are used:

• Symbol: B1 - Cell with the option symbol ("SPY260205P00680000").
• Date: A5 - Price setting date ("Feb 5, 2026").
• Indicator: G4 - Indicator (trading volume) ("volume").

Corresponding data from the Yahoo Finance website:

How Does It Work?

The OPTIONS() 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 data table.

To select all cells related to the array formula, simply select any array cell 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 OPTIONS() function by installing the YLC Utilities extension.

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