Profile Function

PROFILE() Description

The PROFILE() function is designed to obtain company data directly from the Yahoo Finance website (finance.yahoo.com) by the specified stock symbol (for example, AAPL, NVDA) and the selected data type.

This function is convenient for creating stock trackers in Excel (LibreOffice Calc) tables and will be useful for investors, traders, and financial analysts.

Key Features of the PROFILE Function

Syntax:

=PROFILE(Ticker; [DataType])

Parameters:

• Ticker: Stock ticker symbol of the company.
• [DataType]: (Optional) Data type: "longName", "industry", "sector", "website" and others. With the value "all" - it returns all possible data. By default, the company name is used ("longName").

Usage Example

Example 1

The PROFILE() function is easy to use. You just need to specify the cell with the company stock code and the type of required data, and Excel (Calc) will automatically import the specified information about the company:

=PROFILE(Ticker; DataType)

We will have the following result:

The following values are used in this example:

• Ticker: B1 - Cell containing the stock ticker ("AAPL").
• DataType: B2 - Display all data ("all").

Example 2

The following values are used in this example:

• Ticker: A5:A8 - Range of cells with stock tickers (AAPL, NVDA, MSFT, ORCL).
• DataType: B1 - Data type ("industry").

Corresponding data from the Yahoo Finance website:

How It Works?

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 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 the array formula, simply select any cell in the array and press Ctrl+/.

If you need to convert an array formula to values, select the entire array and in the menu Data > Calculate select Formula to Value.

Ready Templates

You can also use ready-made templates to obtain historical data, financial metrics, or a company profile.

To do this, go to the menu YLC Utilities > Template > Company screener and choose one of the following reports:

• Profile data ("Profile data")
• Financial data ("Financial data")
• Statistical data ("Statistical data")
• Dividend data ("Dividend data")
• Historical data ("Historical data")

Download Extension

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

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