The PROFILE() function is designed to get company data directly from the Yahoo Finance website (finance.yahoo.com) by the specified ticker symbol (for example, AAPL, NVDA) and the selected data type.
This function is convenient for creating stock trackers in Excel (LibreOffice Calc) spreadsheets and will be useful for investors, traders, and financial analysts.
=PROFILE(Ticker; [DataType])
The PROFILE() function is easy to use. You only need to specify the cell with the company stock code and the type of data required, and Excel (Calc) will automatically import the specified company information:
=PROFILE(Ticker; DataType)
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 website Yahoo Finance:
The PROFILE() function can work both in normal mode and as an array function.
To use it as an array, simply enter the function in any cell, specifying the appropriate parameters. After that, you must press Ctrl+Shift+Enter to enter the array formula, and LO Calc will automatically return a table with the data.
To select all cells associated with the array formula, simply select any cell of the array and press Ctrl+/.
If you need to convert an array formula to values - select the entire array and in the
You can use the PROFILE() function by installing the YLC Utilities extension.
After that, this function will be available in all files that are opened in Excel (LibreOffice Calc).
