FTSE100 Function

FTSE100() Description

The FTSE100() function is designed for automatic retrieval of stock prices of companies from the index "FTSE 100", traded on the London Stock Exchange directly from the Yahoo Finance website (finance.yahoo.com) by the specified stock ticker (e.g., BA, SHEL) and selected date. It supports both historical quotes and real-time current values.

This function is convenient for creating stock trackers in spreadsheets Excel (LibreOffice Calc) and will be useful for investors, traders, and financial analysts.

Key Features of the FTSE100 Function

Syntax:

=FTSE100(Ticker; [Date]; [Indicator])

Parameters:

• Ticker: Stock ticker or "INDEX".
• [Date]: (Optional) Price setting date. By default, today's date is used.
• [Indicator]: (Optional) Stock price indicator or its trading volume ("open", "high", "low", "close", "adjclose", "volume"). By default, the closing price is used, i.e., the value "close".

Usage Example

Example 1

The FTSE100() function is easy to use. You just need to specify the cell with the stock code and Excel (Calc) will automatically import its price for the specified date:

=FTSE100(Ticker; Date)

We will get the following result:

In this example, the following values are used:

• Ticker: B3 - Cell containing the stock code ("SHEL").
• Date: C1 - Date for price retrieval ("Aug 1, 2025").

Example 2

In this example, the following values are used:

• Ticker: B1 - Cell containing the stock code ("SHEL").
• Date: A5 - Date for price retrieval ("Aug 1, 2025").
• Indicator: G4 - Value type (trading volume) ("volume").

Corresponding data from the website Yahoo Finance:

Download Extension

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

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