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") |
Support posture
Customer instructions should wait for a production smoke that proves the add-in installs, stores the key, calls the live API, and recalculates formulas in Excel.