Excel add-in
Refresh OilPriceAPI data inside Excel
The OilPrice Excel add-in is the spreadsheet workflow we are validating: set an API key once and use formulas that recalculate from the workbook.
One setup
Paste or select the OilPriceAPI key in the add-in pane.
Formula workflow
Reference symbols and endpoint inputs from worksheet cells.
Refresh in place
Recalculate the workbook without leaving Excel.
Initial formula set
The preview scope stays intentionally small so support can verify install, key setup, calculation, API logs, and worksheet errors before broader distribution.
| Use | Formula |
|---|---|
| Latest price | =OILPRICE.PRICE("BRENT_CRUDE_USD") |
| Another symbol | =OILPRICE.PRICE("WTI_USD") |
| Endpoint runner | =OILPRICE.GET("/v1/prices/latest", "by_code=DIESEL_USD") |
Install status
The add-in is a preview and is not yet listed in Microsoft AppSource. Excel for Mac has a recorded runtime smoke; Excel on the web and Windows are unverified. Install steps are on the Excel page.