Excel Formula Reference: Commodities

The Add-in provides comprehensive coverage of live commodity prices, such as oil and gold, via simple formulas.

Yahoo Finance Excel Formulas FX Rates Summary

All of these formulas require just a currency pair code, for example: =EPF.Yahoo.Price("CL=F")

If you don't know the commodity symbol then you can use the search function on the Configuration Pane.

Formula Description
EPF.Yahoo.Price Current mid price.
EPF.Yahoo.DayChange Change in price today.
EPF.Yahoo.DayChangePercent Percentage change in price today.
EPF.Yahoo.PrevClose Previous market close price.
EPF.Yahoo.MarketOpen Market open price.
EPF.Yahoo.Bid Bid price.
EPF.Yahoo.Ask Ask price.
EPF.Yahoo.DayLow Day low.
EPF.Yahoo.DayHigh Day high.