The FINANCIALS() function is designed for automatic retrieval of company financial statements directly from the Yahoo Finance website (finance.yahoo.com) using the specified stock ticker (e.g., AAPL, NVDA).
This function allows you to download income statement, balance sheet and cash flow statement for a specific period directly into Excel (LibreOffice Calc) tables.
=FINANCIALS(Ticker; Statement; [Freq]; [Header]; [Indicator]; [Date])
The FINANCIALS() function automates the collection of fundamental data. You specify the stock code, and Excel (Calc) imports the corresponding financial indicators:
=FINANCIALS(Ticker; Statement; Freq)
We will get the following result:
In this example, the following values are used:
In this example, the following values are used:
In this example, the following values are used:
The FINANCIALS() function can work both in normal 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, you need to press Ctrl+Shift+Enter to enter the array formula and LO Calc will automatically return a table with data.
To select all cells associated with an array formula, simply select any cell in the array and press Ctrl+/.
If it is necessary 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 use the FINANCIALS() 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).
