Tools that put EOX forward curves to work
Every EOX subscription includes tools that value positions and deals on the curves you already receive: mark a book to market, explain its P&L and measure its risk; value PPAs, battery and gas storage, options, heat-rate calls, crack and frac spreads and oil storage; and analyse capture prices, hedges, volatility and spreads. In the browser, in Excel and in Python, at no extra charge.
What you can value
Mark-to-market and risk
Paste or upload a book of swaps and forwards and mark it to the latest curves, end of day or intraday. P&L explained by curve and contract, value at risk and expected shortfall from the same contracts' daily history, and replays of past market episodes.
Mark-to-market →PPA valuation
Solar, wind or baseload power purchase agreements on power forward curves, shaped hour by hour: capture price, shape factor, value and the breakeven PPA price.
PPA valuation →Battery storage valuation
The best daily charge and discharge schedule on the forward curve, a backtest on actual day-ahead prices, and regulation and reserves where the market has a day-ahead market for them.
Battery storage →Gas storage valuation
The best injection and withdrawal plan on a gas forward curve, and a rolling-intrinsic backtest that re-hedges it on every day of EOX's own curve history.
Gas storage →Options valuation
Power and gas options with Black-76 on EOX implied vols, and heat-rate call options (tolls) with Kirk's approximation on EOX power and gas vols and EOX correlations. Or bring your own vols.
Options →Basis valuation
Swaps, PPAs and batteries at nodal and zonal locations across the major US power markets, with forward basis against realized day-ahead basis.
Basis valuation →Forward vs. realized
Each past month's EOX on- and off-peak mark against what the day-ahead market then settled at, outright or as a basis between two locations.
Forward vs. realized →Oil and NGL valuation
Crack spreads and NGL frac spreads against their own history, and swaps, tank storage and options on crude, refined products and NGL curves.
Oil and NGL →Hourly shapes
Turn on- and off-peak block prices into hourly prices, shaped from the hub's own day-ahead history, for models that need hours rather than blocks.
Hourly shapes →What you can analyse
Capture prices
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 months ahead.
Capture prices →Best hedge
The hubs that have tracked a node or zone most closely, ranked, with the hedge ratio and the risk a hedge would have left.
Best hedge →Implied vs. realized volatility
EOX implied volatilities beside each contract's realized volatility on EOX curves, and the premium between them.
Volatility →Spread monitor
Basis, spark spreads, market heat rates, winter-summer and calendar spreads, each tenor ranked against its own history.
Spread monitor →Average forward curve
Any EOX curve averaged over a window of curve dates, beside today's curve and the window's range: a smoothed curve for planning and budgets.
Average forward curve →Settlement averages
Monthly on-peak, off-peak and around-the-clock averages of the ISOs' day-ahead and real-time prices, to view or download.
Settlement averages →Gas storage and the curve
Weekly working gas against its five-year range, beside the winter-summer spread on EOX's curve.
Storage and the curve →Where you use them
In the browser
The Portfolio, Valuation, Oil and NGL valuation and Market analysis pages, signed in with your EOX account. Nothing to install, and results download as CSV.
In Excel
The EOX add-in's functions, next to your own models:
=EOX.MTMmarks a book=EOX.BATTERYvalues a battery=EOX.GAS_STORAGEvalues a storage field
In Python
The eoxlive client: mtm, pnl, risk,
value_deals, battery, gas_storage, capture,
best_hedge, spreads and more, returning pandas DataFrames.
Each result lists exactly what it used: the curves and curve dates, the vols, the hours and the assumptions, so a number can always be traced back.
Questions
- Do the tools cost extra?
- No. They come with your data subscription and use only the curves it covers.
- Which curves can I use?
- Any curve in your subscription. Deal valuation uses power and natural gas forwards, and EOX implied vols and correlations where the deal needs them.
- Is anything I enter stored?
- No. Positions and deals are valued and returned; they are not kept.
- Is this advice?
- No. The tools calculate values on EOX curves for your own analysis. They are not an offer, a valuation opinion or a recommendation.
Included with your subscription. The tools use the curves, vols and correlations your subscription already covers, under the same entitlements, and are never charged for separately. Results are for information only; values shown on this page are illustrative.