Function Options

OPTIONS() Description

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

This function allows you to get prices and other options 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 ticker symbol of the option contract. Can accept a range of values.
• [Date]: (Optional) Date of data acquisition. 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.

Usage Example

Example 1

The OPTIONS() function automatically downloads data for a specific contract. You just need to specify the option symbol, and Excel (Calc) will import 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 indicators are needed. ("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 It Works?

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

To use 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 of 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.

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

Ready-made templates

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

To do this, go to the YLC Utilities > Template > Company screener menu and choose 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 the 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).