C Options History — February 2007

In February 2007, C traded between $503.70 and $549.50. ATM implied volatility averaged 15.6%. The 30-day expected move averaged 4.6%. IV traded above realized volatility by 1.3% (HV 20d: 14.3%). Max pain ranged from $500.00 to $550.00. Net GEX was positive for 19 of 19 trading days. Term structure was in contango for 9 of 19 days. Put/call ratio averaged 0.77.

Notable Days

  • 2007-02-28: Highest Volume — 8,774 contracts
  • 2007-02-27: Largest IV spike — 39.1% change
  • 2007-02-27: Largest Expected Move — 7.4%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$537.08$503.70$549.50$547.30$503.70
Max Pain$510.53$500.00$550.00$550.00$500.00
ATM IV15.6%11.3%25.7%12.9%22.6%
Expected Move4.6%3.7%7.4%3.7%6.5%
HV 20d14.3%12.4%19.3%13.1%19.1%
Term Structure-0.4%-4.3%1.3%1.3%-2.1%
VWIV16.1%13.1%24.7%13.4%22.9%
Skew 25d3.3%-0.5%4.8%4.2%-0.5%
Skew 10d6.4%-1.9%10.4%6.5%-1.9%
Call IV 25d14.5%10.4%23.5%10.4%23.2%
Put IV 25d17.7%14.6%27.8%14.6%22.7%
Bid-Ask Spread %6.224.4412.354.617.16
Gamma HHI0.220.190.240.210.19
Net GEX90.6M58.7M103.5M84.8M58.7M
Net DEX-2.27B-2.71B-911.7M-2.58B-911.7M
Net VEX-16.5M-18.8M-14.9M-15.1M-17.6M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.770.101.350.970.81
Total Volume4,045.2639178,7743,1138,774
Total OI144,082.895132,567154,740132,567154,740

Daily Data (19 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call VolPut VolCall OIPut OI
2007-02-01$547.30$550.0012.9%3.7%13.1%0.0%13.4%4.2%1.3%84.8M-2.58B-15.1M0.974.611,5771,53683,15249,415
2007-02-02$546.60$500.0012.1%4.0%13.0%0.0%15.8%2.9%-0.5%89.0M-2.60B-14.9M1.019.251,3681,37683,66649,306
2007-02-05$547.50$500.0013.0%4.1%12.9%0.0%14.4%2.3%-0.3%88.2M-2.57B-15.7M1.355.471,2941,74784,39249,990
2007-02-06$549.50$500.0011.9%3.8%12.8%0.0%13.1%2.9%0.7%91.5M-2.71B-15.6M0.544.722,0281,10484,85350,665
2007-02-07$549.50$500.0011.3%3.9%12.4%0.0%15.4%3.2%-0.1%94.7M-2.70B-15.6M0.747.291,9781,45985,76051,138
2007-02-08$544.40$500.0013.5%3.9%12.5%0.0%14.0%2.7%0.6%97.8M-2.57B-15.5M0.288.101,71747887,21252,160
2007-02-09$534.00$500.0017.3%4.9%14.3%0.0%16.6%3.4%-1.0%81.4M-2.10B-16.4M1.057.601,8761,96387,52151,854
2007-02-12$534.30$500.0018.6%5.3%14.2%0.0%16.4%4.1%-2.0%84.1M-2.25B-15.4M0.825.034,2453,47888,31552,512
2007-02-13$537.10$500.0017.6%5.1%14.1%0.0%15.8%3.7%-1.7%90.2M-2.26B-16.7M0.685.301,31289291,07954,711
2007-02-14$541.80$500.0014.0%4.0%14.3%0.0%14.7%2.8%0.2%100.6M-2.53B-16.1M0.264.822,97778691,24555,204
2007-02-15$542.10$500.0013.7%3.9%14.3%0.0%14.6%2.6%0.4%99.6M-2.51B-16.3M0.634.7294159092,58255,165
2007-02-16$541.00$500.0013.5%3.9%14.3%0.0%14.6%2.4%0.8%97.7M-2.45B-16.6M0.696.403,5882,47793,03155,334
2007-02-20$541.90$525.0013.3%3.8%14.3%0.0%16.2%4.8%1.1%99.6M-2.53B-16.8M0.104.446,33965991,98255,025
2007-02-21$537.50$525.0016.4%4.7%14.5%0.0%14.6%4.1%0.2%103.5M-2.41B-16.9M0.734.841,4091,02893,73955,483
2007-02-22$535.90$525.0016.3%4.7%14.3%0.0%14.8%3.2%-0.3%102.5M-2.19B-18.2M0.674.5654936894,16256,245
2007-02-23$537.70$525.0013.6%3.9%13.1%0.0%16.2%4.8%0.8%103.1M-2.38B-17.4M0.944.491,5211,42594,29556,510
2007-02-26$526.80$525.0018.4%5.3%13.9%0.0%18.4%4.3%-1.4%93.5M-1.82B-17.8M1.146.932,3402,66794,91557,220
2007-02-27$506.00$525.0025.7%7.4%19.3%0.0%24.7%4.3%-4.3%61.5M-1.01B-18.8M1.1812.353,2083,78694,99658,001
2007-02-28$503.70$500.0022.6%6.5%19.1%0.0%22.9%-0.5%-2.1%58.7M-911.7M-17.6M0.817.164,8383,93695,31959,421