MSFT Options History — October 2017

In October 2017, MSFT traded between $74.28 and $83.92. ATM implied volatility averaged 19.5%, placing in the 52.6% IV rank vs the trailing year. The 30-day expected move averaged 5.5%. IV traded above realized volatility by 6.9% (HV 20d: 12.5%). Max pain ranged from $72.50 to $77.50. Net GEX was positive for 22 of 22 trading days. Term structure was in contango for 4 of 22 days. Put/call ratio averaged 0.71.

Notable Days

  • 2017-10-27: Highest Volume — 569,471 contracts
  • 2017-10-27: Largest IV drop — 35.9% change
  • 2017-10-23: Highest IV Rank — 73.1%
  • 2017-10-25: Largest Expected Move — 6.8%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$77.93$74.28$83.92$74.59$83.18
Max Pain$74.59$72.50$77.50$72.50$77.50
ATM IV19.5%13.7%21.9%20.2%15.4%
Expected Move5.5%4.1%6.8%4.1%4.7%
HV 20d12.5%8.0%22.3%11.9%22.3%
HV 60d13.1%11.7%17.0%13.3%17.0%
IV Rank52.6%17.5%73.1%55.4%29.1%
IV Percentile65.0%10.3%82.1%69.0%36.5%
Term Structure-0.6%-2.3%0.7%-0.4%0.2%
VWIV19.4%14.7%24.5%14.7%16.4%
Skew 25d2.2%0.0%2.9%2.2%1.0%
Skew 10d4.5%-0.0%6.8%4.6%1.5%
Call IV 25d18.6%14.0%20.4%19.1%15.3%
Put IV 25d20.8%14.1%23.0%21.3%16.3%
Bid-Ask Spread %3.271.737.072.146.34
Gamma HHI0.150.120.210.130.12
Net GEX213.0M142.7M336.3M150.6M161.1M
Net DEX-3.78B-6.30B-2.20B-2.31B-5.16B
Net VEX-17.3M-18.0M-15.0M-16.5M-16.4M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio0.710.411.350.700.46
Total Volume145,023.54561,435569,47182,160142,232
Total OI2,007,523.4091,791,5462,196,8301,869,3412,003,458

Daily Data (22 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call WallPut WallCall VolPut VolCall OIPut OI
2017-10-02$74.59$72.5020.2%4.1%11.9%55.4%14.7%2.2%-0.4%150.6M-2.31B-16.5M0.702.14N/AN/A48,34333,817943,913925,428
2017-10-03$74.28$72.5021.0%4.2%11.9%60.4%14.9%2.4%-0.6%142.7M-2.20B-17.3M1.042.01N/AN/A32,58534,027967,640940,165
2017-10-04$74.68$72.5021.0%4.2%11.9%60.6%15.0%2.1%-0.8%162.6M-2.43B-17.5M1.204.37N/AN/A31,70937,986981,320955,401
2017-10-05$75.97$72.5019.9%5.7%12.5%53.6%19.8%2.3%-0.8%201.1M-3.22B-17.3M0.591.73N/AN/A97,42257,567981,307972,779
2017-10-06$75.96$72.5019.7%5.7%12.4%52.3%19.7%2.1%-0.9%249.4M-3.24B-17.6M0.605.25N/AN/A53,96532,1251,006,897991,695
2017-10-09$76.32$75.0019.3%5.4%12.1%50.3%19.5%2.1%-0.3%206.2M-3.24B-18.0M0.783.06N/AN/A48,31537,618996,946976,492
2017-10-10$76.22$75.0019.9%5.8%12.1%53.7%19.9%2.4%0.7%207.5M-3.28B-17.2M0.652.94N/AN/A58,10137,7241,009,536988,751
2017-10-11$76.43$75.0019.5%5.4%11.9%51.4%20.1%2.2%-0.8%219.1M-3.39B-17.4M0.493.63N/AN/A97,66048,0231,026,4901,003,119
2017-10-12$77.11$75.0019.3%5.5%11.9%50.1%19.6%2.3%-0.4%262.1M-4.01B-17.6M0.723.86N/AN/A76,13754,6441,085,5861,024,496
2017-10-13$77.44$75.0019.1%5.5%11.7%48.9%19.6%2.5%-0.1%272.5M-4.19B-17.6M0.412.18N/AN/A105,74343,2011,082,8811,039,984
2017-10-16$77.61$75.0019.8%5.7%11.7%52.8%20.1%2.9%-1.4%259.7M-4.03B-17.8M0.621.77N/AN/A37,87323,5621,079,5581,030,364
2017-10-17$77.57$75.0020.1%5.7%11.7%54.6%20.5%2.6%-0.5%284.4M-4.13B-16.9M0.762.64N/AN/A76,08057,6351,080,8101,039,215
2017-10-18$77.60$75.0019.4%5.6%11.4%50.8%19.7%2.7%-1.4%329.7M-3.99B-18.0M0.471.96N/AN/A58,66327,5131,117,6311,070,792
2017-10-19$77.86$75.0020.2%5.8%10.6%55.2%20.9%2.9%-1.6%336.3M-4.28B-17.3M0.731.90N/AN/A53,69439,4601,118,9441,073,536
2017-10-20$78.69$75.0019.8%5.9%11.0%53.1%20.1%2.7%-2.3%197.8M-4.89B-17.1M0.462.30N/AN/A132,75260,9451,123,2441,073,586
2017-10-23$78.79$75.0021.9%6.7%8.4%73.1%23.8%2.7%-1.1%156.8M-3.32B-18.0M0.652.49N/AN/A85,29155,661917,952873,594
2017-10-24$78.78$75.0021.0%6.4%8.4%67.0%22.8%2.0%-0.7%165.9M-3.35B-18.0M0.733.06N/AN/A63,57546,126943,512893,313
2017-10-25$78.68$75.0021.5%6.8%8.3%70.3%24.5%2.3%-0.6%164.7M-3.34B-17.6M1.352.25N/AN/A62,91485,185964,601913,808
2017-10-26$78.91$75.0021.3%6.7%8.0%69.2%22.9%2.4%-0.9%161.3M-3.45B-17.7M0.667.07N/AN/A162,949106,998983,623961,453
2017-10-27$83.88$75.0013.7%4.3%22.0%17.5%15.6%0.0%0.1%226.2M-6.30B-15.0M0.474.42N/AN/A386,621182,8501,032,2951,010,530
2017-10-30$83.92$76.0015.2%4.6%22.0%27.9%17.3%0.5%0.6%168.0M-5.49B-15.9M1.044.47N/AN/A85,81589,412999,220959,650
2017-10-31$83.18$77.5015.4%4.7%22.3%29.1%16.4%1.0%0.2%161.1M-5.16B-16.4M0.466.34N/AN/A97,46944,7631,013,867989,591