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 stock symbol (for example, AIR, BNP) and selected date. It supports both historical quotes and current 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.

Key Features of the CAC_40 Function

Syntax:

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

Parameters:

• Ticker: Stock ticker symbol or "INDEX".
• [Date]: (Optional) Date of price setting. 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 CAC_40() function is simple to use. You just need to specify the cell with the stock code and Excel (Calc) automatically imports its price for the specified date:

=CAC_40(Ticker; Date)

We will get the following result:

The following values are used in this example:

• Ticker: B3 - Cell containing the stock code ("AIR").
• Date: C1 - Date of price setting ("Aug 1, 2025").

Example 2

The following values are used in this example:

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

Corresponding data from Yahoo Finance website:

Download extension

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

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