Statistics Function

STATISTICS() Description

The STATISTICS() function is designed to obtain company valuation metrics (valuation metrics) directly from the Yahoo Finance website (finance.yahoo.com) by the specified stock ticker (e.g., AAPL, NVDA) and selected data type.

This function allows you to analyze market capitalization, P/E ratios, profitability metrics, and other key statistical data directly in Excel (LibreOffice Calc) tables.

Key Characteristics of the STATISTICS Function

Syntax:

=STATISTICS(Ticker; [Indicator])

Parameters:

• Ticker: Stock ticker symbol of the company.
• [Indicator]: (Optional) Financial indicator: "marketCap", "trailingPE", "forwardPE", "priceToSalesTrailing12Months" and other indicators. When the value is "all" - returns all available statistical data. By default, returns market capitalization ("marketCap").

Example Usage

Example 1

The STATISTICS() function allows you to quickly get financial metrics. Just specify the ticker and parameter, and Excel (Calc) will load the data:

=STATISTICS(Ticker; Indicator)

We will get the following result:

In this example, the following values are used:

• Ticker: B3:B8 - Range of cells with stock tickers.
• Indicator: C2:H2 - Range of cells with indicators.

Example 2

In this example, the following values are used:

• Ticker: B1 - Cell containing the stock ticker ("AAPL").
• Indicator: B5:B13 - Range of cells with indicators.

Example 3

In this example, the following values are used:

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

How It Works?

The STATISTICS() 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 the array formula, simply select any array cell 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.

Download extension

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

After installation, the function will be globally available in your Excel (LibreOffice Calc).