Commodity Function

COMMODITY() Description

The COMMODITY() function is designed to automatically obtain commodity prices directly from the website Yahoo Finance (finance.yahoo.com) by the specified exchange symbol (for example, GC, SI) and selected date. It supports both historical quotes and current real-time values.

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

Main Characteristics of the COMMODITY Function

Syntax:

=COMMODITY(Symbol; [Date]; [Indicator])

Parameters:

• Symbol: Exchange symbol of the commodity.
• [Date]: (Optional) Date of price setting. By default, today's date is used.
• [Indicator]: (Optional) Indicator of commodity price or trading volume ("open", "high", "low", "close", "volume"). By default, the closing price is used, i.e., the value "close".

Example of Use

Example 1

The COMMODITY() function is easy to use. You just need to specify a cell with the commodity code and Excel (Calc) automatically imports its exchange price for the specified date:

=COMMODITY(Symbol; Date)

We will get the following result:

The following values are used in this example:

• Symbol: B2 - The cell containing the commodity code (gold) ("GC").
• Date: C1 - Date of price setting ("Aug 1, 2025").

Example 2

The following values are used in this example:

• Symbol: B1 - The cell containing the commodity code ("GC").
• Date: A5 - Date of price setting ("Aug 1, 2025").
• Indicator: G4 - Value type (trading volume) ("volume").

Corresponding data from the website Yahoo Finance:

Download extension

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

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