- In short
- Writes the price history of the commodity you choose into your worksheet as a table. Brent crude, WTI crude and Henry Hub natural gas come from the U.S. Energy Information Administration (EIA); gold and silver come from the Borsa İstanbul Precious Metals daily bulletin. The output carries the commodity name, its unit, the source and the last publication date.
What it is for
Commodities brings energy and precious metal price history into Excel. You choose a daily, weekly or monthly period, and for gold and silver you choose the unit: TRY/gram, TRY/kg or USD/ounce.
The Excel problem it solves
Commodity price series are published on different institutions' websites, in different formats and in different units. Getting them into a report usually means a download step, a cleanup step and a unit conversion step.
When to use it
For production and logistics teams that put an energy price into a cost analysis, and for accounting and finance teams working with a precious metal price series.
Example scenarios
- Pulling a year of daily Brent and WTI prices into one table to compare them.
- Adding the monthly TRY/gram gold series to a report.
- Writing the Henry Hub natural gas history into a sheet as the input for an energy cost model.
Modes
- Brent crude oil
- WTI crude oil
- Henry Hub natural gas
- Gold
- Silver
- Daily / weekly / monthly period
- TRY/gram, TRY/kg, USD/ounce
What it needs
This tool does not need any data selected first. You choose the commodity, the period and the date range, set the unit for gold and silver, then point at the cell where the table should start.
How to use it
- Open Commodities from the Finance group on the XLMind ribbon.
- Choose the commodity: Brent crude, WTI crude, Henry Hub natural gas, gold or silver.
- Set the period to daily, weekly or monthly, then enter the date range.
- For gold and silver, choose the unit: TRY/gram, TRY/kg or USD/ounce.
- Point at the cell where the table should start and create it.
What it produces
A table of dates and prices is written from the cell you pick. Its description states the commodity you chose, the unit, the source of the data and the last publication date; when you picked the market history rather than a single commodity, the output says so plainly.
Effect on your data and undo
The table is written only to the area you point at, and the rest of your workbook stays as it is. Only the published price data is downloaded; the contents of your workbook are never sent anywhere.
How it differs from similar tools
It brings series published by different institutions into one window, in the same table layout and in the unit you asked for, so the download and unit conversion steps disappear.
Good to know
The prices are official figures published by the source institutions, not intraday market prices. No row is produced for days the source did not publish. For gold and silver the TRY/gram figure is the gram equivalent of the TRY/kg value published in the Borsa İstanbul bulletin.
Limitations
The scope is Brent crude, WTI crude, Henry Hub natural gas, gold and silver. The series reach as far as the source institutions published them, and an internet connection is needed to download the data.
Also
On the energy side the source is the U.S. Energy Information Administration (EIA); on the precious metals side it is the Borsa İstanbul Precious Metals daily bulletin. No value is produced for a day or a price the bulletin does not carry.
Frequently asked questions
- Which commodities are supported?
- Brent crude oil, WTI crude oil, Henry Hub natural gas, gold and silver.
- Which unit can I get the gold price in?
- TRY/gram, TRY/kg and USD/ounce. The TRY/gram figure is the gram equivalent of the TRY/kg value published in the bulletin.
- Are the prices live?
- No. They are official series published by the source institutions; the output shows the date the data belongs to and when it was last published.
- What happens on days with no data?
- No row is produced for days the source did not publish, and no price is invented for a missing day.
- How does the data reach Excel?
- The result is written as a table of dates and prices, starting at the cell you pick.
Works well with
- As a complement, use Exchange Rates
- As a complement, use Stock Market
- To turn the series into a report, use Create Report
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.