MSFT Options History — July 2017

In July 2017, MSFT traded between $68.17 and $74.25. ATM implied volatility averaged 20.5%, placing in the 57.1% IV rank vs the trailing year. The 30-day expected move averaged 6.0%. IV traded above realized volatility by 2.8% (HV 20d: 17.7%). Max pain ranged from $67.50 to $72.50. Net GEX was positive for 20 of 20 trading days. Term structure was in contango for 2 of 20 days. Put/call ratio averaged 0.68.

Notable Days

  • 2017-07-20: Highest Volume — 414,164 contracts
  • 2017-07-21: Largest IV drop — 30.2% change
  • 2017-07-06: Highest IV Rank — 80.6%
  • 2017-07-05: Largest Expected Move — 7.9%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$72.00$68.17$74.25$68.17$72.80
Max Pain$70.25$67.50$72.50$67.50$72.50
ATM IV20.5%14.9%24.4%24.1%15.6%
Expected Move6.0%4.3%7.9%7.8%4.7%
HV 20d17.7%16.6%19.4%17.4%16.6%
HV 60d16.2%15.3%16.7%15.3%16.6%
IV Rank57.1%23.3%80.6%76.9%27.4%
IV Percentile66.0%33.7%89.3%86.1%39.7%
Term Structure-0.6%-1.4%0.0%-0.8%-0.0%
VWIV20.8%15.2%27.4%26.6%16.8%
Skew 25d2.7%2.1%3.6%2.8%2.5%
Skew 10d5.4%3.2%7.8%6.0%5.5%
Call IV 25d19.4%14.1%23.3%22.5%14.9%
Put IV 25d22.1%16.4%26.9%25.3%17.4%
Bid-Ask Spread %3.261.8915.896.442.17
Gamma HHI0.120.100.160.100.13
Net GEX141.3M47.5M209.7M60.6M135.3M
Net DEX-2.59B-4.18B-912.9M-912.9M-2.11B
Net VEX-18.3M-19.1M-17.8M-19.1M-18.2M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.680.451.090.800.69
Total Volume140,002.956,426414,16456,426101,696
Total OI1,904,483.351,751,6722,312,3951,836,1961,771,984

Daily Data (20 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call WallPut WallCall VolPut VolCall OIPut OI
2017-07-03$68.17$67.5024.1%7.8%17.4%76.9%26.6%2.8%-0.8%60.6M-912.9M-19.1M0.806.44N/AN/A31,30325,123979,332856,864
2017-07-05$69.18$67.5023.5%7.9%18.5%73.4%27.4%3.2%-0.5%87.1M-1.44B-18.8M0.653.84N/AN/A40,17426,286989,811865,327
2017-07-06$68.52$70.0024.4%6.9%18.6%80.6%23.2%3.6%-0.7%63.5M-1.08B-18.9M1.092.84N/AN/A32,95235,828998,160871,671
2017-07-07$69.49$70.0023.1%6.3%19.4%72.6%23.7%3.5%-0.9%112.0M-1.58B-19.0M0.612.36N/AN/A87,47753,1311,006,582883,214
2017-07-10$70.20$70.0023.1%6.4%17.2%72.9%22.9%3.1%-0.5%110.5M-1.97B-18.5M0.951.89N/AN/A30,59229,045995,786875,806
2017-07-11$70.10$70.0022.9%6.4%17.1%71.6%21.6%2.9%-0.5%108.4M-1.89B-18.7M0.732.22N/AN/A34,77025,4661,002,525878,867
2017-07-12$71.23$70.0022.7%6.4%17.2%70.5%22.0%2.6%-0.3%144.0M-2.57B-18.2M0.942.10N/AN/A49,49846,6811,016,890886,703
2017-07-13$71.72$70.0022.6%6.2%16.9%70.4%22.0%2.9%-1.3%143.0M-2.79B-18.6M0.681.92N/AN/A64,03443,6761,014,970904,780
2017-07-14$73.17$70.0022.9%6.4%18.1%71.9%21.9%2.4%-0.7%161.3M-3.66B-17.8M0.492.21N/AN/A158,06077,5351,026,145916,956
2017-07-17$73.36$70.0022.7%6.5%18.1%71.0%22.7%2.5%-1.4%176.7M-3.64B-17.8M0.732.45N/AN/A63,65146,3271,055,180906,870
2017-07-18$73.07$70.0023.5%6.7%18.0%75.4%23.7%2.4%-1.3%173.0M-3.48B-17.9M0.802.37N/AN/A73,97759,2381,065,141921,959
2017-07-19$73.89$70.0023.1%6.6%17.7%72.9%23.8%2.3%-0.9%180.0M-3.88B-18.7M0.482.34N/AN/A135,37065,0211,089,404945,569
2017-07-20$74.19$70.0022.7%6.5%17.6%70.9%22.9%2.1%-0.4%198.9M-4.18B-18.3M0.6415.89N/AN/A251,848162,3161,132,397966,574
2017-07-21$73.30$70.0015.9%4.6%18.4%29.1%15.7%2.5%-0.8%178.6M-3.67B-17.9M0.451.93N/AN/A266,200120,6001,259,4311,052,964
2017-07-24$73.66$70.0015.4%4.5%18.2%26.1%15.8%2.3%0.0%191.8M-2.75B-17.9M0.662.38N/AN/A58,99538,811965,884785,788
2017-07-25$74.25$70.0015.3%4.5%18.1%25.7%15.5%2.4%0.0%209.7M-3.08B-17.9M0.592.68N/AN/A61,01836,139973,914802,390
2017-07-26$73.86$72.5014.9%4.3%17.0%23.3%15.2%2.3%0.0%201.7M-2.80B-18.0M0.462.39N/AN/A55,91325,472975,393813,904
2017-07-27$72.82$72.5016.1%4.8%18.0%30.6%16.8%2.6%-0.0%142.9M-2.19B-18.3M0.682.39N/AN/A77,11952,406977,634820,789
2017-07-28$73.03$72.5015.7%4.6%16.6%28.2%16.1%2.8%-0.1%47.5M-2.16B-18.1M0.562.41N/AN/A100,43555,875990,550845,559
2017-07-31$72.80$72.5015.6%4.7%16.6%27.4%16.8%2.5%-0.0%135.3M-2.11B-18.2M0.692.17N/AN/A60,17241,524958,670813,314