Gas storage valuation

Deal

Import workbook

Contract Start date End date Start volume End volume

Valuation Valuation date Discount rate Liquidity spread $/MMBtu Ratchet basis Month length Net/gross limits

Facility Max working gas Min working gas Injection cost $/MMBtu Withdrawal cost $/MMBtu Ratable Ratchet reading Injection fuel fraction Withdrawal fuel fraction

Injection ratchets volume MMBtu, max daily rate

Withdrawal ratchets volume MMBtu, max daily rate

Forward curve $/MMBtu; bid/ask derived from the spread

Month	Price	Bid	Ask

Months follow the contract term. Paste a column of prices into the first cell.

Minimum lot size >1 makes the problem an MILP

Limit mode Kirk, European; pricing uses r = q = 0.02, not the discount rate

Trials Rebalance every days Seed runs in the background; 1000 trials is ~20–70 s

the fitted envelope must never sit above the true curve

read-only, from the shipped price history