Client Tools

CLIENT TOOLS

Get EOX curves into your models, spreadsheets and systems

Every subscription includes the same tools, at no extra charge. One personal API key works across all of them.

REST API

JSON or CSV

Curves, implied volatilities and history by curve date or date range, or the full end-of-day file in the layout you already receive.

Excel add-in

Windows, Mac and web

EOX.PRICE, EOX.CURVE, EOX.HISTORY and EOX.DATES, a browse-and-insert pane and one-click loading of a full end-of-day file.

Python

pip install eoxlive

Pull a curve, a history range or a whole file in one line.

EOX Charts

In the browser

Forward curves, contract history, intraday moves and spreads, with chart and data downloads and shareable links.

Curve Picker

Query builder

Choose curves, tenors and dates and download Excel or CSV.

Files, email and FTP

Daily files

Browse and download your files, receive reports by email through the trading day, or load files automatically over secure FTP (FTPES).

Maps

Every EOX power and gas location

See every EOX power and gas location on a map, with solar and wind capture coloring and an interconnection queue layer.

Morning report

A quick read on the curves

A morning report built on the EOX curves, for a quick read at the start of the day.

Data dictionary

Columns, history and curve lists

Every complex’s columns, history and curve list, always current, so you know exactly what each file and API call returns.

Tools

Every EOX subscription includes tools that put your curves to work, at no extra charge: mark a book to market and measure its risk; value PPAs, storage and options; and see spreads, capture prices and hedge ratios against their own history.

Mark-to-market and risk

Swaps and forwards

Mark a book of swaps and forwards to any EOX curve date, with value at risk, expected shortfall, replays of past market episodes and P&L explain by curve, contract and position.

Options valuation

Power, gas and heat-rate options

Value power and gas options and heat-rate call options on EOX forward curves and volatilities, or use your own volatilities.

Implied vs. realized volatility

Option pricing against actual movement

EOX implied volatilities beside each contract’s realized volatility.

PPA valuation

Solar, wind and baseload

Value a solar, wind or baseload power purchase agreement hour by hour, with capture price, shape factor and breakeven PPA price.

Capture prices

What solar and wind actually earn

What a typical solar or wind plant has earned at a hub, month by month, against the hub’s average, and what the forward curve implies for the years ahead.

Battery storage valuation

Energy and ancillary services

See a battery’s best charge and discharge schedule on the forward curve, a backtest on past day-ahead prices, and ancillary service revenue where available.

Gas storage valuation

Injection and withdrawal plans

Find the best injection and withdrawal plan on a gas forward curve, with a backtest that re-hedges it across past EOX curves.

Gas storage and the curve

Working gas beside the spread

Weekly working gas from public government data against its five-year range, beside the winter–summer spread.

Basis valuation

Nodal and zonal locations

Value power deals at nodal and zonal locations across the major US power markets, priced against EOX basis curves.

Best hedge

Hubs ranked for a node or zone

The hubs that have tracked a node or zone most closely, ranked, with the hedge ratio for each.

Spread monitor

Spreads against their own history

Basis, spark spreads, heat rates, winter–summer and calendar spreads, each ranked against its own history.

Forward vs. realized

Forwards against settlements

Compare each past month’s EOX forward mark with what the day-ahead market settled at, outright or as a basis between two locations.

Average forward curve

A smoothed curve for planning

Any EOX curve averaged over a window of curve dates, for a smoothed curve to use in planning and budgets.

Oil and NGL valuation

Cracks, fracs, swaps, storage and options

Crack spreads and NGL frac spreads against their own history, plus swaps, tank storage and options on crude, refined products and NGL curves.

Hourly shapes

Block prices to hourly prices

Turn on- and off-peak prices into an hourly curve, shaped from the location’s own day-ahead history, with each block averaging back exactly.

Included with your EOX data subscription. Nothing you enter is stored on our servers. You can save portfolios and charts locally in your own browser to reopen later. Saved settings never leave your computer and are not stored on EOX’s servers. The API also exports a month of curve history in one download.

Intraday snapshots

EOX curves are re-marked every 15 minutes through the trading day, and each run is kept as an intraday snapshot for 90 business days. Chart it in EOX Charts, or pull it through the API, Excel or Python by adding _rt to a dataset name, for example power_rt.

One key for everything

Each user has a personal API key. It signs you in to the API, the Excel add-in, file downloads, the Curve Picker and EOX Charts, and access follows your subscription by complex.

Not a subscriber yet?

Ask for a trial or the full coverage list for any complex.