XLE Options History — May 2007

In May 2007, XLE traded between $31.82 and $34.33. ATM implied volatility averaged 20.4%. The 30-day expected move averaged 5.9%. IV traded above realized volatility by 4.9% (HV 20d: 15.5%). Max pain ranged from $31.00 to $33.00. Net GEX was positive for 2 of 22 trading days. Term structure was in contango for 19 of 22 days. Put/call ratio averaged 2.46.

Notable Days

  • 2007-05-22: Highest Volume — 410,810 contracts
  • 2007-05-10: Largest IV spike — 11.1% change
  • 2007-05-31: Largest Expected Move — 6.3%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$33.05$31.82$34.33$31.82$34.15
Max Pain$31.57$31.00$33.00$31.00$32.00
ATM IV20.4%18.9%22.1%20.4%22.1%
Expected Move5.9%5.4%6.3%5.8%6.3%
HV 20d15.5%13.7%18.0%14.6%18.0%
HV 60d17.1%15.5%17.9%17.4%16.0%
Term Structure0.4%-0.5%1.9%1.1%-0.5%
VWIV21.6%19.2%24.5%21.3%24.5%
Skew 25d3.2%1.9%4.0%2.8%3.6%
Skew 10d6.1%3.8%7.3%5.7%6.0%
Call IV 25d19.2%17.7%20.5%19.5%20.5%
Put IV 25d22.4%20.9%24.1%22.2%24.1%
Bid-Ask Spread %10.417.2413.447.769.63
Gamma HHI0.150.090.210.090.14
Net GEX-36.2M-111.2M20.2M12.0M-89.4M
Net DEX-1.47B-2.46B-865.5M-1.24B-1.47B
Net VEX-10.9M-11.9M-9.3M-11.1M-11.4M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio2.460.5411.524.633.18
Total Volume119,190.36423,640410,810338,72875,800
Total OI2,665,210.2732,271,1743,123,3062,271,1743,123,306

Daily Data (22 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call VolPut VolCall OIPut OI
2007-05-01$31.82$31.0020.4%5.8%14.6%0.0%21.3%2.8%1.1%12.0M-1.24B-11.1M4.637.7660,196278,5321,010,9661,260,208
2007-05-02$32.09$31.0019.9%5.7%14.7%0.0%19.2%2.9%1.4%-14.0M-1.20B-11.9M1.069.1632,98434,9141,028,2421,482,002
2007-05-03$32.35$31.0018.9%5.4%14.9%0.0%19.6%2.4%1.9%-14.5M-1.40B-11.5M1.227.7419,18423,3481,009,9201,483,998
2007-05-04$32.33$31.5019.0%6.0%14.9%0.0%21.5%4.0%0.1%-15.9M-1.37B-11.5M3.849.4626,780102,9561,013,3661,490,950
2007-05-07$32.41$31.5020.1%6.1%14.7%0.0%23.1%4.0%0.0%-22.9M-1.35B-11.3M0.9611.9217,00416,3541,017,6281,528,148
2007-05-08$32.41$31.5019.9%6.0%13.9%0.0%22.1%4.0%0.4%-21.1M-1.39B-11.3M1.609.1618,62029,8621,023,1521,534,094
2007-05-09$32.40$31.5019.3%6.0%13.7%0.0%21.1%3.7%0.3%-22.5M-1.41B-11.2M1.419.2118,62226,1781,029,8421,548,192
2007-05-10$31.88$31.5021.5%6.2%14.2%0.0%21.9%3.8%0.3%-34.7M-960.2M-11.8M2.8211.1218,73452,7741,041,8881,559,798
2007-05-11$32.60$31.5020.6%5.9%16.3%0.0%21.4%3.3%0.2%-24.7M-1.50B-11.1M2.5311.4017,88445,2981,045,8681,590,322
2007-05-14$32.62$31.5021.1%6.0%16.2%0.0%21.0%3.3%0.0%-23.6M-1.60B-10.7M1.0210.9111,72011,9201,047,9921,608,946
2007-05-15$32.73$31.5020.8%6.0%16.0%0.0%20.5%3.2%0.8%-23.8M-1.66B-10.5M1.5412.4346,15671,2021,052,5201,595,460
2007-05-16$32.85$31.5020.2%5.8%15.9%0.0%20.8%3.4%0.6%-18.6M-1.78B-10.5M2.1712.4626,92858,5241,084,5441,633,008
2007-05-17$33.38$31.5019.7%5.7%15.3%0.0%20.7%3.1%0.5%-532.2K-2.16B-9.9M0.549.7442,64223,0881,094,6081,652,762
2007-05-18$33.91$31.5019.4%5.6%15.1%0.0%20.2%3.6%0.6%20.2M-2.46B-9.4M1.4910.4451,21476,3141,099,0741,660,942
2007-05-21$34.20$31.5020.3%5.8%15.1%0.0%21.4%3.4%0.2%-7.8M-1.78B-9.3M3.3710.4440,844137,830882,4081,399,216
2007-05-22$33.88$31.5020.7%5.9%15.7%0.0%21.0%1.9%0.5%-20.6M-1.64B-9.8M11.527.2432,814377,996908,4881,492,310
2007-05-23$33.95$33.0021.2%6.1%14.7%0.0%21.5%2.4%0.5%-80.9M-1.32B-10.7M1.299.8059,27676,650927,2741,811,740
2007-05-24$33.33$31.5021.5%6.2%16.5%0.0%23.6%3.1%-0.2%-100.6M-865.5M-11.7M1.6011.76123,294197,744967,0941,834,658
2007-05-25$33.85$31.5020.5%5.9%17.1%0.0%23.2%2.9%0.3%-98.3M-1.20B-11.6M3.8011.3619,62474,6141,023,4881,957,154
2007-05-29$33.63$32.0021.4%6.1%16.6%0.0%21.4%3.5%0.0%-111.2M-993.6M-11.6M1.7713.4417,26630,5921,038,0341,986,708
2007-05-30$34.33$32.0020.6%5.9%17.8%0.0%23.2%2.9%-0.2%-83.6M-1.57B-11.0M0.7412.3656,36841,5441,045,2722,009,036
2007-05-31$34.15$32.0022.1%6.3%18.0%0.0%24.5%3.6%-0.5%-89.4M-1.47B-11.4M3.189.6318,12457,6761,090,6562,032,650