XLP Options History — February 2007

In February 2007, XLP traded between $26.20 and $27.05. ATM implied volatility averaged 8.4%. The 30-day expected move averaged 2.4%. IV traded above realized volatility by 2.6% (HV 20d: 5.8%). Max pain ranged from $25.00 to $26.00. Net GEX was positive for 19 of 19 trading days. Term structure was in contango for 15 of 19 days. Put/call ratio averaged 0.79.

Notable Days

  • 2007-02-27: Highest Volume — 1,049 contracts
  • 2007-02-27: Largest IV spike — 89.8% change
  • 2007-02-28: Largest Expected Move — 4.3%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$26.68$26.20$27.05$26.75$26.30
Max Pain$25.05$25.00$26.00$26.00$25.00
ATM IV8.4%5.4%15.1%5.4%15.1%
Expected Move2.4%1.6%4.3%1.6%4.3%
HV 20d5.8%4.5%10.1%5.7%10.1%
Term Structure0.5%-2.7%2.3%2.2%-2.6%
VWIV10.2%6.2%15.1%6.2%15.1%
Skew 25d1.3%-2.1%4.0%1.0%3.9%
Skew 10d1.2%-2.0%4.5%2.3%0.3%
Call IV 25d8.3%6.7%11.2%8.1%9.2%
Put IV 25d9.6%6.6%13.6%9.1%13.0%
Bid-Ask Spread %22.8611.3193.5321.9411.31
Gamma HHI0.500.330.600.510.33
Net GEX1.6M1.3M2.0M1.6M1.4M
Net DEX-33.6M-39.3M-22.0M-36.1M-23.2M
Net VEX-251.3K-266.7K-234.1K-255.8K-266.7K
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.790.005.500.000.26
Total Volume137.52601,04996432
Total OI43,381.78942,47843,68143,56843,681

Daily Data (19 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call VolPut VolCall OIPut OI
2007-02-01$26.75$26.005.4%1.6%5.7%0.0%0.0%1.0%2.2%1.6M-36.1M-255.8K0.0021.9496023,64819,920
2007-02-02$26.80$25.008.3%2.3%5.7%0.0%0.0%1.9%1.3%1.5M-35.1M-259.1K0.0021.800023,58519,920
2007-02-05$26.71$25.0010.5%1.9%5.1%0.0%6.2%2.4%0.6%1.4M-34.9M-255.2K4.8393.5362923,58519,920
2007-02-06$26.67$25.005.8%1.8%5.2%0.0%7.5%1.8%1.4%1.6M-35.1M-253.0K0.0022.8225023,58519,949
2007-02-07$26.61$25.005.6%1.7%5.3%0.0%10.1%2.1%1.8%1.5M-33.6M-254.2K0.0324.5531123,59319,949
2007-02-08$26.56$25.006.3%1.8%5.2%0.0%9.6%2.5%1.1%1.5M-31.4M-260.7K0.1114.9619223,62319,949
2007-02-09$26.52$25.005.9%1.7%4.5%0.0%10.4%4.0%2.3%1.4M-30.4M-261.6K0.0015.1520023,63719,949
2007-02-12$26.46$25.0010.1%2.9%4.5%0.0%0.0%2.0%-1.1%1.3M-31.2M-260.4K0.0024.450023,64719,949
2007-02-13$26.55$25.007.9%2.3%4.7%0.0%0.0%2.4%-0.0%1.5M-32.6M-253.2K0.0021.4716023,64719,949
2007-02-14$26.71$25.006.6%1.9%5.0%0.0%11.6%1.3%1.0%1.7M-33.5M-252.4K5.5015.6721123,66319,949
2007-02-15$26.87$25.008.3%2.4%5.4%0.0%8.4%-1.4%0.8%1.8M-36.2M-242.8K0.0016.4128023,66519,953
2007-02-16$26.91$25.008.1%2.3%5.4%0.0%11.6%-0.8%1.5%1.8M-37.8M-238.5K0.0012.1037023,68619,953
2007-02-20$27.05$25.008.8%2.5%5.6%0.0%8.5%-0.5%0.3%1.6M-39.3M-234.7K0.0011.81676023,54318,935
2007-02-21$26.90$25.008.4%2.4%6.0%0.0%0.0%-0.4%0.4%1.9M-39.0M-234.1K0.0213.9843124,07418,935
2007-02-22$26.80$25.007.3%2.1%6.1%0.0%8.9%-2.0%0.3%2.0M-37.4M-235.5K0.0018.1845024,11218,934
2007-02-23$26.82$25.008.9%2.6%5.5%0.0%0.0%3.6%0.6%1.9M-35.1M-245.3K0.0020.910024,11918,934
2007-02-26$26.81$25.007.6%2.2%5.4%0.0%0.0%-2.1%0.1%1.9M-35.0M-247.9K0.0014.1744024,11918,934
2007-02-27$26.20$25.0014.5%4.2%9.9%0.0%14.0%2.4%-2.7%1.4M-22.0M-263.4K1.9339.1935869124,12718,934
2007-02-28$26.30$25.0015.1%4.3%10.1%0.0%15.1%3.9%-2.6%1.4M-23.2M-266.7K0.2611.313429024,23819,443