FTSE100 Function

FTSE100() Description

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

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

Main Characteristics of the FTSE100 Function

Syntax:

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

Parameters:

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

Example of Use

Example 1

The FTSE100() function is easy to use. You just need to specify the cell with the stock code and Excel (Calc) automatically imports 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 of price setting ("Aug 1, 2025").

Example 2

In this example, the following values are used:

• Ticker: B1 - Cell containing the stock code ("SHEL").
• Date: A5 - Date of price setting ("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 that, this function will be available in all files that will be opened in Excel (LibreOffice Calc).