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.
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.