XLU Options History — January 2007

In January 2007, XLU traded between $17.93 and $18.41. ATM implied volatility averaged 10.9%. The 30-day expected move averaged 3.2%. IV traded above realized volatility by 2.2% (HV 20d: 8.6%). Max pain ranged from $18.00 to $18.50. Net GEX was positive for 0 of 20 trading days. Term structure was in contango for 20 of 20 days. Put/call ratio averaged 16.74.

Notable Days

  • 2007-01-25: Highest Volume — 108,582 contracts
  • 2007-01-31: Largest IV drop — 34.6% change
  • 2007-01-09: Largest Expected Move — 3.6%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$18.12$17.93$18.41$18.41$18.30
Max Pain$18.07$18.00$18.50$18.50$18.00
ATM IV10.9%7.2%12.1%10.4%7.2%
Expected Move3.2%2.1%3.6%3.0%2.1%
HV 20d8.6%8.3%9.0%9.0%8.3%
Term Structure1.0%0.3%2.6%1.5%1.9%
VWIV11.1%8.8%12.9%10.4%10.5%
Skew 25d2.1%-0.1%3.6%2.9%1.8%
Skew 10d3.7%-0.4%7.7%4.0%2.1%
Call IV 25d9.6%7.9%11.6%8.4%8.2%
Put IV 25d11.7%9.1%13.5%11.3%10.0%
Bid-Ask Spread %18.766.0525.297.3923.90
Gamma HHI0.810.620.940.890.62
Net GEX-29.4M-102.1M-9.4M-16.5M-9.4M
Net DEX46.6M-6.2M108.3M18.7M-6.2M
Net VEX-409.2K-485.5K-331.5K-432.0K-349.9K
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio16.740.01292.460.421.42
Total Volume10,492.6312108,5822,4343,576
Total OI208,158.6131,430266,680241,822140,450

Daily Data (20 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call VolPut VolCall OIPut OI
2007-01-03$18.41$18.5010.4%3.0%0.0%0.0%10.4%2.9%1.5%-16.5M18.7M-432.0K0.427.391,71272239,656202,166
2007-01-04$18.39$18.5010.6%3.0%0.0%0.0%11.1%2.6%1.2%-17.7M25.7M-443.3K1.606.052,5304,05040,630202,296
2007-01-05$18.05$18.0010.9%3.5%0.0%0.0%12.4%1.4%1.2%-27.4M78.6M-485.5K0.2214.723,05465842,926206,102
2007-01-08$18.05$18.0011.4%3.6%0.0%0.0%12.6%2.7%1.1%-28.9M83.6M-475.0K0.6316.591,9761,24645,440206,882
2007-01-09$18.06$18.0010.7%3.6%0.0%0.0%12.6%3.3%0.8%-30.4M75.4M-471.6K0.3619.6592233646,746206,990
2007-01-10$18.07$18.0010.9%3.4%0.0%0.0%11.6%2.7%0.9%-31.0M65.5M-462.4K0.1920.622625047,364206,238
2007-01-11$18.09$18.0011.7%3.3%0.0%0.0%10.5%2.7%0.8%-36.2M68.8M-451.1K0.3420.134,2921,44447,428206,072
2007-01-12$17.93$18.0011.8%3.4%0.0%0.0%11.2%1.6%0.4%-36.0M108.3M-442.0K5.3719.699785,25645,718207,250
2007-01-16$17.99$18.5012.1%3.5%0.0%0.0%12.6%2.8%0.3%-41.2M93.0M-423.9K0.5316.0511,1525,87845,662212,132
2007-01-17$18.03$18.0011.9%3.4%0.0%0.0%12.5%1.6%0.8%-54.9M72.9M-408.2K5.1819.601,4727,62855,092209,044
2007-01-18$18.02$18.0011.9%3.4%0.0%0.0%12.9%1.4%1.0%-61.5M78.8M-402.6K0.4916.791,39068455,534211,146
2007-01-19$18.02$18.0010.7%3.1%0.0%0.0%10.4%1.9%0.9%-102.1M49.0M-387.1K0.0120.339,02810855,272208,488
2007-01-22$18.02$18.0010.8%3.1%0.0%0.0%10.8%1.8%0.5%-14.1M28.5M-363.2K0.5524.3926614639,61891,812
2007-01-23$18.13$18.0011.5%3.3%0.0%0.0%11.2%3.4%0.3%-12.6M22.1M-355.8K0.0825.294403439,67491,892
2007-01-24$18.18$18.0010.0%2.9%0.0%0.0%8.8%3.6%2.6%-11.4M253.1K-331.5K0.0817.001,0408839,97491,926
2007-01-25$18.17$18.0010.8%3.1%9.0%0.0%10.7%-0.1%1.2%-14.0M18.0M-346.2K292.4620.71370108,21240,43491,974
2007-01-26$18.13$18.0010.3%3.0%8.7%0.0%10.0%1.5%0.4%-15.2M22.1M-390.8K0.2323.442,23652440,558110,020
2007-01-29$18.18$18.0010.6%3.0%8.6%0.0%10.3%0.5%0.8%-15.7M22.5M-395.0K24.5819.5995223,39842,504110,506
2007-01-30$18.24$18.0011.0%3.1%8.5%0.0%9.2%1.9%0.5%-11.4M6.0M-366.1K0.0623.271,6469643,10696,450
2007-01-31$18.30$18.007.2%2.1%8.3%0.0%10.5%1.8%1.9%-9.4M-6.2M-349.9K1.4223.901,4782,09843,94896,502