DAX Function

DAX() Description

The DAX() function is designed to automatically obtain stock prices of companies from the "DAX" index traded on the Frankfurt Stock Exchange directly from the Yahoo Finance website (finance.yahoo.com) by the specified ticker symbol (for example, SAP, SIE) and a selected date. It supports both historical quotes and current real-time values.

This function is convenient for creating stock trackers in Excel (LibreOffice Calc) spreadsheets and will be useful for investors, traders, and financial analysts working with the German stock market.

Main Characteristics of the DAX Function

Syntax:

=DAX(Ticker; [Date]; [Indicator])

Parameters:

• Ticker: Stock ticker symbol (for example, "SAP", "BMW" or "SAP.DE", "BMW.DE"). You can also get the value of the entire index ("INDEX").
• [Date]: (Optional) Date of price setting. By default, today's date is used.
• [Indicator]: (Optional) Stock price indicator or its trading volume ("open", "high", "low", "close", "adjclose", "volume"). By default, the closing price is used, i.e., the "close" value.

Usage Example

Example 1

The DAX() function is easy to use. You just need to specify the cell with the stock code, the date, and the desired indicator, and Excel (Calc) will automatically import its price on the specified date:

=DAX(Ticker; Date; Indicator)

We will have the following result:

In this example, the following values are used:

• Ticker: B3 - Cell range with ticker symbols (INDEX, SAP, SIE, BMW, ADS).
• Date: C1 - Date of price setting ("Aug 1, 2025").
• Indicator: C4:H4 - Cell range with indicators (open, high, low, close, adjclose, volume).

Example 2

In this example, the following values are used:

• Ticker: B1 - Cell containing the stock code ("SAP").
• Date: A5 - Date of price setting ("Aug 1, 2025").
• Indicator: G4 - Value type (trading volume) ("volume").

Corresponding data from the Yahoo Finance website:

How It Works?

The DAX() function can work both in normal mode and as an array function.

To use it as an array, just 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 you need to convert an array formula into values - select the entire array and in the Data > Calculate menu select Formula to Value.

Download extension

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

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