Function CAC_40

CAC_40() Description

The CAC_40() function is designed for automatic retrieval of stock prices of companies from the 'CAC 40' index, traded on the exchange "EURONEXT" directly from the website Yahoo Finance (finance.yahoo.com) by the specified ticker symbol (e.g., AIR, BNP) and selected date. It supports both historical quotes and current real-time values.

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

Main Features of the Function CAC_40

Syntax:

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

Parameters:

• Ticker: Stock ticker symbol or "INDEX".
• [Date]: (Optional) Price settlement 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".

Example Usage

Example 1

The CAC_40() 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:

=CAC_40(Ticker; Date)

We will get the following result:

In this example, the following values are used:

• Ticker: B3 - Cell containing the stock code ("AIR").
• Date: C1 - Price settlement date ("Aug 1, 2025").

Example 2

In this example, the following values are used:

• Ticker: B1 - Cell containing the stock code ("AIR").
• Date: A5 - Price settlement date ("Aug 1, 2025").
• Indicator: G4 - Value type (trading volume) ("volume").

Corresponding data from the website Yahoo Finance:

Download extension

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

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