The FTSE100() function is designed to automatically retrieve stock prices of companies from the "FTSE 100" index traded on the London Stock Exchange directly from the Yahoo Finance website (finance.yahoo.com) by specified ticker symbol (for example, BA, SHEL) 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.
=FTSE100(Ticker; [Date]; [Indicator])
The FTSE100() function is easy to use. You just need to specify a cell with the stock code and Excel (Calc) will automatically import its price for the given date:
=FTSE100(Ticker; Date)
We will get 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 FTSE100() function can work both in standard mode and as an array function.
To use it as an array, simply enter the function into any cell, specifying the appropriate parameters. After that, press Ctrl+Shift+Enter to enter an array formula, and LO Calc will automatically return a table with data.
To select all cells associated with an array formula, simply select any array cell 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 the corresponding index or exchange.
To do this, go to the menu
You can use the FTSE100() function by installing the YLC Utilities extension.
After this, the function will be available in all files opened in Excel (LibreOffice Calc).
