Oil Prices in Excel, as Refreshable Formulas

OilPriceAPI prices with Excel Power Query

If you already use Power Query, create a text parameter namedOilPriceAPIKeyin Manage Parameters, then paste this M query into a blank query's Advanced Editor. Choose Anonymous for the web source credential: the request itself carries your API token.

let
  Source = Json.Document(Web.Contents(
    "https://api.oilpriceapi.com",
    [RelativePath = "v1/prices/latest",
     Query = [by_code = "BRENT_CRUDE_USD"],
     Headers = [Authorization = "Token " & OilPriceAPIKey]]
  )),
  Prices = Table.FromRecords({Source[data]})
in
  Prices

The response includes the price and its source timestamp. Power Query parameters can be retained with a workbook; do not share a workbook containing your API key. The add-in above stores the key outside the worksheet and is the simpler option for refreshable formulas. Dataset access still depends on your account plan.

Quick start on Mac Excel

1. Create a free account and copy an API key from the dashboard.
2. Run this in Terminal, then restart Excel:

   mkdir -p ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef && curl -fsSL https://oilpriceapi.github.io/excel-energy-addin/manifest.xml -o ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef/oilprice-manifest.xml

3. In Excel, open Insert > My Add-ins, choose the OilPrice developer add-in and open the OilPrice pane. Paste your key, save it and choose Test Key.
4. Type =OILPRICE.PRICE("BRENT_CRUDE_USD") in any cell.

On Excel on the web or Windows, follow the install guide; those paths are unverified preview for now. The add-in is not yet listed in Microsoft AppSource.

Formulas