MSFT Options History — August 2012

In August 2012, MSFT traded between $29.19 and $30.90. ATM implied volatility averaged 17.4%, placing in the 6.2% IV rank vs the trailing year. The 30-day expected move averaged 4.9%. IV traded below realized volatility by 1.2% (HV 20d: 18.6%). Max pain ranged from $29.00 to $30.00. Net GEX was positive for 23 of 23 trading days. Term structure was in contango for 21 of 23 days. Put/call ratio averaged 0.70.

Notable Days

  • 2012-08-13: Highest Volume — 1,159,216 contracts
  • 2012-08-02: Largest IV drop — 25.1% change
  • 2012-08-01: Highest IV Rank — 24.3%
  • 2012-08-01: Largest Expected Move — 6.1%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$30.36$29.19$30.90$29.41$30.82
Max Pain$29.74$29.00$30.00$30.00$30.00
ATM IV17.4%14.7%27.0%27.0%15.6%
Expected Move4.9%4.4%6.1%6.1%4.8%
HV 20d18.6%13.0%24.9%24.2%13.0%
HV 60d23.2%21.7%24.1%23.8%21.9%
IV Rank6.2%0.0%24.3%24.3%2.9%
IV Percentile11.0%0.0%72.6%72.6%2.8%
Term Structure2.7%-0.5%3.7%-0.5%3.6%
VWIV18.2%15.9%23.6%22.3%17.8%
Skew 25d2.3%1.7%2.8%2.6%2.5%
Skew 10d5.1%2.1%7.6%4.1%5.7%
Call IV 25d16.7%14.9%19.9%19.9%16.6%
Put IV 25d19.1%17.4%22.5%22.5%19.1%
Bid-Ask Spread %4.852.6912.386.4712.38
Gamma HHI0.120.100.260.100.10
Net GEX74.7M39.6M144.4M46.2M78.6M
Net DEX-1.43B-1.72B-717.2M-865.9M-1.72B
Net VEX-15.6M-16.3M-15.2M-15.4M-15.7M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.700.021.290.650.64
Total Volume133,574.52258,1041,159,21666,196113,145
Total OI3,113,016.872,985,3153,204,3173,074,0503,145,519

Daily Data (23 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call WallPut WallCall VolPut VolCall OIPut OI
2012-08-01$29.41$30.0027.0%6.1%24.2%24.3%22.3%2.6%-0.5%46.2M-865.9M-15.4M0.656.47N/AN/A40,16626,0301,829,4951,244,555
2012-08-02$29.19$30.0020.2%5.8%24.3%10.0%21.3%2.6%-0.0%39.6M-717.2M-15.3M1.083.87N/AN/A38,93342,1841,841,1961,250,537
2012-08-03$29.75$30.0017.9%5.4%24.8%5.1%18.9%1.7%0.8%53.8M-1.08B-15.7M0.272.99N/AN/A190,97752,0371,848,2721,262,874
2012-08-06$29.95$29.0020.1%5.4%24.8%9.7%19.0%2.4%2.3%66.8M-1.23B-15.3M0.375.94N/AN/A46,72017,2771,869,1581,267,884
2012-08-07$30.26$29.0020.7%5.3%24.9%11.0%18.9%2.6%2.5%76.0M-1.42B-15.6M0.423.93N/AN/A43,64218,3271,879,9631,268,730
2012-08-08$30.33$29.0018.0%5.2%24.2%7.8%19.0%2.4%2.9%79.0M-1.48B-15.5M1.115.19N/AN/A29,75032,9001,891,8151,268,769
2012-08-09$30.50$29.0017.7%5.1%22.3%6.9%18.4%2.4%2.8%83.1M-1.61B-15.4M0.502.69N/AN/A58,03929,1601,897,5761,276,696
2012-08-10$30.42$29.0016.5%4.9%20.7%3.5%17.8%2.6%3.0%80.7M-1.54B-15.3M0.587.74N/AN/A44,00825,7151,902,4381,290,205
2012-08-13$30.39$29.0018.1%4.8%20.7%8.5%23.6%2.4%3.0%84.1M-1.49B-15.2M0.022.92N/AN/A1,131,51827,6981,910,3691,293,948
2012-08-14$30.13$30.0016.2%4.8%20.9%2.4%17.4%2.4%3.3%55.7M-1.15B-16.0M0.396.11N/AN/A72,14728,2961,827,3761,305,949
2012-08-15$30.20$30.0014.7%4.7%18.6%0.0%17.1%2.1%3.2%57.8M-1.27B-15.6M0.435.10N/AN/A61,55426,3931,854,6861,308,305
2012-08-16$30.78$30.0016.6%4.8%19.7%6.0%17.6%2.6%2.9%98.1M-1.64B-16.3M0.703.07N/AN/A70,54349,0521,856,2061,304,001
2012-08-17$30.90$30.0015.6%4.5%18.5%2.7%16.4%2.8%3.4%144.4M-1.71B-16.2M0.974.10N/AN/A40,45239,0451,860,2711,312,771
2012-08-20$30.74$30.0015.3%4.4%15.1%1.7%15.9%2.6%3.4%77.2M-1.64B-15.5M0.884.25N/AN/A42,74837,6801,767,1481,218,167
2012-08-21$30.80$30.0015.3%4.4%14.9%1.9%16.2%2.8%3.5%78.3M-1.66B-16.0M0.814.22N/AN/A49,45840,1591,789,3851,233,537
2012-08-22$30.54$30.0015.4%4.4%14.6%2.4%16.2%1.9%3.5%74.1M-1.53B-15.5M0.703.30N/AN/A49,51234,6771,808,1271,245,383
2012-08-23$30.26$30.0017.1%4.9%14.8%7.5%17.1%1.8%3.2%67.7M-1.36B-15.5M0.873.31N/AN/A47,49441,4531,811,0631,245,296
2012-08-24$30.56$30.0016.3%4.7%13.5%4.9%16.9%2.0%3.1%75.1M-1.49B-16.1M0.593.44N/AN/A36,56721,6791,810,6791,252,178
2012-08-27$30.69$30.0016.4%4.7%13.4%5.4%17.2%2.0%2.9%79.6M-1.63B-15.4M1.105.38N/AN/A34,48838,0411,804,3521,244,237
2012-08-28$30.63$30.0016.0%4.6%13.2%4.0%17.0%2.1%3.7%78.7M-1.60B-15.4M1.295.14N/AN/A25,37732,7271,823,0071,260,597
2012-08-29$30.65$30.0016.2%4.6%13.1%4.8%17.2%1.9%3.4%76.0M-1.59B-15.4M0.805.41N/AN/A37,49929,9861,825,0221,273,804
2012-08-30$30.32$30.0017.8%5.1%13.5%9.8%19.1%2.7%3.3%68.0M-1.35B-16.0M0.824.70N/AN/A42,19634,7651,834,2061,283,636
2012-08-31$30.82$30.0015.6%4.8%13.0%2.9%17.8%2.5%3.6%78.6M-1.72B-15.7M0.6412.38N/AN/A68,84444,3011,842,6971,302,822