The CAC_40() function is designed to automatically retrieve stock prices of companies from the 'CAC 40' index traded on the "EURONEXT" exchange directly from the Yahoo Finance website (finance.yahoo.com) by the specified ticker 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.
=CAC_40(Ticker; [Date]; [Indicator])
The CAC_40() function is simple to use. You just need to specify a cell with the stock code, and Excel (Calc) will automatically import its price for the specified date:
=CAC_40(Ticker; Date)
We will have the following result:
The following values are used in this example:
The following values are used in this example:
Corresponding data from the Yahoo Finance website:
The CAC_40() 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 appropriate parameters. After that, press Ctrl+Shift+Enter to enter the array formula, and LO Calc will automatically return a data table.
To select all cells associated with an array formula, simply select any cell in the array and press Ctrl+/.
If you need to convert an array formula into values, select the entire array and in the menu
When using a date as text, it must first be converted into a real date, for example:
You can also use ready-made templates to get a stock watchlist for a specific index or exchange.
To do this, go to the menu
You can use the CAC_40() function by installing the YLC Utilities extension.
After that, this function will be available in all files opened in Excel (LibreOffice Calc).
