MSFT Options History — March 2008

In March 2008, MSFT traded between $26.99 and $29.42. ATM implied volatility averaged 30.6%, placing in the 49.2% IV rank vs the trailing year. The 30-day expected move averaged 8.9%. IV traded above realized volatility by 1.6% (HV 20d: 29.0%). Max pain ranged from $27.50 to $30.00. Net GEX was positive for 20 of 20 trading days. Term structure was in contango for 17 of 20 days. Put/call ratio averaged 0.81.

Notable Days

  • 2008-03-11: Highest Volume — 189,539 contracts
  • 2008-03-14: Largest IV spike — 15.7% change
  • 2008-03-17: Highest IV Rank — 69.2%
  • 2008-03-17: Largest Expected Move — 10.6%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$28.37$26.99$29.42$26.99$28.38
Max Pain$29.50$27.50$30.00$27.50$30.00
ATM IV30.6%26.8%36.9%31.1%29.4%
Expected Move8.9%8.1%10.6%8.9%8.4%
HV 20d29.0%22.8%34.0%23.4%32.7%
HV 60d30.7%29.0%31.9%30.0%31.9%
IV Rank49.2%37.2%69.2%50.9%45.4%
IV Percentile84.8%72.6%96.8%89.3%77.8%
Term Structure2.0%-2.7%6.5%1.0%6.5%
VWIV31.4%28.2%38.1%32.0%30.5%
Skew 25d3.7%-0.5%5.9%-0.5%4.4%
Skew 10d6.9%-0.8%12.0%-0.8%8.0%
Call IV 25d30.0%26.6%35.8%32.6%29.1%
Put IV 25d33.7%29.8%41.2%32.1%33.5%
Bid-Ask Spread %3.182.045.842.042.37
Gamma HHI0.130.110.210.110.12
Net GEX19.4M4.7M44.4M10.2M7.2M
Net DEX-46.7M-635.9M445.0M445.0M58.2M
Net VEX-19.8M-20.6M-18.5M-18.5M-19.7M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.810.402.470.570.78
Total Volume99,880.5557,787189,53969,17461,214
Total OI3,334,116.93,064,0813,488,1183,354,1293,201,562

Daily Data (20 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call WallPut WallCall VolPut VolCall OIPut OI
2008-03-03$26.99$27.5031.1%8.9%23.4%50.9%32.0%-0.5%1.0%10.2M445.0M-18.5M0.572.04N/AN/A43,93425,2402,081,3141,272,815
2008-03-04$27.59$27.5030.6%8.8%25.4%49.2%31.1%0.7%1.4%17.1M214.3M-19.6M2.472.20N/AN/A47,265116,5632,090,9131,279,163
2008-03-05$28.12$27.5028.3%8.1%23.5%42.0%28.2%2.3%2.4%21.4M36.9M-19.4M0.632.25N/AN/A62,17238,8672,060,8051,291,423
2008-03-06$27.57$27.5029.3%8.4%23.5%45.1%29.7%2.1%1.8%11.5M299.9M-19.0M1.022.25N/AN/A33,46234,2192,051,9531,295,373
2008-03-07$27.87$30.0028.4%9.1%23.4%42.4%31.4%2.8%0.9%15.3M154.1M-19.2M1.082.86N/AN/A43,41346,8082,064,5651,313,954
2008-03-10$28.05$30.0031.3%9.5%22.8%51.5%32.8%2.6%0.2%18.4M52.2M-19.7M0.402.89N/AN/A41,25516,5322,070,0601,337,694
2008-03-11$29.28$30.0026.8%8.5%27.2%37.2%29.6%4.1%1.2%41.3M-546.8M-20.6M0.542.24N/AN/A123,23966,3002,081,8541,336,411
2008-03-12$28.63$30.0029.8%8.8%28.5%46.7%32.0%3.5%0.6%24.2M-184.3M-20.4M0.533.78N/AN/A81,60343,6522,065,8921,364,466
2008-03-13$28.62$30.0030.4%8.7%27.4%48.7%30.6%3.5%1.3%27.3M-201.2M-20.2M0.533.08N/AN/A67,37935,4062,076,0451,356,327
2008-03-14$27.96$30.0035.2%10.1%28.0%63.8%34.7%4.1%-0.6%14.6M109.8M-20.0M0.975.84N/AN/A88,55486,0062,072,4451,368,082
2008-03-17$28.30$30.0036.9%10.6%28.4%69.2%38.1%5.5%-2.7%20.1M-52.6M-20.2M0.494.09N/AN/A72,89936,0872,094,7981,386,128
2008-03-18$29.42$30.0032.6%9.3%31.4%55.5%33.4%5.8%-0.3%44.4M-635.9M-20.5M0.503.38N/AN/A96,80448,6232,100,6521,387,466
2008-03-19$28.62$30.0031.7%9.1%33.1%52.8%31.7%5.9%0.5%25.1M-136.1M-20.0M0.614.26N/AN/A56,40634,6572,089,6541,395,632
2008-03-20$29.18$30.0030.6%8.8%33.7%49.4%30.9%5.9%1.4%43.4M-420.7M-20.3M0.573.14N/AN/A47,37627,2402,085,7481,397,007
2008-03-24$29.17$30.0029.6%8.5%33.1%46.0%29.7%4.3%4.9%14.6M-275.6M-20.1M0.773.08N/AN/A38,81129,9091,792,9511,271,130
2008-03-25$29.14$30.0028.5%8.2%33.1%42.7%29.1%4.9%5.6%13.6M-231.9M-20.0M0.903.07N/AN/A43,54139,0071,803,3161,288,145
2008-03-26$28.56$30.0028.8%8.2%33.4%43.5%29.7%4.6%5.6%8.9M-15.6M-19.8M0.674.20N/AN/A48,69132,4861,824,0211,305,386
2008-03-27$28.05$30.0030.9%8.9%34.0%50.4%30.6%3.6%4.6%4.7M179.4M-19.1M0.453.34N/AN/A49,34322,0991,825,2401,319,708
2008-03-28$27.91$30.0031.5%9.0%33.8%52.2%31.3%3.6%4.0%4.7M217.1M-19.2M1.783.20N/AN/A25,35245,1971,857,4231,324,817
2008-03-31$28.38$30.0029.4%8.4%32.7%45.4%30.5%4.4%6.5%7.2M58.2M-19.7M0.782.37N/AN/A34,48626,7281,866,9211,334,641