MSFT Options History — November 2017

In November 2017, MSFT traded between $82.44 and $84.77. ATM implied volatility averaged 14.6%, placing in the 24.1% IV rank vs the trailing year. The 30-day expected move averaged 4.3%. IV traded below realized volatility by 6.5% (HV 20d: 21.1%). Max pain ranged from $77.50 to $81.00. Net GEX was positive for 21 of 21 trading days. Term structure was in contango for 13 of 21 days. Put/call ratio averaged 0.79.

Notable Days

  • 2017-11-14: Highest Volume — 666,518 contracts
  • 2017-11-29: Largest IV spike — 16.6% change
  • 2017-11-29: Highest IV Rank — 35.2%
  • 2017-11-29: Largest Expected Move — 5.0%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$83.71$82.44$84.77$83.14$84.20
Max Pain$79.55$77.50$81.00$77.50$81.00
ATM IV14.6%13.5%16.3%14.9%15.5%
Expected Move4.3%3.7%5.0%4.5%4.8%
HV 20d21.1%11.5%24.5%22.4%13.5%
HV 60d16.5%16.2%17.1%17.0%16.7%
IV Rank24.1%16.2%35.2%26.1%29.8%
IV Percentile26.4%7.9%52.0%30.6%44.4%
Term Structure0.1%-0.8%0.6%0.4%0.6%
VWIV15.5%13.2%18.1%16.9%16.9%
Skew 25d1.2%-0.3%1.8%0.7%1.8%
Skew 10d3.0%0.9%5.2%0.9%3.2%
Call IV 25d14.4%13.1%15.8%14.9%14.9%
Put IV 25d15.7%14.6%17.5%15.6%16.7%
Bid-Ask Spread %3.622.189.162.599.16
Gamma HHI0.130.110.200.110.11
Net GEX144.9M16.4M251.3M170.9M100.4M
Net DEX-3.91B-5.67B-2.25B-5.15B-3.06B
Net VEX-17.6M-18.5M-16.8M-17.5M-18.0M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.790.061.250.761.10
Total Volume119,614.42954,327666,51878,41773,806
Total OI1,931,799.2861,739,7902,099,8052,049,6451,896,928

Daily Data (21 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call WallPut WallCall VolPut VolCall OIPut OI
2017-11-01$83.14$77.5014.9%4.5%22.4%26.1%16.9%0.7%0.4%170.9M-5.15B-17.5M0.762.59N/AN/A44,65133,7661,057,820991,825
2017-11-02$84.18$77.5014.7%4.5%22.2%24.6%16.0%0.9%0.2%176.8M-5.67B-17.2M0.683.07N/AN/A74,71350,8841,068,185995,960
2017-11-03$84.06$77.5014.5%4.3%22.2%23.2%15.6%0.9%0.4%251.3M-5.62B-17.2M0.852.72N/AN/A61,81752,5401,076,6261,008,315
2017-11-06$84.57$77.5014.5%4.3%22.2%23.1%15.7%0.9%0.3%169.9M-5.35B-16.8M0.782.22N/AN/A45,14235,2931,005,077953,981
2017-11-07$84.14$77.5014.7%4.3%22.4%24.2%15.4%-0.3%-0.8%166.9M-5.16B-17.0M1.104.38N/AN/A55,85361,2551,014,435959,684
2017-11-08$84.56$80.0014.2%4.2%22.4%20.8%15.1%0.8%0.6%183.7M-5.33B-17.1M0.972.97N/AN/A39,17438,0201,036,175998,959
2017-11-09$84.12$80.0015.0%4.4%22.6%26.6%15.9%1.1%0.2%165.0M-5.07B-17.4M0.863.79N/AN/A77,17166,7471,036,3221,012,610
2017-11-10$83.84$80.0015.3%4.5%22.8%28.5%16.2%1.1%0.6%172.3M-4.89B-18.3M0.672.62N/AN/A48,04232,0501,060,5561,039,249
2017-11-13$83.87$80.0015.3%4.4%22.8%28.5%16.6%1.7%-0.0%180.5M-4.77B-18.5M0.552.74N/AN/A35,97519,7981,046,3921,022,385
2017-11-14$84.06$80.0014.7%4.2%22.8%24.5%17.6%1.6%0.6%196.0M-4.96B-18.1M0.062.18N/AN/A629,55536,9631,052,4151,030,596
2017-11-15$82.82$80.0015.9%4.6%23.7%32.3%16.5%1.6%-0.2%100.7M-2.34B-18.1M0.613.14N/AN/A52,71931,916804,2721,046,479
2017-11-16$83.21$80.0015.0%4.3%23.7%26.3%14.9%1.8%-0.3%116.4M-2.61B-17.7M0.593.13N/AN/A43,04125,233820,5601,055,683
2017-11-17$82.44$80.0014.4%4.1%24.0%22.3%14.5%1.4%0.4%16.4M-2.25B-17.8M0.593.59N/AN/A64,66838,264828,4981,056,450
2017-11-20$82.54$80.0014.1%4.0%24.0%20.4%14.1%1.5%-0.2%113.6M-2.45B-17.6M0.633.15N/AN/A35,50122,508788,978950,812
2017-11-21$83.69$80.0013.6%3.7%24.3%17.2%13.4%1.5%-0.1%139.7M-2.98B-17.1M0.633.04N/AN/A52,60633,216795,199957,522
2017-11-22$83.11$80.0013.9%3.8%24.5%18.8%13.2%1.4%-0.3%127.4M-2.63B-17.4M0.954.21N/AN/A58,02255,377802,561966,959
2017-11-24$83.26$80.0013.6%3.7%24.5%17.0%13.7%1.2%-0.0%117.8M-2.78B-17.6M1.035.72N/AN/A26,75527,572828,2371,002,886
2017-11-27$83.84$80.0013.5%3.8%11.5%16.2%14.4%1.5%0.3%131.0M-2.98B-17.5M1.252.74N/AN/A38,28647,955816,663983,467
2017-11-28$84.77$81.0014.0%4.1%12.1%19.6%14.9%1.3%0.2%140.3M-3.38B-17.7M0.613.50N/AN/A83,05350,495830,0561,005,594
2017-11-29$83.40$81.0016.3%5.0%13.1%35.2%18.1%1.7%0.1%105.4M-2.69B-17.8M1.255.44N/AN/A49,45562,046839,2971,023,117
2017-11-30$84.20$81.0015.5%4.8%13.5%29.8%16.9%1.8%0.6%100.4M-3.06B-18.0M1.109.16N/AN/A35,18438,622850,0211,046,907