COST Options History — April 2007

In April 2007, COST traded between $53.57 and $55.60. ATM implied volatility averaged 19.0%. The 30-day expected move averaged 5.4%. IV traded above realized volatility by 4.6% (HV 20d: 14.3%). Max pain ranged from $52.50 to $55.00. Net GEX was positive for 20 of 20 trading days. Term structure was in contango for 19 of 20 days. Put/call ratio averaged 1.14.

Notable Days

  • 2007-04-27: Highest Volume — 16,268 contracts
  • 2007-04-09: Largest IV spike — 10.4% change
  • 2007-04-30: Largest Expected Move — 5.9%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$54.55$53.57$55.60$53.91$53.57
Max Pain$53.38$52.50$55.00$52.50$55.00
ATM IV19.0%17.9%20.4%19.8%20.4%
Expected Move5.4%5.1%5.9%5.7%5.9%
HV 20d14.3%12.7%18.3%18.0%15.2%
HV 60d17.0%16.6%17.5%17.1%16.9%
Term Structure1.4%-0.1%2.7%-0.1%1.9%
VWIV18.9%17.9%20.6%20.6%19.3%
Skew 25d2.1%0.8%3.1%2.4%1.3%
Skew 10d5.2%2.4%9.6%4.8%2.5%
Call IV 25d18.2%17.7%19.3%19.2%19.3%
Put IV 25d20.2%18.9%21.6%21.6%20.6%
Bid-Ask Spread %8.414.2512.0411.8610.13
Gamma HHI0.270.140.830.170.15
Net GEX6.2M387.9K44.9M2.1M1.5M
Net DEX-86.0M-152.8M-53.7M-60.5M-76.6M
Net VEX-1.1M-1.4M-1.0M-1.2M-1.4M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio1.140.087.011.080.57
Total Volume4,947.051,15816,2681,8231,803
Total OI134,838.2103,779153,508141,239125,825

Daily Data (20 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call VolPut VolCall OIPut OI
2007-04-02$53.91$52.5019.8%5.7%18.0%0.0%20.6%2.4%-0.1%2.1M-60.5M-1.2M1.0811.8687694773,68267,557
2007-04-03$54.55$52.5018.8%5.4%18.3%0.0%17.9%3.1%0.3%4.0M-86.4M-1.2M0.2111.134,29591474,03567,939
2007-04-04$54.45$52.5018.6%5.3%18.0%0.0%19.7%3.0%0.5%3.9M-80.3M-1.2M1.294.2550565375,64868,032
2007-04-05$54.88$52.5017.9%5.1%13.7%0.0%18.0%1.8%0.7%5.0M-99.2M-1.1M1.007.3666366273,41467,993
2007-04-09$54.82$55.0019.7%5.5%13.7%0.0%19.1%2.6%1.1%4.3M-91.7M-1.1M1.2111.101,0421,25873,52068,201
2007-04-10$54.67$55.0019.1%5.5%12.9%0.0%18.5%2.4%1.0%3.7M-83.1M-1.1M0.585.461,01859473,94968,913
2007-04-11$54.03$55.0018.6%5.5%12.7%0.0%18.3%2.2%1.0%1.7M-56.4M-1.1M0.666.211,45996674,50068,900
2007-04-12$54.68$52.5018.8%5.4%12.8%0.0%18.6%2.0%1.3%4.6M-90.1M-1.1M0.688.552,5391,72275,06369,009
2007-04-13$54.16$52.5018.7%5.4%12.8%0.0%18.3%2.3%1.3%2.7M-68.9M-1.1M7.018.291,45710,22076,14669,235
2007-04-16$54.40$52.5018.8%5.4%12.7%0.0%19.2%2.0%1.3%2.7M-66.3M-1.1M1.129.4482893075,65477,854
2007-04-17$55.60$52.5019.6%5.6%14.6%0.0%19.4%2.0%1.1%8.8M-136.8M-1.0M0.376.598,1513,00576,08164,803
2007-04-18$55.02$52.5019.1%5.5%15.3%0.0%19.1%1.8%1.5%12.6M-116.3M-1.1M0.4410.536,1492,68579,53266,056
2007-04-19$55.32$52.5019.4%5.6%13.5%0.0%19.7%2.2%1.2%17.0M-145.8M-1.2M0.425.121,86778783,82067,846
2007-04-20$55.12$52.5018.9%5.4%13.5%0.0%18.6%2.1%1.8%44.9M-152.8M-1.1M0.369.845,2591,91283,90267,558
2007-04-23$54.88$52.5018.7%5.4%13.5%0.0%18.4%1.7%2.4%1.4M-75.1M-1.1M0.416.062,26492054,86948,910
2007-04-24$54.25$52.5018.9%5.4%14.1%0.0%18.9%1.9%2.2%1.2M-61.2M-1.1M1.9612.042,5695,02856,46049,480
2007-04-25$54.27$55.0018.7%5.3%13.9%0.0%18.6%2.1%2.1%547.2K-55.2M-1.2M1.608.201,6962,72056,58553,076
2007-04-26$54.04$55.0018.1%5.2%13.7%0.0%18.8%0.8%2.4%387.9K-53.7M-1.2M1.666.178691,44157,38953,211
2007-04-27$54.46$55.0018.5%5.3%13.9%0.0%19.3%1.5%2.7%556.7K-64.0M-1.2M0.089.8115,0661,20257,71854,399
2007-04-30$53.57$55.0020.4%5.9%15.2%0.0%19.3%1.3%1.9%1.5M-76.6M-1.4M0.5710.131,15265170,90254,923