MSFT Options History — July 2010

In July 2010, MSFT traded between $23.16 and $26.16. ATM implied volatility averaged 28.0%, placing in the 57.3% IV rank vs the trailing year. The 30-day expected move averaged 8.4%. IV traded above realized volatility by 0.5% (HV 20d: 27.5%). Max pain ranged from $23.00 to $27.00. Net GEX was positive for 18 of 21 trading days. Term structure was in contango for 8 of 21 days. Put/call ratio averaged 0.50.

Notable Days

  • 2010-07-28: Highest Volume — 393,959 contracts
  • 2010-07-23: Largest IV drop — 25.4% change
  • 2010-07-01: Highest IV Rank — 94.6%
  • 2010-07-01: Largest Expected Move — 10.6%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$25.07$23.16$26.16$23.16$25.81
Max Pain$24.43$23.00$27.00$27.00$25.00
ATM IV28.0%21.6%37.1%37.1%21.6%
Expected Move8.4%6.2%10.6%10.6%6.2%
HV 20d27.5%20.7%30.6%30.6%21.3%
HV 60d29.5%28.1%30.6%28.4%30.1%
IV Rank57.3%31.2%94.6%94.6%31.2%
IV Percentile72.4%28.2%99.2%99.2%28.2%
Term Structure-0.7%-2.7%5.3%1.8%2.2%
VWIV30.1%22.5%35.7%35.7%22.5%
Skew 25d5.1%2.5%6.8%5.8%3.7%
Skew 10d10.9%6.7%14.6%10.4%10.1%
Call IV 25d27.6%20.5%34.2%34.2%21.2%
Put IV 25d32.7%24.5%40.0%40.0%25.0%
Bid-Ask Spread %2.932.063.782.063.46
Gamma HHI0.110.100.130.120.13
Net GEX21.4M-5.5M65.0M-5.5M65.0M
Net DEX248.3M-627.7M1.27B1.27B-352.1M
Net VEX-13.5M-15.4M-11.8M-11.8M-15.0M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.500.170.950.490.30
Total Volume173,942.04884,287393,959210,056155,710
Total OI3,471,584.3332,895,3563,878,0103,534,1333,587,373

Daily Data (21 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call WallPut WallCall VolPut VolCall OIPut OI
2010-07-01$23.16$27.0037.1%10.6%30.6%94.6%35.7%5.8%1.8%-5.5M1.27B-11.8M0.492.06N/AN/A140,90269,1542,001,5691,532,564
2010-07-02$23.27$27.0031.9%9.1%28.2%73.3%33.6%4.8%5.3%-3.7M1.20B-12.0M0.772.64N/AN/A69,78053,4232,070,1011,537,215
2010-07-06$23.82$23.0031.2%9.9%29.4%70.5%35.3%6.8%-2.6%-1.2M1.05B-12.2M0.532.65N/AN/A127,47868,1232,104,3941,563,064
2010-07-07$24.30$23.0029.6%9.6%30.4%64.0%34.2%6.5%-2.1%4.4M820.7M-13.0M0.423.20N/AN/A91,13138,3562,161,2091,585,515
2010-07-08$24.41$24.0027.8%9.4%30.2%56.3%33.4%6.6%-2.2%7.2M803.6M-12.9M0.603.10N/AN/A52,53731,7502,172,3391,596,931
2010-07-09$24.27$24.0025.9%9.7%30.1%49.0%33.3%6.3%-2.3%6.4M898.9M-12.7M0.863.32N/AN/A65,75456,6762,174,8131,600,903
2010-07-12$24.83$24.0028.9%9.3%29.7%60.9%33.1%6.7%-2.5%14.3M524.8M-13.5M0.582.84N/AN/A86,77150,2202,203,3591,613,235
2010-07-13$25.13$24.0028.0%9.2%30.0%57.3%32.4%6.2%-2.4%14.9M402.5M-13.5M0.403.05N/AN/A84,28333,4062,209,7341,624,741
2010-07-14$25.44$24.0028.2%9.0%26.1%58.1%32.5%5.5%-2.3%20.1M152.0M-13.9M0.322.85N/AN/A120,30238,0162,225,2241,627,179
2010-07-15$25.51$24.0029.4%8.4%26.0%63.1%31.3%6.0%-1.4%17.0M139.6M-13.9M0.613.59N/AN/A88,68353,7812,221,7151,629,294
2010-07-16$24.89$24.0031.5%9.0%27.2%71.7%31.8%5.7%-1.8%11.9M659.2M-13.6M0.672.78N/AN/A88,24959,2782,239,8791,638,131
2010-07-19$25.23$24.0030.3%8.7%27.8%66.6%31.1%5.3%-2.2%17.2M-26.5M-13.3M0.482.65N/AN/A74,52136,1311,632,5001,262,856
2010-07-20$25.48$24.0029.5%8.5%27.4%63.4%30.2%4.5%-2.3%20.6M-95.8M-13.5M0.393.20N/AN/A91,68035,7251,652,2461,273,569
2010-07-21$25.12$24.0030.8%8.8%27.7%69.0%30.5%5.1%-1.7%17.6M79.5M-13.2M0.392.99N/AN/A114,94045,1061,667,1681,285,358
2010-07-22$25.84$24.0030.3%8.7%28.9%66.6%30.6%4.0%-2.7%28.0M-326.3M-14.0M0.423.78N/AN/A239,180101,2261,722,0341,305,036
2010-07-23$25.81$24.0022.6%6.5%28.4%35.1%23.6%4.2%1.1%31.4M-197.7M-13.8M0.692.70N/AN/A160,096110,3021,795,7171,350,984
2010-07-26$26.10$25.0022.2%6.4%27.5%33.4%24.1%4.5%1.0%38.0M-393.4M-14.1M0.952.80N/AN/A66,79963,1651,782,7591,346,920
2010-07-27$26.16$25.0021.9%6.3%27.2%32.5%23.2%4.0%1.6%38.6M-384.4M-14.0M0.172.75N/AN/A140,00623,6261,789,2911,358,437
2010-07-28$25.95$25.0024.4%7.0%21.7%42.5%24.6%3.1%0.1%43.6M-379.5M-14.5M0.172.47N/AN/A338,12155,8381,897,1171,364,534
2010-07-29$26.03$25.0024.7%7.1%20.7%43.9%25.3%2.5%0.9%63.9M-627.7M-15.4M0.242.69N/AN/A187,93944,6192,126,0781,370,186
2010-07-30$25.81$25.0021.6%6.2%21.3%31.2%22.5%3.7%2.2%65.0M-352.1M-15.0M0.303.46N/AN/A119,85335,8572,201,1291,386,244