Statistics Function

STATISTICS() Description

The STATISTICS() function is designed to get valuation metrics 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 allows analyzing market capitalization, P/E ratios, profitability metrics, and other key statistical data directly in Excel (LibreOffice Calc) spreadsheets.

Key Features of the STATISTICS Function

Syntax:

=STATISTICS(Ticker; [Indicator])

Parameters:

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

Usage Example

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 have the following result:

The following values are used in this example:

• Ticker: B3:B8 - Cell range with stock tickers.
• Indicator: C2:H2 - Cell range with indicators.

Example 2

The following values are used in this example:

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

Example 3

The following values are used in this example:

• 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 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 Data > Calculate menu select Formula to Value.

Ready Templates

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

To do this, go to the YLC Utilities > Template > Company screener menu 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 STATISTICS() function by installing the YLC Utilities extension.

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