MSFT Options History — October 2013

In October 2013, MSFT traded between $33.01 and $35.73. ATM implied volatility averaged 24.4%, placing in the 67.2% IV rank vs the trailing year. The 30-day expected move averaged 7.2%. IV traded above realized volatility by 5.6% (HV 20d: 18.8%). Max pain ranged from $30.00 to $30.00. Net GEX was positive for 23 of 23 trading days. Term structure was in contango for 8 of 23 days. Put/call ratio averaged 0.69.

Notable Days

  • 2013-10-25: Highest Volume — 528,425 contracts
  • 2013-10-25: Largest IV drop — 29.2% change
  • 2013-10-08: Highest IV Rank — 100.0%
  • 2013-10-08: Largest Expected Move — 7.5%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$34.38$33.01$35.73$33.58$35.41
Max Pain$30.00$30.00$30.00$30.00$30.00
ATM IV24.4%18.2%31.0%22.7%18.6%
Expected Move7.2%7.0%7.5%7.0%7.2%
HV 20d18.8%13.8%26.1%19.1%26.0%
HV 60d30.3%25.4%36.4%36.3%28.3%
IV Rank67.2%35.8%100.0%59.7%37.8%
IV Percentile76.4%21.0%100.0%77.8%24.6%
Term Structure-1.1%-3.4%3.8%3.2%0.4%
VWIV25.7%24.6%27.3%25.4%25.4%
Skew 25d3.0%1.5%5.1%1.5%2.9%
Skew 10d6.1%4.2%9.2%5.4%5.2%
Call IV 25d23.0%16.9%29.4%19.6%17.5%
Put IV 25d26.0%19.7%33.4%21.1%20.4%
Bid-Ask Spread %3.602.2413.134.282.66
Gamma HHI0.140.110.180.140.14
Net GEX139.1M85.4M165.0M131.6M157.1M
Net DEX-2.65B-3.63B-1.50B-2.11B-3.18B
Net VEX-19.8M-21.1M-18.2M-18.2M-21.1M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.690.211.160.821.16
Total Volume195,738.21772,787528,425107,60472,787
Total OI3,953,966.6093,589,1864,172,2283,747,2514,067,963

Daily Data (23 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call WallPut WallCall VolPut VolCall OIPut OI
2013-10-01$33.58$30.0022.7%7.0%19.1%59.7%25.4%1.5%3.2%131.6M-2.11B-18.2M0.824.28N/AN/A59,26848,3362,255,6471,491,604
2013-10-02$33.92$30.0022.8%7.1%17.0%60.3%25.5%1.6%3.8%144.0M-2.45B-19.0M0.712.49N/AN/A164,394117,1832,277,5961,516,522
2013-10-03$33.86$30.0026.0%7.1%17.1%77.1%24.8%2.3%-1.6%144.1M-2.45B-20.0M1.073.29N/AN/A51,72255,4092,358,4641,588,797
2013-10-04$33.88$30.0026.3%7.1%16.9%78.8%25.0%3.1%-1.5%151.5M-2.45B-19.9M0.942.61N/AN/A52,13349,1782,371,0631,605,029
2013-10-07$33.30$30.0028.9%7.4%17.9%91.8%27.3%3.3%-2.1%113.6M-1.82B-20.1M0.633.07N/AN/A96,69761,1862,368,2491,618,097
2013-10-08$33.01$30.0030.6%7.5%16.6%100.0%26.4%4.0%-3.1%98.1M-1.50B-20.2M1.052.96N/AN/A65,20668,6762,393,1971,642,377
2013-10-09$33.07$30.0031.0%7.4%16.2%100.0%27.0%4.0%-3.2%100.1M-1.55B-20.2M0.302.58N/AN/A76,99923,0732,405,3131,652,379
2013-10-10$33.76$30.0027.0%7.2%17.7%79.7%26.7%3.0%-1.4%147.2M-2.39B-20.2M0.402.89N/AN/A96,01738,8292,444,8891,655,870
2013-10-11$34.13$30.0025.5%7.1%17.8%72.2%25.9%3.2%-1.7%158.1M-2.73B-19.8M0.892.94N/AN/A86,60077,1992,436,4971,667,195
2013-10-14$34.45$30.0025.4%7.2%17.6%72.1%26.0%3.3%-2.2%164.0M-3.04B-19.5M0.853.28N/AN/A97,67883,2772,425,8551,676,115
2013-10-15$34.49$30.0027.1%7.2%17.6%80.1%25.3%3.5%-2.9%157.8M-3.04B-19.8M0.482.92N/AN/A147,96570,7682,428,9801,697,387
2013-10-16$34.64$30.0024.9%7.1%17.3%69.3%25.2%2.8%-2.3%165.0M-3.22B-19.5M0.392.54N/AN/A97,88638,6382,443,0131,714,228
2013-10-17$34.92$30.0023.4%7.1%17.2%61.5%25.3%2.5%0.2%164.0M-3.52B-19.2M0.552.24N/AN/A91,09349,7682,429,7061,697,502
2013-10-18$34.96$30.0023.1%7.0%13.9%60.0%26.4%2.6%0.4%163.4M-3.56B-19.2M0.732.89N/AN/A132,99897,0342,454,6351,717,593
2013-10-21$34.99$30.0023.5%7.0%13.8%62.4%24.7%3.1%-2.3%123.7M-2.76B-19.7M1.012.84N/AN/A42,98543,3542,136,8791,452,307
2013-10-22$34.58$30.0024.9%7.1%14.2%69.5%26.2%3.3%-3.4%115.8M-2.41B-19.6M0.653.05N/AN/A114,11574,2062,157,0951,474,139
2013-10-23$33.76$30.0026.0%7.2%17.2%74.8%25.6%4.1%-3.4%92.9M-1.70B-20.2M0.887.68N/AN/A139,025122,8222,227,0461,512,425
2013-10-24$33.72$30.0027.5%7.1%17.0%82.5%26.1%5.1%-3.0%85.4M-1.57B-20.0M1.0313.13N/AN/A236,238242,9172,202,5101,559,529
2013-10-25$35.73$30.0019.5%7.2%26.0%42.2%25.0%2.9%-0.8%149.2M-3.63B-19.8M0.554.41N/AN/A340,302188,1232,274,9381,681,140
2013-10-28$35.57$30.0018.8%7.1%26.1%38.6%25.4%2.5%0.1%151.8M-3.25B-19.6M0.322.31N/AN/A160,65452,0622,239,9931,618,597
2013-10-29$35.52$30.0018.2%7.1%26.1%35.8%24.6%2.7%0.5%159.0M-3.30B-19.5M0.212.74N/AN/A245,45150,3692,274,4481,626,942
2013-10-30$35.54$30.0018.9%7.2%26.0%39.2%25.8%2.5%0.5%162.6M-3.37B-20.5M0.313.11N/AN/A138,17243,1872,351,2751,650,207
2013-10-31$35.41$30.0018.6%7.2%26.0%37.8%25.4%2.9%0.4%157.1M-3.18B-21.1M1.162.66N/AN/A33,76639,0212,398,5621,669,401